On Fri, 2 Mar 2007, elein wrote:
> 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.
When you dumped/restored the file did it already include the slony
schema/triggers? You can likely tell if there's aproblem by comparing the
OIDs in the sl_table table with the actual OIDs in pg_class.
>
> 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';
>>>
>
>
--
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
