RE: No thread isolation-- Unusual or Common?

I encountered the same problem a year ago on IDS 7.31.UC2 - One rogue query can blow the stack size and crash the engine... not good on a production system. IMHO, exceeding the stack size shouldn't crash the engine, just terminate the session. -----Original Message----- From: David E. Grove [mailto:david_grove@correct.state.ak.us] Sent: Monday, May 12, 2003 5:45 PM To: informix-list@iiug.org Subject: Re: No thread isolation-- Unusual or Common? Thank you. STACKSIZE is already configured to 64K. That is the configuration that failed. DG "Samar Desai" <samarof74@yahoo.com> wrote in message news:b9k9ms$tte$1@terabinaries.xmission.com... > > John, > > You may need to increase STACKSIZE parameter in > ONCONFIG file and bounce the engine. Standard value is > 32K. Try using 64K stacksize. > > HTH > Regards > Samar > > > --- John Carlson <john_carlson@whsmithusa.com> wrote: > > On Tue, 6 May 2003 08:21:36 -0800, "David E. Grove" > > <david_grove@correct.state.ak.us> wrote: > > > > >Just had an experience in which a user attempted to > > run a very long SQL > > >query. ("Long" in the sense that just to view the > > text of the query > > >required about a dozen screens when looking at it > > with onstat) The SQL > > >involved over 170 tables and UNION ALLs. However, > > the selectivity on each > > >table was pretty high, though. In any event,. it > > used all the stack > > >resources and crashed the server. > > > > > >This led me to ask tech support if there wasn't > > some way to limit resources > > >used by each user session so that users are > > isolated. In other words, I > > >wondered if there were some way to insulate users > > from each other so that an > > >individual user couldn't crash the system with a > > rogue query. I was told > > >that was not possible. > > > > > >Is this a common situation with other RDBMS's, or > > is Informix unusual? Just > > >wondering. > > > > > >Thank you for any comments from folks experienced > > with other DBMS's. > > > > > >Regards, > > > > > >DG > > > > Which engine version is this? > > > __________________________________ > Do you Yahoo!? > The New Yahoo! Search - Faster. Easier. Bingo. > http://search.yahoo.com ********************************************************************** Privileged/Confidential information may be contained in this message. If you are not an addressee indicated in this message (or responsible for delivery of the message to such person[s]), you may not copy or deliver this message to anyone. If you have received this message in error, you should destroy and delete it from your computer and notify the sender by reply email. Opinions, conclusions and other information in this message that do not relate to the official business of Diversified Collection Services shall be understood as neither given nor endorsed by the company. Accordingly, Diversified Collection Services disclaims all responsibility and accepts no responsibility for the consequences of any person(s) acting, or refraining from acting, on such information prior to the receipt by that person(s) of subsequent written confirmation. **********************************************************************