Re: Postgres jdbc bulk insert stuck

From: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
To: dmachop <dmachop(at)gmail(dot)com>
Cc: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Postgres jdbc bulk insert stuck
Date: 2016-05-22 06:45:38
Message-ID: CAB=Je-G-koBJ_Ygd8h8Fz81HdqMEoXPs7Je=v35tmCEj_7ArFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Can you please share the code that reproduces the issue? I mean DDL to
create the table, and the data for the batch insert.

Alternatively, can you try rebuilding pgjdbc with MAX_BUFFERED_RECV_BYTES=250
and check if that helps? (see
https://github.com/pgjdbc/pgjdbc/blob/94549ffe6c2e643efb1f779a23673b2518e465c1/pgjdbc/src/main/java/org/postgresql/core/v3/QueryExecutorImpl.java#L291
)

Vladimir

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bazan, Hernan 2016-05-24 00:48:04 JDBC failing due to networking issues
Previous Message dmachop 2016-05-22 03:38:20 Re: Postgres jdbc bulk insert stuck