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