Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

HDR: SPL caching on secondary - BUG

57 views
Skip to first unread message

Alexey Sonkin

unread,
Oct 25, 2004, 11:16:42 PM10/25/04
to
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

rkusenet

unread,
Oct 26, 2004, 6:08:56 AM10/26/04
to
I think I have seen this bug in version 7.30, way back in 1999.

"Alexey Sonkin" <alexey...@verizon.net> wrote in message news:906b40fc.0410...@posting.google.com...


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

Try this:

on the primary server, after you drop and recreate the new procedure

update statistics for procedure.


Alexey Sonkin

unread,
Oct 26, 2004, 12:08:00 PM10/26/04
to
"rkusenet" <rkus...@sympatico.ca> wrote
> > 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:
>
> Try this:
>
> on the primary server, after you drop and recreate the new procedure
>
> update statistics for procedure.

Doesn't help - forgot to mention in the original post

Alexey Sonkin

unread,
Oct 26, 2004, 6:14:43 PM10/26/04
to
Willem,

With 9.40uc5, after " update statistics for procedure spl_test;"
on HDR Secondary, I'm getting SQL Error -9753:
Unable to find User Defined Routine with the given ID


> -----Original Message-----
> From: Willem Roos [mailto:wr...@shoprite.co.za]
>
>
> 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.


>
> >
> > Hi, everybody,
> >
> > I've just run into a very unpleasant problem obviously related to SPL
> > caching on HDR secondary.
> >
> >

0 new messages