On Mon, Sep 26, 2011 at 2:21 PM, Korey Calmettes <kcalmet...@icontime.com>wrote:
> 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) - > Looks like a mmap() call is failing here: http://www.sqlite.org/src/artifact/10e0c4dcdb?ln=4009-4011 Looks like you are using a database in the root of the filesystem ("/test.db"). Do you get the same error if you put the database file in a directory someplace? > (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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
