Re: [HACKERS] FlushRelationBuffers error

2004-09-30 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: I'm running postgres 7.4.5 on a linux box, this morning I got this error on my logs: WARNING: FlushRelationBuffers("exp_provider", 1836): block 1460 is referenced (private 0, global 1) ERROR: FlushRelationBuffers returned -2 Info for

Re: [HACKERS] FlushRelationBuffers error

2004-09-30 Thread Gaetano Mendola
Jan Wieck wrote: > Any chance for bad memory? > I'll say near 0. However who never knows ? Now the server is again up and running without glitches. I suspect a race condition somewhere for the reindex operation. I had with the engine 7.3 ( see in the archives ) a duplicate error during reindexes at

Re: [HACKERS] FlushRelationBuffers error

2004-09-30 Thread Tom Lane
Gaetano Mendola <[EMAIL PROTECTED]> writes: > I'm running postgres 7.4.5 on a linux box, this morning I got this error on my logs: > WARNING: FlushRelationBuffers("exp_provider", 1836): block 1460 is referenced > (private 0, global 1) > ERROR: FlushRelationBuffers returned -2 > Info for hacker

Re: [HACKERS] FlushRelationBuffers error

2004-09-30 Thread Jan Wieck
Any chance for bad memory? Jan On 9/30/2004 6:16 AM, Gaetano Mendola wrote: Hi all, I'm running postgres 7.4.5 on a linux box, this morning I got this error on my logs: WARNING: FlushRelationBuffers("exp_provider", 1836): block 1460 is referenced (private 0, global 1) ERROR: FlushRelationBuffers

[HACKERS] FlushRelationBuffers error

2004-09-30 Thread Gaetano Mendola
Hi all, I'm running postgres 7.4.5 on a linux box, this morning I got this error on my logs: WARNING: FlushRelationBuffers("exp_provider", 1836): block 1460 is referenced (private 0, global 1) ERROR: FlushRelationBuffers returned -2 DEBUG: AbortCurrentTransaction PANIC: cannot abort transactio