Re: Repeated permission violation crashes server (v7.x)

It's a pretty large database with sensitive government data and the app is a 
service application with a lot of other stuff going on.  It will probably 
take me a while and my employer probably won't authorize me to do it.  Also, 
in order to test the test case out I'd have to bring our production server 
down again to make sure I duplicated the problem.  I'll see what I can do to 
put something together in my own spare time, what little I have...

Jason Wharton

"Quinn Wildman" <qwildman@borland.com> wrote in message 
news:447b3b29$1@newsgroups.borland.com...
> If you could submit a reproduceable test case to Quality Central it would 
> be most helpful.
>
> Jason Wharton wrote:
>> I changed a query in a stored procedure with a sub-select on a table
that 
>> the stored procedure didn't have SELECT rights for (nor the USER) and 
>> thus created a permissions violation.  Because the application was a 
>> service application and it retried on exceptions it repeatedly
attempted 
>> to execute the stored procedure as fast as it could.  The server hung
in 
>> there for a couple hours but eventually the server  became
inaccessible. 
>> This suggests to me there is a bug in the handling of these kinds of 
>> exceptions.  Perhaps a resource leak.
>>
>> Obviously I don't consider this a critical bug to fix because I don't 
>> expect that the server should accommodate this kind of behavior.  Now 
>> that I fixed the permissions problem there is no problem.
>>
>> Thanks for anyone on the InterBase team to looks into this.  Perhaps it

>> will help by being the tip of an iceberg of a problem elsewhere that
will 
>> have more general applicability.
>>
>> Jason Wharton
>> www.ibobjects.com
>>
>>
>>