Re: Table copy - Mailing list pgsql-general

From Andy Hartman
Subject Re: Table copy
Date
Msg-id CAEZv3cru5+haHbmD+Erga_QPp6x5E8-s1NLZ0MV4vihk51=15A@mail.gmail.com
Whole thread Raw
In response to Re: Table copy  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Table copy
Re: Table copy
Re: Table copy
List pgsql-general
nothing in log from mssql side and no  anti-virus 

On Wed, Feb 5, 2025 at 2:06 PM 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

pgsql-general by date:

Previous
From: Thiemo Kellner
Date:
Subject: Re: Lookup tables
Next
From: Andy Hartman
Date:
Subject: Re: Table copy