FS#64601 - [gitlab]

Attached to Project: Community Packages
Opened by Jonas Heinrich (onny) - Thursday, 21 November 2019, 19:49 GMT
Last edited by Antonio Rojas (arojas) - Friday, 22 November 2019, 11:16 GMT
Task Type Bug Report
Category Packages
Status Closed
Assigned To No-one
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 1
Private No

Details

Description:
Since postgresql update yesterday (20.11.19), Gitlab is unable to execute database queries with PostgreSQL backend.

This is the error in the production log file:

ActiveRecord::StatementInvalid: PG::InternalError: ERROR: could not load library \"/usr/lib/postgresql/pg_trgm.so\": /usr/lib/postgresql/pg_trgm.so: undefined symbol: pg_number_of_ones

Complete:

{"method":"PUT","path":"/onny/py-piradio/issues/11.json","format":"json","controller":"Projects::IssuesController","action":"update","status":500,"error":"ActiveRecord::StatementInvalid: PG::InternalError: ERROR: could not load library \"/usr/lib/postgresql/pg_trgm.so\": /usr/lib/postgresql/pg_trgm.so: undefined symbol: pg_number_of_ones\n: UPDATE \"issues\" SET \"updated_at\" = $1, \"state\" = $2, \"closed_at\" = $3, \"state_id\" = $4 WHERE \"issues\".\"id\" = $5","duration":147.91,"view":0.0,"db":47.66,"time":"2019-11-21T19:47:40.371Z","params":[{"key":"issue","value":{"state_event":"close"}},{"key":"namespace_id","value":"onny"},{"key":"project_id","value":"py-piradio"},{"key":"id","value":"11"}],"remote_ip":"46.5.3.126","user_id":2,"username":"onny","ua":"Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0","queue_duration":null,"correlation_id":"30AB3YynG58","cpu_s":0.12081193199999962}

I guess Gitlab has to be recomplied after postgresql upgrade.

Additional info:
* package version(s): 12.4.2-2
* config and/or log files etc.
* link to upstream bug report, if any

Steps to reproduce:
This task depends upon

Closed by  Antonio Rojas (arojas)
Friday, 22 November 2019, 11:16 GMT
Reason for closing:  Not a bug
Comment by Jonas Heinrich (onny) - Friday, 22 November 2019, 11:12 GMT
Sorry it was an issue with the database backend. This issue can be closed.

Loading...