search

avo-hq / avo

Build Ruby on Rails apps 10x faster
https://avohq.io
Other
1.51k stars 245 forks source link

Failed to clear Avo HQ response: Could not find table 'solid_cache_entries' #3358

Closed adrienpoly closed 1 hour ago

adrienpoly commented 2 hours ago

Describe the bug

I ran into an issue when trying to deploy an app for the first time with Kamal. At the end of the deploy script it failed with the message 

Failed to clear Avo HQ response: Could not find table 'solid_cache_entries'

I could reproduce it locally by simply running the command rails db:prepare

I suppose it is linked to the multi db configuration I have on my app (primary db + cache db + queue db)

default: &default
  adapter: sqlite3
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 10 } %>
  timeout: 5000

# DATABASE CONFIGURATIONS
primary: &primary
  <<: *default
  database: storage/<%= Rails.env %>_rubyvideo.sqlite3

cache: &cache
  <<: *default
  migrations_paths: db/cache_migrate
  database: storage/<%= Rails.env %>-cache.sqlite3

queue: &queue
  <<: *default
  migrations_paths: db/queue_migrate
  database: storage/<%= Rails.env %>-queue.sqlite3

development:
  primary: *primary
  cache: *cache
  queue: *queue

test:
  primary: *primary
  cache: *cache
  queue: *queue

staging:
  primary: *primary
  cache: *cache
  queue: *queue

production:
  primary: *primary
  cache: *cache
  queue: *queue

Steps to Reproduce

Steps to reproduce the behavior:

  1. clone https://github.com/adrienpoly/rubyvideo
  2. bundle install
  3. comment what is inside the seed.rb for faster feedback
  4. rails db:prepare you should get a message Failed to clear Avo HQ response: Could not find table 'solid_cache_entries'

System configuration

Avo version:

Rails version: Rails 8

Ruby version: 3.3.5

License type:

Impact

adrienpoly commented 1 hour ago

Ok I think it occured while I was trying to add a new staging env to my app and I was missing some staging configuration in config/cache.yml

closing it for now as I think it is unrelated to Avo

adrianthedev commented 48 minutes ago

Got it! Thanks for letting us know.