Jira (PDB-4445) puppetdb hangs on first start after installation

[Daniel Krämer]

Title: Message Title

Daniel Krämer created an issue   PuppetDB / PDB-4445 puppetdb hangs on first start after installation Issue Type: Bug Affects Versions: PDB 5.2.8, PDB 5.1.3 Assignee: Unassigned Components: PuppetDB Created: 2019/06/26 6:25 AM Priority: Major Reporter: Daniel Krämer Distri: Debian 9 Packages from: http://apt.puppetlabs.com/ stretch puppet5 I just try to install and start puppetdb in a virtual machine right after i installed puppetserver. On first start of puppetdb it just hangs. Log: [...] 2019-06-26 13:08:12,575 INFO [p.p.s.migrate] Applying database migration version 64 2019-06-26 13:08:12,576 INFO [p.p.s.migrate] [1/8] Cleaning up unreferenced facts... 2019-06-26 13:08:12,580 INFO [p.p.s.migrate] [2/8] Creating new fact storage tables... 2019-06-26 13:08:12,589 INFO [p.p.s.migrate] [3/8] Copying unique fact values into fact_values 2019-06-26 13:08:12,592 INFO [p.p.s.migrate] [4/8] Reconstructing facts to refer to fact_values... 2019-06-26 13:08:12,596 INFO [p.p.s.migrate] [5/8] Cleaning up duplicate null values... 2019-06-26 13:08:12,598 INFO [p.p.s.migrate] [6/8] Computing fact value hashes... 2019-06-26 13:08:12,600 INFO [p.p.s.migrate] [7/8] Indexing fact_values table... 2019-06-26 13:08:12,614 INFO [p.p.s.migrate] [8/8] Indexing facts table... 2019-06-26 13:08:12,626 INFO [p.p.s.migrate] Applied database migration version 64 in 51 ms 2019-06-26 13:08:12,627 INFO [p.p.s.migrate] Applying database migration version 65   ==> /var/log/postgresql/postgresql-10-main.log <== 2019-06-26 13:08:12.633 GMT [3434] puppetdb@puppetdb ERROR: relation "resource_events_status_for_corrective_change_idx" already exists 2019-06-26 13:08:12.633 GMT [3434] puppetdb@puppetdb STATEMENT: alter table resource_events alter column status type text, alter column property type text, alter column containing_class type text, alter column file type text   ==> /var/log/puppetlabs/puppetdb/puppetdb.log <== 2019-06-26 13:08:12,644 ERROR [p.p.s.migrate] Caught SQLException during migration java.sql.BatchUpdateException: Batch entry 1 alter table resource_events alter column status type text, alter column property type text, alter column containing_class type text, alter column file type text 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   [...]   clojure.core.async.impl.channels.ManyToManyChannel$fn__17042$fn__17043.invoke(channels.clj:95) at clojure.lang.AFn.run(AFn.java:22) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2019-06-26 13:08:12,667 INFO [p.t.internal] Shutting down due to JVM shutdown hook. 2019-06-26 13:08:12,670 INFO [p.t.internal] Beginning shutdown sequence   Tried installation with module puppetlabs-puppetdb and by hand with instructions from https://puppet.com/docs/puppetdb/5.1/install_from_packages.html https://puppet.com/docs/puppetdb/5.1/configure.html#using-postgresql   Add Comment   This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- 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 puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. 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.314168.1561555538000.61652.1561555560475%40Atlassian.JIRA. For more options, visit https://groups.google.com/d/optout.