Too many open files in system FATAL2

Поиск
Список
Период
Сортировка
От Christian MEUNIER
Тема Too many open files in system FATAL2
Дата
Msg-id 9mkntl$1gtu$1@news.tht.net
обсуждение исходный текст
Ответы Re: Too many open files in system FATAL2  (Shaun Thomas <sthomas@townnews.com>)
Список pgsql-general
got the following happened yesterday:

postmaster: StreamConnection: accept: Too many open files in system
postmaster: StreamConnection: accept: Too many open files in system
postmaster: StreamConnection: accept: Too many open files in system
2001-08-30 03:04:27 FATAL 2:  InitOpen(logfile 3 seg 199) failed: Too many
open files in system
Server process (pid 21508) exited with status 512 at Thu Aug 30 03:04:27
2001
Terminating any active server processes...

then like 20 mess like that:

2001-08-30 03:04:27 NOTICE:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend  died
abnormally and possibly corrupted shared memory.
        I have rolled back the current transaction and am       going to
terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.

and DB restarted well after

Any idea why this happen and if i can do something to fix that ?

also i have huge amount of:
2001-08-30 01:26:43 NOTICE:  BEGIN: already a transaction in progress
2001-08-30 01:26:44 NOTICE:  COMMIT: no transaction in progress

and i have no idea why i have those notice too

thx in advance for help





В списке pgsql-general по дате отправления:

Предыдущее
От: "Thurstan R. McDougle"
Дата:
Сообщение: Re: MAX(xmin)
Следующее
От: "Lee Crampton"
Дата:
Сообщение: urgently wanted - plpgsql.so for pg 6.4.2