Qt Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Unsolved

    Qt Academy Launch in California!

    Unsolved system reboot with Qt 4.8.7 and '-system-sqlite' using libsqlite >= 3.21.0

    Mobile and Embedded
    2
    2
    122
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • T
      Thorsten Scherer last edited by

      Hello everybody,

      I'll try to describe the issue very brief and will add further info, if needed/requested.

      • Prerequesties

        • Qt 4.8.7 (upgrade is not an option)
        • built with gcc-7.3.1 for an imx25 board
        • linux kernel 4.17.19
        • the need to use "attach" and "detach" inside transactions and therefor using "-system-sqlite" with a newer version of libsqlite (greater than 3.21.0 released on 2017-10-24)
      • Description / observed behavior

      The code that uses "attach" and "detach" inside transactions runs every 15min (copies data
      from in-memory sqlite files to sqlite files on persistent storage). This is never reached,
      since the system is restarted via watchdog every (roundabout) 10 minutes. In this time
      the system collection various data from various I/O.

      • Qt with built in sqlite (3.7.7.1) -> system works as expected
      • Qt with '-system-sqlite' and libsqlite 3.7.7.1 -> system works as expected
      • Qt with '-system-sqlite' and libsqlite 3.21.0 -> system slows down till reboot via watchdog
      • Qt with '-system-sqlite' and libsqlite 3.24.0 -> system slows down till reboot via watchdog

      Are there any known incompatibilites between Qt and libsqlite versions?

      Or maybe compilte time flags that could should be added?

      Any suggestions howto enclose the issue?

      Thx for your time and interest.

      Best regards
      Thorsten

      1 Reply Last reply Reply Quote 0
      • SGaist
        SGaist Lifetime Qt Champion last edited by

        Hi and welcome to devnet,

        Qt merely uses SQLite, it could simply be an issue with SQLite itself since it's the component that you are changing.

        You should check the SQLite release logs to see what has changed.

        Interested in AI ? www.idiap.ch
        Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

        1 Reply Last reply Reply Quote 0
        • First post
          Last post