dimitri
The value NIL is not of type STRING when binding STRING
-
show what you did, LOAD DATABASE FROM mssql://BreakawayUser@CONL-MP26AJRX\SQLEXPRESS:1433/Breakaway INTO postgresql://[email protected]:49153/postgres with include drop, create tables, create indexes, reset sequences, workers = 2 set work_mem to '16MB', maintenance_work_mem to '512 MB';
-
show the result you got, 2022-07-27T12:27:49.010000Z LOG pgloader version "3.6.3~devel" 2022-07-27T12:27:49.020000Z LOG Data errors in '/tmp/pgloader/' 2022-07-27T12:27:49.020000Z LOG Parsing commands from file #P"/home/abruck/config" KABOOM! FATAL error: Failed to connect to pgsql at "host.docker.internal" (port 49153) as user "postgres": The value NIL is not of type STRING when binding STRING
-
[ ] pgloader --version
pgloader version "3.6.3~devel" compiled with SBCL 2.1.11.debian ```
-
[ ] did you test a fresh compile from the source tree? yes
-
[ ] did you search for other similar issues? yes
-
[ ] how can I reproduce the bug? not sure. this is my first time working with pgloader (and SQL Server as well) So, let me know what you need ...
result of verbose debug: Backtrace for: #<SB-THREAD:THREAD "main thread" RUNNING {1000DD4103}> 0: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE-TO-STREAM #<SB-IMPL::STRING-OUTPUT-STREAM {10088144D3}>) 1: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE #<PGLOADER.CONNECTION:DB-CONNECTION-ERROR {1008814473}> :OUTPUT NIL :IF-EXISTS :APPEND :VERBOSE NIL) 2: ((FLET "H0" :IN PGLOADER::MAIN) #<PGLOADER.CONNECTION:DB-CONNECTION-ERROR {1008814473}>) 3: (SB-KERNEL::%SIGNAL #<PGLOADER.CONNECTION:DB-CONNECTION-ERROR {1008814473}>) 4: (ERROR PGLOADER.CONNECTION:DB-CONNECTION-ERROR :MESG "The value NIL is not of type STRING when binding STRING" :TYPE "pgsql" :HOST "host.docker.internal" :PORT 49153 :USER "postgres") 5: (PGLOADER.PGSQL:LIST-RESERVED-KEYWORDS #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://[email protected]:49153/pg {1007FB7073}>) 6: ((LAMBDA ())) 7: (PGLOADER:RUN-COMMANDS #P"/home/abruck/config" :START-LOGGER NIL :FLUSH-SUMMARY T :SUMMARY NIL :LOG-FILENAME NIL :LOG-MIN-MESSAGES NIL :CLIENT-MIN-MESSAGES NIL) 8: (PGLOADER::PROCESS-COMMAND-FILE ("config") :FLUSH-SUMMARY T) 9: (PGLOADER.MONITOR::CALL-WITH-MONITOR #<FUNCTION (LAMBDA NIL :IN PGLOADER::MAIN) {1006F1150B}>) 10: (PGLOADER::MAIN ("pgloader" "--verbose" "--debug" "config")) 11: ((LAMBDA NIL :IN "/build/pgloader-84qaOu/pgloader-3.6.3/dumper-2SKVI5f7.lisp")) 12: ((FLET SB-UNIX::BODY :IN SB-IMPL::START-LISP)) 13: ((FLET "WITHOUT-INTERRUPTS-BODY-3" :IN SB-IMPL::START-LISP)) 14: (SB-IMPL::START-LISP)
2022-07-27T14:08:12.070000Z INFO Stopping monitor
So based on post https://github.com/dimitri/pgloader/issues/348 I tried the following: docker run --rm --name pgloader dimitri/pgloader:latest pgloader mssql://BreakawayUser@CONL-MP26AJRX\SQLEXPRESS:1433/Breakaway postgresql://[email protected]:49153/pg
And got this result: 2022-07-27T14:22:50.018000Z LOG pgloader version "3.6.3~devel" 2022-07-27T14:22:50.021000Z LOG Data errors in '/tmp/pgloader/' KABOOM! FATAL error: Failed to connect to pgsql at "host.docker.internal" (port 49153) as user "postgres": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8). An unhandled error condition has been signalled: Failed to connect to pgsql at "host.docker.internal" (port 49153) as user "postgres": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8).