On Fri, Mar 02, 2007 at 12:51:32PM -0800, Jeff Frost wrote:
> 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.
>
This sounds like the kind of goofy mistake I may have made.
I can't test it right now, but it sounds very plausible.
Thanks
elein
> >
> >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
