# Cannot sync to Rekordbox: SQLiteError: Expression tree is too large **URL:** \ **Category:** Bug Reports\ **Tags:** rekordbox\ **Created:** [October 3, 2026, 12:55pm UTC](https://discuss.lexicondj.com/t/cannot-sync-to-rekordbox-sqliteerror-expression-tree-is-too-large/3678 "2026-10-03T12:55:30Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![dc87](https://discuss.lexicondj.com/letter_avatar_proxy/v4/letter/d/65b543/32.png) [@dc87](https://discuss.lexicondj.com/u/dc87)\ **Post date:** [October 3, 2026, 12:55pm UTC](https://discuss.lexicondj.com/t/cannot-sync-to-rekordbox-sqliteerror-expression-tree-is-too-large/3678/1 "2026-10-03T12:55:30Z")
**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 **Screenshot:** ![Bildschirmfoto 2026-10-03 at 14.55.08](https://d2jjm7r6i2krmb.cloudfront.net/original/2X/8/889de23145e411e1fe68b04aad0fe7c98e33b60f.png) ---
**Author:** ![Christiaan](https://discuss.lexicondj.com/user_avatar/discuss.lexicondj.com/christiaan/32/10_2.png) [@Christiaan](https://discuss.lexicondj.com/u/Christiaan)\ **Post date:** [October 3, 2026, 5:56pm UTC](https://discuss.lexicondj.com/t/cannot-sync-to-rekordbox-sqliteerror-expression-tree-is-too-large/3678/2 "2026-10-03T17:56:35Z")
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) ---
**Author:** ![dc87](https://discuss.lexicondj.com/letter_avatar_proxy/v4/letter/d/65b543/32.png) [@dc87](https://discuss.lexicondj.com/u/dc87)\ **Post date:** [October 3, 2026, 6:47pm UTC](https://discuss.lexicondj.com/t/cannot-sync-to-rekordbox-sqliteerror-expression-tree-is-too-large/3678/3 "2026-10-03T18:47:05Z")
Thanks! That‘s really interesting, however. 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. ---
**Author:** ![Christiaan](https://discuss.lexicondj.com/user_avatar/discuss.lexicondj.com/christiaan/32/10_2.png) [@Christiaan](https://discuss.lexicondj.com/u/Christiaan)\ **Post date:** [October 3, 2026, 8:29pm UTC](https://discuss.lexicondj.com/t/cannot-sync-to-rekordbox-sqliteerror-expression-tree-is-too-large/3678/4 "2026-10-03T20:29:02Z")
Yeah it came from djay, I don’t know why but I’ll make sure duplicate cues like that are filtered next time ---
**Author:** ![dc87](https://discuss.lexicondj.com/letter_avatar_proxy/v4/letter/d/65b543/32.png) [@dc87](https://discuss.lexicondj.com/u/dc87)\ **Post date:** [October 5, 2026, 2:11pm UTC](https://discuss.lexicondj.com/t/cannot-sync-to-rekordbox-sqliteerror-expression-tree-is-too-large/3678/5 "2026-10-05T14:11:43Z")
Hi @Christiaan, small update. 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. ---
**Author:** ![dc87](https://discuss.lexicondj.com/letter_avatar_proxy/v4/letter/d/65b543/32.png) [@dc87](https://discuss.lexicondj.com/u/dc87)\ **Post date:** [October 5, 2026, 3:47pm UTC](https://discuss.lexicondj.com/t/cannot-sync-to-rekordbox-sqliteerror-expression-tree-is-too-large/3678/6 "2026-10-05T15:47:20Z")
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? ![Bildschirmfoto 2026-10-05 at 17.46.16](https://d2jjm7r6i2krmb.cloudfront.net/original/2X/c/ce9217d1c5cdab3ff2c780d01d8481218eb4416c.png) ---
**Author:** ![dc87](https://discuss.lexicondj.com/letter_avatar_proxy/v4/letter/d/65b543/32.png) [@dc87](https://discuss.lexicondj.com/u/dc87)\ **Post date:** [October 5, 2026, 4:11pm UTC](https://discuss.lexicondj.com/t/cannot-sync-to-rekordbox-sqliteerror-expression-tree-is-too-large/3678/7 "2026-10-05T16:11:31Z")
And a bit more analysis 😃 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. ---
**Author:** ![Christiaan](https://discuss.lexicondj.com/user_avatar/discuss.lexicondj.com/christiaan/32/10_2.png) [@Christiaan](https://discuss.lexicondj.com/u/Christiaan)\ **Post date:** [October 5, 2026, 6:30pm UTC](https://discuss.lexicondj.com/t/cannot-sync-to-rekordbox-sqliteerror-expression-tree-is-too-large/3678/8 "2026-10-05T18:30:18Z")
> [@dc87](#): > > 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? That’s a bug it seems, I’ll fix that