SQLite Forum

SQLite 3.34.0 causes Tracker 3 test suite to fail (database corrupt)
Login
Previous bug report at [Arch Linux FS#68903](https://bugs.archlinux.org/task/68903).

With SQLite 3.34.0, `tracker-fd-test` from the [GNOME Tracker](https://gitlab.gnome.org/GNOME/tracker) 3.0.1 or 3.0.2 test suite fails with:

```
Tracker-CRITICAL **: 02:39:41.823: SQLite error: database disk image is malformed (errno: Success)
```

Apparently `sqlite3_step` returns `SQLITE_CORRUPT`. When using SQLite 3.33.0, the test suite passes.

Enabling debug support by passing `--buildtype debug` to meson and running the tests with `TRACKER_DEBUG=sqlite,sql-statements dbus-run-session meson test --print-errorlogs -t 3` shows the last statement executed:

```
Tracker-Message: 10:22:32.985: Executing update: 'INSERT INTO "main".fts5 (fts5, rowid , "nco:phoneNumber", "nfo:fontFamily", "nmm:artistName", "nfo:tableOfContents", "nfo:fileName", "nfo:genre", "nmm:genre", "nco:emailAddress", "nie:keyword", "nmm:category", "nco:nameAdditional", "nco:nameFamily", "nco:nameGiven", "nco:contactGroupName", "nco:fullname", "nco:nickname", "nco:country", "nco:county", "nco:district", "nco:extendedAddress", "nco:locality", "nco:pobox", "nco:postalcode", "nco:region", "nco:streetAddress", "nco:imID", "nco:imNickname", "nie:comment", "nie:description", "nie:plainTextContent", "nie:subject", "nie:title", "nao:description", "nao:prefLabel", "nco:department", "nco:role", "nco:title", "nco:note") SELECT 'delete', rowid , "nco:phoneNumber", "nfo:fontFamily", "nmm:artistName", "nfo:tableOfContents", "nfo:fileName", "nfo:genre", "nmm:genre", "nco:emailAddress", "nie:keyword", "nmm:category", "nco:nameAdditional", "nco:nameFamily", "nco:nameGiven", "nco:contactGroupName", "nco:fullname", "nco:nickname", "nco:country", "nco:county", "nco:district", "nco:extendedAddress", "nco:locality", "nco:pobox", "nco:postalcode", "nco:region", "nco:streetAddress", "nco:imID", "nco:imNickname", "nie:comment", "nie:description", "nie:plainTextContent", "nie:subject", "nie:title", "nao:description", "nao:prefLabel", "nco:department", "nco:role", "nco:title", "nco:note" FROM "main".fts_view WHERE rowid = 100002'
```