On Thu, Mar 01, 2007 at 07:02:22PM -0800, Jeff Frost wrote:
> On Thu, 1 Mar 2007, elein wrote:
>
> >I've got pg81 replicating pg82. (Don't even ask me about tsearch2).
> >They've both got the same version of slony.
> >
> >When it is up and running, i.e. subscription succeeded, then other
> >users of the master, pg81, are getting the following error messages.
> >They are unable to complete their work so I took slony down (again).
> >
> >The problem seems to be with this oid: ERROR: relation with OID 14757355
> >does not exist
> >and this SQL CONTEXT: SQL statement "SELECT last_value::int4 FROM
> >_platial.sl_log_status"
> >
> >It didn't occur to me to check the sl_log_status table until after I blew
> >it away.
> >
> >Has anyone else seen this error? Any ideas? A 81 vs 82 issue?
> >Help!
>
> Usually when I've seen the relation with OID xxx does not exist error, it
> was because a table referenced in sl_table or a sequence referenced in
> sl_seq had been dropped and recreated by hand and the tab_reloid or
> seq_reloid didn't match anymore. I've been successful just changing it in
> the table, but I understand there's also the lovely REPAIR CONFIG slonik
> function which will fix this.
>
> Perhaps try a quick REPAIR CONFIG to see if it remedies the problem?
>
> Aside from that, I've not seen anything else similar, but I haven't been
> using it with 8.2 yet.
>
> Good luck and let us know what you discover!
>
To create the schema I did a simple schema dump > file; psql < file
I made a minor change to tsearch2 to try to eliminate incompatibility
between 8.1 and 8.2 on the ru_init function.
There were no sequences created by hand. The problem seems to be
in sl_log_status.
I cannot try the repair config yet. I will when I get a window
open.
Thanks
--elein
[EMAIL PROTECTED]
> >
> >
> >60197[2007-03-01 17:01:21 PST] - ERROR: relation with OID 14757355 does
> >not exist
> >60197[2007-03-01 17:01:21 PST] - CONTEXT: SQL statement "SELECT
> >last_value::int4 FROM _platial.sl_log_status"
> > SQL statement "insert into map_tile_sent
> > (map_tile_id,session_number) values ( $1 , $2 )"
> > PL/pgSQL function "f_map_tile_sent" line 8 at SQL statement
> >60197[2007-03-01 17:01:21 PST] - STATEMENT: select * from
> >f_map_tile_sent(24448,161310);
> >
> >60530[2007-03-01 17:02:59 PST] - ERROR: relation with OID 14757355 does
> >not exist
> >60530[2007-03-01 17:02:59 PST] - CONTEXT: SQL statement "SELECT
> >last_value::int4 FROM _platial.sl_log_status"
> > SQL statement "insert into api_session (id,session_id) values ( $1
> > , $2 )"
> > PL/pgSQL function "f_allocate_api_session" line 8 at SQL statement
> >60530[2007-03-01 17:02:59 PST] - STATEMENT: select * from
> >f_allocate_api_session('c9c02d93d8feba1391c3e37184cf8e570');
> >
> >57883[2007-03-01 17:03:13 PST] - ERROR: relation with OID 14757355 does
> >not exist
> >57883[2007-03-01 17:03:13 PST] - CONTEXT: SQL statement "SELECT
> >last_value::int4 FROM _platial.sl_log_status"
> > SQL statement "insert into api_session (id,session_id) values ( $1
> > , $2 )"
> > PL/pgSQL function "f_allocate_api_session" line 8 at SQL statement
> >;:
> >
> >60197[2007-03-01 17:03:19 PST] - LOG: statement: UPDATE user_api_key SET
> >sites = '{"platial.com", "www.platial.com", "tigerandrat.com",
> >"www.tigerandrat.com"}' WHERE user_id='16880';
> >60197[2007-03-01 17:03:19 PST] - ERROR: relation with OID 14757355 does
> >not exist
> >60197[2007-03-01 17:03:19 PST] - CONTEXT: SQL statement "SELECT
> >last_value::int4 FROM _platial.sl_log_status"
> >60197[2007-03-01 17:03:19 PST] - STATEMENT: UPDATE user_api_key SET sites
> >= '{"platial.com", "www.platial.com", "tigerandrat.com",
> >"www.tigerandrat.com"}' WHERE user_id='16880';
> >
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
