> If your build is frequently trying to unlink a file that does not exist, > then something is wrong. We need to figure out what that is and fix it.
I have added some debug. First I create a brand new database called /ata0:3/testdb.sql Then I try and create a table and get an error from unixDelete saying it can't delete /ata0:3/testdb.sql-wal. It actually fails twice. My shell output is shown below Regards Andy Ling [quentina]# ls -l drwxrwxrwx 1 0 0 32768 Aug 13 09:55 logs/ drwxrwxrwx 1 0 0 32768 Aug 13 09:55 db/ drwxrwxrwx 1 0 0 32768 Dec 19 2013 dataLogs/ drwxrwxrwx 1 0 0 32768 Oct 29 2013 csv/ [quentina]# [quentina]# [quentina]# pwd /ata0:3 [quentina]# [quentina]# func call &sql_open "/ata0:3/testdb.sql" & [quentina]# 2014/08/13 10:02:39.00326 [stdout] sql_open opening database /ata0:3/testdb.sql 2014/08/13 10:02:39.00326 [stdout] Database /ata0:3/testdb.sql opened - pDb = 0x3ee9c48 [quentina]# ls -l drwxrwxrwx 1 0 0 32768 Aug 13 09:55 logs/ drwxrwxrwx 1 0 0 32768 Aug 13 09:55 db/ drwxrwxrwx 1 0 0 32768 Dec 19 2013 dataLogs/ drwxrwxrwx 1 0 0 32768 Oct 29 2013 csv/ -rwxrwxrwx 1 0 0 0 Aug 13 10:02 testdb.sql [quentina]# func call &sql_execute "CREATE TABLE t (id INTEGER PRIMARY KEY ASC)" & [quentina]# 2014/08/13 10:03:03.00897 [stdout] Spawning sqlExec 2014/08/13 10:03:03.00898 [stdout] unixDelete error 0x380003 for file /ata0:3/testdb.sql-wal 2014/08/13 10:03:03.00898 [stdout] unixDelete error 0x380003 for file /ata0:3/testdb.sql-wal 2014/08/13 10:03:03.00913 [stdout] Statement CREATE TABLE t (id INTEGER PRIMARY KEY ASC) executed _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users