MIME-Version: 1.0
From: Andy Hartman <hartman60home@gmail.com>
Date: Tue, 4 Feb 2025 14:51:47 -0500
Message-ID: <CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com>
Subject: Table copy
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000076c10c062d5657d9"
Archived-At: <https://www.postgresql.org/message-id/CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R%2B55UW3VtuZZeJQBg%40mail.gmail.com>
Precedence: bulk

--00000000000076c10c062d5657d9
Content-Type: text/plain; charset="UTF-8"

I'm copying a large table from mssql to PG using SImplysql and in the Log I
see this message

2025-02-04 14:42:17.975 EST [4796] ERROR:  unexpected EOF on client
connection with an open transaction
2025-02-04 14:42:17.975 EST [4796] CONTEXT:  COPY sqlt_data_1_2022_03, line
208274199, column tagid
2025-02-04 14:42:17.975 EST [4796] STATEMENT:  COPY sqlt_data_1_2022_03
(tagid, intvalue, floatvalue, stringvalue, datevalue, dataintegrity,
t_stamp) FROM STDIN (FORMAT BINARY)
2025-02-04 14:42:18.158 EST [4796] FATAL:  terminating connection because
protocol synchronization was lost
2025-02-04 14:42:18.265 EST [4796] LOG:  could not send data to client: An
established connection was aborted by the software in your host machine.

it then dies with a data stream error.I have copied other tables on this
size with no problems.

 THanks.

--00000000000076c10c062d5657d9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">I&#39;m copying a large table from mssql =
to PG using SImplysql and in the Log I see this message<br><br><div>2025-02=
-04 14:42:17.975 EST [4796] ERROR:=C2=A0 unexpected EOF on client connectio=
n with an open transaction</div><div>2025-02-04 14:42:17.975 EST [4796] CON=
TEXT:=C2=A0 COPY sqlt_data_1_2022_03, line 208274199, column tagid</div><di=
v>2025-02-04 14:42:17.975 EST [4796] STATEMENT:=C2=A0 COPY sqlt_data_1_2022=
_03 (tagid, intvalue, floatvalue, stringvalue, datevalue, dataintegrity, t_=
stamp) FROM STDIN (FORMAT BINARY)</div><div>2025-02-04 14:42:18.158 EST [47=
96] FATAL:=C2=A0 terminating connection because protocol synchronization wa=
s lost</div><div>2025-02-04 14:42:18.265 EST [4796] LOG:=C2=A0 could not se=
nd data to client: An established connection was aborted by the software in=
 your host machine.<br><br>it then dies with a data stream error.I have cop=
ied other tables on this size with no problems.<br><br>=C2=A0THanks.<br><br=
><br></div></div></div>

--00000000000076c10c062d5657d9--