BUG #4990: JDBC batch insert blocks

From: "dan boeriu" <dan(dot)boeriu(at)roost(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4990: JDBC batch insert blocks
Date: 2009-08-17 21:52:26
Message-ID: 200908172152.n7HLqQga005960@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4990
Logged by: dan boeriu
Email address: dan(dot)boeriu(at)roost(dot)com
PostgreSQL version: 8.3.6 8.3.7 8.4
Operating system: Redhat Linux 5.3
Description: JDBC batch insert blocks
Details:

After I sent 250 records to the database (batch INSERT) the db is not
responding back.
I used the debugger to see what the backend is doing:

#0 0x0000003c4e6d3cf5 in send () from /lib64/libc.so.6
#1 0x000000000053ab05 in internal_flush () at pqcomm.c:1087
#2 0x000000000053ac36 in internal_putbytes (s=0x1f353bf8 "\004\023",
len=378) at pqcomm.c:1042
#3 0x000000000053ac9c in pq_putmessage (msgtype=116 't', s=0x1f353870
"\001@", len=1282) at pqcomm.c:1178
#4 0x000000000053c314 in pq_endmessage (buf=0x7fffbe5c7b60) at
pqformat.c:373
#5 0x00000000005adc53 in PostgresMain (argc=4, argv=<value optimized out>,
username=0x1f2b5fc0 "dbo_staging")
at postgres.c:2266
#6 0x0000000000582fb7 in ServerLoop () at postmaster.c:3207
#7 0x0000000000583c3b in PostmasterMain (argc=5, argv=0x1f2b0ab0) at
postmaster.c:1029
#8 0x000000000053cbce in main (argc=5, argv=<value optimized out>) at
main.c:188

The backtrace is the same if I try to print it several times.
I am using the postgresql-8.3-603.jdbc4.jar driver.

Now the weird thing is that sometimes it works sometimes it doesn't.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2009-08-17 22:18:18 Re: BUG #4990: JDBC batch insert blocks
Previous Message Robert Haas 2009-08-17 20:08:38 Re: BUG #4984: One click Installation error.