dimitri / pgloader

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

Issue with pgloader built using CCL #1479

Open MichaelAnckaert opened 1 year ago

MichaelAnckaert commented 1 year ago
pgloader version "3.6.999791d"
compiled with Clozure Common Lisp Version 1.12 (v1.12) LinuxX8664

I built pgloader from source (master branch) using make CL=CCL pgloader.

When running pgloader to migrate mysql source to a postgresql target, I get the following output (hostnames redacted, but they are correct):

ubuntu@ip-<redacted>:~/pgloader$ build/bin/pgloader -v ../pgload.load
2023-04-19T10:51:37.000379Z NOTICE Starting pgloader, log system is ready.
2023-04-19T10:51:37.000995Z LOG pgloader version "3.6.999791d"
2023-04-19T10:51:37.302750Z LOG Migrating from #<MYSQL-CONNECTION mysql://root@<redacted>.eu-central-1.rds.amazonaws.com:3306/dewaele #x3020020E063D>
2023-04-19T10:51:37.302986Z LOG Migrating into #<PGSQL-CONNECTION pgsql://postgres@<redacted>.eu-central-1.rds.amazonaws.com:5432/iam #x3020020E043D>
2023-04-19T10:51:37.307482Z ERROR #1=mysql: Failed to connect to #1# at "<redacted>.eu-central-1.rds.amazonaws.com" (port 3306) as user "root": Error #<USOCKET:NS-HOST-NOT-FOUND-ERROR #x302002161D9D>
2023-04-19T10:51:37.307602Z LOG report summary reset
       table name     errors       read   imported      bytes      total time       read      write
-----------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
  fetch meta data          0          0          0                     0.000s
-----------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
-----------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------

I found issue #1465 and tried to install an older version of libssl, to no avail.