[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

2015-08-10 Thread Simon Slavin
On 10 Aug 2015, at 10:49pm, ??? ??? wrote: > When I set timeout to 12 ms (2 minutes). It starts work. But as I > understand from reading SQLite C interface, when DB in WAL journal mode it > should work without busytimeout. > > Can it work without busy timeout? It is correct

[sqlite] SQLite crash

2015-08-10 Thread Robert Weiss
Dan Kennedy-- What address, precisely, should I use to send the database to you? ?When I "reply" to your message I get the whole SQLite discussion group, which is what I want to avoid (no offense intended, guys and gals). BTW, the problem does not seem to occur in version 3.8.10.2. Robert Weiss

[sqlite] Fwd: Problem with SQLite in C++. DB is BUSY (Multithread)

2015-08-10 Thread Дмитрий Чепуровский
-- Forwarded message -- From: ??? ??? Date: 2015-08-10 0:37 GMT+03:00 Subject: Problem with SQLite in C++. DB is BUSY (Multithread) To: sqlite-users at mailinglists.sqlite.org Hello! I've got a problem. I'm using sqlite3 in my C++ project. In the

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

2015-08-10 Thread Simon Slavin
On 9 Aug 2015, at 10:37pm, ??? ??? wrote: > I've got a problem. I'm using sqlite3 in my C++ project. In the log I've > got error's *DB is locked error code 5*. As I know error code 5 means, that > DB is busy. For testings, please use

[sqlite] insert use sqlite3_step function return SQLITE_ROWS not return SQLITE_DONE

2015-08-10 Thread smk smk
thx. it is true. i set count_changes = false it return SQLITE_DONE. thx u every much! 2015-08-10 11:32 GMT+08:00 Richard Hipp : > On 8/9/15, smk smk wrote: > > at windows 7 use TDM-GCC-32 tdm-gcc-5.1.0-3 and sqlite 3.08.11.01 > > > > sql: insert into user_tableTest(col1,col2) values(?,?) > >

[sqlite] insert use sqlite3_step function return SQLITE_ROWS not return SQLITE_DONE

2015-08-10 Thread smk smk
at windows 7 use TDM-GCC-32 tdm-gcc-5.1.0-3 and sqlite 3.08.11.01 sql: insert into user_tableTest(col1,col2) values(?,?) sqlite3_prepare_v2 sqlite3_bind_text sqlite3_bind_int sqlite3_step succ need return SQLITE_DONE, but sqlite3_step return SQLITE_ROWS i don't know why ?

[sqlite] SQLite, fork(), and exec()

2015-08-10 Thread Richard Hipp
On 8/10/15, Felipe Gasper wrote: > Hi everyone, > > Does SQLite need to have nothing at all to do with fork()? Even when > the fork() immediately precedes an exec(), and the exec()ed command has > nothing to do with SQLite? > > Or is it only a problem if the child process *uses*

[sqlite] SQLite, fork(), and exec()

2015-08-10 Thread Felipe Gasper
Hi everyone, Does SQLite need to have nothing at all to do with fork()? Even when the fork() immediately precedes an exec(), and the exec()ed command has nothing to do with SQLite? Or is it only a problem if the child process *uses* SQLite? -F

[sqlite] SQLite, fork(), and exec()

2015-08-10 Thread Nico Williams
On Mon, Aug 10, 2015 at 11:02:04AM -0400, Richard Hipp wrote: > On 8/10/15, Felipe Gasper wrote: > > Does SQLite need to have nothing at all to do with fork()? Even when > > the fork() immediately precedes an exec(), and the exec()ed command has > > nothing to do with SQLite? > > > > Or

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

2015-08-10 Thread Дмитрий Чепуровский
Hello! I've got a problem. I'm using sqlite3 in my C++ project. In the log I've got error's *DB is locked error code 5*. As I know error code 5 means, that DB is busy. To solve this I started to use WAL journal mode. But it doesn't help. In my program I've got 2 connections to the same db. I use

[sqlite] insert use sqlite3_step function return SQLITE_ROWS not return SQLITE_DONE

2015-08-10 Thread Richard Hipp
On 8/9/15, smk smk wrote: > at windows 7 use TDM-GCC-32 tdm-gcc-5.1.0-3 and sqlite 3.08.11.01 > > sql: insert into user_tableTest(col1,col2) values(?,?) > sqlite3_prepare_v2 > sqlite3_bind_text > sqlite3_bind_int > sqlite3_step > > succ need return SQLITE_DONE, > but sqlite3_step return