SimpMusic SQLite Blob too big

Describe the bug I can search and play music, but whenever I go to the library the app crashes

To Reproduce Steps to reproduce the behavior:

Click on the library tab

Expected behavior the app not to crash I tried clearing data and cache and it worked for a week, but now its back to crashing again

Log (Error Details) Build version: 0.2.17 Current date: 2025-06-30 19:11:09 Device: Fairphone FP5 OS version: Android 14 (SDK 34)

Stack trace:
android.database.sqlite.SQLiteBlobTooBigException: Row too big to fit into CursorWindow requiredPos=3, totalRows=4 at android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method) at android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:1024) at android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:838) at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62) at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:153) at android.database.sqlite.SQLiteCursor.onMove(SQLiteCursor.java:123) at android.database.AbstractCursor.moveToPosition(AbstractCursor.java:255) at android.database.AbstractCursor.moveToNext(AbstractCursor.java:287) at m4.j.step(Unknown Source:10) at p8.k.l(Unknown Source:110) at p8.k.invoke(Unknown Source:120) at p4.p.invokeSuspend(Unknown Source:203) at p4.p.invoke(SourceFile:1) at p4.p.invoke(SourceFile:2) at m4.b.useConnection(Unknown Source:23) at j4.W.useConnection(Unknown Source:2) at j4.f0.useConnection$room_runtime_release(Unknown Source:10) at p4.q.performSuspending(Unknown Source:115) at p4.b.performSuspending(Unknown Source:0) at p8.Q.getAllPlaylists(Unknown Source:11) at p8.d.getAllRecentData(Unknown Source:225) at p8.P.invokeSuspend(Unknown Source:30) at p8.P.invoke(SourceFile:1) at p8.P.invoke(SourceFile:2) at p4.g.invokeSuspend(Unknown Source:38) at p4.g.invoke(SourceFile:1) at p4.g.invoke(SourceFile:2) at m4.f.a(Unknown Source:106) at m4.f.withTransaction(Unknown Source:0) at p4.h.invokeSuspend(Unknown Source:157) at p4.h.invoke(SourceFile:1) at p4.h.invoke(SourceFile:2) at m4.b.useConnection(Unknown Source:23) at j4.W.useConnection(Unknown Source:2) at j4.f0.useConnection$room_runtime_release(Unknown Source:10) at p4.i.invokeSuspend(Unknown Source:41) at p4.i.invoke(SourceFile:1) at p4.i.invoke(SourceFile:2) at j4.k0.invokeSuspend(Unknown Source:60) at j4.k0.invoke(SourceFile:1) at j4.k0.invoke(SourceFile:2) at Vc.b.a(Unknown Source:22) at Vc.b.startUndispatchedOrReturn(Unknown Source:1) at Oc.m.withContext(Unknown Source:53) at Oc.k.withContext(Unknown Source:0) at j4.i0.invokeSuspend(Unknown Source:65) at ib.a.resumeWith(Unknown Source:11) at Oc.g0.run(Unknown Source:128) at Oc.u0.processNextEvent(Unknown Source:87) at Oc.i.joinBlocking(Unknown Source:18) at Oc.l.runBlocking(Unknown Source:74) at Oc.k.runBlocking(Unknown Source:0) at j4.j0.run(Unknown Source:20) at U3.j1.run(Unknown Source:232) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:644) at java.lang.Thread.run(Thread.java:1012) Suppressed: Uc.h: [k1{Cancelling}@1aa1ae0, Dispatchers.Main.immediate]

User actions: 2025-06-30 19:11:02: MainActivity created 2025-06-30 19:11:03: MainActivity resumed

Jun 30 '25 17:06 sirvinniei

Accidentaly closed it

Jun 30 '25 18:06 sirvinniei

same issue for me @maxrave-dev can you take a look?

Oct 14 '25 06:10 CrazyWolf13

For me it crashes with this error straight on startup:

Build version: 0.2.21
Current date: 2025-10-14 08:20:18
Device: Samsung SM-S938B
OS version: Android 16 (SDK 36)
Stack trace:  
android.database.sqlite.SQLiteBlobTooBigException: Row too big to fit into CursorWindow requiredPos=0, totalRows=1
at android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method)
at android.database.sqlite.SQLiteConnection.executeForCursorWindow([SQLiteConnection.java:1379](http://sqliteconnection.java:1379/))
at android.database.sqlite.SQLiteSession.executeForCursorWindow([SQLiteSession.java:873](http://sqlitesession.java:873/))
at android.database.sqlite.SQLiteQuery.fillWindow([SQLiteQuery.java:62](http://sqlitequery.java:62/))
at android.database.sqlite.SQLiteCursor.fillWindow([SQLiteCursor.java:165](http://sqlitecursor.java:165/))
at android.database.sqlite.SQLiteCursor.onMove([SQLiteCursor.java:126](http://sqlitecursor.java:126/))
at android.database.AbstractCursor.moveToPosition([AbstractCursor.java:269](http://abstractcursor.java:269/))
at android.database.AbstractCursor.moveToNext([AbstractCursor.java:301](http://abstractcursor.java:301/))
at T4.e.X0(Unknown Source:10)
at P8.g.invoke(Unknown Source:1201)
at M4.o.invokeSuspend(Unknown Source:207)
at M4.o.invoke(Unknown Source:12)
at J4.r.invokeSuspend(Unknown Source:30)
at J4.r.invoke(Unknown Source:12)
at androidx.datastore.preferences.protobuf.g0.H(Unknown Source:18)
at xe.B.K(Unknown Source:78)
at J4.s.E(Unknown Source:51)
at H4.A.v(Unknown Source:8)
at M4.l.invokeSuspend(Unknown Source:40)
at Jc.a.resumeWith(Unknown Source:8)
at [xe.K.run](http://xe.k.run/)(Unknown Source:114)
at java.util.concurrent.ThreadPoolExecutor.runWorker([ThreadPoolExecutor.java:1156](http://threadpoolexecutor.java:1156/))
at java.util.concurrent.ThreadPoolExecutor$[Worker.run](http://worker.run/)([ThreadPoolExecutor.java:651](http://threadpoolexecutor.java:651/))
at [java.lang.Thread.run](http://java.lang.thread.run/)([Thread.java:1119](http://thread.java:1119/))
Suppressed: De.e: [v0{Cancelling}@e56b2ac, Dispatchers.Main]
 
User actions:
2025-10-14 08:15:56: MainActivity created
2025-10-14 08:15:56: MainActivity resumed

Oct 14 '25 06:10 CrazyWolf13