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

Reply via email to