WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

12 messages Options
Embed this post
Permalink
Benjamin Reed

WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
So I've finished the work on transitioning to liquibase for revisions to
the database.

I believe I've found all of the bugs (both on upgrading, and fresh
install) but it's a rather large change to the way we create our
database schema.  Be forewarned, if you're playing with OpenNMS 1.7.x
snapshots, be prepared to back up your database first before upgrading
to a snapshot of revision 13498 or higher.

That said, I would really appreciate feedback from testers, letting me
know if they ran into any issues after the update.

Thanks!

--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/




------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, &
iPhoneDevCamp as they present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com 
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel

signature.asc (258 bytes) Download Attachment
Kevin Roberts

Re: WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
I got this error

INFO: Successfully released change log lock
Exception in thread "main" org.opennms.core.schema.MigrationException: unable to update the database
        at org.opennms.core.schema.Migrator.migrate(Migrator.java:72)
        at org.opennms.install.Installer.install(Installer.java:284)
        at org.opennms.install.Installer.main(Installer.java:860)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set sequences.xml::opennmsnxtid::rangerrick:
     Reason: liquibase.exception.JDBCException: Error executing SQL CREATE SEQUENCE opennmsnxtid:
          Caused By: Error executing SQL CREATE SEQUENCE opennmsnxtid:
          Caused By: ERROR: relation "opennmsnxtid" already exists
        at liquibase.ChangeSet.execute(ChangeSet.java:238)
        at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
        at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
        at liquibase.Liquibase.update(Liquibase.java:112)
        at org.opennms.core.schema.Migrator.migrate(Migrator.java:69)
        ... 2 more
Caused by: liquibase.exception.JDBCException: Error executing SQL CREATE SEQUENCE opennmsnxtid
        at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:56)
        at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:87)
        at liquibase.change.AbstractChange.execute(AbstractChange.java:251)
        at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:97)
        at liquibase.ChangeSet.execute(ChangeSet.java:214)
        ... 6 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "opennmsnxtid" already exists
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
        at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:79)
        at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:49)
        ... 10 more

-----Original Message-----
From: Benjamin Reed [mailto:[hidden email]]
Sent: Friday, May 29, 2009 1:39 PM
To: General OpenNMS Discussion; OpenNMS Code Development and Bugs
Subject: [opennms-devel] WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

So I've finished the work on transitioning to liquibase for revisions to the database.

I believe I've found all of the bugs (both on upgrading, and fresh
install) but it's a rather large change to the way we create our database schema.  Be forewarned, if you're playing with OpenNMS 1.7.x snapshots, be prepared to back up your database first before upgrading to a snapshot of revision 13498 or higher.

That said, I would really appreciate feedback from testers, letting me know if they ran into any issues after the update.

Thanks!

--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/



Confidentiality Notice: This page and any accompanying documents contain information that is confidential, privileged, or exempt from disclosure under applicable law and is intended for the exclusive use of the addressee. This information is private and protected by law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the contents of this information in any manner is strictly prohibited.

------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel
Benjamin Reed

Re: WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
On 6/1/09 3:48 PM, Kevin Roberts wrote:

> Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set sequences.xml::opennmsnxtid::rangerrick:
>      Reason: liquibase.exception.JDBCException: Error executing SQL CREATE SEQUENCE opennmsnxtid:

OK, this is fixed in trunk now.  I'm triggering a new nightly snapshot
right now, should be in yum in a few hours.

--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/




------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel

signature.asc (258 bytes) Download Attachment
Kevin Roberts

Re: WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
Still have problems

INFO: Successfully released change log lock
Exception in thread "main" org.opennms.core.schema.MigrationException: unable to update the database
        at org.opennms.core.schema.Migrator.migrate(Migrator.java:72)
        at org.opennms.install.Installer.install(Installer.java:284)
        at org.opennms.install.Installer.main(Installer.java:860)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set 1.7.1/maps.xml::1.7.1-add-map-group::rssntn67:
     Reason: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE map ADD mapgroup VARCHAR(64):
          Caused By: Error executing SQL ALTER TABLE map ADD mapgroup VARCHAR(64):
          Caused By: ERROR: column "mapgroup" of relation "map" already exists
        at liquibase.ChangeSet.execute(ChangeSet.java:238)
        at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
        at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
        at liquibase.Liquibase.update(Liquibase.java:112)
        at org.opennms.core.schema.Migrator.migrate(Migrator.java:69)
        ... 2 more
Caused by: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE map ADD mapgroup VARCHAR(64)
        at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:56)
        at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:87)
        at liquibase.change.AbstractChange.execute(AbstractChange.java:251)
        at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:97)
        at liquibase.ChangeSet.execute(ChangeSet.java:214)
        ... 6 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "mapgroup" of relation "map" already exists
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
        at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:79)
        at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:49)
        ... 10 more


-----Original Message-----
From: Benjamin Reed [mailto:[hidden email]]
Sent: Tuesday, June 02, 2009 6:51 AM
To: OpenNMS Code Development and Bugs
Subject: Re: [opennms-devel] WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

On 6/1/09 3:48 PM, Kevin Roberts wrote:

> Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set sequences.xml::opennmsnxtid::rangerrick:
>      Reason: liquibase.exception.JDBCException: Error executing SQL CREATE SEQUENCE opennmsnxtid:

OK, this is fixed in trunk now.  I'm triggering a new nightly snapshot right now, should be in yum in a few hours.

--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/



Confidentiality Notice: This page and any accompanying documents contain information that is confidential, privileged, or exempt from disclosure under applicable law and is intended for the exclusive use of the addressee. This information is private and protected by law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the contents of this information in any manner is strictly prohibited.

------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel
Benjamin Reed

Re: WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
On 6/2/09 3:19 PM, Kevin Roberts wrote:
> Still have problems

A different error though.

Mind sending me the output of:

  pg_dump -U opennms -d opennms -s

?

Also, what version of OpenNMS are you currently running?  1.7.3?  A
snapshot?

--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/




------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel

signature.asc (258 bytes) Download Attachment
Benjamin Reed

Re: WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
On 6/2/09 3:49 PM, Benjamin Reed wrote:
> On 6/2/09 3:19 PM, Kevin Roberts wrote:
>> Still have problems
>
> A different error though.

Actually, I figured it out.

Fix committed in revision 13551


--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/




------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel

signature.asc (258 bytes) Download Attachment
Kevin Roberts

Re: WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
1.7.4-0.13541.snapshot when will it be uploaded?
-----Original Message-----
From: Benjamin Reed [mailto:[hidden email]]
Sent: Tuesday, June 02, 2009 12:52 PM
To: OpenNMS Code Development and Bugs
Subject: Re: [opennms-devel] WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

On 6/2/09 3:49 PM, Benjamin Reed wrote:
> On 6/2/09 3:19 PM, Kevin Roberts wrote:
>> Still have problems
>
> A different error though.

Actually, I figured it out.

Fix committed in revision 13551


--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/



Confidentiality Notice: This page and any accompanying documents contain information that is confidential, privileged, or exempt from disclosure under applicable law and is intended for the exclusive use of the addressee. This information is private and protected by law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the contents of this information in any manner is strictly prohibited.

------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel
Benjamin Reed

Re: WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
On 6/2/09 3:59 PM, Kevin Roberts wrote:
> 1.7.4-0.13541.snapshot when will it be uploaded?

It's building now; probably another hour or so again.


--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/




------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel

signature.asc (258 bytes) Download Attachment
weiofj

Re: WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
In reply to this post by Benjamin Reed
Benjamin Reed

Re: WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
On 8/11/09 7:34 AM, weiofj wrote:
>
> For not to duplicate posts please take a look at that:
> http://n2.nabble.com/PSQLException-during-installation-with-both--disU-and--discU-options-td3398949.html

Did you open a bug?


--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/




------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel

signature.asc (267 bytes) Download Attachment
Philippe Guillebert-2

Re: WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
Benjamin Reed wrote:
> On 8/11/09 7:34 AM, weiofj wrote:
>  
>> For not to duplicate posts please take a look at that:
>> http://n2.nabble.com/PSQLException-during-installation-with-both--disU-and--discU-options-td3398949.html
>>    
>
> Did you open a bug?
>
>  

Hello

it looks like http://bugzilla.opennms.org/show_bug.cgi?id=3289

maybe have also a look at
http://bugzilla.opennms.org/show_bug.cgi?id=3296 about liquibase problems.


--
Philippe Guillebert

Bull, Architect of an Open World
Tél : +33 (0)1 30 80 61 81
http://www.bull.com


[philippe_guillebert.vcf]

begin:vcard
fn:Philippe Guillebert
n:Guillebert;Philippe
org:Bull Telecom & Media;Operation Support Systems
email;internet:[hidden email]
title:SmartOSS Technical Manager
tel;work:+33 1 30 80 61 81
version:2.1
end:vcard



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel
weiofj

Re: WARNING: database volatility in 1.7.x snapshots starting tomorrow -- please help test!!

Reply Threaded More More options
Print post
Permalink
(This post was updated on )
In reply to this post by Benjamin Reed
> Did you open a bug?

I did, that's my record:  http://bugzilla.opennms.org/show_bug.cgi?id=3289

>maybe have also a look at
>http://bugzilla.opennms.org/show_bug.cgi?id=3296 about liquibase problems.

That's different. In my case PostgreSQL gets connected with no problem, then it seems to receive wrong request from the ONMS module. Strange... the same database, server, software and settings - 1.7.0 and older get installed successfully, but no luck with the latest ones.

Any ideas? I'm ready for testing.