Chasing "signal 11" issues

Поиск
Список
Период
Сортировка
От Tass Chapman
Тема Chasing "signal 11" issues
Дата
Msg-id ec9575e80603300502l573df7afqb33a223cdd1886ee@mail.gmail.com
обсуждение исходный текст
Ответы Re: Chasing "signal 11" issues  (Douglas McNaught <doug@mcnaught.org>)
Re: Chasing "signal 11" issues  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
Since Monday I have been seeing "terminated by signal 11" messages in my 7.4.6 + Slon 1.0.5 system,. but only on the master

I've done a dumapall, initdb and restore , which reduced the frequency but I still get them 6-8 times a day.

After turning up logging it seemed to die when calling a very small table (2 rows, 4 columns, 8 char text strings), but manually selecting caused no issues, so I then took a hit and shutdown the system and swapped out the RAM (from earlier list suggestions).

This seemed to work until 7 hours later when the problem has reappeared, at a higher frequency too.

It is ONLY occuring on the master, not on any of the leaf (replicated) nodes, and seems to be triggered by a few different systems connecting (so no common code base)

Suggestions/help ?

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: How to detect primary key of a table
Следующее
От: Douglas McNaught
Дата:
Сообщение: Re: Chasing "signal 11" issues