RE: SPL caching on secondary - BUG
I got a message from the tech support, that the
problem is fixed in 9.40uc7 (I suppose, the release
the development is working on)
------------------------------------------
Alexey Sonkin
> -----Original Message-----
> From: Sean Baker [mailto:SBaker@moneymailer.com]
>
> > >
> > > 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
> > > >
> > > > 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; endfunction;
> > > >
> > > > 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; endfunction;
> > > >
> > > > 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
sending to informix-list