Jira (PDB-2951) Handle missing postgresql-contrib gracefully

Wyatt Alt (JIRA)

unread,

Aug 10, 2016, 6:12:04 PM8/10/16

to puppe...@googlegroups.com

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 <jdehnert> 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 <jdehnert> < 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 <jdehnert> 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

This message was sent by Atlassian JIRA (v6.4.13#64028-sha1:b7939e9)

Rob Browning (JIRA)

unread,

May 7, 2018, 4:59:02 PM5/7/18

to puppe...@googlegroups.com

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)

Austin Blatt (JIRA)

unread,

Jul 27, 2018, 2:41:04 PM7/27/18

to puppe...@googlegroups.com

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

Austin Blatt (JIRA)

unread,

Aug 1, 2018, 3:01:04 PM8/1/18

to puppe...@googlegroups.com

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)
1. You should see the above warning about pg_trgm
Stop PuppetDB
Back in the postgres source navigate into the pg_trgm dir and run
1. make install
Use psql to run CREATE EXTENSION pg_trgm;
1. 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.