Jira (PDB-3840) Add additional cleanup of the facts table during migrations

Title: Message Title

Rob Browning commented on

For future reference, when this issue causes a crash, it should produce an error in the log that looks like this:

      ERROR [p.p.s.migrate] Caught SQLException during migration

      java.sql.BatchUpdateException: Batch entry 3 ALTER TABLE facts ADD CONSTRAINT fact_path_id_fk

      FOREIGN KEY (fact_path_id)

      REFERENCES fact_paths(id) was aborted. Call getNextException to see the cause.

      at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:133)

      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2004)

      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:360)

      at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:1019)

      at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125)

      at com.zaxxer.hikari.pool.HikariProxyStatement.executeBatch(HikariProxyStatement.java)

      at clojure.java.jdbc$execute_batch.invokeStatic(jdbc.clj:439)

      at clojure.java.jdbc$execute_batch.invoke(jdbc.clj:432)

      at clojure.java.jdbc$db_do_commands$fn__21859.invoke(jdbc.clj:748)

      at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:662)

      at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:598)

      at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:611)

      at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:598)

      at clojure.java.jdbc$db_do_commands.invokeStatic(jdbc.clj:747)

      at clojure.java.jdbc$db_do_commands.invoke(jdbc.clj:732)

      at puppetlabs.puppetdb.jdbc$do_commands.invokeStatic(jdbc.clj:38)

      at puppetlabs.puppetdb.jdbc$do_commands.doInvoke(jdbc.clj:33)

      at clojure.lang.RestFn.invoke(RestFn.java:512)

      at puppetlabs.puppetdb.scf.migrate$rededuplicate_facts.invokeStatic(migrate.clj:1433)

      at puppetlabs.puppetdb.scf.migrate$rededuplicate_facts.invoke(migrate.clj:1315)

      at puppetlabs.puppetdb.scf.migrate$migrate_BANG_$fn__36253$fn__36255$fn__36257.invoke(migrate.clj:1616)

This message was sent by Atlassian JIRA

--
You received this message because you are subscribed to the Google Groups "Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/puppet-bugs.
To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.235772.1518051868000.22291.1559062080703%40Atlassian.JIRA.
For more options, visit https://groups.google.com/d/optout.

Reply via email to