dimitri / pgloader

Migrate to PostgreSQL in a single command!
http://pgloader.io
Other
5.35k stars 541 forks source link

Connection problem with postgres when migratin data from SQLite database to Postgres #1593

Open skelclique opened 2 months ago

skelclique commented 2 months ago

pgloader version 3.6.7~devel compiled with SBCL 2.1.1.debian sb-impl::default-external-format :UTF-8 tmpdir: #P"/tmp/pgloader/" 2024-07-05T14:03:50.016001Z NOTICE Starting pgloader, log system is ready. 2024-07-05T14:03:50.052003Z INFO Starting monitor 2024-07-05T14:03:50.084005Z LOG pgloader version "3.6.7~devel" 2024-07-05T14:03:50.196011Z INFO Parsed command: LOAD DATABASE FROM sqlite://home/portal/server/prisma/sqlite_dump.sql INTO postgresql://hub:hubpsql@localhost:5432/hub

WITH include drop, create tables, create indexes, reset sequences

SET work_mem to '128MB', maintenance_work_mem to '512 MB'; KABOOM! DB-CONNECTION-ERROR: Failed to connect to pgsql at "localhost" (port 5432) as user "hub": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8). Date/time: 2024-07-05-11:03! An unhandled error condition has been signalled: Failed to connect to pgsql at "localhost" (port 5432) as user "hub": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8).

Backtrace for: #<SB-THREAD:THREAD "main thread" RUNNING {1005598103}> 0: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE-TO-STREAM #<SB-IMPL::STRING-OUTPUT-STREAM {1006AD0473}>) 1: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE #<PGLOADER.CONNECTION:DB-CONNECTION-ERROR {1006AD0413}> :OUTPUT NIL :IF-EXISTS :APPEND :VERBOSE NIL) 2: ((FLET "H0" :IN PGLOADER::MAIN) #<PGLOADER.CONNECTION:DB-CONNECTION-ERROR {1006AD0413}>) 3: (SB-KERNEL::%SIGNAL #<PGLOADER.CONNECTION:DB-CONNECTION-ERROR {1006AD0413}>) 4: (ERROR PGLOADER.CONNECTION:DB-CONNECTION-ERROR :MESG "10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8)." :TYPE "pgsql" :HOST "localhost" :PORT 5432 :USER "hub") 5: (PGLOADER.PGSQL:LIST-RESERVED-KEYWORDS #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://hub@localhost:5432/hub {1006434763}>) 6: ((LAMBDA ())) 7: (PGLOADER:RUN-COMMANDS #P"/home/portal/server/prisma/migrate.load" :START-LOGGER NIL :FLUSH-SUMMARY T :SUMMARY NIL :LOG-FILENAME NIL :LOG-MIN-MESSAGES NIL :CLIENT-MIN-MESSAGES NIL) 8: (PGLOADER::PROCESS-COMMAND-FILE ("migrate.load") :FLUSH-SUMMARY T) 9: (PGLOADER.MONITOR::CALL-WITH-MONITOR #<FUNCTION (LAMBDA NIL :IN PGLOADER::MAIN) {10055B6BAB}>) 10: (PGLOADER::MAIN ("pgloader" "--debug" "migrate.load")) 11: ((LAMBDA NIL :IN "/build/pgloader-jZD9Ua/pgloader-3.6.10/dumper-2SKVI5f7.lisp")) 12: ((FLET SB-UNIX::BODY :IN SB-IMPL::START-LISP)) 13: ((FLET "WITHOUT-INTERRUPTS-BODY-1" :IN SB-IMPL::START-LISP)) 14: (SB-IMPL::START-LISP)

2024-07-05T14:03:50.320018Z INFO Stopping monitor

What I am doing here?

Failed to connect to pgsql at "localhost" (port 5432) as user "hub": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8).