public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Andy Hartman <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Table copy
Date: Tue, 4 Feb 2025 12:02:19 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com>
References: <CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com>



On 2/4/25 11:51 AM, Andy Hartman wrote:
> 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

The above pretty much spells it out.

Something messed with the connection from the client.

You need to look at Postgres and system logs to see if you can track 
down what?

FYI, more information would be helpful:

1) MS SQL version.

2) Postgres version.

3) SimplySQL version.

4) The complete copy command.

5) The amount of data being transferred.

6) The OS'es and their versions on both ends.


> 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.
> 
> 

-- 
Adrian Klaver
[email protected]

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Table copy
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox