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: 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

Reply via email to