new dependency sqlite 3.40 fails on debian bullseye (stable)
I've been looking for an easy fix but it looks like I'm going to have to compile SQLite 3.40. Error message: ``` Failed to load native library:sqlite-3.40.0.0-ef06b2f1-37b2-48d0-9feb-965b82ef1fbf-libsqlitejdbc.so. osinfo: Linux/x86_64 java.lang.UnsatisfiedLinkError: Can't load library: /tmp/sqlite-3.40.0.0-ef06b2f1-37b2-48d0-9feb-965b82ef1fbf-libsqlitejdbc.so at org.graalvm.nativeimage.builder/com.oracle.svm.core.jdk.NativeLibrarySupport.loadLibraryAbsolute(NativeLibrarySupport.java:92) at java.base@17.0.5/java.lang.ClassLoader.loadLibrary(ClassLoader.java:57) at java.base@17.0.5/java.lang.Runtime.load0(Runtime.java:755) at java.base@17.0.5/java.lang.System.load(System.java:1953) at org.sqlite.SQLiteJDBCLoader.loadNativeLibrary(SQLiteJDBCLoader.java:280) at org.sqlite.SQLiteJDBCLoader.extractAndLoadLibraryFile(SQLiteJDBCLoader.java:237) at org.sqlite.SQLiteJDBCLoader.loadSQLiteNativeLibrary(SQLiteJDBCLoader.java:350) at org.sqlite.SQLiteJDBCLoader.initialize(SQLiteJDBCLoader.java:68) at org.sqlite.core.NativeDB.load(NativeDB.java:63) at org.sqlite.SQLiteConnection.open(SQLiteConnection.java:278) at org.sqlite.SQLiteConnection.<init>(SQLiteConnection.java:65) at org.sqlite.jdbc3.JDBC3Connection.<init>(JDBC3Connection.java:28) at org.sqlite.jdbc4.JDBC4Connection.<init>(JDBC4Connection.java:19) at org.sqlite.JDBC.createConnection(JDBC.java:104) at org.sqlite.JDBC.connect(JDBC.java:77) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:121) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) at org.asamk.signal.manager.storage.Database.getHikariDataSource(Database.java:101) at org.asamk.signal.manager.storage.Database.initDatabase(Database.java:32) at org.asamk.signal.manager.storage.AccountDatabase.init(AccountDatabase.java:32) at org.asamk.signal.manager.storage.SignalAccount.lambda$getAccountDatabase$38(SignalAccount.java:1236) at org.asamk.signal.manager.storage.SignalAccount.getOrCreate(SignalAccount.java:1649) at org.asamk.signal.manager.storage.SignalAccount.getAccountDatabase(SignalAccount.java:1234) at org.asamk.signal.manager.storage.SignalAccount.lambda$getRecipientStore$30(SignalAccount.java:1209) at org.asamk.signal.manager.storage.SignalAccount.getOrCreate(SignalAccount.java:1649) at org.asamk.signal.manager.storage.SignalAccount.getRecipientStore(SignalAccount.java:1206) at org.asamk.signal.manager.storage.SignalAccount.getProfileStore(SignalAccount.java:1213) at org.asamk.signal.manager.storage.SignalAccount.migrateLegacyConfigs(SignalAccount.java:404) at org.asamk.signal.manager.storage.SignalAccount.load(SignalAccount.java:183) at org.asamk.signal.manager.SignalAccountFiles.initManager(SignalAccountFiles.java:92) at org.asamk.signal.manager.SignalAccountFiles.initManager(SignalAccountFiles.java:79) at org.asamk.signal.App.loadManager(App.java:355) at org.asamk.signal.App.handleLocalCommand(App.java:288) at org.asamk.signal.App.init(App.java:229) at org.asamk.signal.Main.main(Main.java:60) ERROR HikariPool - HikariPool-1 - Exception during pool initialization. java.sql.SQLException: Error opening connection at org.sqlite.SQLiteConnection.open(SQLiteConnection.java:281) at org.sqlite.SQLiteConnection.<init>(SQLiteConnection.java:65) at org.sqlite.jdbc3.JDBC3Connection.<init>(JDBC3Connection.java:28) at org.sqlite.jdbc4.JDBC4Connection.<init>(JDBC4Connection.java:19) at org.sqlite.JDBC.createConnection(JDBC.java:104) at org.sqlite.JDBC.connect(JDBC.java:77) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:121) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) at org.asamk.signal.manager.storage.Database.getHikariDataSource(Database.java:101) at org.asamk.signal.manager.storage.Database.initDatabase(Database.java:32) at org.asamk.signal.manager.storage.AccountDatabase.init(AccountDatabase.java:32) at org.asamk.signal.manager.storage.SignalAccount.lambda$getAccountDatabase$38(SignalAccount.java:1236) at org.asamk.signal.manager.storage.SignalAccount.getOrCreate(SignalAccount.java:1649) at org.asamk.signal.manager.storage.SignalAccount.getAccountDatabase(SignalAccount.java:1234) at org.asamk.signal.manager.storage.SignalAccount.lambda$getRecipientStore$30(SignalAccount.java:1209) at org.asamk.signal.manager.storage.SignalAccount.getOrCreate(SignalAccount.java:1649) at org.asamk.signal.manager.storage.SignalAccount.getRecipientStore(SignalAccount.java:1206) at org.asamk.signal.manager.storage.SignalAccount.getProfileStore(SignalAccount.java:1213) at org.asamk.signal.manager.storage.SignalAccount.migrateLegacyConfigs(SignalAccount.java:404) at org.asamk.signal.manager.storage.SignalAccount.load(SignalAccount.java:183) at org.asamk.signal.manager.SignalAccountFiles.initManager(SignalAccountFiles.java:92) at org.asamk.signal.manager.SignalAccountFiles.initManager(SignalAccountFiles.java:79) at org.asamk.signal.App.loadManager(App.java:355) at org.asamk.signal.App.handleLocalCommand(App.java:288) at org.asamk.signal.App.init(App.java:229) at org.asamk.signal.Main.main(Main.java:60) Caused by: java.lang.Exception: No native library found for os.name=Linux, os.arch=x86_64, paths=[/org/sqlite/native/Linux/x86_64:/usr/lib64:/lib64:/lib:/usr/lib] at org.sqlite.SQLiteJDBCLoader.loadSQLiteNativeLibrary(SQLiteJDBCLoader.java:375) at org.sqlite.SQLiteJDBCLoader.initialize(SQLiteJDBCLoader.java:68) at org.sqlite.core.NativeDB.load(NativeDB.java:63) at org.sqlite.SQLiteConnection.open(SQLiteConnection.java:278) ... 30 common frames omitted Error loading state file for user +17152567356: Failed to initialize pool: Error opening connection (PoolInitializationException) ``` Here is the link showing which Debian versions include with SQLite version (bullseye/stable is 3.34): https://packages.debian.org/search?keywords=libsqlite3-0 I'll follow up once I work through getting v3.40 compiled to see if that settles things.
issue