That is a great question. To be honest, I ran into the problem using londiste (skytools) where I was getting the
SystemError. It happens right around 500MB every time (out of around 1.5GB) during the copy_expert (with a copy_to).
Istumbled on the empty query thing accidently when I was trying to reproduce my problem with generic data. Since it is
thesame error I suppose it could be related. However, I have not looked at the psycopg code enough to see what sort of
problemsmight trigger the SystemError. So I am not sure if an empty query is slipping in there somehow, or if it's
somethingelse that triggers the same failure.
I have been working with Marko on this a little, but also was trying to understand the error better. Thanks for the
effortso far. I would certainly be grateful for any further help!
-eric
-----Original Message-----
From: Daniele Varrazzo [mailto:daniele.varrazzo@gmail.com]
Sent: Friday, March 04, 2011 3:16 PM
To: Eric Snow
Cc: Jan Urbański; psycopg@postgresql.org
Subject: Re: [psycopg] SystemError: null argument to internal routine
On Fri, Mar 4, 2011 at 12:03 AM, Eric Snow <esnow@verio.net> wrote:
> Thanks Jan, that helps explain that. So you are saying that the
> problem is in pq_raise
...
I've fixed the unhandled exception in pq_raise and the handling of empty queries. Patches in my devel branch.
Eric, is your problem related to the "empty query" result not handled or is it something else related to the copy
command,that psycopg may still not handle correctly?
Thanks,
-- Daniele
This email message is intended for the use of the person to whom it has been sent, and may contain information that is
confidentialor legally protected. If you are not the intended recipient or have received this message in error, you are
notauthorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender
immediatelyby return e-mail and permanently delete this message and any attachments. Verio, Inc. makes no warranty that
thisemail is error or virus free. Thank you.
