Jira (PDB-1363) Puppetdb broken because of forced check for tables in public schema

[Chuck Schweizer (JIRA)]

Title: Message Title

Chuck Schweizer commented on PDB-1363   Re: Puppetdb broken because of forced check for tables in public schema Postgres Error 2015-03-31 22:50:37 UTC|puppetdb|39489|CREATE TABLE|10.0.0.50|puppet ERROR: relation "certnames" already exists 2015-03-31 22:50:37 UTC|puppetdb|39489|CREATE TABLE|10.0.0.50|puppet STATEMENT: CREATE TABLE certnames (name TEXT PRIMARY KEY) PuppetDB Error 2015-03-31 22:39:57,606 INFO [c.p.p.s.migrate] Applying database migration version 1 2015-03-31 22:39:57,622 ERROR [c.p.p.s.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) ~[puppetdb.jar:na] PuppetDB debug 2015-03-31 23:09:24,987 DEBUG [main] [c.j.b.PreparedStatementHandle] SELECT table_name FROM information_schema.tables WHERE LOWER(table_schema) = 'public' 2015-03-31 23:09:25,025 DEBUG [main] [c.j.b.PreparedStatementHandle] SELECT table_name FROM information_schema.tables WHERE LOWER(table_schema) = 'public' 2015-03-31 23:09:25,030 INFO [main] [c.p.p.s.migrate] Applying database migration version 1 Postgres tables exist List of relations Schema | Name | Type | Owner | Size | Description --------+-----------------------+-------+------------+------------+------------- puppet | catalog_resources | table | puppetdb | 8192 bytes | puppet | catalogs | table | puppetdb | 8192 bytes | puppet | certnames | table | puppetdb | 3024 kB | puppet | edges | table | puppetdb | 8192 bytes | puppet | environments | table | puppetdb | 16 kB | puppet | fact_paths | table | puppetdb | 168 kB | puppet | fact_values | table | puppetdb | 216 MB | puppet | facts | table | puppetdb | 591 MB | puppet | factsets | table | puppetdb | 6176 kB | puppet | latest_reports | table | puppetdb | 8192 bytes | puppet | report_statuses | table | puppetdb | 8192 bytes | puppet | reports | table | puppetdb | 8192 bytes | puppet | resource_events | table | puppetdb | 8192 bytes | puppet | resource_params | table | puppetdb | 8192 bytes | puppet | resource_params_cache | table | puppetdb | 8192 bytes | puppet | schema_migrations | table | puppetdb | 40 kB | puppet | value_types | table | puppetdb | 40 kB | (17 rows) Add Comment   This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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 http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.