FS#68418 - [postgresql] undefined symbol loading pg_trgm.so extension

Attached to Project: Arch Linux
Opened by wilkie (wilkie) - Monday, 26 October 2020, 00:33 GMT
Last edited by Doug Newgard (Scimmia) - Monday, 26 October 2020, 00:45 GMT
Task Type Bug Report
Category Packages: Testing
Status Closed
Assigned To No-one
Architecture All
Severity Medium
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description:

Attempt to load the pg_trgm.so library results in an error:

ERROR: could not load library "/usr/lib/postgresql/pg_trgm.so": /usr/lib/postgresql/pg_trgm.so: undefined symbol: pg_number_of_ones

Prevents some projects from being able to create databases, such as peertube and apparently gitlab (see linked issue on that package)

Additional info:
* package version(s): 12.3 through 12.4-1
* related to: [gitlab]: https://bugs.archlinux.org/task/64601

Steps to reproduce:

Attempt to enable the trgm extension on an existing database:

sudo -u postgres psql -c "CREATE EXTENSION pg_trgm;" my_db
This task depends upon

Closed by  Doug Newgard (Scimmia)
Monday, 26 October 2020, 00:45 GMT
Reason for closing:  Not a bug
Comment by wilkie (wilkie) - Monday, 26 October 2020, 00:43 GMT
Completely rebuilding my database does seem to fix this somehow.

Loading...