Обсуждение: Out of buffer error

Hi all,

during a sql statement (running in pgadmin III) I got an error message:

  Out of buffer error - Time to abort

Which buffers are meant?
How could I increase the amount of these buffers?

I hope someone could help me ...

Regards,

Christian

"Christian Brosig" <Brosig@dataconsult.de> writes:
> during a sql statement (running in pgadmin III) I got an error message:
>   Out of buffer error - Time to abort

If this is 7.3.something, update to 7.3.4.

            regards, tom lane

Tom Lane wrote:

> "Christian Brosig" <Brosig@dataconsult.de> writes:
>
>>during a sql statement (running in pgadmin III) I got an error message:
>>  Out of buffer error - Time to abort
>
>
> If this is 7.3.something, update to 7.3.4.

I suspect that is an pgadmin III related problem,
not a postgres problem.


Regards
Gaetano Mendola

Gaetano Mendola <mendola@bigfoot.com> writes:
> Tom Lane wrote:
>> "Christian Brosig" <Brosig@dataconsult.de> writes:
>>> Out of buffer error - Time to abort
>>
>> If this is 7.3.something, update to 7.3.4.

> I suspect that is an pgadmin III related problem,
> not a postgres problem.

No, it's definitely a backend failure.  I think this CVS entry is
probably relevant:

2003-03-23 16:55  tgl

    * src/backend/access/index/indexam.c (REL7_3_STABLE): Band-aid
    patch for Shraibman's 'out of free buffers' bug: disable the
    keys_are_unique optimization introduced in 7.3.  A better fix will
    appear in 7.4, but I think back-patching it is too risky for the
    stable branch.

but if Christian is running something other than 7.3-7.3.2 then we need
another theory.

            regards, tom lane

I am running 7.3.2.
I will update to 7.3.4 as soon as possible.
If the problem is still there after the update, I will post once more
the issue.
Thank you for your help

Best Regards

Christian Brosig

Gaetano Mendola <mendola@bigfoot.com> writes:
> Tom Lane wrote:
>> "Christian Brosig" <Brosig@dataconsult.de> writes:
>>> Out of buffer error - Time to abort
>>
>> If this is 7.3.something, update to 7.3.4.

> I suspect that is an pgadmin III related problem,
> not a postgres problem.

No, it's definitely a backend failure.  I think this CVS entry is
probably relevant:

2003-03-23 16:55  tgl

    * src/backend/access/index/indexam.c (REL7_3_STABLE): Band-aid
    patch for Shraibman's 'out of free buffers' bug: disable the
    keys_are_unique optimization introduced in 7.3.  A better fix
will
    appear in 7.4, but I think back-patching it is too risky for the
    stable branch.

but if Christian is running something other than 7.3-7.3.2 then we need
another theory.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings