signal 11 on one child process ( frequently )
| От | Gaetano Mendola |
|---|---|
| Тема | signal 11 on one child process ( frequently ) |
| Дата | |
| Msg-id | b6updo$2gss$1@news.hub.org обсуждение исходный текст |
| Ответы |
Re: signal 11 on one child process ( frequently )
|
| Список | pgsql-admin |
Hi, I'm running Postgres 7.3.2 and since a couple of week I can read in the log ( twice in a week ): Apr 8 16:00:03 sdr2 postgres[16882]: [255913] DEBUG: child process (pid 9081) was terminated by signal 11 Apr 8 16:00:03 sdr2 postgres[16882]: [255914] LOG: server process (pid 9081) was terminated by signal 11 Apr 8 16:00:03 sdr2 postgres[16882]: [255915] LOG: terminating any other active server processes This is all activity that was performed by the process 9081 ( is always the same select that genereate the signal 11 ): Apr 8 16:00:03 sdr2 postgres[9081]: [255912] LOG: connection received: host=192.168.135.69 port=33274 Apr 8 16:00:03 sdr2 postgres[9081]: [255913] LOG: connection authorized: user=push database=empdb Apr 8 16:00:03 sdr2 postgres[9081]: [255914] DEBUG: /usr/bin/postmaster child[9081]: starting with ( Apr 8 16:00:03 sdr2 postgres[9081]: [255915] DEBUG: ^Ipostgres Apr 8 16:00:03 sdr2 postgres[9081]: [255916] DEBUG: ^I-v131072 Apr 8 16:00:03 sdr2 postgres[9081]: [255917] DEBUG: ^I-p Apr 8 16:00:03 sdr2 postgres[9081]: [255918] DEBUG: ^Iempdb Apr 8 16:00:03 sdr2 postgres[9081]: [255919] DEBUG: ) Apr 8 16:00:03 sdr2 postgres[9081]: [255920] DEBUG: InitPostgres Apr 8 16:00:03 sdr2 postgres[9081]: [255921] DEBUG: StartTransactionCommand Apr 8 16:00:03 sdr2 postgres[9081]: [255922-1] LOG: query: set datestyle to 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII ' then 'UNKNOWN' else Apr 8 16:00:03 sdr2 postgres[9081]: [255922-2] getdatabaseencoding() end; Apr 8 16:00:03 sdr2 postgres[9081]: [255923] DEBUG: ProcessUtility Apr 8 16:00:03 sdr2 postgres[9081]: [255924] DEBUG: CommitTransactionCommand Apr 8 16:00:03 sdr2 postgres[9081]: [255925] DEBUG: StartTransactionCommand Apr 8 16:00:03 sdr2 postgres[9081]: [255926] DEBUG: ProcessQuery Apr 8 16:00:03 sdr2 postgres[9081]: [255927] DEBUG: CommitTransactionCommand Apr 8 16:00:03 sdr2 postgres[9081]: [255928] LOG: duration: 0.016100 sec Apr 8 16:00:03 sdr2 postgres[9081]: [255929] DEBUG: StartTransactionCommand Apr 8 16:00:03 sdr2 postgres[9081]: [255930-1] LOG: query: SELECT id_publisher FROM v_psl_package_info WHERE id_publisher = 30 AND publisher_na me = 'ReutersNews' AND Apr 8 16:00:03 sdr2 postgres[9081]: [255930-2] id_package = 178 AND package_name = 'ReutersNews_IT' Reagards Gaetano
В списке pgsql-admin по дате отправления: