Jira (PDB-2951) Handle missing postgresql-contrib gracefully
Title: Message Title Morgan Rhodes updated an issue PuppetDB / PDB-2951 Handle missing postgresql-contrib gracefully Change By: Morgan Rhodes Sprint: Release Engineering Hopper Add Comment This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.146351.1470867113000.163860.1615490700460%40Atlassian.JIRA.
Jira (PDB-2951) Handle missing postgresql-contrib gracefully
Title: Message Title Zachary Kent updated an issue PuppetDB / PDB-2951 Handle missing postgresql-contrib gracefully Change By: Zachary Kent Sprint: Release Engineering Hopper Add Comment This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.146351.1470867113000.162694.1615408441032%40Atlassian.JIRA.
Jira (PDB-2951) Handle missing postgresql-contrib gracefully
Title: Message Title Zachary Kent updated an issue PuppetDB / PDB-2951 Handle missing postgresql-contrib gracefully Change By: Zachary Kent Sprint: Add Comment This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.146351.1470867113000.162659.1615408381304%40Atlassian.JIRA.
Jira (PDB-2951) Handle missing postgresql-contrib gracefully
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-2951 Handle missing postgresql-contrib gracefully Change By: Austin Blatt Fix Version/s: PDB 6.0.1 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. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-2951) Handle missing postgresql-contrib gracefully
Title: Message Title Zachary Kent updated an issue PuppetDB / PDB-2951 Handle missing postgresql-contrib gracefully Change By: Zachary Kent Fix Version/s: PDB 5.2.5 Fix Version/s: PDB 5.2.6 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. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-2951) Handle missing postgresql-contrib gracefully
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-2951 Handle missing postgresql-contrib gracefully Change By: Austin Blatt Fix Version/s: PDB 5.2.5 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. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-2951) Handle missing postgresql-contrib gracefully
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-2951 Handle missing postgresql-contrib gracefully We added FAQ docs describing the error and how to fix it. Change By: Austin Blatt Release Notes: Not Needed 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. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-2951) Handle missing postgresql-contrib gracefully
Title: Message Title Austin Blatt commented on PDB-2951 Re: Handle missing postgresql-contrib gracefully I was able to reproduce the error via the following steps. Install postgres from source (following short version instructions to ensure contrib packages were not installed Start up PuppetDB from source (let all the migrations run) You should see the above warning about pg_trgm Stop PuppetDB Back in the postgres source navigate into the pg_trgm dir and run make install Use psql to run CREATE EXTENSION pg_trgm; DO NOT run puppetdb after the above step Back in the postgres pg_trgm folder run make uninstall Fire up PuppetDB, it should crash with a BatchUpdateException referencing java.sql.BatchUpdateException: Batch entry 0 CREATE INDEX fact_paths_path_trgm ON fact_paths USING gist (path gist_trgm_ops) was aborted. Add Comment This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93)
Jira (PDB-2951) Handle missing postgresql-contrib gracefully
Title: Message Title Austin Blatt assigned an issue to Austin Blatt PuppetDB / PDB-2951 Handle missing postgresql-contrib gracefully Change By: Austin Blatt Assignee: Austin Blatt 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. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-2951) Handle missing postgresql-contrib gracefully
Title: Message Title Rob Browning updated an issue PuppetDB / PDB-2951 Handle missing postgresql-contrib gracefully Change By: Rob Browning Sprint: Hopper/Triage 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. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-2951) Handle missing postgresql-contrib gracefully
Title: Message Title Wyatt Alt created an issue PuppetDB / PDB-2951 Handle missing postgresql-contrib gracefully Issue Type: Bug Assignee: Unassigned Created: 2016/08/10 3:11 PM Priority: Normal Reporter: Wyatt Alt A user encountered this error on Centos 6.7 while upgrading to 4.2.0 from the previous version: http://pastebin.com/UEB5YSxQ looking at the postgres logs showed 14:54 From postgres.. < 2016-08-10 14:03:04.523 PDT >ERROR: could not access file "$libdir/pg_trgm": No such file or directory 14:54 < 2016-08-10 14:03:04.523 PDT >STATEMENT: CREATE INDEX fact_values_string_trgm ON fact_values USING gin (value_string gin_tr 14:54 gm_ops) Installing postgresql-contrib resolved it, but we need to make sure we're handling the case where that package is missing and also figure out why (sutils/pg-extension? "pg_trgm") returned truthy. Add Comment
