Re: [HACKERS] query crashes backend - cvs

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] query crashes backend - cvs
Дата
Msg-id 199809210129.VAA15270@candle.pha.pa.us
обсуждение исходный текст
Ответ на query crashes backend - cvs  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-hackers
> interesting that
> select * from work_flats where (METRO_ID = 81 or METRO_ID = 82) and  DISTRICT_ID < 11;
> crashes backend
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally before or while processing the request.
> We have lost the connection to the backend, so further processing is impossible.  Terminating.
> while
> select * from work_flats where METRO_ID = 81 or METRO_ID = 82 and  DISTRICT_ID < 11;
> works ok.
>
> This happens with latest cvs, 6.3.2 has no problem.

I can't reproduce this.  Can you send a reproducable example with data,
or tell me what columns have indexes.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
http://www.op.net/~candle              |  (610) 353-9879(w)
  +  If your life is a hard drive,     |  (610) 853-3000(h)
  +  Christ can be your backup.        |

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Christopher Oliver
Дата:
Сообщение: Re: [sferac@bo.nettuno.it: Re: [HACKERS] BUG: NOT boolfield kills backend]
Следующее
От: Tom Lane
Дата:
Сообщение: Version numbers (was Re: [PATCHES] Several libpgtcl fixes)