Thread: Vacuum Failed - backend closed the channel unexpectedly
Running Linux 2.2.14 postgresql 7.0.3 I am trying to run a vacuum and I get the following output vacuum; NOTICE: FlushRelationBuffers(menudt, 6): block 3 is referenced (private 0, global 2) FATAL 1: VACUUM (vc_vacheap): FlushRelationBuffers returned -2 pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Succeeded. This is only a test database so I can blow away the table and rebuild it but if this is not a known problem then I could do some debugging. Dave
Dave Smith <dave@candata.com> writes: > Running Linux 2.2.14 postgresql 7.0.3 > I am trying to run a vacuum and I get the following output > vacuum; > NOTICE: FlushRelationBuffers(menudt, 6): block 3 is referenced (private > 0, global 2) > FATAL 1: VACUUM (vc_vacheap): FlushRelationBuffers returned -2 Is this reproducible from a standing start? I'd expect it to go away after a postmaster restart. It would be moderately interesting if you can figure out the sequence that got you into that state (ie, buffer reference counts > 0). regards, tom lane