Обсуждение: signal 11 on one child process ( frequently )

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

On Tue, Apr 08, 2003 at 05:21:33PM +0200, Gaetano Mendola wrote:
> 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 ):

Signal 11 is SIGSEGV on Linux (and any POSIX UNIX, I believe), which
should terminate and dump core.  Do you have a corefile anywhere?
You could run a debugger on it and find out what happened.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110