Re: Abnormal Exit Quandary

Joe Lester <joe_lester@sweetwater.com> · Tue, 25 May 2004 08:11:07 -0500

Thank you for pointing that out Tom. This is much more revealing. I 
think I can take it from here. I'll check max_files_per_process in 
postgresql.conf and I'll check my kernal's settings. Thanks!

2004-05-24 15:02:16 LOG:  out of file descriptors: Too many open files 
in system; release and retry

2004-05-24 15:02:16 LOG:  out of file descriptors: Too many open files 
in system; release and retry

2004-05-24 15:20:12 LOG:  out of file descriptors: Too many open files 
in system; release and retry

2004-05-24 15:20:13 PANIC:  could not open control file 
"/Library/PostgreSQL/data/global/pg_control": Too many open files in 
system

2004-05-24 15:20:13 LOG:  checkpoint process (PID 1188) was terminated 
by signal 6

2004-05-24 15:20:13 LOG:  terminating any other active server processes

2004-05-24 15:20:13 WARNING:  terminating connection because of crash 
of another server process

DETAIL:  The postmaster has commanded this server process to roll back 
the current transaction and exit, because another server process exited 
abnormally and possibly corrupted shared memory.

HINT:  In a moment you should be able to reconnect to the database and 
repeat your command.

On May 24, 2004, at 8:31 PM, Tom Lane wrote:

Joe Lester <joe_lester@sweetwater.com> writes:
I'm getting this message on Postgres 7.4.1 (Mac OS 10.3)
2004-05-24 15:20:15 WARNING:  terminating connection because of crash
of another server process

Well, for starters you could tell us about the actual crash, and not 
the

subsequent shutdown/restart.  The messages you've quoted tell nothing 
at

all.  What happened just before that?

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faqs/FAQ.html