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