Because the file doesn't exist. I assume because this is a brand new database the file hasn't been created yet.
I did debug this originally, but I don't remember the file it is trying to delete. It definitely didn't exist though. To some extent it doesn't really matter. The unixDelete function on vxWorks with dosFs is broken for files that don't exist, so some change is needed. The patch I sent is what Jan and I came up with. Regards Andy Ling ________________________________________ From: [email protected] [[email protected]] on behalf of Richard Hipp [[email protected]] Sent: 12 August 2014 18:01 To: Andy Ling Cc: General Discussion of SQLite Database; 王庆刚 Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ On Tue, Aug 12, 2014 at 12:45 PM, Andy Ling <[email protected]<mailto:[email protected]>> wrote: Doing a create table generates a disk I/O error I open / create a new database with sqlite3_open_v2 int err = sqlite3_open_v2 (file, &pDb, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, "unix-namedsem") ; Then call sqlite3_exec with “CREATE TABLE t (id INTEGER PRIMARY KEY ASC)” This generates a disk I/O error. I assume it is trying to remove a temporary file. It might be trying to unlink the rollback journal to commit the transaction. But why is that generating an error? The file exists, so it shouldn't be generating a FILE_NOT_FOUND error... -- D. Richard Hipp [email protected]<mailto:[email protected]> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
