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 > <david....@gmail.com<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 puppet-users...@googlegroups.com <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 puppet-users+unsubscr...@googlegroups.com. 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.
