Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-67863

SQLite database got malformed during use in multithreads

    XMLWordPrintable

Details

    • Bug
    • Resolution: Invalid
    • Not Evaluated
    • None
    • 5.10.1
    • SQL Support

    Description

      Since Qt 5.10.1 released we realised that our clients, who used our software, got their local sqlite database to be failed with messages like "malformed database image" or "disk write error I/O" and command "check integrity" on such databases tells about errors.

      Our software been working ok since Qt5.5 and we didnt change SQLite part, and we had releases on 5.5, 5.7, 5.8, 5.9 and never had such problems. But now after 5.10.1 we got it. So I founded that 5.9.4 SQLite version is 3.16.2 and Qt 5.10.1 has 3.20.1 sqlite version.

      Is it your bug or new behavoir of new sqlite version?

      To produce this bug one could open 2 thread, in each do cycle of insert in database 1 row. After second cycle starts there are many errors on insert like this: 

      "database disk image is malformed Невозможно получить строку" sql: "INSERT INTO `users` (name, email, num) VALUES ('user_thread_297', 'email@mail.ru', 297);"

       

      And such error occurs only on 5.10.1 not on 5.9.4.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            mabrand Mark Brand
            no no
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes