On 22 Apr 2019, at 3:19pm, Polly Tang <[email protected]> wrote:

> I have an urgent issue with multiple reader processes in C++ accessing the 
> same DB file in Ubuntu and all reader experience "Table Not Found".

/All/ say "Table Not Found" ?  Including if you open just one reader process ?  
Are you sure your processes are opening the file with your database in, and not 
a different, blank, file ?

Please set a timeout for each connection by executing this command

    PRAGMA busy_timeout = 10000

before you execute your SELECT command.  Does that change things ?

Also, you are not checking the result codes returned by 
"sqlite3pp::transaction".  Check it and make sure it equals 0.  I have no idea 
how to do that in the library you're using.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to