Re: SystemError: null argument to internal routine

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). I stumbled on the empty query thing accidently when I was trying to reproduce my problem with generic data. Since it is the same error I suppose it could be related. However, I have not looked at the psycopg code enough to see what sort of problems might trigger the SystemError. So I am not sure if an empty query is slipping in there somehow, or if it's something else 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 effort so far. I would certainly be grateful for any further help!

-eric

-----Original Message-----
From: Daniele Varrazzo [mailto:daniele(dot)varrazzo(at)gmail(dot)com]
Sent: Friday, March 04, 2011 3:16 PM
To: Eric Snow
Cc: Jan Urbański; psycopg(at)postgresql(dot)org
Subject: Re: [psycopg] SystemError: null argument to internal routine

On Fri, Mar 4, 2011 at 12:03 AM, Eric Snow <esnow(at)verio(dot)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 confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Verio, Inc. makes no warranty that this email is error or virus free. Thank you.