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!
>
> --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
>
>
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
