If you have only one thread accessing the database, how do you determine that it is hanging and that the database is locked?
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Aydin Ozgur Yagmur Gesendet: Dienstag, 11. Dezember 2018 11:31 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] [EXTERNAL] Transaction commits hangs up I set busy-timeout 1000 ms. I have been using threads but only one thread can access to database. I will upgrade sqlite version as soon as possible. Could this lead to that problem? On Tue, Dec 11, 2018 at 12:11 PM Hick Gunter <h...@scigames.at> wrote: > You are leaving out a lot of necessary detail. Are you using threads? > Does each thread have it's own connection or are you sharing > connections? Did you set a busy timeout? > > BTW: Your Version of SQLiteis quite old. > > -----Ursprüngliche Nachricht----- > Von: sqlite-users > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Aydin Ozgur Yagmur > Gesendet: Dienstag, 11. Dezember 2018 09:53 > An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Betreff: [EXTERNAL] [sqlite] Transaction commits hangs up > > I have been using sqlite3.8.11 on fat32 file system. Sometimes, while > committing a transaction commit process hangs up and database became > locked. I am trying to find a cause or a solution for this problem. > Does anyone encounter with similar problem before? Do you have any > suggestion or any idea for this problem? > > Thank you, > yagmur > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___________________________________________ > Gunter Hick | Software Engineer | Scientific Games International GmbH > | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 > | (O) > +43 1 80100 - 0 > > May be privileged. May be confidential. Please delete if not the addressee. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
