On 04/24/2013 03:57 PM, Richard Hipp wrote: > On Wed, Apr 24, 2013 at 8:28 AM, Sašo Kiselkov <skiselkov...@gmail.com>wrote: > >> I'm running into I/O errors when trying to access a sqlite3 database >> which is using WAL from my app. While using journal_mode=delete, >> everything is fine, but as soon as I switch over to journal_mode=wal, I >> just get a load of I/O errors on any query, regardless if it is a SELECT >> or UPDATE/INSERT. >> > > > Can you please turn on error logging (as described at > http://www.sqlite.org/draft/errlog.html) and let us know more details about > the I/O error you are seeing?
Here's my error log: #4874: os_unix.c:27116: (22) fallocate(/root/test/idx/block.db-shm) - Invalid argument #4874: os_unix.c:27116: (22) fallocate(/root/test/idx/block.db-shm) - Invalid argument #4874: statement aborts at 3: [DROP TABLE IF EXISTS `version`] disk I/O error Cheers, -- Saso _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users