public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andy Hartman <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Table copy
Date: Tue, 4 Feb 2025 14:51:47 -0500
Message-ID: <CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com> (raw)
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.
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]
Subject: Re: Table copy
In-Reply-To: <CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com>
* 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