From: | Joe Lester <joe_lester(at)sweetwater(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | postgres list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Abnormal Exit Quandary |
Date: | 2004-05-25 13:11:07 |
Message-ID: | FBB5A661-AE4C-11D8-9330-000A95A58EA0@sweetwater.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)sweetwater(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2004-05-25 13:46:02 | Re: FW: Majordomo results: subscribe pgsql-general |
Previous Message | Joe Lester | 2004-05-25 12:45:02 | Re: Abnormal Exit Quandary |