On Wed, Sep 28, 2011 at 2:40 PM, Korey Calmettes <kcalmet...@icontime.com>wrote:
> Richard, > > That is my conclusion as well. From what I have read online, JFFS > doesn't support mmap. Would it be possible to place those files in > tmpfs instead? Is there logic to do that? > An early implementation of WAL did just that. But then we realized that doing it that way won't work from a chroot jail - which is why we changed it to the current mechanism of using a file in the same directory as the database. If you recompile with SQLITE_SHM_DIRECTORY set to a directory name (that is perhaps a tmpfs mount) then the old behavior is active again and the WAL-index will be put in the named directory rather than in the same directory as the database file. http://www.sqlite.org/src/artifact/10e0c4dcdbec8?ln=3827 > > Korey > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: September 26, 2011 11:55 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 2:48 PM, Korey Calmettes > <kcalmet...@icontime.com>wrote: > > > Richard, > > > > Thanks for the tip of recreating the experiment in a separate > directory. > > However the same error occurs. > > > > sqlite> .tables > > (5386) os_unix.c:28414: (22) mmap(/data/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 additional ideas why mmap would be failing? > > > > > Perhaps your kernel doesn't support mmap() on JFFS filesystems? (That's > just a guess.) > > > > > Korey > > > > -----Original Message----- > > From: sqlite-users-boun...@sqlite.org > > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp > > Sent: September 26, 2011 11:36 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 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 > > _______________________________________________ > > 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 > _______________________________________________ > 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
