Hi all,
I am experiencing a pretty annoying issue with my Sqlite3 databases.
I am using PDO to access small ( approx. 300Kb ) databases stored on an NFS
v3 mount. These queries are multithreaded as they come from a web
application. However, there are only SELECT statements, not any
update/delete/insert, and I am facing some lock errors, as follow :
SQLSTATE[HY000]: General error: 5 database is locked
Stack:
#0 /home/www/libs/Zend/Db/Statement.php(283):
Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/www/libs/Zend/Db/Adapter/Abstract.php(405):
Zend_Db_Statement->execute(Array)
#2 /home/www/libs/Zend/Db/Adapter/Pdo/Abstract.php(205):
Zend_Db_Adapter_Abstract->query('SELECT * FROM m...', Array)
I am aware of issues using sqlite over NFS. But I was thinking these issues
were related to read/write queries working in parallel, and not to read-only
queries.
Is Sqlite locking the database for *any* query ?
Is there a way to tell Sqlite to not lock the database when we know there
are only read-only queries ?
Thanks !
--
David LEVY {Selenium}
Chief Technical Officer - Zlio.com
-----------------------------------------------------------------------------
Blog : http://www.davidlevy.org
ZlioShop : http://shop.davidlevy.org
Music : http://www.davidlevy.org/music/
-----------------------------------------------------------------------------
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
