MIME-Version: 1.0
References: <CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com>
 <fd275e8a-80fa-4915-8aa3-9b48728d562a@aklaver.com> <CAEZv3cpop1fqe7Z8tsiAvbvzSFVqZUMwLJ7ccv0g0F8hKhD_GA@mail.gmail.com>
 <0057c073-6dcb-4425-92fc-3a766a78ee96@aklaver.com>
In-Reply-To: <0057c073-6dcb-4425-92fc-3a766a78ee96@aklaver.com>
From: Andy Hartman <hartman60home@gmail.com>
Date: Wed, 5 Feb 2025 12:46:35 -0500
Message-ID: <CAEZv3cqCAZhh9UVV8EvwW7W53HT84TnvyCTgzXNbOp42zE7-ug@mail.gmail.com>
Subject: Re: Table copy
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000090c9cf062d68b587"
Archived-At: <https://www.postgresql.org/message-id/CAEZv3cqCAZhh9UVV8EvwW7W53HT84TnvyCTgzXNbOp42zE7-ug%40mail.gmail.com>
Precedence: bulk

--00000000000090c9cf062d68b587
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

[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

On Wed, Feb 5, 2025 at 11:15=E2=80=AFAM Adrian Klaver <adrian.klaver@aklave=
r.com>
wrote:

> On 2/5/25 05:40, Andy Hartman wrote:
> > mssql - 2016
> > PG - 16.1
> > latest release for Simplysql
> Latest is a relative term and requires anyone in the future coming
> across this thread to work out what you are talking about. For that
> person the current version is 2.1.0.
>
> > Invoke-SqlBulkCopy -SourceConnectionName "src" -SourceTable
> > "sqlt_data_1_2022_03" -DestinationConnectionName "dst" -DestinationTabl=
e
> > "sqlt_data_1_2022_03" -BatchSize 10000 -Notify
> >
> > 2.4 billion records  -- I have down other tables of same size no proble=
ms
>
> Same version of SimplySql?
>
> Same source and destination databases?
>
> Did you look at the Postgres and system logs to see if there was
> relevant information?
>
>
> >
> > mssql OS Windows Server 2019
> > PG OS Windows Server 2022
> >
> > Table:
> > image.png
> >
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

--00000000000090c9cf062d68b587
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>[6992] ERROR:=C2=A0 unexpected EOF o=
n client connection with an open transaction</div><div>2025-02-05 12:19:44.=
919 EST [6992] CONTEXT:=C2=A0 COPY sqlt_data_1_2022_03, line 24431524, colu=
mn dataintegrity</div><div>2025-02-05 12:19:44.919 EST [6992] STATEMENT:=C2=
=A0 COPY sqlt_data_1_2022_03 (tagid, intvalue, floatvalue, stringvalue, dat=
evalue, dataintegrity, t_stamp) FROM STDIN (FORMAT BINARY)</div><div>2025-0=
2-05 12:19:44.919 EST [6992] FATAL:=C2=A0 terminating connection because pr=
otocol synchronization was lost</div></div></div><br><div class=3D"gmail_qu=
ote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Fe=
b 5, 2025 at 11:15=E2=80=AFAM Adrian Klaver &lt;<a href=3D"mailto:adrian.kl=
aver@aklaver.com">adrian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockq=
uote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1p=
x solid rgb(204,204,204);padding-left:1ex">On 2/5/25 05:40, Andy Hartman wr=
ote:<br>
&gt; mssql - 2016<br>
&gt; PG - 16.1<br>
&gt; latest release=C2=A0for Simplysql<br>
Latest is a relative term and requires anyone in the future coming <br>
across this thread to work out what you are talking about. For that <br>
person the current version is 2.1.0.<br>
<br>
&gt; Invoke-SqlBulkCopy -SourceConnectionName &quot;src&quot; -SourceTable =
<br>
&gt; &quot;sqlt_data_1_2022_03&quot; -DestinationConnectionName &quot;dst&q=
uot; -DestinationTable <br>
&gt; &quot;sqlt_data_1_2022_03&quot; -BatchSize 10000 -Notify<br>
&gt; <br>
&gt; 2.4 billion records=C2=A0 -- I have down=C2=A0other tables of same siz=
e no problems<br>
<br>
Same version of SimplySql?<br>
<br>
Same source and destination databases?<br>
<br>
Did you look at the Postgres and system logs to see if there was <br>
relevant information?<br>
<br>
<br>
&gt; <br>
&gt; mssql OS Windows Server 2019<br>
&gt; PG OS Windows Server 2022<br>
&gt; <br>
&gt; Table:<br>
&gt; image.png<br>
&gt; <br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div>

--00000000000090c9cf062d68b587--