Community Packages

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#52116 - [gitlab] 500 error due to postgresql version mismatch

Attached to Project: Community Packages
Opened by Tiago Peixoto (count0) - Sunday, 11 December 2016, 17:33 GMT
Last edited by Doug Newgard (Scimmia) - Sunday, 11 December 2016, 18:25 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 0
Private No

Details

With the current version 8.14.4-1 I get a 500 error. When inspecting production.log I see:

Started GET "/count0/graph-tool/issues.atom?private_token=[FILTERED]" for 74.50.54.54 at 2016-12-11 00:09:12 +0100
Processing by Projects::IssuesController#index as ATOM
Parameters: {"private_token"=>"[FILTERED]", "namespace_id"=>"count0", "project_id"=>"graph-tool"}
Completed 500 Internal Server Error in 8ms (ActiveRecord: 2.6ms)

ActiveRecord::StatementInvalid (PG::InternalError: ERROR: incompatible library "/usr/lib/postgresql/pg_trgm.so": version mismatch
DETAIL: Server is version 9.5, library is version 9.6.
: UPDATE "users" SET "last_sign_in_at" = $1, "current_sign_in_at" = $2, "sign_in_count" = $3, "updated_at" = $4 WHERE "users"."id" = $5):
config/initializers/ar_monkey_patch.rb:16:in `_update_record'
app/controllers/application_controller.rb:64:in `authenticate_user_from_private_token!'
lib/gitlab/request_profiler/middleware.rb:15:in `call'
lib/gitlab/middleware/go.rb:16:in `call'

If I downgrade to postgresql-9.5.4-1 and postgresql-libs-9.5.4-1, this error disappears, and everything starts to work again.
This task depends upon

Closed by  Doug Newgard (Scimmia)
Sunday, 11 December 2016, 18:25 GMT
Reason for closing:  Not a bug
Comment by Doug Newgard (Scimmia) - Sunday, 11 December 2016, 17:49 GMT
Sounds like you haven't started the new server.
Comment by Tiago Peixoto (count0) - Sunday, 11 December 2016, 18:03 GMT
Yes I did. I followed the upgrade instructions to the letter (database update, daemon-reload and service restart).

It is worth noting that I have been observing this error for several releases now.
Comment by Tiago Peixoto (count0) - Sunday, 11 December 2016, 18:17 GMT
Ugh, nevermind. This has been an error on my part when upgrading postgresql.
Comment by Doug Newgard (Scimmia) - Sunday, 11 December 2016, 18:19 GMT
So why does it say "Server is version 9.5"?

Loading...