Thread

1. backend crashes deterministically

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-03-02T19:13:28Z

   Marinos Yannikos (mjy@geizhals.at) reports a bug with a severity of 1
   The lower the number the more severe it is.
   
   Short Description
   backend crashes deterministically
   
   Long Description
   With the postgresql-7.0.3 port for FreeBSD, using FreeBSD 4.1.1-STABLE, the following query kills the backend:
   
   select m.topic_id,m.message_id,m.message_author,
   t.topic_subject,m.message_subject,m.message_timestamp::date
   from forum_messages m, forum_topics t where t.topic_id=m.topic_id
   and (( lower(m.message_body) like '%ecotec%')
   or ( lower(m.message_subject) like '%ecotec%')
   or (lower(m.message_author) like '%ecotec%'))
   order by topic_id asc;
   
   Without "order by topic_id asc", the query works without problems. Also, it works with most other search strings I tried.
   
   Database schema available on request. Since this is data-dependent, I have a copy (dump) of the database as well.
   
   
   
   Sample Code
   
   
   No file was uploaded with this report
   
   
   

2. Re: backend crashes deterministically

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-03-03T00:25:58Z

   Marinos Yannikos (mjy@geizhals.at) writes:
   > Database schema available on request. Since this is data-dependent, I
   > have a copy (dump) of the database as well.
   
   Please.  A stack trace from the crashed backend would be nice too.
   
   			regards, tom lane