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