On 02/03/2011 10:22 PM, Tiberio, Sylvain wrote:
>
> Dan,
>
> Thanks for your attention.
>
> sqlite3_extended_errcode() return 0xA0A that means SQLITE_IOERR_DELETE.
Earlier versions of SQLite ignored the return code of unlink(). That
is probably why you're not seeing a problem with 3.6.22.
Search the code for a function called "unixDelete". In sqlite3.c if
you are using the amalgamation, os_unix.c otherwise. Near the top
of that function is this:
if( unlink(zPath)==(-1) && errno!=ENOENT ){
return SQLITE_IOERR_DELETE;
}
That's where your error is coming from. If you can put a call to
perror() or print the value of errno just before SQLITE_IOERR_DELETE,
it might show why that call to unlink() is failing. Printing out
"zPath" as well is probably a good idea.
Dan.
>
> Here are others information:
> - My problem occurs in Sparc/Solaris 10 system.
> - After my program error, the file try.db exists and has the correct
> right -rw-r--r--, correct owner/group and a null size.
>
> Regards,
>
> Sylvain
>
> -----Original Message-----
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Kennedy
> Sent: Thursday, February 03, 2011 3:16 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Multithreading problem
>
> On 02/02/2011 09:31 PM, Tiberio, Sylvain wrote:
>> Hi!
>>
>>
>>
>> I have a problem when I try to create a new database in a thread and
> try
>> to add a table on it.
>>
>>
>>
>> The following C code (see in the end of this e-mail) produces:
>
> The program is working Ok with 3.7.5 here.
>
> After the IO error in sqlite3_exec(), what value does
> sqlite3_extended_errcode() return?
>
> Dan.
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
