Re: [sqlite] process blocks on sqlite3_close?

2008-11-13 Thread RanRan
Roger Binns wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > RanRan wrote: >> I have a program that would create a child process. > > http://www.sqlite.org/faq.html > > Question 6, last paragraph. > > Roger > -BEGIN PGP SIGNATU

[sqlite] process blocks on sqlite3_close?

2008-11-13 Thread RanRan
Hi everyone! I have a program that would create a child process. The run-through of the part of the program is as follows: [code] int main() { pid_t pid; int status = -1; static sqlite3 *dbPtr; status = sqlite3_open( "mine.db", dbPtr ); while(1) { if((pid =

[sqlite] Deadlock on SQLite

2008-11-07 Thread RanRan
Good day! I would just like to ask if SQLite transactions might result to a deadlock? Because I have this type of code snippet: [code] printf( "before sqlite3_prepare\n" ); sqlite3_prepare( ... ); printf( "after sqlite3_prepare" ); [/code] Then sometimes, when my program is executing, the resul