Got this error and trying to understand what happened...
I deployed the app to the server (copy/paste folder) and it worked
well, but after couple hours the part related to the db, out of a
sudden stopped working... The same app still works on the local
computer, and is accessing the same remote MySQL db.
As I was typing this, I deleted the cache folder files:
cache.shelve.db and cache.lock, and everything started working again.
Should I have deleted the cache files, and should I have set the time
shorter instead of 3600?
I use it in one place to build a dropdown field:
rows_inv =
db(db.inventory.company_id<0).select(db.inventory.ALL,
orderby=db.inventory.name, cache=(cache.ram,3600))