Each thread access the SQLiteManager array m_dbs, indexed by its unique index provided by openmp. Since SQLiteManager opens a connection in its init() method each thread has a private connection. The tests are passing when I set the parallel loops for one thread only.
2016-02-02 19:27 GMT-02:00 Hick Gunter <hick at scigames.at>: > Does the error still occur if you run with only one thread? Does each > thread have ist own connection or are you sharing a single connection > across multiple threads? > > -----Urspr?ngliche Nachricht----- > Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto: > sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Vin?cius da > Silva > Gesendet: Dienstag, 02. Februar 2016 22:08 > An: SQLite mailing list > Betreff: Re: [sqlite] Table entries disappearing for unknown reason. > > The error occur after commenting the SQLite setup pragmas. All threads > access the same database file and the same table. I'm using an ext4 file > system with Ubuntu. > > 2016-02-02 17:58 GMT-02:00 Clemens Ladisch <clemens at ladisch.de>: > > > Vin?cius da Silva wrote: > > > after commenting the pragmas, > > > > Which ones? omp or SQLite? > > > > > SQLiteManager is throwing > > > an exception because stepping the statement in endTransaction() is > > > returning SQLITE_IOERR_DELETE_NOENT > > > <https://sqlite.org/rescode.html#ioerr_delete_noent> in the parallel > > loop. > > > > Do your threads access the same database file? > > > > What file system are you using? > > > > > > Regards, > > Clemens > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > Best Regards, > > Vin?cius da Silva <http://www.lcg.ufrj.br/Members/viniciusdasilva>, > Ph. D. Student. > PESC <http://www.cos.ufrj.br> - UFRJ <http://www.ufrj.br> > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___________________________________________ > Gunter Hick > Software Engineer > Scientific Games International GmbH > FN 157284 a, HG Wien > Klitschgasse 2-4, A-1130 Vienna, Austria > Tel: +43 1 80100 0 > E-Mail: hick at scigames.at > > This communication (including any attachments) is intended for the use of > the intended recipient(s) only and may contain information that is > confidential, privileged or legally protected. Any unauthorized use or > dissemination of this communication is strictly prohibited. If you have > received this communication in error, please immediately notify the sender > by return e-mail message and delete all copies of the original > communication. Thank you for your cooperation. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Best Regards, Vin?cius da Silva <http://www.lcg.ufrj.br/Members/viniciusdasilva>, Ph. D. Student. PESC <http://www.cos.ufrj.br> - UFRJ <http://www.ufrj.br>
