RDBMS Error (Query failed): Query failed: database is locked

[housecor]

I am receiving a "RDBMS Error (Query failed): Query failed: database is locked(5)" when I run the database check under shopsite utilities. I'm running version 9.0.

I pulled the shopsite_db file down to my local machine to view it and when I upload it back to our dev server I get this lock error. How do I clear this lock?

Thanks in advance!

[loren_d_c]

It's probably a permissions issue on the file you uploaded. When you upload it into your new/dev store, try explicitly setting permissions on the file to 666, since your FTP user may not be the same user that the webserver is running as. Also, make sure when you are downloading and uploading it you are doing so in Binary FTP mode (this file is NOT a text file).

-Loren

[housecor]

Thanks for the quick reply! However, I have permissions set to 777 to rule out ownership issues as the problem. I've confirmed the shopsite_db file is owned by Apache like it should be. And yes, I transferred it in binary mode and know the db isn't corrupted. I can pull it back down and open it just fine.

I continue to get this database is locked error even if I backup from old files. Any other guesses?

[housecor]

Just FYI in case anyone else sees this problem. The issue was when I migrated over the database from production down to dev I didn't grab the 3 related DB files:

ref_orders.db
orders.stats.db
referers.db

So in short, when you move a shopsite_db file, you must move the 3 files above at the same time. They gotta stick together.