Proj not loading on x86 platforms

[BenCurran98]

Hi! I've recently noticed that Proj isn't loading its artifacts from PROJ_jll properly on ubuntu with x86 architecture? You can see an example of it here but the main error it shows is:

ERROR: LoadError: InitError: could not load library "/home/runner/.julia/artifacts/1d0059ab198b22a3ed51541671c40258be799733/lib/libproj.so"
libsqlite3.so.0: cannot open shared object file: No such file or directory
Stacktrace:
  [1] #dlopen#3
    @ ./libdl.jl:120 [inlined]
  [2] dlopen(s::String, flags::UInt32)
    @ Base.Libc.Libdl ./libdl.jl:119
  [3] macro expansion
    @ ~/.julia/packages/JLLWrappers/m2Pjh/src/products/library_generators.jl:63 [inlined]
  [4] __init__()
    @ PROJ_jll ~/.julia/packages/PROJ_jll/lq5nt/src/wrappers/i686-linux-gnu-cxx11.jl:50

Any help would be greatly appreciated!

[visr]

I see in the CI logs it uses a SQLite_jll released recently. Does it also happen on older versions? And does the same error occur when loading only SQLite_jll? See JuliaPackaging/Yggdrasil#10496 for a similar issue. Based on JuliaBinaryWrappers/SQLite_jll.jl@a590f44#diff-248757425c80d519c91e1be718766832fdd989ae7837c5c4b6e64f95931a4757 it seems like it broke the ABI again.

[visr]

I ran CI, see https://github.com/JuliaGeo/Proj.jl/actions/runs/21374545170, it doesn't look too bad, though we don't currently run x86 CI, perhaps we should. The MacOS failures are #125.

[BenCurran98]

Thanks for the response! It looks like it works fine (here if I fix the version of SQLite to 3.48.0, consistent with that issue you posted. Interestingly just loading the newest version of SQLite as per your suggestion works on x86, so I suspect it must be some interaction with proj itself? (See here)