From: | "Vincent Kessler" <vincent(dot)kessler(at)quantec-networks(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4527: Prepare of large multirow insert fails without error |
Date: | 2008-11-13 01:17:10 |
Message-ID: | 200811130117.mAD1HAra061986@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: 4527
Logged by: Vincent Kessler
Email address: vincent(dot)kessler(at)quantec-networks(dot)de
PostgreSQL version: 8.3.4
Operating system: Debian Linux 2.6.18-6-686-bigmem
Description: Prepare of large multirow insert fails without error
Details:
Hi,
i am trying to do large multirow inserts using PQsendPrepare. I have not
found a limit in the number of parameters or the size of the querystring, so
i assume memory is the limit.
When executing the PQsendPrepare function using a querystring of about 100kb
in size and about 10000 parameters the function returns after timeout. A
tcpdump shows a "parse" message with a length of 100kb but the transfer
stops after roughly 30kb.
The server log shows:
LOG: incomplete message from client
LOG: unexpected EOF on client connection
A pcap file for analysis using tcpdump or wireshark is available here:
http://www.quantec-networks.de/downloads/dump.pcap
I have no quick way to upgrade to 8.3.5 but according to the changelog it
should not be relevant in this case.
What can i do to narrow down the problem?
Any help is greatly apreciated.
Regards,
Vincent
From | Date | Subject | |
---|---|---|---|
Next Message | Russell Smith | 2008-11-13 10:19:56 | Re: Re: [BUGS] libpq does not manage SSL callbacks properly when other libraries are involved. |
Previous Message | Alvaro Herrera | 2008-11-12 19:52:39 | Re: BUG #4526: Problem with sorting order by clause and null values(space) in the beginning og a string |