I have already been upgrading sqlite version. After this If I encounter with the same problem I will inform you.. For Hick Gunter I'm sorry for the inconveinence. I have been using C++. I have been using some kind of wrapper : yes. Operating system (cat /proc/version): Linux version 3.17.0-xilinx-00016-g9d68a4a-dirty I cannot reproduce the problem as I already said I have encountered such an error for the first time. But i'm sure that the wrapper cannot cause such a problem.
For Simon Slavin Ok, if i encounter with same problem, I will use command shell, enter pragma command and after that I will execute analyze command. If you have any idea which may cause to this problem please let me know. Thank you very much for your help. Best regards On Tue, Dec 11, 2018 at 4:39 PM Hick Gunter <h...@scigames.at> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
