Search Postgresql Archives

Table copy

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux