Could not find symbol named: #sqlite3_close_v2 searching in module: '/usr/lib/libsqlite3.so.0'

[kedare]

Hello.

I am just starting with Pharo/smalltalk and sqlite

Running Pharo 11 and 12 (tried both) on Fedora, I installed the library, but most tests are failing with the following error

Could not find symbol named: #sqlite3_close_v2 searching in module: '/usr/lib/libsqlite3.so.0'

The file does exists and is provided by the following rpm package

sudo dnf provides /usr/lib/libsqlite3.so.0
sqlite-libs-3.45.1-2.fc40.i686 : Shared library for the sqlite3 embeddable SQL database engine.
Repo        : @System
Matched from:
Filename    : /usr/lib/libsqlite3.so.0

sqlite-libs-3.45.1-2.fc40.i686 : Shared library for the sqlite3 embeddable SQL database engine.
Repo        : fedora
Matched from:
Filename    : /usr/lib/libsqlite3.so.0

It looks like it's trying to load the i686 version of the library, however pharo is running 64 bits, not sure this is expected ?

This simple code would throw the same error also

| connection |
connection := SQLite3Connection memory.

How can I fix it ?

Thank you.