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?
Korey
-----Original Message-----
From: [email protected]
[mailto:[email protected]] 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
<[email protected]>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: [email protected]
> [mailto:[email protected]] 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
> <[email protected]>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
> [email protected]
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
