|
Home > Archive > PostgeSQL ODBC > November 2005 > ERROR [HY000] Out of memory while reading tuples.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ERROR [HY000] Out of memory while reading tuples.
|
|
| Leendert Paul Diterwich 2005-11-02, 9:23 am |
| Dear all,
When reading via the 8.00.01.02 odbc driver I get the error: ERROR [HY000]
Out of memory while reading tuples.
The strange thing is, I have plenty of memory space left and it only happens
when I request data in a certain order.
Can anyone perhaps shed some light on this problem?
With kind regards,
Paul
| |
| Johann Zuschlag 2005-11-02, 9:23 am |
| Hi Dave,
I just thought that we have some kind of problem with memory allocation
in bind.c (line 210 -230?). Maybe that one below is linked to it. Seems
that declare/fetch allocates to much memory and crashes. Only strange
thing is Anoop didn't change anything there. Unfortunately I don't know
anything about the libpq internals.
regards
Johann
Leendert Paul Diterwich:
> Dear all,
>
>
>
> When reading via the 8.00.01.02 odbc driver I get the error: ERROR
> [HY000] Out of memory while reading tuples.
>
> The strange thing is, I have plenty of memory space left and it only
> happens when I request data in a certain order.
>
> Can anyone perhaps shed some light on this problem?
>
>
>
> With kind regards,
>
>
>
> Paul
>
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| Dave Page 2005-11-02, 11:23 am |
|
> -----Original Message-----
> From: Johann Zuschlag & #91;mailto:zuschlag2
@online.de]
> Sent: 02 November 2005 15:09
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] ERROR [HY000] Out of memory while reading tuples.
>
> Hi Dave,
>
> I just thought that we have some kind of problem with memory
> allocation
> in bind.c (line 210 -230?). Maybe that one below is linked to
> it. Seems
> that declare/fetch allocates to much memory and crashes. Only strange
> thing is Anoop didn't change anything there. Unfortunately I
> don't know
> anything about the libpq internals.
>
Well, do you see the same issue with 08.01.0005 Paul? 08.00.0102 is very
different from what we have now.
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
| |
| Leendert Paul Diterwich 2005-11-02, 11:23 am |
| I took the 08.01.0005 driver and set my connection string to utilize the
Unicode driver. This seems to work like a charm. I got an Accessviolation in
the first 10 sec of testing though. But I'm unable to replicate it, by
clicking like a delirious user (trigger a lot of data traffic).
So everything seem to work fine for now.
I will keep you posted if I get other error messages!
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
| |
| Johann Zuschlag 2005-11-02, 11:23 am |
| Dave Page:
>
>
>
>
>
>Well, do you see the same issue with 08.01.0005 Paul? 08.00.0102 is very
>different from what we have now.
>
>Regards, Dave
>
>
>
Sorry, didn't see the version. But still there seems to be a memory problem.
regards
Johann
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
| Dave Page 2005-11-02, 11:23 am |
|
> -----Original Message-----
> From: Johann Zuschlag & #91;mailto:zuschlag2
@online.de]
> Sent: 02 November 2005 15:56
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] ERROR [HY000] Out of memory while reading tuples.
>
> Dave Page:
>
> reading tuples.
> Only strange
> 08.00.0102 is very
> Sorry, didn't see the version. But still there seems to be a
> memory problem.
Possibly - but I don't want to try chasing bugs until they're confirmed
to be in the latest version.
/D
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
|
|
|
|
|