Hello
I recently noticed that the activity view on our gitlab install wasn’t updating. I’ve seen a few different possible causes and fixes for this, but none seem to match what I am seeing.
This is gitlab 8.17.2-ce installed from the Ubuntu package repo.
I recently upgraded from 8.14.something.
gitlab-ctl reconfigure runs cleanly.
The only error I see is in sidekiq’s log where I get this:
2017-03-02_09:57:38.29406 2017-03-02T09:57:38.294Z 30423 TID-ow8uy0uso WARN: {“context”:“Job raised exception”,“job”:{“retry”:true,“queue”:“default”,“class”:“PruneOldEventsWorker”,“args”:,“jid”:“bf90b59a47e9d5c23c7b41ef”,“created_at”:1487527279.0503523,“enqueued_at”:1488448658.2866504,“error_message”:“PG::InvalidSqlStatementName: ERROR: unnamed prepared statement does not exist\n: DELETE FROM "events" WHERE ((id IN (SELECT id FROM (SELECT "events"."id" FROM "events" WHERE (created_at < ‘2016-03-01 09:57:38.288412’) LIMIT 10000) ids_to_remove)))”,“error_class”:“ActiveRecord::StatementInvalid”,“failed_at”:1487527279.0624595,“retry_count”:22,“retried_at”:1488448658.293646},“jobstr”:“{"retry":true,"queue":"default","class":"PruneOldEventsWorker","args":,"jid":"bf90b59a47e9d5c23c7b41ef","created_at":1487527279.0503523,"enqueued_at":1488448658.2866504,"error_message":"PG::InvalidSqlStatementName: ERROR: unnamed prepared statement does not exist\n: DELETE FROM \"events\" WHERE ((id IN (SELECT id FROM (SELECT \"events\".\"id\" FROM \"events\" WHERE (created_at < ‘2016-02-27 03:46:34.227921’) LIMIT 10000) ids_to_remove)))","error_class":"ActiveRecord::StatementInvalid","failed_at":1487527279.0624595,"retry_count":21,"retried_at":1488253594.2343347}”}
2017-03-02_09:57:38.29418 2017-03-02T09:57:38.294Z 30423 TID-ow8uy0uso WARN: ActiveRecord::StatementInvalid: PG::InvalidSqlStatementName: ERROR: unnamed prepared statement does not exist
2017-03-02_09:57:38.29420 : DELETE FROM “events” WHERE ((id IN (SELECT id FROM (SELECT “events”.“id” FROM “events” WHERE (created_at < ‘2016-03-01 09:57:38.288412’) LIMIT 10000) ids_to_remove)))
2017-03-02_09:57:38.29429 2017-03-02T09:57:38.294Z 30423 TID-ow8uy0uso WARN: /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `async_exec’
Google is silent on this error in relation to gitlab. Any pointers appreciated!
Thanks
Martin.