MIME-Version: 1.0
References: <CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com>
 <fd275e8a-80fa-4915-8aa3-9b48728d562a@aklaver.com> <CAEZv3cpop1fqe7Z8tsiAvbvzSFVqZUMwLJ7ccv0g0F8hKhD_GA@mail.gmail.com>
 <0057c073-6dcb-4425-92fc-3a766a78ee96@aklaver.com> <CAEZv3cqCAZhh9UVV8EvwW7W53HT84TnvyCTgzXNbOp42zE7-ug@mail.gmail.com>
 <ae581d81-3d0a-471b-9dc5-e23d98ee1fe6@aklaver.com>
In-Reply-To: <ae581d81-3d0a-471b-9dc5-e23d98ee1fe6@aklaver.com>
From: Andy Hartman <hartman60home@gmail.com>
Date: Wed, 5 Feb 2025 16:05:13 -0500
Message-ID: <CAEZv3cru5+haHbmD+Erga_QPp6x5E8-s1NLZ0MV4vihk51=15A@mail.gmail.com>
Subject: Re: Table copy
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f9dba7062d6b7b24"
Archived-At: <https://www.postgresql.org/message-id/CAEZv3cru5%2BhaHbmD%2BErga_QPp6x5E8-s1NLZ0MV4vihk51%3D15A%40mail.gmail.com>
Precedence: bulk

--000000000000f9dba7062d6b7b24
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

nothing in log from mssql side and no  anti-virus

On Wed, Feb 5, 2025 at 2:06=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver=
.com>
wrote:

>
>
> On 2/5/25 9:46 AM, Andy Hartman wrote:
> > [6992] ERROR:  unexpected EOF on client connection with an open
> transaction
> > 2025-02-05 12:19:44.919 EST [6992] CONTEXT:  COPY sqlt_data_1_2022_03,
> > line 24431524, column dataintegrity
> > 2025-02-05 12:19:44.919 EST [6992] STATEMENT:  COPY sqlt_data_1_2022_03
> > (tagid, intvalue, floatvalue, stringvalue, datevalue, dataintegrity,
> > t_stamp) FROM STDIN (FORMAT BINARY)
> > 2025-02-05 12:19:44.919 EST [6992] FATAL:  terminating connection
> > because protocol synchronization was lost
>
> You need to look at the other end of the connection also, in other words
> what is happening on the MS SQL Server 2016/Windows Server 2019 side?
>
> Also is there anti-virus software running on either end?
>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>

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

<div dir=3D"ltr"><div dir=3D"ltr">nothing in log from mssql side and no=C2=
=A0=C2=A0anti-virus=C2=A0</div></div><br><div class=3D"gmail_quote gmail_qu=
ote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Feb 5, 2025 at=
 2:06=E2=80=AFPM Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.=
com">adrian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><br>
<br>
On 2/5/25 9:46 AM, Andy Hartman wrote:<br>
&gt; [6992] ERROR:=C2=A0 unexpected EOF on client connection with an open t=
ransaction<br>
&gt; 2025-02-05 12:19:44.919 EST [6992] CONTEXT:=C2=A0 COPY sqlt_data_1_202=
2_03, <br>
&gt; line 24431524, column dataintegrity<br>
&gt; 2025-02-05 12:19:44.919 EST [6992] STATEMENT:=C2=A0 COPY sqlt_data_1_2=
022_03 <br>
&gt; (tagid, intvalue, floatvalue, stringvalue, datevalue, dataintegrity, <=
br>
&gt; t_stamp) FROM STDIN (FORMAT BINARY)<br>
&gt; 2025-02-05 12:19:44.919 EST [6992] FATAL:=C2=A0 terminating connection=
 <br>
&gt; because protocol synchronization was lost<br>
<br>
You need to look at the other end of the connection also, in other words <b=
r>
what is happening on the MS SQL Server 2016/Windows Server 2019 side?<br>
<br>
Also is there anti-virus software running on either end?<br>
<br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
</blockquote></div>

--000000000000f9dba7062d6b7b24--