signal 11 on one child process ( frequently )

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: signal 11 on one child process ( frequently )
Date: 2003-04-08 15:21:33
Message-ID: b6updo$2gss$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2003-04-08 15:30:49 secondary password file
Previous Message Nick Fankhauser 2003-04-08 14:54:59 Re: How does PG know when a database is being accessed ?