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!
--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
