Obviously you are using some kind of wrapper and a currently undisclosed programming language running under some OS you have neglected to name to call SQLite.
Without the aid of a debugger, it will not even be possible to discern if the problem is in SQLite itself or the wrapper code you are using. Can you provide a simple schema and a query that exhibits the problem? Can you reproduce the problem by running the statements from the SQLite shell? In 5 posts so far, you have volunteered practically no information at all, which severely limits the amount of help you can be provided with. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Aydin Ozgur Yagmur Gesendet: Dienstag, 11. Dezember 2018 14:20 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] [EXTERNAL] Transaction commits hangs up *Ist hat always the same location or is it maybe running in a loop? Is it always the same statement that "hangs"? * >>> I use sqlite for more than 3 years, i encouter such an error for the first time. That is, no. *Can you check what the thread is doing with a debugger? * >>> I have been logging the situation. log--> before commit sqlitetx->commit(); log--> after commit i can see "before commit" log but cannot see "after commit" log. On Tue, Dec 11, 2018 at 3:48 PM Hick Gunter <h...@scigames.at> wrote: > That answers question 2. What about the thread? Can you check what the > thread is doing with a debugger? Ist hat always the same location or > is it maybe running in a loop? Is it always the same statement that "hangs"? > > -----Ursprüngliche Nachricht----- > Von: sqlite-users > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Aydin Ozgur Yagmur > Gesendet: Dienstag, 11. Dezember 2018 13:43 > An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Betreff: Re: [sqlite] [EXTERNAL] Transaction commits hangs up > > I am trying to edit the database using command shell. > for instance i try to execute analyze commad i get "database is locked" > message > > On Tue, Dec 11, 2018 at 1:36 PM Hick Gunter <h...@scigames.at> wrote: > > > 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-use > > > rs > > > > > > > > > ___________________________________________ > > > 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-use > > > rs > > > > > _______________________________________________ > > 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 > _______________________________________________ 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
