PG 7.3.1 with ssl on linux hangs (testcase available)

Поиск
Список
Период
Сортировка
От Hans-Jürgen Hay
Тема PG 7.3.1 with ssl on linux hangs (testcase available)
Дата
Msg-id 1059237369.19643.77.camel@hera.local
обсуждение исходный текст
Ответы Re: PG 7.3.1 with ssl on linux hangs (testcase available)
Список pgsql-bugs
since I moved from postgres 7.1 to 7.3 I get hangs when executing a
select on certaint rows with binary data using psql

The problem is reproducible and affects only single rows in the table .
The hangs happen only when I connect via network unsing psql -h
localhost template1

And the problem is gone, when ssl is switched off in postgresql.conf
But the problem seems to be on the client side, cause its the same using
a 7.1 server.

I have generated a testcase with 2 rows, one works the other not:

The table looks like this

create table testy (id integer, data bytea
);
  (I can send a dump of the table with the offending rows to anybody
interessted by mail -- its about 130 K )
  select * from testy where id=28162    --> works  select * from testy where id=28163    --> hangs + process goes up to
99% utilisation

The offending row is much larger, that might trigger.
  I use a debian system with:  postgresql                               7.3.3-1 client and server


--
Hans-Jürgen Hay <hjh@alterras.de>



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

Предыдущее
От: "Nick Fankhauser"
Дата:
Сообщение: pg_dump failure in tar format.
Следующее
От: Troels Arvin
Дата:
Сообщение: Transactions and exceptions; trailing spaces in byteas