Re: problem trying to upgrade with yum

Yum has now completed normally.

Following a reboot to the new kernel, I did an "/opt/opennms/bin/runjava 
-s" and it still seems to like the old java 1.5.

Then I ran the install script and it failed at:

Exception in thread "main" org.opennms.core.schema.MigrationException: 
unable to update the database
         at org.opennms.core.schema.Migrator.migrate(Migrator.java:415)
         at org.opennms.install.Installer.install(Installer.java:258)
         at org.opennms.install.Installer.main(Installer.java:931)
Caused by: liquibase.exception.MigrationFailedException: Migration 
failed for change set 
1.7.1/datalinkinterface.xml::1.7.1-datalinkinterface-index::mattraykow:
      Reason: liquibase.exception.JDBCException: Error executing SQL 
ALTER TABLE datalinkinterface ADD id integer DEFAULT 
nextval('opennmsNxtId') PRIMARY KEY  NOT NULL:
           Caused By: Error executing SQL ALTER TABLE datalinkinterface 
ADD id integer DEFAULT nextval('opennmsNxtId') PRIMARY KEY  NOT NULL:
           Caused By: ERROR: adding columns with defaults is not implemented
   Hint: Add the column, then use ALTER TABLE SET DEFAULT.
         at liquibase.ChangeSet.execute(ChangeSet.java:236)
         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:412)
         ... 2 more
Caused by: liquibase.exception.JDBCException: Error executing SQL ALTER 
TABLE datalinkinterface ADD id integer DEFAULT nextval('opennmsNxtId') 
PRIMARY KEY  NOT NULL
         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:212)
         ... 6 more
Caused by: org.postgresql.util.PSQLException: ERROR: adding columns with 
defaults is not implemented
   Hint: Add the column, then use ALTER TABLE SET DEFAULT.
         at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
         at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
         at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
         at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
         at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
         at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
         at 
liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:79)
         at 
liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:49)
         ... 10 more


Not sure where to go from here.

             ...jgm








On 5/24/2011 2:07 PM, Joe in MPLS wrote:
> Yup, it looks like I grabbed the tarball.
>
> I did the RPM install and things seem to be progressing on the update front.
>
> Thanks!
>
> Now I just have to try and remember the right arguments for running the
> Opennms install script after updating...
>
>                   ...jgm
>
>
>
>
>
>
> On 5/24/2011 1:26 PM, Benjamin Reed wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> On 5/24/11 12:56 PM, Joe in MPLS wrote:
>>> the same result. I manually downloaded the latest jdk 6 from sun and
>>> installed that. I then tried yum again and still got the same result.
>> Hrm, if you installed the latest jdk6 *rpm* (not just the tarball
>> version) it should not try to download that one...
>>
>> - -- 
>> Benjamin Reed
>> The OpenNMS Group
>> http://www.opennms.org/
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>>
>> iD8DBQFN2/hMUu+jZtP2Zf4RAualAJ9m09OGHCiiDBTkjQ+3ESsIU9LmGQCfZaVH
>> lJtIW4hBQdNfYPL3IQiUJ+s=
>> =qIza
>> -----END PGP SIGNATURE-----
>>
>>
>> ------------------------------------------------------------------------------
>> vRanger cuts backup time in half-while increasing security.
>> With the market-leading solution for virtual backup and recovery,
>> you get blazing-fast, flexible, and affordable data protection.
>> Download your free trial now.
>> http://p.sf.net/sfu/quest-d2dcopy1
>> _______________________________________________
>> Please read the OpenNMS Mailing List FAQ:
>> http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>> opennms-install mailing list
>>
>> To *unsubscribe* or change your subscription options, see the bottom of this page:
>> https://lists.sourceforge.net/lists/listinfo/opennms-install
>
>
> ------------------------------------------------------------------------------
> vRanger cuts backup time in half-while increasing security.
> With the market-leading solution for virtual backup and recovery,
> you get blazing-fast, flexible, and affordable data protection.
> Download your free trial now.
> http://p.sf.net/sfu/quest-d2dcopy1
> _______________________________________________
> Please read the OpenNMS Mailing List FAQ:
> http://www.opennms.org/index.php/Mailing_List_FAQ
>
> opennms-install mailing list
>
> To *unsubscribe* or change your subscription options, see the bottom of this page:
> https://lists.sourceforge.net/lists/listinfo/opennms-install



------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery, 
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now. 
http://p.sf.net/sfu/quest-d2dcopy1
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-install mailing list

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