Postgres Pro
Downloads
Home   >   mailing lists

Re: Table copy - Mailing list pgsql-general

From Andy Hartman
Subject Re: Table copy
Date
Msg-id CAEZv3co2Nmkn462mUL9WXUxwpYws62SD_YDn9xbpUkEZLB-jJA@mail.gmail.com
Whole thread Raw
In response to Re: Table copy  (Andy Hartman <hartman60home@gmail.com>)
Responses Re: Table copy
List pgsql-general
Tree view
I also reduced batch size to 5000 on the last run  .. I like using this SImplySql because it's a script I can launch, so that's why I chose that solution...  I'm using it to load a History Env.

THanks again.

On Wed, Feb 5, 2025 at 4:05 PM Andy Hartman <hartman60home@gmail.com> wrote:
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: Andy Hartman
Date:
Subject: Re: Table copy
Next
From: Ron Johnson
Date:
Subject: Re: Table copy