Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug Report] Missing FROM-clause entry for table "failed_jobs" #2462

Open
escircrelit opened this issue Feb 24, 2025 · 0 comments
Open

[Bug Report] Missing FROM-clause entry for table "failed_jobs" #2462

escircrelit opened this issue Feb 24, 2025 · 0 comments

Comments

@escircrelit
Copy link

Thank you for the good product. But there's a bug. I would like to see a correction.

PG::UndefinedTable: ERROR:  missing FROM-clause entry for table "failed_jobs"
LINE 1: DELETE FROM "public"."delayed_jobs" WHERE (failed_jobs.id IN...
                                                   ^

/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/postgresql_adapter.rb:894:in 'PG::Connection#exec_params'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/postgresql_adapter.rb:894:in 'block (2 levels) in ActiveRecord::ConnectionAdapters::PostgreSQLAdapter#exec_no_cache'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/abstract_adapter.rb:1028:in 'block in ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'
/canvas/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.3/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/abstract_adapter.rb:1000:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/postgresql_adapter.rb:893:in 'block in ActiveRecord::ConnectionAdapters::PostgreSQLAdapter#exec_no_cache'
/canvas/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.3/lib/active_support/notifications/instrumenter.rb:58:in 'ActiveSupport::Notifications::Instrumenter#instrument'
/application/modules/.local/share/mise/installs/ruby/3.4.2/lib/ruby/3.4.0/delegate.rb:87:in 'Delegator#method_missing'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/sharded_instrumenter.rb:26:in 'Switchman::ShardedInstrumenter#instrument'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/abstract_adapter.rb:1143:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#log'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/active_record/abstract_adapter.rb:39:in 'Switchman::ActiveRecord::AbstractAdapter#log'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/postgresql_adapter.rb:892:in 'ActiveRecord::ConnectionAdapters::PostgreSQLAdapter#exec_no_cache'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/postgresql_adapter.rb:872:in 'ActiveRecord::ConnectionAdapters::PostgreSQLAdapter#execute_and_clear'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:77:in 'ActiveRecord::ConnectionAdapters::PostgreSQL::DatabaseStatements#exec_delete'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/abstract/database_statements.rb:208:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#delete'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/abstract/query_cache.rb:25:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#delete'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/relation.rb:664:in 'ActiveRecord::Relation#delete_all'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/guard_rail/relation.rb:19:in 'block in Switchman::GuardRail::Relation#delete_all'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/database_server.rb:189:in 'Switchman::DatabaseServer#unguard'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/guard_rail/relation.rb:19:in 'Switchman::GuardRail::Relation#delete_all'
/canvas/config/initializers/active_record.rb:1491:in 'UpdateAndDeleteWithJoins#delete_all'
/canvas/config/initializers/active_record.rb:1524:in 'UpdateAndDeleteAllWithLimit#delete_all'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/call_super.rb:16:in 'Method#call'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/call_super.rb:16:in 'Switchman::CallSuper#call_super'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/active_record/relation.rb:69:in 'block in Switchman::ActiveRecord::Relation#delete_all'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/active_record/relation.rb:119:in 'Switchman::ActiveRecord::Relation#activate'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/active_record/relation.rb:69:in 'Switchman::ActiveRecord::Relation#delete_all'
/canvas/config/initializers/active_record.rb:1522:in 'UpdateAndDeleteAllWithLimit#delete_all'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/call_super.rb:16:in 'Method#call'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/call_super.rb:16:in 'Switchman::CallSuper#call_super'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/active_record/relation.rb:69:in 'block in Switchman::ActiveRecord::Relation#delete_all'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/active_record/relation.rb:119:in 'Switchman::ActiveRecord::Relation#activate'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/active_record/relation.rb:69:in 'Switchman::ActiveRecord::Relation#delete_all'
/canvas/config/initializers/active_record.rb:1154:in 'block (2 levels) in UsefulBatchEnumerator#delete_all'
/canvas/config/initializers/postgresql_adapter.rb:300:in 'block in PostgreSQLAdapterExtensions#with_max_update_limit'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/abstract/transaction.rb:535:in 'block in ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'
/canvas/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.3/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/abstract/transaction.rb:532:in 'ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'
/canvas/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.3/lib/active_record/connection_adapters/abstract/database_statements.rb:344:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#transaction'
/canvas/config/initializers/postgresql_adapter.rb:298:in 'PostgreSQLAdapterExtensions#with_max_update_limit'
/canvas/config/initializers/active_record.rb:1153:in 'block in UsefulBatchEnumerator#delete_all'
<internal:kernel>:168:in 'Kernel#loop'
/canvas/config/initializers/active_record.rb:1151:in 'UsefulBatchEnumerator#delete_all'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/backend/active_record.rb:650:in 'Delayed::Backend::ActiveRecord::Job::Failed.cleanup_old_jobs'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/performable_method.rb:51:in 'Kernel#public_send'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/performable_method.rb:51:in 'Delayed::PerformableMethod#perform'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/backend/base.rb:313:in 'block in Delayed::Backend::Base#invoke_job'
/canvas/vendor/bundle/ruby/3.4.0/gems/sentry-inst_jobs-5.10.0/lib/sentry/inst_jobs/plugin.rb:25:in 'block (3 levels) in <class:Plugin>'
/canvas/vendor/bundle/ruby/3.4.0/gems/sentry-ruby-5.22.1/lib/sentry/hub.rb:59:in 'Sentry::Hub#with_scope'
/canvas/vendor/bundle/ruby/3.4.0/gems/sentry-ruby-5.22.1/lib/sentry-ruby.rb:396:in 'Sentry.with_scope'
/canvas/vendor/bundle/ruby/3.4.0/gems/sentry-inst_jobs-5.10.0/lib/sentry/inst_jobs/plugin.rb:15:in 'block (2 levels) in <class:Plugin>'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:98:in 'block (2 levels) in Delayed::Callback#add'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:74:in 'block in Delayed::Callback#initialize'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:98:in 'block in Delayed::Callback#add'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:79:in 'Delayed::Callback#execute'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:52:in 'Delayed::Lifecycle#run_callbacks'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/backend/base.rb:310:in 'Delayed::Backend::Base#invoke_job'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-inst-jobs-4.0.16/lib/switchman_inst_jobs/delayed/backend/base.rb:94:in 'block in SwitchmanInstJobs::Delayed::Backend::Base#invoke_job'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/shard.rb:105:in 'Switchman::Shard.activate'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/shard.rb:595:in 'Switchman::Shard#activate'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-inst-jobs-4.0.16/lib/switchman_inst_jobs/delayed/backend/base.rb:94:in 'SwitchmanInstJobs::Delayed::Backend::Base#invoke_job'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/worker.rb:225:in 'block (2 levels) in Delayed::Worker#perform'
/application/modules/.local/share/mise/installs/ruby/3.4.2/lib/ruby/3.4.0/benchmark.rb:323:in 'Benchmark.realtime'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/worker.rb:219:in 'block in Delayed::Worker#perform'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/rails_reloader_plugin.rb:22:in 'block (2 levels) in <class:RailsReloaderPlugin>'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:98:in 'block (2 levels) in Delayed::Callback#add'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-statsd-4.0.2/lib/inst_jobs_statsd/stats/timing/perform.rb:24:in 'block (2 levels) in InstJobsStatsd::Stats::Timing::Perform.enable_perform_timing'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst_statsd-3.3.2/lib/inst_statsd/statsd.rb:97:in 'InstStatsd::Statsd.time'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-statsd-4.0.2/lib/inst_jobs_statsd/stats/timing.rb:10:in 'InstJobsStatsd::Stats::Timing.report_timing'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-statsd-4.0.2/lib/inst_jobs_statsd/stats/timing/perform.rb:23:in 'block in InstJobsStatsd::Stats::Timing::Perform.enable_perform_timing'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:98:in 'block (2 levels) in Delayed::Callback#add'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-statsd-4.0.2/lib/inst_jobs_statsd/stats/timing/perform.rb:15:in 'block (2 levels) in InstJobsStatsd::Stats::Timing::Perform.enable_batching'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst_statsd-3.3.2/lib/inst_statsd/statsd.rb:103:in 'InstStatsd::Statsd.batch'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-statsd-4.0.2/lib/inst_jobs_statsd/stats/timing/perform.rb:14:in 'block in InstJobsStatsd::Stats::Timing::Perform.enable_batching'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:98:in 'block (2 levels) in Delayed::Callback#add'
/canvas/config/initializers/delayed_job.rb:153:in 'block (2 levels) in <main>'
/canvas/lib/base/temp_cache.rb:30:in 'TempCache.enable'
/canvas/config/initializers/delayed_job.rb:152:in 'block in <main>'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:98:in 'block (2 levels) in Delayed::Callback#add'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:74:in 'block in Delayed::Callback#initialize'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:98:in 'block in Delayed::Callback#add'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:98:in 'block in Delayed::Callback#add'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:98:in 'block in Delayed::Callback#add'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:98:in 'block in Delayed::Callback#add'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:79:in 'Delayed::Callback#execute'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:52:in 'Delayed::Lifecycle#run_callbacks'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/worker.rb:216:in 'Delayed::Worker#perform'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/worker.rb:186:in 'block (2 levels) in Delayed::Worker#run'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/worker.rb:296:in 'block in Delayed::Worker#configure_for_job'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/worker.rb:54:in 'Delayed::Worker.running_job'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/worker.rb:292:in 'Delayed::Worker#configure_for_job'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/worker.rb:185:in 'block in Delayed::Worker#run'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:74:in 'block in Delayed::Callback#initialize'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:79:in 'Delayed::Callback#execute'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:52:in 'Delayed::Lifecycle#run_callbacks'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/worker.rb:177:in 'Delayed::Worker#run'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-inst-jobs-4.0.16/lib/switchman_inst_jobs/delayed/worker.rb:31:in 'block in SwitchmanInstJobs::Delayed::Worker#run'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/shard.rb:105:in 'Switchman::Shard.activate'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/shard.rb:595:in 'Switchman::Shard#activate'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-inst-jobs-4.0.16/lib/switchman_inst_jobs/delayed/worker.rb:31:in 'SwitchmanInstJobs::Delayed::Worker#run'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/worker.rb:141:in 'block in Delayed::Worker#start'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:74:in 'block in Delayed::Callback#initialize'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:79:in 'Delayed::Callback#execute'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/lifecycle.rb:52:in 'Delayed::Lifecycle#run_callbacks'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/worker.rb:140:in 'Delayed::Worker#start'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-inst-jobs-4.0.16/lib/switchman_inst_jobs/delayed/worker.rb:24:in 'block in SwitchmanInstJobs::Delayed::Worker#start'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/shard.rb:105:in 'Switchman::Shard.activate'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-3.6.8/lib/switchman/shard.rb:595:in 'Switchman::Shard#activate'
/canvas/vendor/bundle/ruby/3.4.0/gems/switchman-inst-jobs-4.0.16/lib/switchman_inst_jobs/delayed/worker.rb:24:in 'SwitchmanInstJobs::Delayed::Worker#start'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:113:in 'block in Delayed::Pool#spawn_worker'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:125:in 'block in Delayed::Pool#fork_with_reconnects'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:121:in 'Kernel#fork'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:121:in 'Delayed::Pool#fork_with_reconnects'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:112:in 'Delayed::Pool#spawn_worker'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:278:in 'Delayed::Pool#respawn_child'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:239:in 'block in Delayed::Pool#maintain_children'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:238:in 'Array#each'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:238:in 'Delayed::Pool#maintain_children'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:185:in 'block in Delayed::Pool#join'
<internal:kernel>:168:in 'Kernel#loop'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:184:in 'Delayed::Pool#join'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/pool.rb:50:in 'Delayed::Pool#start'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/cli.rb:112:in 'Delayed::CLI#start'
/canvas/vendor/bundle/ruby/3.4.0/gems/inst-jobs-3.1.17/lib/delayed/cli.rb:50:in 'Delayed::CLI#run'
script/delayed_job:14:in '<main>'
@escircrelit escircrelit changed the title Missing FROM-clause entry for table "failed_jobs" [Bug Report] Missing FROM-clause entry for table "failed_jobs" Feb 24, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@escircrelit