Thread: Autovacuum Launcher Process Exception

Hello,

I have been running PostgreSQL for many months and just recently started
getting this exception upon start up.  Does anyone know what the issue
might be?

LOG:   database system is ready to accept connections
LOG:   autovacuum launcher started
LOG:   autovacuum launcher process <PID 7060> was terminated by exception
0xC0000006
HINT:   See C include file "ntstatus.h" for a description of the
hexadecimal value.
LOG:   terminating any other active server processes
LOG:   could not open temporary statistics file "global/pgstat.tmp": No
such file or directory
LOG:   all server processes terminated; reinitializing
PANIC:   could not open control file "global/pg_control": No such file or
directory

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.

elliott@cpi.com wrote:
> Hello,
>
> I have been running PostgreSQL for many months and just recently started
> getting this exception upon start up.  Does anyone know what the issue
> might be?
>
> LOG:   database system is ready to accept connections
> LOG:   autovacuum launcher started
> LOG:   autovacuum launcher process <PID 7060> was terminated by exception
> 0xC0000006
> HINT:   See C include file "ntstatus.h" for a description of the
> hexadecimal value.

http://www.experts-exchange.com/Programming/System/Windows__Programming/Q_20267274.html
(Scroll way down to see the answers to the question)

Do you have the binaries on a network filesystem which is sporadically
failing?

> LOG:   could not open temporary statistics file "global/pgstat.tmp": No
> such file or directory
> LOG:   all server processes terminated; reinitializing
> PANIC:   could not open control file "global/pg_control": No such file or
> directory

So the files in the data directory are suddenly gone?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services