I have a strange PHP/SQLite problem.
When I try to execute a query to a SQLite DB on ServerA, I get this error:
Last Error: database is locked
Then I copy the DB to another server (ServerB) with exact the same installation of PHP/SQLite, the query succeeds.
SQLite: PECL Module version 2.0-dev $Id: sqlite.c,v 126.96.36.199.2.11 2008/12/01 12:28:27 felipe Exp $
SQLite Library 2.8.17
SQLite Encoding UTF-8
It seems really be caused by the server, I just installed sqlite (cli) and then when I run:
# sqlite db1.sqlite
SQLite version 2.8.17
Enter ".help" for instructions
Error: database is locked
Is there some lockfile somewhere that I don't know about?
The file is located on NFS, and when I try to open it on ServerB, there is no lock.
So for some reason ServerA is buggy, but I really can't pinpoint the problem. I've already been working on this for over a week and already tried to reinstall SQLite several times with no luck.
I someone can point me at least in the direction of troubleshooting that would be great!