Lexicon version: 1.11.14 Operating system (remove one): MacOS 27.0.1
Bug description:
Rekordbox 7 Direct Sync fails (even with a brand-new empty Rekordbox database).
Error: SQLiteError: Expression tree is too large (maximum depth 1000)
I deleted the existing master.db, created completely empty library and tried again. The same error occurs.
Rekordbox was of course not running during the sync attempts.
Logs were uploaded from Lexicon.
Step by step to reproduce:
Sync → Rekordbox Direct (RB 7): Full or Playlists
Somehow you have tracks in your library with 1000+ cues which breaks on sync. Try making a smartlist with a rule Cue points > 100 and delete those from Lexicon (copy smartlist as playlist to delete them)
I also use Djay Pro. Some time ago, after re-importing from Djay Pro (bc I set hot cues there), I noticed that some tracks had around 20 hot cues set for no reason (I only set about 6-8 via performance pads on controller). There were only 4-5 tracks, so I just deleted excessive cues. But maybe there is something with the import then. The tracks are still okay in Djay Pro without irregular cues count.
I just did another check. So, in the smart list with “cues >100”, there really some tracks with massive amount of cues, all with “infinity” sign instead of color.
I deleted everything from Lexicon and did a new import (merge disabled) from DjayPro. And again, there are same tracks with >100 cue points. Lexicon also experiences massive lags when trying to navigate this playlist. Understandable, though.
In DjayPro itself, I see only first 16 queues. I set manually max of 8 and on second page (cues 9-16), I see all cues set to the same timestamp. Probably other ones as well.
Unfortunately, I have no clue how these cues were multiplied, and only for limited number of tracks.
And one more thing.. if I do full import from DjayPro even into empty Lexicon and then immediately go to sync without doing anything, why Lexicon keeps telling me that all tracks were modified?
Restored old backup where cues were still okay. Created empty db on djay pro. Did full sync from Lexicon. Everything fine. Then immediately did import from djay pro → 33 tracks have 9-12 cues instead of original 7-8. Uploaded logs as well.
