Обсуждение: contrib/tsearch crashing postgresql 7.3 Stable
Hi, tserach seems to have some problem with 7.3 Stable. test=# SELECT version(); version ----------------------------------------------------------- PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 (1 row) test=# SELECT 'hello&world'::mquery_txt ; mquery_txt ------------------- 'hello' & 'world' (1 row) test=# SELECT 'hello4&world'::mquery_txt ; mquery_txt -------------------- 'hello4' & 'world' (1 row) test=# SELECT '4hello&world'::mquery_txt ; mquery_txt -------------------- '4hello' & 'world' (1 row) test=# SELECT '4-hello&world'::mquery_txt ; server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. !# Can anyone replicate this problem ? In my case it happens consistently . Sadly i had to remove features depending on tsearch on my production website. So if the author takes notice of this and comment on solution i would be grateful. Otherwise 7.3 has been an amazing xperience till now. regds mallah. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.
known problem and fixed in CVS Get patch from http://www.sai.msu.su/~megera/postgres/gist/ Oleg On Tue, 10 Dec 2002, Rajesh Kumar Mallah. wrote: > > Hi, > > tserach seems to have some problem with 7.3 Stable. > > test=# SELECT version(); > version > ----------------------------------------------------------- > PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 > (1 row) > > test=# SELECT 'hello&world'::mquery_txt ; > mquery_txt > ------------------- > 'hello' & 'world' > (1 row) > > test=# SELECT 'hello4&world'::mquery_txt ; > mquery_txt > -------------------- > 'hello4' & 'world' > (1 row) > > test=# SELECT '4hello&world'::mquery_txt ; > mquery_txt > -------------------- > '4hello' & 'world' > (1 row) > > test=# SELECT '4-hello&world'::mquery_txt ; > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > The connection to the server was lost. Attempting reset: Failed. > !# > > Can anyone replicate this problem ? > > In my case it happens consistently . > > Sadly i had to remove features depending on tsearch on my production > website. So if the author takes notice of this and comment on solution > i would be grateful. > > Otherwise 7.3 has been an amazing xperience till now. > > regds > mallah. > > > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
Thanks!! lemme check it out. mallah. On Tuesday 10 December 2002 07:07 pm, Oleg Bartunov wrote: > known problem and fixed in CVS > Get patch from http://www.sai.msu.su/~megera/postgres/gist/ > > Oleg > > On Tue, 10 Dec 2002, Rajesh Kumar Mallah. wrote: > > Hi, > > > > tserach seems to have some problem with 7.3 Stable. > > > > test=# SELECT version(); > > version > > ----------------------------------------------------------- > > PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 > > (1 row) > > > > test=# SELECT 'hello&world'::mquery_txt ; > > mquery_txt > > ------------------- > > 'hello' & 'world' > > (1 row) > > > > test=# SELECT 'hello4&world'::mquery_txt ; > > mquery_txt > > -------------------- > > 'hello4' & 'world' > > (1 row) > > > > test=# SELECT '4hello&world'::mquery_txt ; > > mquery_txt > > -------------------- > > '4hello' & 'world' > > (1 row) > > > > test=# SELECT '4-hello&world'::mquery_txt ; > > server closed the connection unexpectedly > > This probably means the server terminated abnormally > > before or while processing the request. > > The connection to the server was lost. Attempting reset: Failed. > > !# > > > > Can anyone replicate this problem ? > > > > In my case it happens consistently . > > > > Sadly i had to remove features depending on tsearch on my production > > website. So if the author takes notice of this and comment on solution > > i would be grateful. > > > > Otherwise 7.3 has been an amazing xperience till now. > > > > regds > > mallah. > > Regards, > Oleg > _____________________________________________________________ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.