From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Out of memory with ODBC |
Date: | 2007-10-12 14:16:30 |
Message-ID: | 470F81BE.7040700@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Relyea, Mike wrote:
> I tried posting this to the OBC list but didn't get any responses, so
> I'm trying my luck here.
>
>> I'm receiving an out of memory error when trying to execute a long,
>> complex query involving many temp tables. I'm using psqlODBC ver
>> 8.02.0500 and PG 8.2.4 on WinXP. I'm trying to execute this query via
>> a pass-through query in MS Access 2003. If I execute this query in
>> PGAdmin III it runs without any errors and returns no records.
Hmm. So what's different about the queries?
>> My connection string in Access is:
>> ODBC; DRIVER={PostgreSQL Unicode}; SERVER=myServer; DATABASE=iqdb;
>> PORT=5432; UID=myUserName; PWD=xxxxxxx; B9=0; B7=1; B3=1; C8=1
>>
>> I've attached the log file which contains the SQL I'm trying to
>> execute and the error details. I've tried setting UseDeclareFetch = 1
>
>> but it didn't resolve the error. Any suggestions?
[145.188]ERROR from backend during send_query: 'SERROR'
[145.188]ERROR from backend during send_query: 'C53200'
[145.188]ERROR from backend during send_query: 'Mout of memory'
[145.188]ERROR from backend during send_query: 'DFailed on request of
size 16.'
[145.188]ERROR from backend during send_query: 'Faset.c'
[145.188]ERROR from backend during send_query: 'L712'
[145.188]ERROR from backend during send_query: 'RAllocSetAlloc'
OK, so this seems to be a server-side error, which means something
should be in the server logs. Is there anything?
Oh, and I'd probably split that query into about a dozen smaller ones -
one per statement.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2007-10-12 14:22:32 | Re: Query problem |
Previous Message | Richard Huxton | 2007-10-12 14:05:32 | Re: how to truncate/purge the pg_xlog directory? |