Re: An I/O error occured while sending to the backend

2022-11-17 Thread gzh
Hi, Rob >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? Thank you for your reply. I didn't use CopyManager. ②'s query statement query the data inserted by ①, and a large amount of data in

Re: An I/O error occured while sending to the backend

2022-11-16 Thread Rob Sargent
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 executin

Re: An I/O error occured while sending to the backend

2022-11-15 Thread gzh
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 ② affected by ① ? Cou

Re: An I/O error occured while sending to the backend

2022-11-15 Thread Laurenz Albe
On Wed, 2022-11-16 at 13:04 +0800, gzh wrote: > I have developed an application using the jdbc driver and  > connecting to a postgresql database . > The application mainly does the following two things: > ① read data from the CSV file and insert it into the database > ② perform a database query > I

An I/O error occured while sending to the backend

2022-11-15 Thread gzh
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:382