Thanks for responding so quickly. I performed the same general experiment. Here is the output when the error occurred.
sqlite> .tables (5386) os_unix.c:28414: (22) mmap(//test.db-shm) - (5386) statement aborts at 109: [SELECT name FROM sqlite_master WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%' UNION ALL SELECT name FROM sqlite_temp_master WHERE type IN ('table','view') ORDER BY 1] disk I/O error Error: disk I/O error sqlite> Any ideas? Korey -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: September 26, 2011 8:38 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problem with using WAL journal mode in embedded system (disk I/O error) On Mon, Sep 26, 2011 at 11:30 AM, Korey Calmettes <kcalmet...@icontime.com>wrote: > ~ # sqlite3 test.db > SQLite version 3.7.7.1 2011-06-28 17:39:05 Enter ".help" for > instructions Enter SQL statements terminated with a ";" > sqlite> .tables > test > sqlite> pragma journal_mode=wal; > wal > sqlite> .tables > Error: disk I/O error > sqlite> > > > Any ideas on what may be causing this error and any suggestions for a > work-around? > Type: .log stdout at the beginning of this session and run your experiment again please. The extra output might give some clues. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users