Kirjoittaja Aihe: Pgloader valittaa migraatiossa "No such file or directory: postgresql://..."  (Luettu 1634 kertaa)

JA5U

  • Käyttäjä
  • Viestejä: 463
    • Profiili
Moi

Googlesta ei löytynyt toimivaa ratkaisua, joten pitäisi pähkäillä, että mikä tuossa prosesissa mättää.
Sen verran antoi kuitenkin vihiä, että testi
Koodia: [Valitse]
$psql postgresql://postgres:postgres@localhost:5433/mysqltopsql antaa ymmärtää, että yhteys ainakin toimii.

Koodia: [Valitse]
$ pgloader --debug -S mysql://root:root/mysqltopsql postgresql://postgres:postgres@localhost:5433/mysqltopsql
mkdir -p #P"/tmp/pgloader/"
sb-impl::*default-external-format* :UTF-8
tmpdir: #P"/tmp/pgloader/"
mkdir -p #P"/tmp/pgloader/mysql:/root:root/"
KABOOM!
FATAL error: No such file or directory: "postgresql://postgres:postgres@localhost:5433/mysqltopsql"
Date/time: 2020-03-18-16:49An unhandled error condition has been signalled:
                              No such file or directory: "postgresql://postgres:postgres@localhost:5433/mysqltopsql"


Backtrace for: #<SB-THREAD:THREAD "main thread" RUNNING {10090A46B3}>
0: ((LAMBDA NIL :IN SB-DEBUG::FUNCALL-WITH-DEBUG-IO-SYNTAX))
1: (SB-IMPL::CALL-WITH-SANE-IO-SYNTAX #<CLOSURE (LAMBDA NIL :IN SB-DEBUG::FUNCALL-WITH-DEBUG-IO-SYNTAX) {10093C7E0B}>)
2: (SB-IMPL::%WITH-STANDARD-IO-SYNTAX #<CLOSURE (LAMBDA NIL :IN SB-DEBUG::FUNCALL-WITH-DEBUG-IO-SYNTAX) {10093C7DDB}>)
3: (PRINT-BACKTRACE :STREAM #<SB-IMPL::STRING-OUTPUT-STREAM {10093C3DF3}> :START 0 :FROM :DEBUGGER-FRAME :COUNT 4611686018427387903 :PRINT-THREAD T :PRINT-FRAME-SOURCE NIL :METHOD-FRAME-STYLE NIL :EMERGENCY-BEST-EFFORT NIL)
4: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE-TO-STREAM #<SB-IMPL::STRING-OUTPUT-STREAM {10093C3DF3}>)
5: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE #<PGLOADER::LOAD-FILES-NOT-FOUND-ERROR {10093C3C93}> :OUTPUT NIL :IF-EXISTS :APPEND :VERBOSE NIL)
6: ((FLET #:H0 :IN PGLOADER::MAIN) #<PGLOADER::LOAD-FILES-NOT-FOUND-ERROR {10093C3C93}>)
7: (SIGNAL #<PGLOADER::LOAD-FILES-NOT-FOUND-ERROR {10093C3C93}>)
8: (ERROR PGLOADER::LOAD-FILES-NOT-FOUND-ERROR :FILENAME-LIST ("postgresql://postgres:postgres@local:5433/mysqltopsql"))
9: (PGLOADER::PROCESS-COMMAND-FILE ("postgresql://postgres:postgres@localhost:5433/mysqltopsql") :FLUSH-SUMMARY T)
10: (PGLOADER::MAIN ("pgloader" "--debug" "-S" "mysql://root:root/mysqltopsql" "postgresql://postgres:postgres@localhost:5433/mysqltopsql"))
11: ((LAMBDA NIL :IN "/build/pgloader-2tdEH0/pgloader-3.4.1+dfsg/dumper-2SKVI5f7.lisp"))
12: ((FLET #:WITHOUT-INTERRUPTS-BODY-88 :IN SAVE-LISP-AND-DIE))
13: ((LABELS SB-IMPL::RESTART-LISP :IN SAVE-LISP-AND-DIE))



2020-03-18T14:49:47.005000Z NOTICE Starting pgloader, log system is ready.
2020-03-18T14:49:47.011000Z INFO Starting monitor
2020-03-18T14:49:47.013000Z LOG Data errors in '/tmp/pgloader/'
2020-03-18T14:49:47.013000Z ERROR Can not find file: "postgresql://postgres:postgres@localhost:5433/mysqltopsql"
2020-03-18T14:49:47.014000Z INFO Stopping monitor

What I am doing here?

No such file or directory: "postgresql://postgres:postgres@localhost:5433/mysqltopsql"


Waiting for the monitor thread to complete.