Skip to content

Brand new project and there are no solid queue migrations and tables. solid_queue_jobs is missing #688

@thebravoman

Description

@thebravoman

On development

/Users/kireto/.rvm/gems/ruby-3.2.2/gems/activerecord-8.0.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:167:in `exec': ERROR: relation "solid_queue_processes" does not exist (PG::UndefinedTable)
LINE 10: WHERE a.attrelid = '"solid_queue_processes"'::regclass
^

On production

2025-11-27T12:24:31.206587+00:00 app[web.1]: [b56c505a-8bbf-9054-38f5-26c29d6edce0] Completed 500 Internal Server Error in 12ms (ActiveRecord: 9.0ms (1 query, 0 cached) | GC: 0.0ms)
2025-11-27T12:24:31.208228+00:00 app[web.1]: [b56c505a-8bbf-9054-38f5-26c29d6edce0]
2025-11-27T12:24:31.208229+00:00 app[web.1]: [b56c505a-8bbf-9054-38f5-26c29d6edce0] SolidQueue::Job::EnqueueError (ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "solid_queue_jobs" does not exist

bin/rails solid_queue:install is

from bin/jobs:6:in `<main>' kireto@kireto-pc % RAILS_ENV=development bin/rails solid_queue:install identical config/queue.yml identical config/recurring.yml identical db/queue_schema.rb identical bin/jobs gsub config/environments/production.rb 

db:prepare does not help

I don't know what did I do to break it, it is a brand new project, that was just created.

Here is a log from reproducing

kireto@kireto-pc code % rails -v Rails 8.0.4 kireto@kireto-pc code % rails new solid create create README.md create Rakefile create .ruby-version create config.ru create .gitignore create .gitattributes create Gemfile run git init from "." Initialized empty Git repository in /Users/kireto/axles/code/solid/.git/ create app create app/assets/stylesheets/application.css create app/controllers/application_controller.rb create app/helpers/application_helper.rb create app/jobs/application_job.rb create app/mailers/application_mailer.rb create app/models/application_record.rb create app/views/layouts/application.html.erb create app/views/layouts/mailer.html.erb create app/views/layouts/mailer.text.erb create app/views/pwa/manifest.json.erb create app/views/pwa/service-worker.js create app/assets/images create app/assets/images/.keep create app/controllers/concerns/.keep create app/models/concerns/.keep create bin create bin/brakeman create bin/dev create bin/rails create bin/rake create bin/rubocop create bin/setup create bin/thrust create Dockerfile create .dockerignore create bin/docker-entrypoint create .rubocop.yml create .github/workflows create .github/workflows/ci.yml create .github/dependabot.yml create config create config/routes.rb create config/application.rb create config/environment.rb create config/cable.yml create config/puma.rb create config/storage.yml create config/environments create config/environments/development.rb create config/environments/production.rb create config/environments/test.rb create config/initializers create config/initializers/assets.rb create config/initializers/content_security_policy.rb create config/initializers/cors.rb create config/initializers/filter_parameter_logging.rb create config/initializers/inflections.rb create config/initializers/new_framework_defaults_8_0.rb create config/locales create config/locales/en.yml create config/master.key append .gitignore create config/boot.rb create config/database.yml create db create db/seeds.rb create lib create lib/tasks create lib/tasks/.keep create log create log/.keep create public create public/400.html create public/404.html create public/406-unsupported-browser.html create public/422.html create public/500.html create public/icon.png create public/icon.svg create public/robots.txt create script create script/.keep create tmp create tmp/.keep create tmp/pids create tmp/pids/.keep create vendor create vendor/.keep create test/fixtures/files create test/fixtures/files/.keep create test/controllers create test/controllers/.keep create test/mailers create test/mailers/.keep create test/models create test/models/.keep create test/helpers create test/helpers/.keep create test/integration create test/integration/.keep create test/test_helper.rb create test/system create test/system/.keep create test/application_system_test_case.rb create storage create storage/.keep create tmp/storage create tmp/storage/.keep remove config/initializers/cors.rb remove config/initializers/new_framework_defaults_8_0.rb run bundle install --quiet run bundle lock --add-platform=x86_64-linux Writing lockfile to /Users/kireto/axles/code/solid/Gemfile.lock run bundle lock --add-platform=aarch64-linux Writing lockfile to /Users/kireto/axles/code/solid/Gemfile.lock run bundle binstubs bundler rails importmap:install apply /Users/kireto/.rvm/gems/ruby-3.2.2/gems/importmap-rails-2.2.2/lib/install/install.rb Add Importmap include tags in application layout insert app/views/layouts/application.html.erb Create application.js module as entrypoint create app/javascript/application.js Use vendor/javascript for downloaded pins create vendor/javascript create vendor/javascript/.keep Configure importmap paths in config/importmap.rb create config/importmap.rb Copying binstub create bin/importmap run bundle install --quiet rails turbo:install stimulus:install apply /Users/kireto/.rvm/gems/ruby-3.2.2/gems/turbo-rails-2.0.20/lib/install/turbo_with_importmap.rb Import Turbo append app/javascript/application.js Pin Turbo append config/importmap.rb run bundle install --quiet apply /Users/kireto/.rvm/gems/ruby-3.2.2/gems/stimulus-rails-1.3.4/lib/install/stimulus_with_importmap.rb Create controllers directory create app/javascript/controllers create app/javascript/controllers/index.js create app/javascript/controllers/application.js create app/javascript/controllers/hello_controller.js Import Stimulus controllers append app/javascript/application.js Pin Stimulus Appending: pin "@hotwired/stimulus", to: "stimulus.min.js" append config/importmap.rb Appending: pin "@hotwired/stimulus-loading", to: "stimulus-loading.js" append config/importmap.rb Pin all controllers Appending: pin_all_from "app/javascript/controllers", under: "controllers" append config/importmap.rb run bundle install --quiet run bundle binstubs kamal run bundle exec kamal init Created configuration file in config/deploy.yml Created .kamal/secrets file Created sample hooks in .kamal/hooks force .kamal/secrets force config/deploy.yml rails solid_cache:install solid_queue:install solid_cable:install create config/cache.yml create db/cache_schema.rb gsub config/environments/production.rb create config/queue.yml create config/recurring.yml create db/queue_schema.rb create bin/jobs gsub config/environments/production.rb create db/cable_schema.rb force config/cable.yml kireto@kireto-pc code % cd solid kireto@kireto-pc solid % ls Dockerfile Gemfile.lock Rakefile bin config.ru lib public storage tmp Gemfile README.md app config db log script test vendor kireto@kireto-pc solid % rake db:prepare kireto@kireto-pc solid % bin/jobs /Users/kireto/.rvm/gems/ruby-3.2.2/gems/activerecord-8.0.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:517:in `table_structure': Could not find table 'solid_queue_processes' (ActiveRecord::StatementInvalid)	from /Users/kireto/.rvm/gems/ruby-3.2.2/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:109:in `columns' 

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions