Problems of connexion with Tsearch2 functions

From: Séverine Gedzelman <severine(dot)gedzelman(at)evodia(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Problems of connexion with Tsearch2 functions
Date: 2007-07-10 13:40:29
Message-ID: 46938C4D.7040701@evodia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am a beginner with Postgresql and Full-Text indexing enabled by Tsearch2.
I have recently set all the configuration to run Tsearch2 on my
databases (Postgresql 8.2), under Linux (Fedora).
Everything worked great for a period of time. The queries I frequently
used were :
- select finddoc('word') - a special query using the function to_tsquery
- select lexize('word')

Then today, all the queries that call a Tsearch2 function,
instanteanously breaks the connection to the base, failing the query of
course.

1) Example when attempting the query from a Xterminal (french version)

# select set_curdict('fr_ispell');
La connexion au serveur a été coupée à l'improviste
Le serveur s'est peut-être arrêté anormalement
avant ou durant le traitement de la requête.
La connexion au serveur a été perdue. Tentative de réinitialisation : Echec.

2) Example when attempting from our JAVA Application (english version)

# The backend has broken the connection. Possibly the action you have
attempted has caused it to close.
at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:140)
at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:76) at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)

at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:183)

Queries like the following work just fine,

# select count(*) from table ;

So what is the problem really ? Anyone experienced something like this
before with Tsearch2 ? Should I reinstall Tsearch2 completely in
Postgresql ? I have already applied 'uninstall_tsearch2.sql' on my base,
but it does not change anything
Thanks you for advise, hope someone can help.
S.G.

Browse pgsql-general by date

  From Date Subject
Next Message Brad Nicholson 2007-07-10 13:43:44 Vaccum Stalling
Previous Message Richard Huxton 2007-07-10 13:32:14 Re: vacuumdb: PANIC: corrupted item pointer