Failed to load dynamic library `sqlite3.dll` on version 3.2.0

[GT-610]

Platform: Windows 11
sqlite3 version: 3.2.0

[ZONE] Invalid argument(s): Couldn't resolve native function 'sqlite3_initialize' in 'package:sqlite3/src/ffi/libsqlite3.g.dart' : Failed to load dynamic library 'sqlite3.dll': Failed to load dynamic library 'sqlite3.dll': The specified module could not be found.

 (error code: 126).

#0      Native._ffi_resolver.#ffiClosure0 (dart:ffi-patch/ffi_patch.dart)
#1      Native._ffi_resolver_function (dart:ffi-patch/ffi_patch.dart:1943:20)
#2      sqlite3_initialize (package:sqlite3/src/ffi/libsqlite3.g.dart)
#3      FfiBindings.sqlite3_initialize (package:sqlite3/src/ffi/bindings.dart:194:23)
#4      Sqlite3Implementation.initialize (package:sqlite3/src/implementation/sqlite3.dart:32:25)
#5      Sqlite3Implementation.open (package:sqlite3/src/implementation/sqlite3.dart:49:5)
#6      FfiSqlite3.open (package:sqlite3/src/ffi/implementation.dart:29:18)
#7      SqlStore.init (package:fl_lib/src/core/store/sqlite.dart:54:26)
<asynchronous suspension>
#8      ConnectionStatsStoreSqlite.init (package:server_box/data/store/connection_stats_sqlite.dart:33:5)
<asynchronous suspension>
#9      Stores.init (package:server_box/data/res/store.dart:52:5)
<asynchronous suspension>
#10     _initData (package:server_box/main.dart:58:3)
<asynchronous suspension>
#11     _initApp (package:server_box/main.dart:41:3)
<asynchronous suspension>
#12     main.<anonymous closure> (package:server_box/main.dart:23:5)
<asynchronous suspension>

I ran with flutter run -d windows. Also I tried to build but build passed. Still can't open the app.

I manually downloaded sqlite3.dll and placed it in the root directory of build artifacts, and app worked.

[simolus3]

Is this with a Flutter app created before native assets were released? This might require some changes to your CMakeLists.tx, does adding this work for you?

[GT-610]

Is this with a Flutter app created before native assets were released? This might require some changes to your CMakeLists.tx, does adding this work for you?

I'll try this later. Thanks!

[guitarpicva]

Same issue with a pure Dart program, when trying to create an in memory database.

_db = sqlite3.openInMemory();


Connecting to VM Service at ws://127.0.0.1:41183/R0IZXcs_WZA=/ws
Connected to the VM Service.
[log] Settings: getData: settings/config.json
[log] DSDATA: Connect to broker:localhost:8884
[log] MQTT: Connect to Broker...localhost:8884 secure: true
Unhandled exception:
Invalid argument(s): Couldn't resolve native function 'sqlite3_initialize' in 'package:sqlite3/src/ffi/libsqlite3.g.dart' : No asset with id 'package:sqlite3/src/ffi/libsqlite3.g.dart' found. No available native assets. Attempted to fallback to process lookup. /home/mitch/flutter_sdk/flutter/bin/cache/dart-sdk/bin/dartvm: undefined symbol: sqlite3_initialize.

#0      Native._ffi_resolver.#ffiClosure0 (dart:ffi-patch/ffi_patch.dart)
#1      Native._ffi_resolver_function (dart:ffi-patch/ffi_patch.dart:1943:20)
#2      sqlite3_initialize (package:sqlite3/src/ffi/libsqlite3.g.dart)
#3      FfiBindings.sqlite3_initialize (package:sqlite3/src/ffi/bindings.dart:194:23)
#4      Sqlite3Implementation.initialize (package:sqlite3/src/implementation/sqlite3.dart:32:25)
#5      Sqlite3Implementation.open (package:sqlite3/src/implementation/sqlite3.dart:49:5)
#6      FfiSqlite3.open (package:sqlite3/src/ffi/implementation.dart:29:18)
#7      Sqlite3Implementation.openInMemory (package:sqlite3/src/implementation/sqlite3.dart:100:12)
#8      FfiSqlite3.openInMemory (package:sqlite3/src/ffi/implementation.dart:35:18)
#9      new DsData (file:///containers/src/dart/dsdata/bin/dsdata.dart:41:19)
#10     main (file:///containers/src/dart/dsdata/bin/main.dart:4:3)
#11     _delayEntrypointInvocation.<anonymous closure> (dart:isolate-patch/isolate_patch.dart:312:33)
#12     _RawReceivePort._handleMessage (dart:isolate-patch/isolate_patch.dart:193:12)

Exited (255).

[simolus3]

Are you running that Dart program with dart file.dart? You need to use dart run file.dart for hooks to run and native assets to get built.

[guitarpicva]

This happens particularly in the VS Code debug process (Dart Code extension) which would presumably use dart run....

If I build it with : dart build cli -o deploy -t bin/main.dart and manually run it, it seems to be fine.

So we may be chasing something else, like dart run...

    // Use IntelliSense to learn about possible attributes.
    // Hover to view descriptions of existing attributes.
    // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
    "version": "0.2.0",
    "configurations": [
        {
            "name": "dsdata",
            "request": "launch",
            "type": "dart"  
        }
    ]
}```

[guitarpicva]

Are you running that Dart program with dart file.dart? You need to use dart run file.dart for hooks to run and native assets to get built.

Confirmed that dart run bin/main.dart seems to function normally.

I think we're/I'm into an IDE issue at this point.

[guitarpicva]

Also confirmed. Needed to add a "program": "bin/main.dart" to the launch.json for the runner.

{
    // Use IntelliSense to learn about possible attributes.
    // Hover to view descriptions of existing attributes.
    // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
    "version": "0.2.0",
    "configurations": [
        {
            "name": "dsdata",
            "request": "launch",
            "type": "dart",
            "program": "bin/main.dart"
        }
    ]
}

[simolus3]

Did you also manage to fix the issue in a Flutter app? Let me know if this is still an issue, I can reopen this in that case.

dart run being required is expected, and Flutter apps should also work with the updated native CMake build configuration.