uffizzi
uffizzi copied to clipboard
BUG: PG::UndefinedColumn: ERROR: column repo.credential_id does not exist
Sometimes we catch error:
2022-08-25T10:09:50.262Z pid=1 tid=26zd WARN: {"context":"Job raised exception","job":{"retry":60,"queue":"deployments","args":[11],"class":"Deployment::DeployContainersJob","jid":"871cd7ac3b464014ea0cf165","created_at":1661422187.6823604,"enqueued_at":1661422187.6824265,"error_message":"PG::UndefinedColumn: ERROR: column repo.credential_id does not exist\nLINE 1: ...po.\"branch\" AS t1_r5, repo.\"project_id\" AS t1_r6, repo.\"cred...\n ^\n","error_class":"ActiveRecord::StatementInvalid","processor":"app-deployment-5247-6b5499dd77-v8qxv:1","failed_at":1661422190.2623594},"jobstr":"{\"retry\":60,\"queue\":\"deployments\",\"args\":[11],\"class\":\"Deployment::DeployContainersJob\",\"jid\":\"871cd7ac3b464014ea0cf165\",\"created_at\":1661422187.6823604,\"enqueued_at\":1661422187.6824265}"}
2022-08-25T10:09:50.262Z pid=1 tid=26zd WARN: ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column repo.credential_id does not exist
LINE 1: ...po."branch" AS t1_r5, repo."project_id" AS t1_r6, repo."cred...
^
2022-08-25T10:09:50.262Z pid=1 tid=26zd WARN: /bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:678:in `async_exec_params'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:678:in `block (2 levels) in exec_no_cache'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:677:in `block in exec_no_cache'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:697:in `block (2 levels) in log'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:696:in `block in log'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:688:in `log'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:676:in `exec_no_cache'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:655:in `execute_and_clear'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:53:in `exec_query'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:532:in `select'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:69:in `select_all'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:101:in `block in select_all'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:118:in `block in cache_sql'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:109:in `cache_sql'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:101:in `select_all'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/relation.rb:845:in `block (2 levels) in exec_queries'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/relation/finder_methods.rb:421:in `apply_join_dependency'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/relation.rb:840:in `block in exec_queries'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/relation.rb:868:in `skip_query_cache_if_necessary'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/relation.rb:835:in `exec_queries'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/association_relation.rb:44:in `exec_queries'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/relation.rb:638:in `load'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/relation.rb:249:in `records'
/bundle_cache/ruby/2.7.0/gems/activerecord-6.1.0/lib/active_record/relation/delegation.rb:88:in `each'
/app/app/services/deployment_service.rb:165:in `run_github_containers_build_process'
/app/app/services/deployment_service.rb:48:in `deploy_containers'
/app/app/jobs/deployment/deploy_containers_job.rb:25:in `perform'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:196:in `execute_job'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:164:in `block (2 levels) in process'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/middleware/chain.rb:144:in `block in invoke'
/bundle_cache/ruby/2.7.0/gems/sidekiq-statistic-1.4.0/lib/sidekiq/statistic/middleware.rb:12:in `call'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/middleware/chain.rb:146:in `block in invoke'
/bundle_cache/ruby/2.7.0/gems/sentry-sidekiq-5.3.1/lib/sentry/sidekiq/sentry_context_middleware.rb:7:in `call'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/middleware/chain.rb:146:in `block in invoke'
/bundle_cache/ruby/2.7.0/gems/sidekiq-failures-1.0.1/lib/sidekiq/failures/middleware.rb:9:in `call'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/middleware/chain.rb:146:in `block in invoke'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/middleware/chain.rb:149:in `invoke'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:163:in `block in process'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:136:in `block (6 levels) in dispatch'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/job_retry.rb:115:in `local'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:135:in `block (5 levels) in dispatch'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/rails.rb:14:in `block in call'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/execution_wrapper.rb:88:in `wrap'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/reloader.rb:72:in `block in wrap'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/execution_wrapper.rb:88:in `wrap'
/bundle_cache/ruby/2.7.0/gems/activesupport-6.1.0/lib/active_support/reloader.rb:71:in `wrap'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/rails.rb:13:in `call'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:131:in `block (4 levels) in dispatch'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:257:in `stats'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:126:in `block (3 levels) in dispatch'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/job_logger.rb:13:in `call'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:125:in `block (2 levels) in dispatch'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/job_retry.rb:82:in `global'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:124:in `block in dispatch'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/job_logger.rb:39:in `prepare'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:123:in `dispatch'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:162:in `process'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:78:in `process_one'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/processor.rb:68:in `run'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/component.rb:8:in `watchdog'
/bundle_cache/ruby/2.7.0/gems/sidekiq-6.5.1/lib/sidekiq/component.rb:17:in `block in safe_thread'