Upgrade from OpenNMS 19.0.0 to 19.0.0-1 Fails
Vance Baker <[email protected]> Thu, 16 Feb 2017 08:56:59 -0500
| Newsgroups | gmane.network.opennms.install |
|---|---|
| Message-ID | <CAL7Mk_Pu+H7q8Vg0BfnoXaJm3fEVYv0i6_LLwhQQR+QqJfdKrQ@mail.gmail.com> |
--===============9168850221956065834==
Content-Type: multipart/alternative; boundary=001a114df80acf30ca0548a62bf5
--001a114df80acf30ca0548a62bf5
Content-Type: text/plain; charset=UTF-8
After applying RPMs to a CENTOS server, the following database
reinitialization errors occur.
Please offer some guidance for correction.
Thank you.
[root@sentry opennms]# /opt/opennms/bin/install -dis
==============================================================================
OpenNMS Installer
==============================================================================
Configures PostgreSQL tables, users, and other miscellaneous settings.
DEBUG: Platform is IPv6 ready: true
- searching for libjicmp.so:
- trying to load /usr/lib64/libjicmp.so: OK
- searching for libjicmp6.so:
- trying to load /usr/lib64/libjicmp6.so: OK
- searching for libjrrd.so:
- trying to load /usr/lib64/libjrrd.so: NO
- trying to load /usr/lib64/libjrrd.so: NO
- trying to load /libjrrd.so: NO
- trying to load /opt/opennms/lib/libjrrd.so: NO
- trying to load /opt/opennms/lib/linux64/libjrrd.so: NO
- trying to load /usr/java/packages/lib/amd64/libjrrd.so: NO
- trying to load /usr/lib64/libjrrd.so: NO
- trying to load /lib64/libjrrd.so: NO
- trying to load /lib/libjrrd.so: NO
- trying to load /usr/lib/libjrrd.so: NO
- trying to load /usr/lib/jni/libjrrd.so: NO
- trying to load /usr/lib/libjrrd.so: NO
- trying to load /usr/local/lib/libjrrd.so: NO
- trying to load /opt/NMSjicmp/lib/32/libjrrd.so: NO
- trying to load /opt/NMSjicmp/lib/64/libjrrd.so: NO
- trying to load /opt/NMSjicmp6/lib/32/libjrrd.so: NO
- trying to load /opt/NMSjicmp6/lib/64/libjrrd.so: NO
- Failed to load the optional jrrd library.
- This error is not fatal, since jrrd is only required for optional
features.
- For more information, see http://www.opennms.org/index.php/jrrd
- searching for libjrrd2.so:
- trying to load /usr/lib64/libjrrd2.so: NO
- trying to load /usr/lib64/libjrrd2.so: NO
- trying to load /libjrrd2.so: NO
- trying to load /opt/opennms/lib/libjrrd2.so: NO
- trying to load /opt/opennms/lib/linux64/libjrrd2.so: NO
- trying to load /usr/java/packages/lib/amd64/libjrrd2.so: NO
- trying to load /usr/lib64/libjrrd2.so: NO
- trying to load /lib64/libjrrd2.so: NO
- trying to load /lib/libjrrd2.so: NO
- trying to load /usr/lib/libjrrd2.so: NO
- trying to load /usr/lib/jni/libjrrd2.so: NO
- trying to load /usr/lib/libjrrd2.so: NO
- trying to load /usr/local/lib/libjrrd2.so: NO
- trying to load /opt/NMSjicmp/lib/32/libjrrd2.so: NO
- trying to load /opt/NMSjicmp/lib/64/libjrrd2.so: NO
- trying to load /opt/NMSjicmp6/lib/32/libjrrd2.so: NO
- trying to load /opt/NMSjicmp6/lib/64/libjrrd2.so: NO
- Failed to load the optional jrrd2 library.
- This error is not fatal, since jrrd2 is only required for optional
features.
- For more information, see http://www.opennms.org/index.php/jrrd2
04:33:52.261 [Main] WARN org.opennms.install.Installer - Could not create
file: /opt/opennms/etc/libraries.properties
- using SQL directory... /opt/opennms/etc
- using create.sql... /opt/opennms/etc/create.sql
04:33:52.267 [Main] INFO org.opennms.core.schema.Migrator - validating
database version
* using 'postgres' as the PostgreSQL user for OpenNMS
* using 'opennms' as the PostgreSQL database name for OpenNMS
04:33:52.357 [Main] INFO org.opennms.core.schema.Migrator - validating
database version
04:33:52.366 [Main] INFO org.opennms.core.schema.Migrator - adding
PL/PgSQL support to the database, if necessary
04:33:52.371 [Main] INFO org.opennms.core.schema.Migrator - PL/PgSQL call
handler exists
04:33:52.372 [Main] INFO org.opennms.core.schema.Migrator - PL/PgSQL
language exists
- checking if database "opennms" is unicode... ALREADY UNICODE
- Checking for old import files in /opt/opennms/etc... DONE
- Running migration for changelog: URL
[jar:file:/opt/opennms/lib/org.opennms.core.schema-19.0.0-liquibase.jar!/changelog.xml]
INFO 2/16/17 4:33 AM:liquibase: Successfully acquired change log lock
INFO 2/16/17 4:33 AM:liquibase: Reading from databasechangelog
INFO 2/16/17 4:33 AM:liquibase: Reading from databasechangelog
SEVERE 2/16/17 4:33 AM:liquibase: Change Set
19.0.0/changelog.xml::19.0.0-insert-default-monitoringlocation::seth
failed. Error: Error executing SQL INSERT INTO monitoringlocations (id,
monitoringarea) VALUES ('localhost', 'localhost'): ERROR: duplicate key
value violates unique constraint "monitoringlocations_pkey"
Detail: Key (id)=(localhost) already exists.
liquibase.exception.DatabaseException: Error executing SQL INSERT INTO
monitoringlocations (id, monitoringarea) VALUES ('localhost', 'localhost'):
ERROR: duplicate key value violates unique constraint
"monitoringlocations_pkey"
Detail: Key (id)=(localhost) already exists.
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at
liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at
liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
at
liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
at
liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
at
liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at liquibase.Liquibase.update(Liquibase.java:114)
at org.opennms.core.schema.Migrator.migrate(Migrator.java:477)
at org.opennms.install.Installer.install(Installer.java:273)
at org.opennms.install.Installer.main(Installer.java:989)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.opennms.bootstrap.Bootstrap$4.run(Bootstrap.java:460)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
violates unique constraint "monitoringlocations_pkey"
Detail: Key (id)=(localhost) already exists.
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)
at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:305)
at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:291)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:269)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:265)
at
liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
... 16 more
INFO 2/16/17 4:33 AM:liquibase: Successfully released change log lock
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.opennms.bootstrap.Bootstrap$4.run(Bootstrap.java:460)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.opennms.core.schema.MigrationException: unable to migrate
the database
at org.opennms.core.schema.Migrator.migrate(Migrator.java:479)
at org.opennms.install.Installer.install(Installer.java:273)
at org.opennms.install.Installer.main(Installer.java:989)
... 6 more
Caused by: liquibase.exception.MigrationFailedException: Migration failed
for change set
19.0.0/changelog.xml::19.0.0-insert-default-monitoringlocation::seth:
Reason: liquibase.exception.DatabaseException: Error executing SQL
INSERT INTO monitoringlocations (id, monitoringarea) VALUES ('localhost',
'localhost'): ERROR: duplicate key value violates unique constraint
"monitoringlocations_pkey"
Detail: Key (id)=(localhost) already exists.:
Caused By: Error executing SQL INSERT INTO monitoringlocations
(id, monitoringarea) VALUES ('localhost', 'localhost'): ERROR: duplicate
key value violates unique constraint "monitoringlocations_pkey"
Detail: Key (id)=(localhost) already exists.:
Caused By: ERROR: duplicate key value violates unique constraint
"monitoringlocations_pkey"
Detail: Key (id)=(localhost) already exists.
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
at
liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
at
liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at liquibase.Liquibase.update(Liquibase.java:114)
at org.opennms.core.schema.Migrator.migrate(Migrator.java:477)
... 8 more
Caused by: liquibase.exception.DatabaseException: Error executing SQL
INSERT INTO monitoringlocations (id, monitoringarea) VALUES ('localhost',
'localhost'): ERROR: duplicate key value violates unique constraint
"monitoringlocations_pkey"
Detail: Key (id)=(localhost) already exists.
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at
liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at
liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
at
liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
... 12 more
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
violates unique constraint "monitoringlocations_pkey"
Detail: Key (id)=(localhost) already exists.
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)
at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:305)
at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:291)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:269)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:265)
at
liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
... 16 more
--001a114df80acf30ca0548a62bf5
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><div><div>After applying RPMs to a CENTOS server, the foll=
owing database reinitialization errors occur.=C2=A0 <br><br></div>Please of=
fer some guidance for correction.<br><br></div>Thank you.<br><br><div><div>=
<div><br><br>[root@sentry opennms]# /opt/opennms/bin/install -dis<br>=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D<br>OpenNMS Installer<br>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<br><br>Configures PostgreSQL tables=
, users, and other miscellaneous settings.<br><br>DEBUG: Platform is IPv6 r=
eady: true<br>- searching for libjicmp.so:<br>=C2=A0 - trying to load /usr/=
lib64/libjicmp.so: OK<br>- searching for libjicmp6.so:<br>=C2=A0 - trying t=
o load /usr/lib64/libjicmp6.so: OK<br>- searching for libjrrd.so:<br>=C2=A0=
- trying to load /usr/lib64/libjrrd.so: NO<br>=C2=A0 - trying to load /usr=
/lib64/libjrrd.so: NO<br>=C2=A0 - trying to load /libjrrd.so: NO<br>=C2=A0 =
- trying to load /opt/opennms/lib/libjrrd.so: NO<br>=C2=A0 - trying to load=
/opt/opennms/lib/linux64/libjrrd.so: NO<br>=C2=A0 - trying to load /usr/ja=
va/packages/lib/amd64/libjrrd.so: NO<br>=C2=A0 - trying to load /usr/lib64/=
libjrrd.so: NO<br>=C2=A0 - trying to load /lib64/libjrrd.so: NO<br>=C2=A0 -=
trying to load /lib/libjrrd.so: NO<br>=C2=A0 - trying to load /usr/lib/lib=
jrrd.so: NO<br>=C2=A0 - trying to load /usr/lib/jni/libjrrd.so: NO<br>=C2=
=A0 - trying to load /usr/lib/libjrrd.so: NO<br>=C2=A0 - trying to load /us=
r/local/lib/libjrrd.so: NO<br>=C2=A0 - trying to load /opt/NMSjicmp/lib/32/=
libjrrd.so: NO<br>=C2=A0 - trying to load /opt/NMSjicmp/lib/64/libjrrd.so: =
NO<br>=C2=A0 - trying to load /opt/NMSjicmp6/lib/32/libjrrd.so: NO<br>=C2=
=A0 - trying to load /opt/NMSjicmp6/lib/64/libjrrd.so: NO<br>- Failed to lo=
ad the optional jrrd library.<br>=C2=A0 - This error is not fatal, since jr=
rd is only required for optional features.<br>=C2=A0 - For more information=
, see <a href=3D"http://www.opennms.org/index.php/jrrd">http://www.opennms.=
org/index.php/jrrd</a><br>- searching for libjrrd2.so:<br>=C2=A0 - trying t=
o load /usr/lib64/libjrrd2.so: NO<br>=C2=A0 - trying to load /usr/lib64/lib=
jrrd2.so: NO<br>=C2=A0 - trying to load /libjrrd2.so: NO<br>=C2=A0 - trying=
to load /opt/opennms/lib/libjrrd2.so: NO<br>=C2=A0 - trying to load /opt/o=
pennms/lib/linux64/libjrrd2.so: NO<br>=C2=A0 - trying to load /usr/java/pac=
kages/lib/amd64/libjrrd2.so: NO<br>=C2=A0 - trying to load /usr/lib64/libjr=
rd2.so: NO<br>=C2=A0 - trying to load /lib64/libjrrd2.so: NO<br>=C2=A0 - tr=
ying to load /lib/libjrrd2.so: NO<br>=C2=A0 - trying to load /usr/lib/libjr=
rd2.so: NO<br>=C2=A0 - trying to load /usr/lib/jni/libjrrd2.so: NO<br>=C2=
=A0 - trying to load /usr/lib/libjrrd2.so: NO<br>=C2=A0 - trying to load /u=
sr/local/lib/libjrrd2.so: NO<br>=C2=A0 - trying to load /opt/NMSjicmp/lib/3=
2/libjrrd2.so: NO<br>=C2=A0 - trying to load /opt/NMSjicmp/lib/64/libjrrd2.=
so: NO<br>=C2=A0 - trying to load /opt/NMSjicmp6/lib/32/libjrrd2.so: NO<br>=
=C2=A0 - trying to load /opt/NMSjicmp6/lib/64/libjrrd2.so: NO<br>- Failed t=
o load the optional jrrd2 library.<br>=C2=A0 - This error is not fatal, sin=
ce jrrd2 is only required for optional features.<br>=C2=A0 - For more infor=
mation, see <a href=3D"http://www.opennms.org/index.php/jrrd2">http://www.o=
pennms.org/index.php/jrrd2</a><br>04:33:52.261 [Main] WARN=C2=A0 org.opennm=
s.install.Installer - Could not create file: /opt/opennms/etc/libraries.pro=
perties<br>- using SQL directory... /opt/opennms/etc<br>- using create.sql.=
.. /opt/opennms/etc/create.sql<br>04:33:52.267 [Main] INFO=C2=A0 org.opennm=
s.core.schema.Migrator - validating database version<br>* using 'postgr=
es' as the PostgreSQL user for OpenNMS<br>* using 'opennms' as =
the PostgreSQL database name for OpenNMS<br>04:33:52.357 [Main] INFO=C2=A0 =
org.opennms.core.schema.Migrator - validating database version<br>04:33:52.=
366 [Main] INFO=C2=A0 org.opennms.core.schema.Migrator - adding PL/PgSQL su=
pport to the database, if necessary<br>04:33:52.371 [Main] INFO=C2=A0 org.o=
pennms.core.schema.Migrator - PL/PgSQL call handler exists<br>04:33:52.372 =
[Main] INFO=C2=A0 org.opennms.core.schema.Migrator - PL/PgSQL language exis=
ts<br>- checking if database "opennms" is unicode... ALREADY UNIC=
ODE<br>- Checking for old import files in /opt/opennms/etc... DONE<br>- Run=
ning migration for changelog: URL [jar:file:/opt/opennms/lib/org.opennms.co=
re.schema-19.0.0-liquibase.jar!/changelog.xml]<br>INFO 2/16/17 4:33 AM:liqu=
ibase: Successfully acquired change log lock<br>INFO 2/16/17 4:33 AM:liquib=
ase: Reading from databasechangelog<br>INFO 2/16/17 4:33 AM:liquibase: Read=
ing from databasechangelog<br>SEVERE 2/16/17 4:33 AM:liquibase: Change Set =
19.0.0/changelog.xml::19.0.0-insert-default-monitoringlocation::seth failed=
.=C2=A0 Error: Error executing SQL INSERT INTO monitoringlocations (id, mon=
itoringarea) VALUES ('localhost', 'localhost'): ERROR: dupl=
icate key value violates unique constraint "monitoringlocations_pkey&q=
uot;<br>=C2=A0 Detail: Key (id)=3D(localhost) already exists.<br>liquibase.=
exception.DatabaseException: Error executing SQL INSERT INTO monitoringloca=
tions (id, monitoringarea) VALUES ('localhost', 'localhost'=
): ERROR: duplicate key value violates unique constraint "monitoringlo=
cations_pkey"<br>=C2=A0 Detail: Key (id)=3D(localhost) already exists.=
<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.executor.jvm.Jd=
bcExecutor.execute(JdbcExecutor.java:62)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.ja=
va:104)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.database=
.AbstractDatabase.execute(AbstractDatabase.java:1091)<br>=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.database.AbstractDatabase.executeStat=
ements(AbstractDatabase.java:1075)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0 at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)<br>=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.changelog.visitor.Upda=
teVisitor.visit(UpdateVisitor.java:27)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.ja=
va:58)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.Liquibase=
.update(Liquibase.java:114)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 a=
t org.opennms.core.schema.Migrator.migrate(Migrator.java:477)<br>=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.opennms.install.Installer.install(=
Installer.java:273)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.op=
ennms.install.Installer.main(Installer.java:989)<br>=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ=
e Method)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at sun.reflect.Nati=
veMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br>=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at sun.reflect.DelegatingMethodAccessorIm=
pl.invoke(DelegatingMethodAccessorImpl.java:43)<br>=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0 at java.lang.reflect.Method.invoke(Method.java:497)<br>=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.opennms.bootstrap.Bootstr=
ap$4.run(Bootstrap.java:460)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
at java.lang.Thread.run(Thread.java:745)<br>Caused by: org.postgresql.util.=
PSQLException: ERROR: duplicate key value violates unique constraint "=
monitoringlocations_pkey"<br>=C2=A0 Detail: Key (id)=3D(localhost) alr=
eady exists.<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresq=
l.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:245=
8)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresql.core.v3.=
QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)<br>=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresql.core.v3.QueryExecutorIm=
pl.execute(QueryExecutorImpl.java:291)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.ja=
va:432)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresql.jdb=
c.PgStatement.execute(PgStatement.java:358)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgState=
ment.java:305)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgre=
sql.jdbc.PgStatement.executeCachedSql(PgStatement.java:291)<br>=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresql.jdbc.PgStatement.executeWi=
thFlags(PgStatement.java:269)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:265)<br>=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.executor.jvm.JdbcExecutor=
$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)<br>=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.executor.jvm.JdbcExecutor.ex=
ecute(JdbcExecutor.java:55)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 .=
.. 16 more<br>INFO 2/16/17 4:33 AM:liquibase: Successfully released change =
log lock<br>java.lang.reflect.InvocationTargetException<br>=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0 at sun.reflect.NativeMethodAccessorImpl.invoke0=
(Native Method)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at sun.reflec=
t.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br>=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at sun.reflect.DelegatingMethodAcce=
ssorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0 at java.lang.reflect.Method.invoke(Method.java:497=
)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.opennms.bootstrap.Bo=
otstrap$4.run(Bootstrap.java:460)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0 at java.lang.Thread.run(Thread.java:745)<br>Caused by: org.opennms.c=
ore.schema.MigrationException: unable to migrate the database<br>=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.opennms.core.schema.Migrator.migra=
te(Migrator.java:479)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.=
opennms.install.Installer.install(Installer.java:273)<br>=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0 at org.opennms.install.Installer.main(Installer.ja=
va:989)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ... 6 more<br>Caused =
by: liquibase.exception.MigrationFailedException: Migration failed for chan=
ge set 19.0.0/changelog.xml::19.0.0-insert-default-monitoringlocation::seth=
:<br>=C2=A0=C2=A0=C2=A0=C2=A0 Reason: liquibase.exception.DatabaseException=
: Error executing SQL INSERT INTO monitoringlocations (id, monitoringarea) =
VALUES ('localhost', 'localhost'): ERROR: duplicate key val=
ue violates unique constraint "monitoringlocations_pkey"<br>=C2=
=A0 Detail: Key (id)=3D(localhost) already exists.:<br>=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Caused By: Error executing SQL INSERT =
INTO monitoringlocations (id, monitoringarea) VALUES ('localhost', =
'localhost'): ERROR: duplicate key value violates unique constraint=
"monitoringlocations_pkey"<br>=C2=A0 Detail: Key (id)=3D(localho=
st) already exists.:<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0 Caused By: ERROR: duplicate key value violates unique constraint "=
monitoringlocations_pkey"<br>=C2=A0 Detail: Key (id)=3D(localhost) alr=
eady exists.<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.cha=
ngelog.ChangeSet.execute(ChangeSet.java:347)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVi=
sitor.java:27)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.c=
hangelog.ChangeLogIterator.run(ChangeLogIterator.java:58)<br>=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.Liquibase.update(Liquibase.java=
:114)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.opennms.core.sch=
ema.Migrator.migrate(Migrator.java:477)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 ... 8 more<br>Caused by: liquibase.exception.DatabaseException=
: Error executing SQL INSERT INTO monitoringlocations (id, monitoringarea) =
VALUES ('localhost', 'localhost'): ERROR: duplicate key val=
ue violates unique constraint "monitoringlocations_pkey"<br>=C2=
=A0 Detail: Key (id)=3D(localhost) already exists.<br>=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcEx=
ecutor.java:62)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.=
executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)<br>=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.database.AbstractDatabase.execute(=
AbstractDatabase.java:1091)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 a=
t liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.ja=
va:1075)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at liquibase.changel=
og.ChangeSet.execute(ChangeSet.java:317)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 ... 12 more<br>Caused by: org.postgresql.util.PSQLException: E=
RROR: duplicate key value violates unique constraint "monitoringlocati=
ons_pkey"<br>=C2=A0 Detail: Key (id)=3D(localhost) already exists.<br>=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresql.core.v3.QueryE=
xecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)<br>=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresql.core.v3.QueryExecutorIm=
pl.processResults(QueryExecutorImpl.java:2158)<br>=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0 at org.postgresql.core.v3.QueryExecutorImpl.execute(Quer=
yExecutorImpl.java:291)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at or=
g.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)<br>=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresql.jdbc.PgStatement.=
execute(PgStatement.java:358)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:305)<=
br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresql.jdbc.PgStat=
ement.executeCachedSql(PgStatement.java:291)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgState=
ment.java:269)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgre=
sql.jdbc.PgStatement.execute(PgStatement.java:265)<br>=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0 at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatem=
entCallback.doInStatement(JdbcExecutor.java:92)<br>=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecu=
tor.java:55)<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ... 16 more<br><=
br></div></div></div></div>
--001a114df80acf30ca0548a62bf5--
--===============9168850221956065834==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
--===============9168850221956065834==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
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
--===============9168850221956065834==--