Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. Mobile and Embedded
  4. system reboot with Qt 4.8.7 and '-system-sqlite' using libsqlite >= 3.21.0
QtWS25 Last Chance

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

Scheduled Pinned Locked Moved Unsolved Mobile and Embedded
2 Posts 2 Posters 240 Views
  • 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 Offline
    T Offline
    Thorsten Scherer
    wrote on last edited by
    #1

    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
    0
    • SGaistS Offline
      SGaistS Offline
      SGaist
      Lifetime Qt Champion
      wrote on last edited by
      #2

      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
      0

      • Login

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Users
      • Groups
      • Search
      • Get Qt Extensions
      • Unsolved