>  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

Reply via email to