SQLiteException thrown when running jvm only in version 1.0.0-BETA29 and 1.0.0-BETA30

[fethij]

org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (dlopen(file:/Users/user/.gradle/caches/modules-2/files-2.1/com.powersync/core-jvm/1.0.0-BETA30/f24b96de5745e4c19cdbf3cd6c56362b6c4b9983/core-jvm-1.0.0-BETA30.jar!/libpowersync_aarch64.dylib.dylib, 0x000A): tried: 'file:/Users/user/.gradle/caches/modules-2/files-2.1/com.powersync/core-jvm/1.0.0-BETA30/f24b96de5745e4c19cdbf3cd6c56362b6c4b9983/core-jvm-1.0.0-BETA30.jar!/libpowersync_aarch64.dylib.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OSfile:/Users/fet)
at org.sqlite.core.DB.newSQLException(DB.java:1179)
at org.sqlite.core.DB.newSQLException(DB.java:1190)
at org.sqlite.core.DB.execute(DB.java:988)
at org.sqlite.jdbc3.JDBC3PreparedStatement.lambda$execute$0(JDBC3PreparedStatement.java:59)
at org.sqlite.jdbc3.JDBC3Statement.withConnectionTimeout(JDBC3Statement.java:458)
at org.sqlite.jdbc3.JDBC3PreparedStatement.execute(JDBC3PreparedStatement.java:53)
at com.powersync.db.JdbcSqliteDriver.loadExtensions$core(JdbcSqliteDriver.kt:103)
at com.powersync.DatabaseDriverFactory.createDriver$core(DatabaseDriverFactory.jvm.kt:35)
at com.powersync.DatabaseDriverFactory.createDriver$core$default(DatabaseDriverFactory.jvm.kt:12)
at com.powersync.db.internal.InternalDatabaseImpl.(InternalDatabaseImpl.kt:37)
at com.powersync.db.PowerSyncDatabaseImpl.(PowerSyncDatabaseImpl.kt:86)
at com.powersync.PowerSyncDatabaseFactoryKt.createPowerSyncDatabaseImpl(PowerSyncDatabaseFactory.kt:55)
at com.powersync.PowerSyncDatabaseFactoryKt.createPowerSyncDatabaseImpl$default(PowerSyncDatabaseFactory.kt:46)
at com.powersync.PowerSyncDatabaseFactoryKt.PowerSyncDatabase(PowerSyncDatabaseFactory.kt:36)
at com.powersync.PowerSyncDatabaseFactoryKt.PowerSyncDatabase$default(PowerSyncDatabaseFactory.kt:20)

[michaelbarnes]

Hey @fethij can you provide some more information on this one please?

[fethij]

@michaelbarnes I am getting the above error when database.connect(connector)
is called on jvm version of the app. Only BETA29 and BETA30 seem to cause the crash, older version work fine.
kotlin = "2.1.21-RC"
Android Studio Meerkat | 2024.3.1

if more info is needed let me know.

[simolus3]

Thanks, I think I know what's going on here.

dlopen(file:/Users/user/.gradle/caches/modules-2/files-2.1/com.powersync/core-jvm/1.0.0-BETA30/f24b96de5745e4c19cdbf3cd6c56362b6c4b9983/core-jvm-1.0.0-BETA30.jar!/libpowersync_aarch64.dylib.dylib

There are two things that stand out here: The duplicate .dylib extension (I think it's possible sqlite3 may have added one of them, so this would just be an artifact of the error reporting), and the fact that the path points towards a .jar, which SQLite obviously wouldn't be able to dlopen.

I think this may be caused by a recent change to how we load the extension, I'll take a look at fixing this.