From: Rob Sargent <robjsargent@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: An I/O error occured while sending to the backend
Date: Wed, 16 Nov 2022 07:23:21 -0700
Message-ID: <f4701634-77ae-167e-89af-651b9e6085b4@gmail.com> (raw)
In-Reply-To: <18cffc90.499d.1847f5f6458.Coremail.gzhcoder@126.com>
References: <449f5c48.3136.1847ed35c08.Coremail.gzhcoder@126.com>
<240a2e90ec4e940cd71e42d25435e2f3d4e6a4f9.camel@cybertec.at>
<18cffc90.499d.1847f5f6458.Coremail.gzhcoder@126.com>
On 11/16/22 00:37, gzh wrote:
> Thank you very much for your advice.
>
> What I don't understand is that there is no problem when executing
> ① alone or ② alone,
> the error occurs when ① and ② are executed together .
> It works well when i let the application sleep after ① for 10 seconds
> before executing ② .
>
Is this true for large numbers of lines in you csv? Originally you said
something like 'adding 1000 lines' broke your app. Are you using
CopyManager?
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: robjsargent@gmail.com
Subject: Re: An I/O error occured while sending to the backend
In-Reply-To: <f4701634-77ae-167e-89af-651b9e6085b4@gmail.com>
References: <449f5c48.3136.1847ed35c08.Coremail.gzhcoder@126.com> <240a2e90ec4e940cd71e42d25435e2f3d4e6a4f9.camel@cybertec.at> <18cffc90.499d.1847f5f6458.Coremail.gzhcoder@126.com> <f4701634-77ae-167e-89af-651b9e6085b4@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox