Hi All,



I have an installation II 9.2.0 (a64.lnx/143)NPTL + 13556.



On some databases, when catalogs are optimized (-zk -zc), the result of
help procedure <procedure_name> is that the server goes into a flat spin
and chews up 100% of CPU...never to return.



If I drop the catalog statistics the help procedure is perfectly OK.



If I run this on patch 13695 the same behaviour is observed.



But on patch 13767 the optimized catalogs behave themselves. I can't
find anything in the patch notes for 13767 that suggests this is a known
problem which has been fixed.



Has anyone seen anything like this before? Know of the bug number?



Martin Bowes

Hi Marty

I don't see anything similar in BUGs. Can you please log an issue and
supply a test case so we can take a look.

Thanks

Alex


--
hanal04

Hi Alex,

Already done.

Dave Harbour is looking after issue 144569. He suspects bug 122831.

Marty

-----Original Message-----
From: Ingres Forums [mailto:info-ingres (AT) kettleriverconsulting (DOT) com]
Sent: 13 May 2010 09:22
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] The never ending procedure definition.


Hi Marty

I don't see anything similar in BUGs. Can you please log an issue and
supply a test case so we can take a look.

Thanks

Alex


--
hanal04
------------------------------------------------------------------------
hanal04's Profile:
http://community.ingres.com/forum/member.php?userid=443
View this thread:
http://community.ingres.com/forum/sh...ad.php?t=12027

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres