Hi all,
I have a piece of code that utilizes test_server.c, (master thread)
there are 3 threads, each performing seperate tasks, that get a conection
(shared) and set
PRAGMA read_uncommitted=1.
My understanding is that this would allow each individual thread to
concurrently execute a select statement?
I get the following errors:
Thread Load: ( begin txn, insert, commit) using the master thread since
it is a write. )
rc=[10] msg=[disk I/O error] (after thread proc disconnects)
Thread proc: (select not using the master_thread queue, updates using
thread queu )
rc=[11] msg=[malformed database schema - table sqlite_master already
exists]
Thread purg: (select not using the master_thread queue, delete using
the master thread queue).
rc=[10] msg=[disk I/O error] (on delete statement after thread proc
disconnects).
I was under the impression that using the PRAGM read uncommitted would not
cause blocking amongst readers/writers? So I built an interface that would send
write operations to the Writer Queue and would call sqlite3_ commands for
selects...
Is this not a correct utilization? Also the code dumps core, but sometimes
will run to completion as above.
Note that If i use and api that sen