RE: SPL caching on secondary - BUG
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org] On Behalf Of Sean Baker
> Sent: Thursday, November 18, 2004 9:50 AM
> To: informix-list@iiug.org
> Subject: RE: SPL caching on secondary - BUG
>
>
> > -----Original Message-----
> > From: owner-informix-list@iiug.org
> > [mailto:owner-informix-list@iiug.org] On Behalf Of Willem Roos
> > Sent: Tuesday, October 26, 2004 7:29 AM
> > To: Alexey Sonkin; informix-list@iiug.org
> > Subject: RE: SPL caching on secondary - BUG
> >
> >
> > Also seen on IDS 7.31.ud8 and earlier. As a workaround do
> > 'update statistics for procedure spl_test' on secondary,
> > you'll get an error but the sp recompiles.
> >
> > > -----Original Message-----
> > > From: owner-informix-list@iiug.org
> > > [mailto:owner-informix-list@iiug.org] On Behalf Of Alexey Sonkin
> > > Sent: 26 October 2004 05:17
> > > To: informix-list@iiug.org
> > > Subject: HDR: SPL caching on secondary - BUG
> > >
> > > Hi, everybody,
> > >
> > > I've just run into a very unpleasant problem obviously
> > related to SPL
> > > caching on HDR secondary.
> > >
> > > Steps to reproduce: (ANSI database, IDS 9.40uc5, also reproduces
> > > 9.21):
> > >
> > > 1. Primary:
> > >
> > > create function spl_test() returning INT; return 1; end function;> > >
> > > commit;
> > >
> > > execute function spl_test();> > > commit;
> > >
> > > -- returns 1
> > >
> > > 2. Secondary:
> > >
> > > execute function spl_test();> > > commit;
> > >
> > > -- returns 1
> > >
> > > 3. primary:
> > >
> > > drop function spl_test;> > > commit;
> > >
> > > create function spl_test() returning INT; return 0; end function;> > >
> > > commit;
> > >
> > > execute function spl_test();> > > commit;
> > >
> > > -- returns 0
> > >
> > > -- CHECKPOINT ON PRIMARY:
> > >
> > > onmode -c> > >
> > > 4. secondary:
> > >
> > > execute function spl_test();> > > commit;
> > >
> > > -- returns 1
> > >
> > > The only way to get expected "0" on Secondary - restart the
> > Secondary
> > >
> > >
> > >
> > > ---------------
> > > I've filed a level-2 bug about it
> > >
> > > '
> > > ------------------------------------------
> > > Alexey Sonkin
>
> Does anyone have an update on this bug? I'm also seeing this
> now (IDS 9.40.FC4W4). I tried running update statistics for
> the procedure (spl_dbinfo) both on the primary and the
> secondary, as well as onmode -c. I get "9753: Unable to find
> User Defined Routine with the given id." when I try to run it
> on the secondary. The funny this is that when I run dbschema
> on the secondary:
>
> dbschema -d eagle -f spl_dbinfo>
> it prints out the routine!
>
> We're going to try bouncing the secondary later today to see
> if that fixes it.
>
> Any help of input is appreciated.
>
> Thanks,
>
> Sean.
For what it's worth, bouncing the secondary server solved the problem, temporarily at least.
Thanks,
Sean.
sending to informix-list