I'm having an issue updating from 1.6.2.
2014-04-22 17:00:33,043 INFO [main] [cli.services] PuppetDB version 1.6.3
2014-04-22 17:00:33,124 ERROR [main] [scf.migrate] Caught SQLException
during migration
java.sql.BatchUpdateException: Batch entry 0 CREATE TABLE certnames (name
TEXT PRIMARY KEY) was aborted. Call getNextException to see the cause.
at
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2746)
at
org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:457)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1887)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893)
at
com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469)
at clojure.java.jdbc$do_commands$fn__2182.invoke(jdbc.clj:188)
at
clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223)
at clojure.java.jdbc$do_commands.doInvoke(jdbc.clj:187)
at clojure.lang.RestFn.invoke(RestFn.java:408)
at clojure.java.jdbc$create_table.doInvoke(jdbc.clj:236)
at clojure.lang.RestFn.invoke(RestFn.java:423)
at
com.puppetlabs.puppetdb.scf.migrate$initialize_store.invoke(migrate.clj:95)
at
com.puppetlabs.puppetdb.scf.migrate$migrate_BANG_$fn__12703$fn__12716.invoke(migrate.clj:740)
at
com.puppetlabs.puppetdb.scf.migrate$migrate_BANG_$fn__12703.invoke(migrate.clj:739)
at
clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:204)
at
com.puppetlabs.puppetdb.scf.migrate$migrate_BANG_.invoke(migrate.clj:736)
at
com.puppetlabs.puppetdb.cli.services$_main$fn__12813.invoke(services.clj:274)
at
clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186)
at
com.puppetlabs.puppetdb.cli.services$_main.doInvoke(services.clj:272)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at clojure.lang.Var.invoke(Var.java:419)
at clojure.lang.AFn.applyToHelper(AFn.java:163)
at clojure.lang.Var.applyTo(Var.java:532)
at clojure.core$apply.invoke(core.clj:617)
at com.puppetlabs.puppetdb.core$run_command.invoke(core.clj:87)
at com.puppetlabs.puppetdb.core$_main.doInvoke(core.clj:95)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at com.puppetlabs.puppetdb.core.main(Unknown Source)
2014-04-22 17:00:33,125 ERROR [main] [scf.migrate] Unravelled exception
org.postgresql.util.PSQLException: ERROR: relation "certnames" already
exists
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893)
at
com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469)
at clojure.java.jdbc$do_commands$fn__2182.invoke(jdbc.clj:188)
at
clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223)
at clojure.java.jdbc$do_commands.doInvoke(jdbc.clj:187)
at clojure.lang.RestFn.invoke(RestFn.java:408)
at clojure.java.jdbc$create_table.doInvoke(jdbc.clj:236)
at clojure.lang.RestFn.invoke(RestFn.java:423)
at
com.puppetlabs.puppetdb.scf.migrate$initialize_store.invoke(migrate.clj:95)
at
com.puppetlabs.puppetdb.scf.migrate$migrate_BANG_$fn__12703$fn__12716.invoke(migrate.clj:740)
at
com.puppetlabs.puppetdb.scf.migrate$migrate_BANG_$fn__12703.invoke(migrate.clj:739)
at
clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:204)
at
com.puppetlabs.puppetdb.scf.migrate$migrate_BANG_.invoke(migrate.clj:736)
at
com.puppetlabs.puppetdb.cli.services$_main$fn__12813.invoke(services.clj:274)
at
clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186)
at
com.puppetlabs.puppetdb.cli.services$_main.doInvoke(services.clj:272)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at clojure.lang.Var.invoke(Var.java:419)
at clojure.lang.AFn.applyToHelper(AFn.java:163)
at clojure.lang.Var.applyTo(Var.java:532)
at clojure.core$apply.invoke(core.clj:617)
at com.puppetlabs.puppetdb.core$run_command.invoke(core.clj:87)
at com.puppetlabs.puppetdb.core$_main.doInvoke(core.clj:95)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at com.puppetlabs.puppetdb.core.main(Unknown Source)
2014-04-22 17:00:33,128 INFO [Thread-4] [cli.services] Shutdown request
received; puppetdb exiting.
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/7989b0b9-458f-407f-a240-70364072c826%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
