Me thinkst the database can't open the WAL file.
I don't see your script in the attachments but where is your database being
opened?
Michael D. Black
Senior Scientist
NG Information Systems
Advanced Analytics Directorate
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Artyom Beilis [artyom...@yahoo.com]
Sent: Wednesday, September 21, 2011 9:51 AM
To: sqlite-users@sqlite.org
Cc: artyom...@yahoo.com
Subject: EXT :[sqlite] Assertion in Sqlite 3.7.x on Cygwin using WAL
Hello,
This simple script:
pragma journal_mode=wal;
CREATE TABLE IF NOT EXISTS sessions (
sid varchar(32) primary key not null
);
begin;
INSERT OR REPLACE INTO sessions values('0123456789abcdef0123456789abcde1');
-- There it fails after insert or replace before commit
commit;
Fails on Cygwin and passess without problems using
windows builds.
With normal build the script reports
unable to open database file
While building with -DSQLITE_DEBUG
it reports an assertion:
assertion "isExclusive==0 || isCreate" failed: file "sqlite3.c", line 34058,
function: winOpen
(Version 3.7.8)
This does not happen on Windows builds of the same sources.
I've attached the script and VDBE traces under cygwin and windows builds.
Cygwin version: 1.7.9(0.237/5/3)
Artyom Beilis
--------------
CppCMS - C++ Web Framework: http://cppcms.sf.net/
CppDB - C++ SQL Connectivity: http://cppcms.sf.net/sql/cppdb/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
