Sqlite and Solid queue issues

[eliklein02]

Hi, I am stuck on this issue and no tutorial or article was able to help me so far.
I am trying to deploy using Kamal to a vps, and the server stops right away, with the error "Detected Solid Queue has gone away, stopping Puma..." and it says 2025-07-04T04:59:57.522746884Z SolidQueue-1.1.5 Error registering Supervisor (13.0ms) pid: 34, hostname: "azure-1ff93140e7d0", name: "supervisor-4ad24bf21dc5048984ce", error: "ActiveRecord::StatementInvalid Could not find table 'solid_queue_processes'"

I do not even know what this might mean. I have the database setup and the table is there.

I will post my database.yml and deploy.yml as a starting point, any help will be appreciated

service: youtube_rails

image: eliklein02/youtube_rails

ssh:
  user: azureuser
  keys:
    - ~/.ssh/vps_key_now.pem

servers:
  web:
    hosts:
      - azure
  job:
    hosts:
      - azure
    cmd: bin/jobs
    env:
      clear:
        SOLID_QUEUE_ROLE: worker

registry:
  username: eliklein02

  password:
    - KAMAL_REGISTRY_PASSWORD

env:
  secret:
    - RAILS_MASTER_KEY
    - YOUTUBE_API_KEY
  clear:
    SOLID_QUEUE_IN_PUMA: false
    RAILS_ENV: production

aliases:
  console: app exec --interactive --reuse "bin/rails console"
  shell: app exec --interactive --reuse "bash"
  logs: app logs -f
  dbc: app exec --interactive --reuse "bin/rails dbconsole"
volumes:
  - "/db:/rails/db"
  - "/storage:/rails/storage"

asset_path: /rails/public/assets

builder:
  arch: amd64

# SQLite. Versions 3.8.0 and up are supported.
#   gem install sqlite3
#
#   Ensure the SQLite 3 gem is defined in your Gemfile
#   gem "sqlite3"
#
default: &default
  adapter: sqlite3
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  timeout: 5000

development:
  primary:
    <<: *default
    adapter: sqlite3
    database: storage/development.sqlite3

  cache:
    <<: *default
    adapter: sqlite3
    database: storage/cache_development.sqlite3

  cable:
    <<: *default
    adapter: sqlite3
    database: storage/cable_development.sqlite3

  queue:
    <<: *default
    adapter: sqlite3
    database: storage/queue_development.sqlite3

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  <<: *default
  adapter: sqlite3
  database: storage/test.sqlite3

# Store production database in the storage/ directory, which by default
# is mounted as a persistent Docker volume in config/deploy.yml.
production:
  primary:
    <<: *default
    database: storage/production.sqlite3

  cache:
    <<: *default
    database: storage/cache_production.sqlite3
    migrations_path: db/cache_migrate

  cable:
    <<: *default
    database: storage/cable_production.sqlite3
    migrations_path: db/cable_migrate

  queue:
    <<: *default
    database: storage/queue_production.sqlite3
    migrations_path: db/queue_migrate

Thank you in advance.