when migrate data from mysql to postgresql using pgloader show fell through ECASE expression

Viewed 2289

when I using this command to migrate data from mysql 5.17.1 to postgresql 13 in my macOS Catalina 10.15.7:

pgloader mysql://root:udUS1y5Mb634ugPD@17.101.228.134:3309/common postgresql://postgres:postgres123456@postgres.dolphin.com:5432/dolphin

shows this error:

2021-02-02T14:35:18.015000Z LOG pgloader version "3.6.2"
2021-02-02T14:35:18.017000Z LOG Data errors in '/private/tmp/pgloader/'
KABOOM!
FATAL error: Failed to connect to pgsql at "postgres.dolphin.com" (port 5432) 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 "postgres.dolphin.com" (port 5432) as user "postgres": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8).




What I am doing here?

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

(base)

I read the issue has the same problem but still not figure out where is the problem. What should I do to fix this problem?

0 Answers
Related