Date: Wed, 23 Jan 2019 11:07:30 +0000 From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 235149] www/gitlab-ce PostgreSQL Error seen in sidekiq.log Message-ID: <bug-235149-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D235149 Bug ID: 235149 Summary: www/gitlab-ce PostgreSQL Error seen in sidekiq.log Product: Ports & Packages Version: Latest Hardware: amd64 OS: Any Status: New Severity: Affects Only Me Priority: --- Component: Individual Port(s) Assignee: mfechner@FreeBSD.org Reporter: manas@bhatnagar.net.in Flags: maintainer-feedback?(mfechner@FreeBSD.org) Assignee: mfechner@FreeBSD.org Main error, which is also logged by postgresql: 2019-01-23T11:00:39.433Z 47612 TID-8174rms WARN: ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: syntax error at or near "SELECT" LINE 4: ( SELECT updated_at, ^ : UPDATE merge_request_metrics SET (latest_closed_at, latest_closed_by_id) =3D ( SELECT updated_at, author_id FROM events WHERE target_id =3D merge_request_id AND target_type =3D 'MergeRequest' AND action =3D 3 ORDER BY id DESC LIMIT 1 ), merged_by_id =3D ( SELECT author_id FROM events WHERE target_id =3D merge_request_id AND target_type =3D 'MergeRequest' AND action =3D 7 ORDER BY id DESC LIMIT 1 ) WHERE merge_request_id BETWEEN 1 AND 4 2019-01-23T11:00:39.433Z 47612 TID-8174rms BackgroundMigrationWorker JID-36c4882cb7333f36aea02bf3 INFO: fail: 0.007 sec 2019-01-23T11:00:39.433Z 47612 TID-8174rms WARN: {"context":"Job raised exception","job":{"class":"BackgroundMigrationWorker","args":["PopulateMerg= eRequestMetricsWithEventsDataImproved",[1,4]],"retry":3,"queue":"background= _migration","jid":"36c4882cb7333f36aea02bf3","created_at":1548241130.667240= 6,"correlation_id":"c7b15686-47e1-41da-86c0-980eba5958f3","enqueued_at":154= 8241239.4254885},"jobstr":"{\"class\":\"BackgroundMigrationWorker\",\"args\= ":[\"PopulateMergeRequestMetricsWithEventsDataImproved\",[1,4]],\"retry\":3= ,\"queue\":\"background_migration\",\"jid\":\"36c4882cb7333f36aea02bf3\",\"= created_at\":1548241130.6672406,\"correlation_id\":\"c7b15686-47e1-41da-86c= 0-980eba5958f3\",\"enqueued_at\":1548241239.4254885}"} 2019-01-23T11:00:39.433Z 47612 TID-8174rms WARN: ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: syntax error at or near "SELECT" LINE 4: ( SELECT updated_at, ^ : UPDATE merge_request_metrics SET (latest_closed_at, latest_closed_by_id) =3D ( SELECT updated_at, author_id FROM events WHERE target_id =3D merge_request_id AND target_type =3D 'MergeRequest' AND action =3D 3 ORDER BY id DESC LIMIT 1 ), merged_by_id =3D ( SELECT author_id FROM events WHERE target_id =3D merge_request_id AND target_type =3D 'MergeRequest' AND action =3D 7 ORDER BY id DESC LIMIT 1 ) WHERE merge_request_id BETWEEN 1 AND 4 2019-01-23T11:00:39.433Z 47612 TID-8174rms WARN: /usr/local/lib/ruby/gems/2.4/gems/peek-pg-1.3.0/lib/peek/views/pg.rb:17:in `async_exec' /usr/local/lib/ruby/gems/2.4/gems/peek-pg-1.3.0/lib/peek/views/pg.rb:17:in `async_exec' /usr/local/lib/ruby/gems/2.4/gems/activerecord-5.0.7.1/lib/active_record/co= nnection_adapters/postgresql/database_statements.rb:98:in `block in execute' /usr/local/lib/ruby/gems/2.4/gems/activerecord-5.0.7.1/lib/active_record/co= nnection_adapters/abstract_adapter.rb:590:in `block in log' /usr/local/lib/ruby/gems/2.4/gems/activesupport-5.0.7.1/lib/active_support/= notifications/instrumenter.rb:21:in `instrument' /usr/local/lib/ruby/gems/2.4/gems/activerecord-5.0.7.1/lib/active_record/co= nnection_adapters/abstract_adapter.rb:583:in `log' /usr/local/lib/ruby/gems/2.4/gems/activerecord-5.0.7.1/lib/active_record/co= nnection_adapters/postgresql/database_statements.rb:97:in `execute' /usr/local/www/gitlab-ce/lib/gitlab/background_migration/populate_merge_req= uest_metrics_with_events_data_improved.rb:95:in `execute' /usr/local/www/gitlab-ce/lib/gitlab/background_migration/populate_merge_req= uest_metrics_with_events_data_improved.rb:63:in `psql_update_metrics_with_events_data' /usr/local/www/gitlab-ce/lib/gitlab/background_migration/populate_merge_req= uest_metrics_with_events_data_improved.rb:33:in `update_metrics_with_events_data' /usr/local/www/gitlab-ce/lib/gitlab/background_migration/populate_merge_req= uest_metrics_with_events_data_improved.rb:12:in `perform' /usr/local/www/gitlab-ce/lib/gitlab/background_migration.rb:51:in `perform' /usr/local/www/gitlab-ce/app/workers/background_migration_worker.rb:26:in `perform' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:18= 5:in `execute_job' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:16= 7:in `block (2 levels) in process' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/middleware/chai= n.rb:128:in `block in invoke' /usr/local/www/gitlab-ce/lib/gitlab/sidekiq_status/server_middleware.rb:7:in `call' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/middleware/chai= n.rb:130:in `block in invoke' /usr/local/www/gitlab-ce/lib/gitlab/sidekiq_middleware/correlation_logger.r= b:10:in `block in call' /usr/local/www/gitlab-ce/lib/gitlab/correlation_id.rb:15:in `use_id' /usr/local/www/gitlab-ce/lib/gitlab/sidekiq_middleware/correlation_logger.r= b:9:in `call' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/middleware/chai= n.rb:130:in `block in invoke' /usr/local/www/gitlab-ce/lib/gitlab/sidekiq_middleware/batch_loader.rb:7:in `call' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/middleware/chai= n.rb:130:in `block in invoke' /usr/local/www/gitlab-ce/lib/gitlab/sidekiq_middleware/request_store_middle= ware.rb:8:in `call' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/middleware/chai= n.rb:130:in `block in invoke' /usr/local/www/gitlab-ce/lib/gitlab/sidekiq_middleware/shutdown.rb:54:in `c= all' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/middleware/chai= n.rb:130:in `block in invoke' /usr/local/lib/ruby/gems/2.4/gems/sentry-raven-2.7.4/lib/raven/integrations= /sidekiq.rb:9:in `call' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/middleware/chai= n.rb:130:in `block in invoke' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/middleware/chai= n.rb:133:in `invoke' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:16= 6:in `block in process' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:13= 7:in `block (6 levels) in dispatch' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/job_retry.rb:10= 8:in `local' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:13= 6:in `block (5 levels) in dispatch' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/rails.rb:42:in `block in call' /usr/local/lib/ruby/gems/2.4/gems/activesupport-5.0.7.1/lib/active_support/= execution_wrapper.rb:85:in `wrap' /usr/local/lib/ruby/gems/2.4/gems/activesupport-5.0.7.1/lib/active_support/= reloader.rb:68:in `block in wrap' /usr/local/lib/ruby/gems/2.4/gems/activesupport-5.0.7.1/lib/active_support/= execution_wrapper.rb:85:in `wrap' /usr/local/lib/ruby/gems/2.4/gems/activesupport-5.0.7.1/lib/active_support/= reloader.rb:67:in `wrap' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/rails.rb:41:in `call' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:13= 2:in `block (4 levels) in dispatch' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:24= 3:in `stats' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:12= 7:in `block (3 levels) in dispatch' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/job_logger.rb:8= :in `call' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:12= 6:in `block (2 levels) in dispatch' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/job_retry.rb:73= :in `global' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:12= 5:in `block in dispatch' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/logging.rb:48:in `with_context' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/logging.rb:42:in `with_job_hash_context' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:12= 4:in `dispatch' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:16= 5:in `process' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:83= :in `process_one' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/processor.rb:71= :in `run' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/util.rb:16:in `watchdog' /usr/local/lib/ruby/gems/2.4/gems/sidekiq-5.2.3/lib/sidekiq/util.rb:25:in `block in safe_thread' --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-235149-7788>