pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

tsearch2,pgsql 7.4.[1|2], pg_dump problem
2+ messages / 2 participants
[nested] [flat]

* tsearch2,pgsql 7.4.[1|2], pg_dump problem
@ 2004-06-25 06:08  Achilleus Mantzios <achill@matrix.gatewaynet.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Achilleus Mantzios @ 2004-06-25 06:08 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; +Cc: pgsql-bugs@postgresql.org


Hi, i noticed a failure when i pg_dump/reload a database with tsearch2.sql 
installed.

I get ERRORS of the type:

dynacom=# SELECT lexize('en_stem','foo bar');
ERROR:  cache lookup failed for function 4652394
dynacom=# SELECT lexize('en_stem','foo bar');
ERROR:  cache lookup failed for function 4652394
dynacom=# SELECT lexize('en_stem','foo bar');
ERROR:  cache lookup failed for function 4652394
dynacom=# SELECT lexize('en_stem','foo bar');
ERROR:  cache lookup failed for function 4652394
dynacom=#
dynacom=# SELECT to_tsvector('default','foo bar');
ERROR:  cache lookup failed for function 4652424
dynacom=# SELECT to_tsvector('default','foo bar');
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.
!>
!>
!> \q

Always the 1st call in a session to to_tsvector gives:
ERROR:  cache lookup failed for function 4652424
and the very next call in the same session causes the postmaster
to SEGV.

This situation is demonstrated in FreeBSD 5.1-RELEASE-p10, pgsql 7.4.1
and in Debian 2.4.18-bf2.4, pgsql 7.4.2.

A workaround is to first load tsearch2.sql script in the newly created
database, reload the dump, and ignore any tsearch2 subsequent ERRORS.

Anyone has a clue?

-- 
-Achilleus




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [GENERAL] tsearch2,pgsql 7.4.[1|2], pg_dump problem
@ 2004-06-25 09:38  Oleg Bartunov <oleg@sai.msu.su>
  parent: Achilleus Mantzios <achill@matrix.gatewaynet.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Oleg Bartunov @ 2004-06-25 09:38 UTC (permalink / raw)
  To: Achilleus Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-general@postgresql.org; pgsql-bugs@postgresql.org

Achilleus,

we have  regprocedure_7.4.patch.gz (http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/)

	Oleg

On Fri, 25 Jun 2004, Achilleus Mantzios wrote:

>
> Hi, i noticed a failure when i pg_dump/reload a database with tsearch2.sql
> installed.
>
> I get ERRORS of the type:
>
> dynacom=# SELECT lexize('en_stem','foo bar');
> ERROR:  cache lookup failed for function 4652394
> dynacom=# SELECT lexize('en_stem','foo bar');
> ERROR:  cache lookup failed for function 4652394
> dynacom=# SELECT lexize('en_stem','foo bar');
> ERROR:  cache lookup failed for function 4652394
> dynacom=# SELECT lexize('en_stem','foo bar');
> ERROR:  cache lookup failed for function 4652394
> dynacom=#
> dynacom=# SELECT to_tsvector('default','foo bar');
> ERROR:  cache lookup failed for function 4652424
> dynacom=# SELECT to_tsvector('default','foo bar');
> 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.
> !>
> !>
> !> \q
>
> Always the 1st call in a session to to_tsvector gives:
> ERROR:  cache lookup failed for function 4652424
> and the very next call in the same session causes the postmaster
> to SEGV.
>
> This situation is demonstrated in FreeBSD 5.1-RELEASE-p10, pgsql 7.4.1
> and in Debian 2.4.18-bf2.4, pgsql 7.4.2.
>
> A workaround is to first load tsearch2.sql script in the newly created
> database, reload the dump, and ignore any tsearch2 subsequent ERRORS.
>
> Anyone has a clue?
>
>

	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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2004-06-25 09:38 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-25 06:08 tsearch2,pgsql 7.4.[1|2], pg_dump problem Achilleus Mantzios <achill@matrix.gatewaynet.com>
2004-06-25 09:38 ` Oleg Bartunov <oleg@sai.msu.su>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox