Forum OpenACS Q&A: Re: Fatal: received fatal signal 11

Here is what was being executed just before the crash...

nccedudotlrn=# SELECT * FROM pg_stat_activity;
datid | datname | procpid | usesysid | usename | current_query | waiting | query_start | backend_start | client_addr | client_port
----------+--------------+---------+----------+--------------+--------------------------------------------------------------------------------------------------------------------------------+---------+-------------------------------+-------------------------------+-------------+-------------
98657666 | nccedudotlrn | 16145 | 10 | postgres | <IDLE> | f | 2009-08-21 13:46:37.414982+01 | 2009-08-21 12:15:27.518698+01 | | -1
98657666 | nccedudotlrn | 21493 | 10 | postgres | <IDLE> | f | 2009-08-21 13:49:43.725297+01 | 2009-08-21 13:47:02.859488+01 | | -1
98657666 | nccedudotlrn | 21549 | 10 | postgres | SELECT * FROM pg_stat_activity; | f | 2009-08-21 15:57:56.399604+01 | 2009-08-21 13:50:55.050635+01 | | -1
98657666 | nccedudotlrn | 25390 | 16388 | nccedudotlrn | | f | 2009-08-21 15:57:52.086032+01 | 2009-08-21 15:54:32.437033+01 | | -1
: select dotlrn_communities_all.*,
: dotlrn_community__url(dotlrn_communities_all.community_id) as url,
: (CASE
: WHEN
: dotlrn_communities_all.community_type = 'dotlrn_community'
: THEN 'dotlrn_community'
: WHEN dotlrn_communities_all.community_type = 'dotlrn_club'
: THEN 'dotlrn_club'
: WHEN dotlrn_communities_all.community_type = 'dotlrn_pers_community'
: THEN 'dotlrn_pers_community'
: ELSE 'dotlrn_class_instance'
: END) as simple_community_type,
: tree_level(dotlrn_communities_all.tree_sortkey) as tree_level,
: coalesce((select tree_level(dotlrn_community_types.tree_sortkey)
: from dotlrn_community_types
: where dotlrn_community_types.community_type = dotlrn_communities_all.community_type), 0) as community_
98657666 | nccedudotlrn | 25433 | 16388 | nccedudotlrn | <IDLE> | f | 2009-08-21 15:56:59.780954+01 | 2009-08-21 15:54:32.484492+01 | | -1
98657666 | nccedudotlrn | 25436 | 16388 | nccedudotlrn | <IDLE> | f | | 2009-08-21 15:54:32.488507+01 | | -1
98657666 | nccedudotlrn | 16801 | 16388 | nccedudotlrn | <IDLE> | f | 2009-08-21 15:57:48.476462+01 | 2009-08-21 15:57:48.462369+01 | | -1
98657666 | nccedudotlrn | 19890 | 16388 | nccedudotlrn | <IDLE> | f | 2009-08-21 15:57:53.895152+01 | 2009-08-21 15:57:53.890079+01 | | -1
(8 rows)

This was after it crashed...

We can't see anything out of the ordinary?
Maybe you could advise?

Forum OpenACS Q&A: Re: Fatal: received fatal signal 11 - new error after years!