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