Unable to load any of the alternatives: ("libsqlite3.so.0" "libsqlite3.so")

[Ambrevar]

I can't compile Next on GuixSD. Running (ql:quickload :next) I get

Unable to load any of the alternatives:
   ("libsqlite3.so.0" "libsqlite3.so")
   [Condition of type LOAD-FOREIGN-LIBRARY-ERROR]

[...]
Backtrace:
  0: (CFFI::FL-ERROR "Unable to load any of the alternatives:~%   ~S" ("libsqlite3.so.0" "libsqlite3.so"))
  1: (CFFI::TRY-FOREIGN-LIBRARY-ALTERNATIVES SQLITE3-LIB ("libsqlite3.so.0" "libsqlite3.so") NIL)
  2: ((FLET CFFI::%DO-LOAD :IN CFFI::%DO-LOAD-FOREIGN-LIBRARY) #<FOREIGN-LIBRARY SQLITE3-LIB> SQLITE3-LIB (:OR "libsqlite3.so.0" "libsqlite3.so"))
  3: (LOAD-FOREIGN-LIBRARY SQLITE3-LIB :SEARCH-PATH NIL)
  4: (SB-FASL::LOAD-FASL-GROUP #S(SB-FASL::FASL-INPUT :STREAM #<SB-SYS:FD-STREAM for "file /home/ambrevar/.cache/common-lisp/sbcl-1.4.4-linux-x64/home/ambrevar/quicklisp/dists/quicklisp/software/cl-sqlite-..
  5: (SB-FASL::LOAD-AS-FASL #<SB-SYS:FD-STREAM for "file /home/ambrevar/.cache/common-lisp/sbcl-1.4.4-linux-x64/home/ambrevar/quicklisp/dists/quicklisp/software/cl-sqlite-20130615-git/sqlite-ffi.fasl" {100..
  6: ((FLET SB-FASL::THUNK :IN LOAD))
  7: (SB-FASL::CALL-WITH-LOAD-BINDINGS #<CLOSURE (FLET SB-FASL::THUNK :IN LOAD) {7FFFF6E4E31B}> #<SB-SYS:FD-STREAM for "file /home/ambrevar/.cache/common-lisp/sbcl-1.4.4-linux-x64/home/ambrevar/quicklisp/d..
  8: ((FLET SB-FASL::LOAD-STREAM :IN LOAD) #<SB-SYS:FD-STREAM for "file /home/ambrevar/.cache/common-lisp/sbcl-1.4.4-linux-x64/home/ambrevar/quicklisp/dists/quicklisp/software/cl-sqlite-20130615-git/sqlite..
  9: (LOAD #P"/home/ambrevar/.cache/common-lisp/sbcl-1.4.4-linux-x64/home/ambrevar/quicklisp/dists/quicklisp/software/cl-sqlite-20130615-git/sqlite-ffi.fasl" :VERBOSE NIL :PRINT NIL :IF-DOES-NOT-EXIST T :E..
 10: (UIOP/UTILITY:CALL-WITH-MUFFLED-CONDITIONS #<CLOSURE (LAMBDA NIL :IN UIOP/LISP-BUILD:LOAD*) {1004390AEB}> ("Overwriting already existing readtable ~S." #(#:FINALIZERS-OFF-WARNING :ASDF-FINALIZERS)))
 11: ((SB-PCL::EMF ASDF/ACTION:PERFORM) #<unused argument> #<unused argument> #<ASDF/LISP-ACTION:LOAD-OP > #<ASDF/LISP-ACTION:CL-SOURCE-FILE "sqlite" "sqlite-ffi">)
 12: ((LAMBDA NIL :IN ASDF/ACTION:CALL-WHILE-VISITING-ACTION))
 13: ((:METHOD ASDF/ACTION:PERFORM-WITH-RESTARTS (ASDF/LISP-ACTION:LOAD-OP ASDF/LISP-ACTION:CL-SOURCE-FILE)) #<ASDF/LISP-ACTION:LOAD-OP > #<ASDF/LISP-ACTION:CL-SOURCE-FILE "sqlite" "sqlite-ffi">) [fast-met..
 14: ((:METHOD ASDF/ACTION:PERFORM-WITH-RESTARTS :AROUND (T T)) #<ASDF/LISP-ACTION:LOAD-OP > #<ASDF/LISP-ACTION:CL-SOURCE-FILE "sqlite" "sqlite-ffi">) [fast-method]
 15: ((:METHOD ASDF/PLAN:PERFORM-PLAN (T)) #<ASDF/PLAN:SEQUENTIAL-PLAN {1001FABDD3}>) [fast-method]
 16: ((FLET SB-C::WITH-IT :IN SB-C::%WITH-COMPILATION-UNIT))
 17: ((:METHOD ASDF/PLAN:PERFORM-PLAN :AROUND (T)) #<ASDF/PLAN:SEQUENTIAL-PLAN {1001FABDD3}>) [fast-method]
 18: ((:METHOD ASDF/OPERATE:OPERATE (ASDF/OPERATION:OPERATION ASDF/COMPONENT:COMPONENT)) #<ASDF/LISP-ACTION:LOAD-OP > #<ASDF/SYSTEM:SYSTEM "sqlite"> :PLAN-CLASS NIL :PLAN-OPTIONS NIL) [fast-method]
 19: ((SB-PCL::EMF ASDF/OPERATE:OPERATE) #<unused argument> #<unused argument> #<ASDF/LISP-ACTION:LOAD-OP > #<ASDF/SYSTEM:SYSTEM "sqlite"> :VERBOSE NIL)
 --more--

I have installed the sqlite package and libsqlite3.so.0 is in ~/.guix-profile/lib/. Any clue? Or am I doing something wrong with ASDF / Quicklisp?

[jmercouris]

I've no experience with this platform, I'm sorry I can't provide you any help. Are you able to use the libsqlite in other projects?

[Ambrevar]

What do you mean "how to"? I simply followed the developers guide until (ql:quickload :next). It could be that cffi is looking into the wrong folder, but I'm don't know how to inspect that.

[sdilts]

Do you have the development packages for those libraries? sqlite-devel or something similar? Oftentimes you need those instead of just the runtime libraries when compiling. If you get any other errors, check if you have the development version of those packages.

[jmercouris]

@Ambrevar One thing that seems strange to me is that there is a 0 as a suffix on libsqlite3.so. That doesn't seem right at all.

[sdilts]

@Ambrevar That's actually vairly common. I don't know what it means though.

[Ambrevar]

The .0 suffix is the major version of the library. Conventionally, libraries are installed this way:

libfoo.so.x.y.z
libfoo.so.x -> libfoo.so.x.y.z
libfoo.so -> libfoo.so.x.y.z

The library with the full version is a regular file while the short names are symbolic links pointing to the desired version.

In my case:

/home/ambrevar/.guix-profile/lib/libsqlite3.so
/home/ambrevar/.guix-profile/lib/libsqlite3.so.0
/home/ambrevar/.guix-profile/lib/libsqlite3.so.0.8.6

[Ambrevar]

@sdilts : Guix does not separate development files (it's mostly a Debian thing).
Here is the list of files:

/gnu/store/sdin91pj2w7m5avvb6vykh6haq8q2ni0-sqlite-3.21.0/bin/sqlite3
/gnu/store/sdin91pj2w7m5avvb6vykh6haq8q2ni0-sqlite-3.21.0/include/sqlite3.h
/gnu/store/sdin91pj2w7m5avvb6vykh6haq8q2ni0-sqlite-3.21.0/include/sqlite3ext.h
/gnu/store/sdin91pj2w7m5avvb6vykh6haq8q2ni0-sqlite-3.21.0/lib/pkgconfig/sqlite3.pc
/gnu/store/sdin91pj2w7m5avvb6vykh6haq8q2ni0-sqlite-3.21.0/lib/libsqlite3.a
/gnu/store/sdin91pj2w7m5avvb6vykh6haq8q2ni0-sqlite-3.21.0/lib/libsqlite3.la
/gnu/store/sdin91pj2w7m5avvb6vykh6haq8q2ni0-sqlite-3.21.0/lib/libsqlite3.so
/gnu/store/sdin91pj2w7m5avvb6vykh6haq8q2ni0-sqlite-3.21.0/lib/libsqlite3.so.0
/gnu/store/sdin91pj2w7m5avvb6vykh6haq8q2ni0-sqlite-3.21.0/lib/libsqlite3.so.0.8.6
/gnu/store/sdin91pj2w7m5avvb6vykh6haq8q2ni0-sqlite-3.21.0/share/man/man1/sqlite3.1.gz

[Ambrevar]

In comparison, the file list on Arch Linux is:

    usr/
    usr/bin/
    usr/bin/showdb
    usr/bin/showjournal
    usr/bin/showstat4
    usr/bin/showwal
    usr/bin/sqldiff
    usr/bin/sqlite3
    usr/include/
    usr/include/sqlite3.h
    usr/include/sqlite3ext.h
    usr/lib/
    usr/lib/libsqlite3.so
    usr/lib/libsqlite3.so.0
    usr/lib/libsqlite3.so.0.8.6
    usr/lib/pkgconfig/
    usr/lib/pkgconfig/sqlite3.pc
    usr/share/
    usr/share/licenses/
    usr/share/licenses/sqlite/
    usr/share/licenses/sqlite/license.txt
    usr/share/man/
    usr/share/man/man1/
    usr/share/man/man1/sqlite3.1.gz

(From https://www.archlinux.org/packages/core/x86_64/sqlite/)

[Ambrevar]

CFFI's documentation suggests that if dlopen() works, it should work...
https://common-lisp.net/project/cffi/manual/html_node/_002aforeign_002dlibrary_002ddirectories_002a.html

[Ambrevar]

OK, the error must be with the ld cache, because dlopen does not find libsqlite, the following C snippet

#define _GNU_SOURCE
#include <stdio.h>
#include <dlfcn.h>

int main(int argc, char** argv) {
    void* lib = dlopen("libsqlite.so", RTLD_NOW | RTLD_GLOBAL);
    if(lib == NULL) {
        fprintf(stderr, "%s\n", dlerror());
        return 1;
    }

    return 0;
}

returns

libsqlite.so: cannot open shared object file: No such file or directory

while it works with other libraries.

I'm not sure how the ld cache works on Guix, I never had this issue before.

[Ambrevar]

My bad, I had missed the "3" in the library name. The dlopen test works, so the issue is indeed with SBCL / CFFI.

[Ambrevar]

I think I've got sbcl-cffi working for Guix (not sure if it works properly). Now (ql:quickload :next) goes on until the next error:

The loaded code expects an incompatible layout for class INVALID-GBK-CHARACTER.
   [Condition of type SIMPLE-ERROR]

Restarts:
 0: [RETRY] Retry loading #<COMPILED-FILE "babel" "babel--system">.
 1: [ACCEPT] Continue, treating loading #<COMPILED-FILE "babel" "babel--system"> as having been successful.
 2: [RETRY] Retry ASDF operation.
 3: [CLEAR-CONFIGURATION-AND-RETRY] Retry ASDF operation after resetting the configuration.
 4: [RETRY] Retry ASDF operation.
 5: [CLEAR-CONFIGURATION-AND-RETRY] Retry ASDF operation after resetting the configuration.
 --more--

Backtrace:
  0: (SB-KERNEL::CHECK-LAYOUT #<SB-KERNEL:LAYOUT for INVALID-GBK-CHARACTER {20512583}> #<SB-KERNEL::CONDITION-CLASSOID INVALID-GBK-CHARACTER> 2 #(#<SB-KERNEL:LAYOUT for T {20300003}> #<SB-KERNEL:LAYOUT for..
  1: (SB-KERNEL::%INIT-OR-CHECK-LAYOUT #<SB-KERNEL:LAYOUT for INVALID-GBK-CHARACTER {20512583}> #<SB-KERNEL::CONDITION-CLASSOID INVALID-GBK-CHARACTER> 2 4 #(#<SB-KERNEL:LAYOUT for T {20300003}> #<SB-KERNEL..
  2: ((FLET "WITHOUT-INTERRUPTS-BODY-29" :IN SB-THREAD::CALL-WITH-RECURSIVE-LOCK))
  3: (SB-THREAD::CALL-WITH-RECURSIVE-LOCK #<CLOSURE (FLET SB-THREAD::WITH-RECURSIVE-LOCK-THUNK :IN SB-KERNEL:FIND-AND-INIT-OR-CHECK-LAYOUT) {7FFFF6E4E05B}> #<SB-THREAD:MUTEX "World Lock" owner: #<SB-THREAD..
  4: (SB-KERNEL:FIND-AND-INIT-OR-CHECK-LAYOUT INVALID-GBK-CHARACTER 2 4 #(#<SB-KERNEL:LAYOUT for T {20300003}> #<SB-KERNEL:LAYOUT for CONDITION {20300E83}> #<SB-KERNEL:LAYOUT for SERIOUS-CONDITION {2030848..
  5: (SB-FASL::LOAD-FASL-GROUP #S(SB-FASL::FASL-INPUT :STREAM #<SB-SYS:FD-STREAM for "file /gnu/store/b5pvyzgwqpi389wk6dw7ad2rq68npa6b-sbcl-babel-0.5.0/lib/sbcl/babel--system.fasl" {1004F5C8B3}> :TABLE #(5..
  6: (SB-FASL::LOAD-AS-FASL #<SB-SYS:FD-STREAM for "file /gnu/store/b5pvyzgwqpi389wk6dw7ad2rq68npa6b-sbcl-babel-0.5.0/lib/sbcl/babel--system.fasl" {1004F5C8B3}> NIL NIL)
  7: ((FLET SB-FASL::THUNK :IN LOAD))
  8: (SB-FASL::CALL-WITH-LOAD-BINDINGS #<CLOSURE (FLET SB-FASL::THUNK :IN LOAD) {7FFFF6E4E3FB}> #<SB-SYS:FD-STREAM for "file /gnu/store/b5pvyzgwqpi389wk6dw7ad2rq68npa6b-sbcl-babel-0.5.0/lib/sbcl/babel--sys..
  9: ((FLET SB-FASL::LOAD-STREAM :IN LOAD) #<SB-SYS:FD-STREAM for "file /gnu/store/b5pvyzgwqpi389wk6dw7ad2rq68npa6b-sbcl-babel-0.5.0/lib/sbcl/babel--system.fasl" {1004F5C8B3}> T)
 10: (LOAD #P"/gnu/store/b5pvyzgwqpi389wk6dw7ad2rq68npa6b-sbcl-babel-0.5.0/lib/sbcl/babel--system.fasl" :VERBOSE NIL :PRINT NIL :IF-DOES-NOT-EXIST T :EXTERNAL-FORMAT :DEFAULT)
 11: (UIOP/UTILITY:CALL-WITH-MUFFLED-CONDITIONS #<CLOSURE (LAMBDA NIL :IN UIOP/LISP-BUILD:LOAD*) {1004F5B6AB}> ("Overwriting already existing readtable ~S." #(#:FINALIZERS-OFF-WARNING :ASDF-FINALIZERS)))
 12: ((SB-PCL::EMF ASDF/ACTION:PERFORM) #<unused argument> #<unused argument> #<ASDF/LISP-ACTION:LOAD-OP > #<ASDF/BUNDLE:COMPILED-FILE "babel" "babel--system">)
 13: ((LAMBDA NIL :IN ASDF/ACTION:CALL-WHILE-VISITING-ACTION))
 14: ((:METHOD ASDF/ACTION:PERFORM-WITH-RESTARTS :AROUND (T T)) #<ASDF/LISP-ACTION:LOAD-OP > #<ASDF/BUNDLE:COMPILED-FILE "babel" "babel--system">) [fast-method]
 15: ((:METHOD ASDF/PLAN:PERFORM-PLAN (T)) #<ASDF/PLAN:SEQUENTIAL-PLAN {1001FA56A3}>) [fast-method]
 16: ((FLET SB-C::WITH-IT :IN SB-C::%WITH-COMPILATION-UNIT))
 17: ((:METHOD ASDF/PLAN:PERFORM-PLAN :AROUND (T)) #<ASDF/PLAN:SEQUENTIAL-PLAN {1001FA56A3}>) [fast-method]
 18: ((:METHOD ASDF/OPERATE:OPERATE (ASDF/OPERATION:OPERATION ASDF/COMPONENT:COMPONENT)) #<ASDF/LISP-ACTION:LOAD-OP > #<ASDF/SYSTEM:SYSTEM "next"> :PLAN-CLASS NIL :PLAN-OPTIONS NIL) [fast-method]
 19: ((SB-PCL::EMF ASDF/OPERATE:OPERATE) #<unused argument> #<unused argument> #<ASDF/LISP-ACTION:LOAD-OP > #<ASDF/SYSTEM:SYSTEM "next"> :VERBOSE NIL)
 --more--

Any clue about that one?

[Ambrevar]

At last! I've managed to run Next on Guix!

First, I had a few dependencies missing:

• sqlite3
• gsettings-desktop-schemas (for webkit)
• glib-networking (for webkit).

@jmercouris: I think we should mention those dependencies in the README. What do you think?

The last issue above was a red herring, the only real issue is that cffi does not find libraries on Guix.

As a workaround, I had to use

> env LD_LIBRARY_PATH="$HOME/.guix-profile/lib" sbcl

before running the install:

(require :asdf)
(asdf:load-asd "/full/path/to/next.asd")
(ql:quickload :next/gtk)
(next:start)

So far it seems to work properly except that I don't have HTML5 videos. Missing dependency?

[Ambrevar]

Seems like gstreamer + some gst-* packages just did it!

[jmercouris]

Nice! shall I close this then? perhaps update the readme?