From: Mike Bell <mike.bell@hashdefine.co.uk>
To: 'Oleg Bartunov' <oleg@sai.msu.su>
Cc: pgsql-admin@postgresql.org
Subject: Re: Cache loolup failed problems with tsearch following pg_restore
Date: Tue, 23 Mar 2004 19:30:29 -0000
Message-ID: <01df01c4110d$5024c2d0$6401a8c0@hashdefine.local> (raw)
In-Reply-To: <Pine.GSO.4.58.0403231810290.588@ra.sai.msu.su>
Oleg,
Thanks for your suggestion but I'm not sure how this will help. The
function is created _after_ the tsearch installation (script below). I'm
backing up on one machine and trying to restore to another.
Cheers
Mike
#!/bin/bash
createdb cms
psql cms < /var/lib/pgsql/backups/globalobjects.sql
psql cms < /var/lib/pgsql/backups/extra.sql
psql cms < /var/lib/pgsql/backups/tsearch2.sql
psql -e cms < /var/lib/pgsql/backups/db_schema_new.sql > errors 2>&1
pg_restore -N -a -d cms
/var/lib/pgsql/backups/2004-03-16-23-10-cms_241103.dmp > errors2 2>&1
-----Original Message-----
From: Oleg Bartunov [mailto:oleg@sai.msu.su]
Sent: 23 March 2004 15:20
To: Mike Bell
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Cache loolup failed problems with tsearch following
pg_restore
Mike,
I think the problem is that tsearch2 is referenced by your SP (stored
procedure)
and your SP should be recreated *after* tsearch2 installed because
functions
are referenced by OID and your SP try to lookup tsearch2 functions
using old OID.
Oleg
On Tue, 23 Mar 2004, Mike Bell wrote:
> Hi,
>
> I'm am having real problems restoring a database which uses tsearch2.
> I've followed the dump/restore notes in the tseach2 documents. After
> much fiddling, I have managed to restore the database. However, as
soon
> as I call a SP which updates a table which uses ts_vector. I get the
> following error:
> 2004-03-23 11:53:03 [27000] ERROR: fmgr_info: function 534990: cache
> lookup failed
>
> The following is from the pg errorlog:
>
> 2004-03-23 11:53:03 [27000] LOG: query: INSERT INTO article_content (
> active , article_id , lang_id , active_date , expire_date ,
> revision_date , revision_days , content_type_id ,
> contribution_receipt_date , version , article_type_id ,
> override_template_id , name , copyright , summary , comment , content
,
> search1 ) VALUES ( true , $1 , $2 , $3 , $4 , $5 , $6 ::interval , $7
,
> $8 , DEFAULT , $9 , $10 , $11 , $12 , $13 , $14 , $15 ,
> to_tsvector('default', coalesce( $16 ,'') || ' ' || coalesce( $17 ,'')
> || ' ' || coalesce(strip_tags( $18 ),'')) )
> 2004-03-23 11:53:03 [27000] LOG: query: select oid from pg_ts_cfg
where
> ts_name = $1
> 2004-03-23 11:53:03 [27000] LOG: query: select prs_name from pg_ts_cfg
> where oid = $1
> 2004-03-23 11:53:03 [27000] LOG: query: select lt.tokid,
> pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 )
as
> lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name =
> pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
> 2004-03-23 11:53:03 [27000] LOG: query: select oid from pg_ts_parser
> where prs_name = $1
> 2004-03-23 11:53:03 [27000] LOG: query: select prs_start,
prs_nexttoken,
> prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
> 2004-03-23 11:53:03 [27000] ERROR: fmgr_info: function 534990: cache
> lookup failed
>
> PostgreSQL 7.3.3 on i386-redhat-linux-gnu, compiled by GCC 2.96
>
> I'm totallly stuck - I have seen pg postings which refer to droping
and
> re-creating SPs but I don't have the knowledge of tseach2 to
understand
> all the dependencies.
> Hope someone can help!!
>
> Cheers
>
> Mike
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mike.bell@hashdefine.co.uk, oleg@sai.msu.su
Subject: Re: Cache loolup failed problems with tsearch following pg_restore
In-Reply-To: <01df01c4110d$5024c2d0$6401a8c0@hashdefine.local>
References: <Pine.GSO.4.58.0403231810290.588@ra.sai.msu.su> <01df01c4110d$5024c2d0$6401a8c0@hashdefine.local>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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