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.
sending to informix-list