Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

server process (PID 1234) was terminated by signal 9: Killed



Здравсвуйте.

Последнее время стало настораживать странное поведение postgres во время
бекапа (pg_dump, потаблично). Понятно, что лочатся таблицы, но настораживает
вот этот кусок лога:

Sep  7 01:01:55 db1 postgres[15320]: [6-1] user=,db= LOG:  server process
(PID 7442) was terminated by signal 9: Killed
Sep  7 01:02:02 db1 postgres[16200]: [6-1] user=xxx,db=xxx LOG:  duration:
7339.559 ms  execute S_2: ROLLBACK
Sep  7 01:02:02 db1 postgres[15320]: [7-1] user=,db= LOG:  terminating any
other active server processes
Sep  7 01:02:02 db1 postgres[7635]: [6-1] user=xxx,db=xxx WARNING:
terminating connection because of crash of another server process
Sep  7 01:02:02 db1 postgres[16200]: [7-1] user=xxx,db=xxx WARNING:
terminating connection because of crash of another server process
Sep  7 01:02:02 db1 postgres[7799]: [6-1] user=postgres,db=xxx WARNING:
terminating connection because of crash of another server process
Sep  7 01:02:02 db1 postgres[7818]: [6-1] user=postgres,db=xxx WARNING:
terminating connection because of crash of another server process
Sep  7 01:02:02 db1 postgres[7634]: [6-1] user=xxx,db=xxx WARNING:
terminating connection because of crash of another server process
Sep  7 01:02:02 db1 postgres[7634]: [6-2] user=xxx,db=xxx DETAIL:  The
postmaster has commanded this server process to roll back the curr
ent

Настораживает что 'was terminated by signal 9: Killed'. Это нормальное
поведение?

При этом с db-машины нету коннектов, помимо коннекта от pg_dump, все
остальные коннекты - с других хостов от jboss и tomcat, используется
hibernate.

-- 
Vladimir Rusinov
http://greenmice.info/


Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group