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