Pgloader: --self-upgrade does not work when installing through the .deb package

[stof]

I have installed the .deb package provided on the site, which contains the 3.1.2 version. When trying to use --self-upgrade, I'm getting an error message No such directory: T

[dimitri]

Fixing this one might be a problem, I now realize I only tried it with a full local build available anyway, and it might need to be able to access to lisp dependencies. Please build from sources for now :(

[stof]

Maybe the --self-upgrade option should be disabled when the tool is installed from a .deb package to get a better error message.

[dimitri]

will see about that yeah

[stof]

Actually, I'm getting the No such directory: T error even with my build from source

[renard]

Have a look at cl-image-builder https://github.com/renard/cl-image-builder

[sorix6]

Is there an update on this issue? I still get the No such directory: T error when using --self-upgrade on Pgloader version 3.4.1.

[dimitri]

Hi @sorix6 ; unfortunately the only way that feature works is when you have all the source code dependencies available somewhere ASDF can find them. I tried to make progress on that a long time ago, to no avail. These days I would recommend building from the latest bundle release, that's easy enough and comes with all the source dependencies. It might be that it's then possible to use --self-upgrade on top of the bundle release, I didn't try. Would you try and report?

[sorix6]

Update:
The previous error can be fixed by installing cl-plus-ssl:

apt install cl-plus-ssl

and building pgloader from the version 3.5.2.

But the following error appears:

KABOOM!
FATAL error: Undefined alien: "SSL_get_version"
Date/time: 2019-03-26-17:55An unhandled error condition has been signalled:
                          Undefined alien: "SSL_get_version"

My configuration:

• docker container using docker-compose
• Ubuntu 18.04

The result of running pgloader --debug commands.load :

KABOOM!
FATAL error: Undefined alien: "SSL_get_version"
Date/time: 2019-03-26-17:55An unhandled error condition has been signalled:
                          Undefined alien: "SSL_get_version"


Backtrace for: #<SB-THREAD:THREAD "main thread" RUNNING {10007305B3}>
0: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE-TO-STREAM #<SB-IMPL::STRING-OUTPUT-STREAM 
{10067A28F3}>)
1: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE #<SB-KERNEL:UNDEFINED-ALIEN-STYLE-WARNING 
{10067A2783}> :OUTPUT NIL :IF-EXISTS :APPEND :VERBOSE NIL)
2: ((FLET "H0" :IN PGLOADER::MAIN) #<SB-KERNEL:UNDEFINED-ALIEN-STYLE-WARNING 
{10067A2783}>)
3: (SB-KERNEL::%SIGNAL #<SB-KERNEL:UNDEFINED-ALIEN-STYLE-WARNING {10067A2783}>)
4: ((FLET SB-KERNEL::%WARN :IN "SYS:SRC;CODE;WARM-ERROR.LISP") SB-KERNEL:UNDEFINED-ALIEN- 
STYLE-WARNING #<SB-KERNEL::CONDITION-CLASSOID STYLE-WARNING> SB-INT:SIMPLE-STYLE- 
WARNING :SYMBOL "SSL_get_version")
5: (SB-SYS:ENSURE-DYNAMIC-FOREIGN-SYMBOL-ADDRESS "SSL_get_version" NIL)
6: ((FLET SB-THREAD::WITH-RECURSIVE-SYSTEM-LOCK-THUNK :IN SB-SYS:UPDATE-LINKAGE-TABLE))
7: ((FLET "WITHOUT-INTERRUPTS-BODY-67" :IN SB-THREAD::CALL-WITH-RECURSIVE-SYSTEM-LOCK))
8: (SB-THREAD::CALL-WITH-RECURSIVE-SYSTEM-LOCK #<CLOSURE (FLET SB-THREAD::WITH-RECURSIVE-SYSTEM-LOCK-THUNK :IN SB-SYS:UPDATE-LINKAGE-TABLE) {7F1DDA54EFBB}> #<SB-THREAD:MUTEX "hash-table lock" owner: #<SB-THREAD:THREAD "main thread" RUNNING {10007305B3}>>)
9: (SB-SYS:UPDATE-LINKAGE-TABLE)
10: ((FLET "WITHOUT-INTERRUPTS-BODY-1" :IN SB-THREAD::CALL-WITH-MUTEX))
11: (SB-THREAD::CALL-WITH-MUTEX #<CLOSURE (FLET SB-THREAD::WITH-MUTEX-THUNK :IN LOAD-SHARED-OBJECT) {7F1DDA54F18B}> #<SB-THREAD:MUTEX "shared object list lock" owner: #<SB-THREAD:THREAD "main thread" RUNNING {10007305B3}>> NIL T NIL)
12: (LOAD-SHARED-OBJECT "libsybdb.so" :DONT-SAVE NIL)
13: (CFFI::LOAD-FOREIGN-LIBRARY-PATH MSSQL::SYBDB "libsybdb.so" NIL)
14: (CFFI::TRY-FOREIGN-LIBRARY-ALTERNATIVES MSSQL::SYBDB ("libsybdb.so" "libsybdb.so.5") NIL)
15: ((FLET CFFI::%DO-LOAD :IN CFFI::%DO-LOAD-FOREIGN-LIBRARY) #<CFFI:FOREIGN-LIBRARY SYBDB "libsybdb.so"> MSSQL::SYBDB (:OR "libsybdb.so" "libsybdb.so.5"))
16: (CFFI:LOAD-FOREIGN-LIBRARY MSSQL::SYBDB :SEARCH-PATH NIL)
17: ((LAMBDA ()))
18: (PGLOADER:RUN-COMMANDS #P"/var/www/html/commands.load" :START-LOGGER NIL :FLUSH-SUMMARY T :SUMMARY NIL :LOG-FILENAME NIL :LOG-MIN-MESSAGES NIL :CLIENT-MIN-MESSAGES NIL)
19: (PGLOADER::PROCESS-COMMAND-FILE ("commands.load") :FLUSH-SUMMARY T)
20: (PGLOADER.MONITOR::CALL-WITH-MONITOR #<CLOSURE (LAMBDA NIL :IN PGLOADER::MAIN) {100574786B}>)
21: (PGLOADER::MAIN ("/opt/pgloader-3.5.2/build/bin/pgloader" "--debug" "commands.load"))
22: ((LAMBDA NIL :IN "/opt/pgloader-3.5.2/dumper-2SKVI5f7.lisp"))
23: ((FLET SB-UNIX::BODY :IN SAVE-LISP-AND-DIE))
24: ((FLET "WITHOUT-INTERRUPTS-BODY-36" :IN SAVE-LISP-AND-DIE))
25: ((LABELS SB-IMPL::RESTART-LISP :IN SAVE-LISP-AND-DIE))



2019-03-26T17:55:43.062000Z INFO Stopping monitor

What I am doing here?

Undefined alien: "SSL_get_version"

---

Hi @dimitri, thank you for your reply. I have managed to build from the latest bundle release and my Pgloader is currently at 3.6.957caa8, with SBCL at 1.4.5.debian. --self-upgrade still throws the same error.

When I run pgloader commands.load, I get a fatal error:

KABOOM!
FATAL error: Undefined alien: "SSLeay"
An unhandled error condition has been signalled: Undefined alien: "SSLeay"
What I am doing here?
Undefined alien: "SSLeay"

The content of my commands.load file is:

LOAD DATABASE
       FROM mssql://user:pass@MSSQLServer/db_name
       INTO postgresql://user:pass@postressv:port/db_name

MATERIALIZE VIEWS
       db_name AS $$ SELECT * FROM db_name; $$

INCLUDING ONLY TABLE NAMES LIKE 'db_name' IN SCHEMA 'dbo'

ALTER SCHEMA 'dbo' RENAME TO 'public'

set work_mem to '32MB', maintenance_work_mem to '512 MB'

[JeffJankowski]

For anyone who comes across FATAL error: Undefined alien: "SSLeay", I solved this error by upgrading SBCL to latest (1.5.1) and recompiling.

http://www.sbcl.org/platform-table.html

[rudi-bruchez]

For anyone who comes across FATAL error: Undefined alien: "SSLeay", I solved this error by upgrading SBCL to latest (1.5.1) and recompiling.

http://www.sbcl.org/platform-table.html

I had to do that to make it work, and I had to compile the latest sbcl (2.0.2) because it was compiled with glbic 2.28 which was too fresh for my Ubuntu 18.04 LTS version ...

If you are like me : I installed first the sbcl package from apt-get because, in order to compile, sbcl needs an older version of sbcl ...