SqliteError: database disk image is malformed

Bug description:

This is my ticket to Pioneer Support Forum (i don’t have reply yet)
Hello Support Team,

I’m reaching out because I can’t find a solution to my issue. I’m an experienced user and have used rekordbox since its first version. At my company, I handle client PC support, develop integrated software solutions, and perform data analysis, so I’m not a beginner user.

I’ve been a DJ since 1996, and I have a music database of about 10,000 tracks, all analyzed with rekordbox, with a good portion having all 8 cue points and 8 hot cues.

After backing up my library using rekordbox’s internal function, formatting my PC, and doing a clean reinstall, I used the library reimport feature. Up until this point, everything worked fine.

However, I am now experiencing five issues:

  1. Tracks that have been played, even for more than 4 minutes, are not marked in green or otherwise shown as already played, even though the display settings are correct.
  2. Tracks with the same key or harmonic key are not flagged, something that previously worked correctly.
  3. USB export does not work when right-clicking on a playlist and selecting Send to > Device; it only works using the Sync Playlist button at the bottom left. The process I must follow to export is:
  • Right-click on a playlist, select Send to > Device
  • The compatibility window for new consoles appears
  • Nothing else happens
  • I have to go to the Sync button at the bottom left for playlists, and when I sync from there, two sync bars start.
  1. History: The folder and history playlists are created, but they are empty, as if no tracks were played. It is completely blank at the end of the set.
  2. If I delete a track and try exporting, it correctly gives an error, but in the log file, in addition to highlighting the missing file with [1], many lines with the [1] (missing track) value appear without track names.

I encountered this problem after another format, and I tried both versions 7.0.5 and 6.8.5, going through the process twice to try both with just version 7 and with both versions installed.

I should note that if I use files from a freshly exported USB drive, the files are correctly marked as played, tracks with similar keys are suggested, and the history on the external device is written correctly. So, the problem isn’t with the XDJ-XZ console or the HDD (Samsung 1TB: Samsung MU-PE1T0R/EU T7 Shield SSD Portatile da 1TB, USB 3.2 Gen.2, blu,compatibile con Mac, iPhone e iPad : Amazon.it: Informatica).

I believe there might be an issue with the database. I wanted to know if you could analyze it to see if it can be fixed.

Looking forward to your response.


At this point, I decided to try using some other software to ‘clean up’ the database. Mixo was able to correctly read the database, but Lexicon DJ gives me an error: ‘Error: SqliteError: database disk image is malformed.’

Do you have any tools that could analyze the database?
Could I share the database with you so it can be reviewed?

Lexicon version: 1.7.6
Operating system: Windows

Step by step to reproduce: I can only send you my database

Screenshot:
db-error