| From: | Andy Hartman <hartman60home(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Table copy |
| Date: | 2025-02-04 19:51:47 |
| Message-ID: | CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2025-02-04 20:02:19 | Re: Table copy |
| Previous Message | Rich Shepard | 2025-02-04 19:33:40 | Re: Lookup tables |