Sorry, you can disregard. It turns out the database was screwed up before the upgrade. This was just on my failover server so a purge and reinitialization took care of it.
On Tuesday, April 22, 2014 6:40:45 PM UTC-4, Ken Barber wrote: > > We didn't actually provide any database schema migration for > 1.6.2->1.6.3. This in fact looks like its trying to migrate from > scratch as if you have no tables loaded, this is done by looking at > the schema_migrations table to work out what needs to be updated. > > So I guess the question is, what does your schema_migrations table > look like? Here is an example of how to get a hold of that info: > https://gist.github.com/kbarber/11196805 > > ken. > > > On Tue, Apr 22, 2014 at 11:10 PM, David Mesler > <[email protected]<javascript:>> > wrote: > > 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] <javascript:>. > > 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. > -- 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/ad32c746-e98d-463d-9e6c-b63a1c78cbb7%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
