powered by simpleCommunicator - 2.0.60     © 2026 Programmizd 02
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / server process was terminated by signal 9
4 сообщений из 4, страница 1 из 1
server process was terminated by signal 9
    #35303969
rhfcyjgthrf
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Доброго времени суток!

При обращении из 1С-ки 7.7 периодически возникает ошибка:
Код: plaintext
1.
2.
3.
4.
Microsoft OLE DB Provider for ODBC Drivers: Error while executing the query;
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.    

В логе следующие записи:
Код: plaintext
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
LOG:  could not create IPv6 socket: Address family not supported by protocol
LOG:  database system was interrupted at  2008 - 05 - 08   21 : 24 : 59  EEST
LOG:  checkpoint record is at  41 /4814D538
LOG:  redo record is at  41 /4814D538; undo record is at  0 / 0 ; shutdown FALSE
LOG:  next transaction ID:  82276558 ; next OID:  182631 
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at  41 /4814D574
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
LOG:  record with zero length at  41 /484E4DA4
LOG:  redo done at  41 /484E4D7C
FATAL:  the database system is starting up
LOG:  database system is ready
LOG:  server process (PID  2603 ) was terminated by signal  9 
LOG:  terminating any other active server processes
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.
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.
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.
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.
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.
CONTEXT:  SQL statement "SELECT * FROM (SELECT max(replica),dtype,mask_agg(mask),id_client FROM t_client_repl WHERE replica>1833003 AND replica<=9505685  GROUP BY 2,4) AS q ORDER BY 4,1"
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.
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.
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.
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.
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.
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.
WARNING:  terminating connection because of crash of another server process

Версия postgres 8.1.
ОС Linux.
Объем оперативной памяти: 1 гиг.

Может кто знает, как с этим бороться?
...
Рейтинг: 0 / 0
server process was terminated by signal 9
    #35303983
Dan Black
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
посмотрите логи /var/log/messages и всё поймете...
если не поймете, то добавьте серверу памяти или/ отключите автоматическую убивалку "жирных процессов" в линуксе
Код: plaintext
1.
----------------------------
 Verba volent, scripta manent 
...
Рейтинг: 0 / 0
server process was terminated by signal 9
    #35304495
rhfcyjgthrf
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Dan Blackпосмотрите логи /var/log/messages и всё поймете...
если не поймете, то добавьте серверу памяти или/ отключите автоматическую убивалку "жирных процессов" в линуксе
Код: plaintext
1.
----------------------------
 Verba volent, scripta manent 


Подскажите пож. как это сделать.
...
Рейтинг: 0 / 0
server process was terminated by signal 9
    #35306137
rhfcyjgthrf
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Нашел в документации, что в файл /etc/sysctl.conf необходимо добавить строку
Код: plaintext
1.
vm.oom-kill =  0 

Перегрузил сервер, но процесcы всеравно периодически убиваются.
С линуксом не очень хорошо знаком. Может кто подскажет, как правильно отключить oom-killer.
...
Рейтинг: 0 / 0
4 сообщений из 4, страница 1 из 1
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / server process was terminated by signal 9
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]