On 11/11/2010 6:47 AM, Alexey Pechnikov wrote: > $ ls -lh merch.db* > -rw-r--r-- 1 - - 5,8G Ноя 10 23:01 merch.db > -rw-r--r-- 1 - - 32K Ноя 10 23:04 merch.db-shm > -rw-r--r-- 1 - - 449M Ноя 10 23:01 merch.db-wal > > sqlite> pragma journal_mode; > wal > sqlite> pragma journal_mode=delete; > Error: database is locked
Can't convert to delete mode while a WAL file exists. > sqlite> pragma integrity_check; > ok Causes WAL file to be written back and deleted. > sqlite> pragma journal_mode=delete; > delete No probs as no WAL file now. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
