Hello, migrating from Mariadb 10.6.10 to Postgresql 14.6 on OpenSuse Leap 15.4 - we recieved the following error
Error from pgloader.log
023-01-05T16:17:20.458000Z ERROR A thread failed with error: on #<BASIC-TCP-STREAM UTF-8 (SOCKET/7) #x30205C2BDD2D> :
Connection reset by peer (error #104) during read
2023-01-05T16:17:20.471270Z ERROR Date/time: 2023-01-05-16:17!
An unhandled error condition has been signalled: on #<BASIC-TCP-STREAM UTF-8 (SOCKET/7) #x30205C2BDD2D> :
Connection reset by peer (error #104) during read
Pgloader version
docker run --rm dimitri/pgloader:ccl.latest pgloader --version
pgloader version "3.6.7~devel"
compiled with Clozure Common Lisp Version 1.12 (v1.12) LinuxX8664
LOAD DATABASE
FROM mysql://test1:test1@128.17.0.1/postgres
INTO postgresql://test1:test1@128.17.0.1/test1
WITH include drop, concurrency = 1, batch size = 1MB, batch rows = 1000
CAST type varchar to text drop typemod
BEFORE LOAD DO
$$ create schema if not exists test1; $$,
$$ alter database test1 set search_path to test1, public; $$;
msg from postgresql.log
2023-01-05 08:17:21 PST [14377]: [1-1] user=test1,db=test1,app=pgloader,client=172.17.0.6WARNING: there is no transaction in progress
2023-01-05 08:17:21 PST [15924]: [1-1] user=test1,db=test1,app=pgloader,client=172.17.0.6WARNING: there is no transaction in progress
Hello, migrating from Mariadb 10.6.10 to Postgresql 14.6 on OpenSuse Leap 15.4 - we recieved the following error
023-01-05T16:17:20.458000Z ERROR A thread failed with error: on #<BASIC-TCP-STREAM UTF-8 (SOCKET/7) #x30205C2BDD2D> : Connection reset by peer (error #104) during read 2023-01-05T16:17:20.471270Z ERROR Date/time: 2023-01-05-16:17! An unhandled error condition has been signalled: on #<BASIC-TCP-STREAM UTF-8 (SOCKET/7) #x30205C2BDD2D> : Connection reset by peer (error #104) during read
docker run --rm dimitri/pgloader:ccl.latest pgloader --version pgloader version "3.6.7~devel" compiled with Clozure Common Lisp Version 1.12 (v1.12) LinuxX8664
docker run --rm -v /var/run/postgresql:/var/run/postgresql -v /var/run/mysql:/var/run/mysql -v ${SCRIPTDIR}/pgloader_workspace:/workspace dimitri/pgloader:ccl.latest pgloader --verbose --logfile=/workspace/pgloader.run --summary=/workspace/pgloader.summary --debug /workspace/cast.load
LOAD DATABASE FROM mysql://test1:test1@128.17.0.1/postgres INTO postgresql://test1:test1@128.17.0.1/test1 WITH include drop, concurrency = 1, batch size = 1MB, batch rows = 1000 CAST type varchar to text drop typemod BEFORE LOAD DO $$ create schema if not exists test1; $$, $$ alter database test1 set search_path to test1, public; $$;
2023-01-05 08:17:21 PST [14377]: [1-1] user=test1,db=test1,app=pgloader,client=172.17.0.6WARNING: there is no transaction in progress 2023-01-05 08:17:21 PST [15924]: [1-1] user=test1,db=test1,app=pgloader,client=172.17.0.6WARNING: there is no transaction in progress