RE: Dynamically allocated new shared memory segment ???!!!

> >In a web datablade page an MISQL statement tries to select from > a table and > >gets back too many results for the webdatablade to handle. I had the problem above. I was able to fix it by adding MI_WEBMAXHTMLSIZE n to my web.cnf file, where n is some large number. At first I put in 200000 for n and it worked, but I eventually had to up the number. Hope this helps. -Debbie Donahue, UCSB/Bren School > -----Original Message----- > From: owner-ius-users@iiug.org [mailto:owner-ius-users@iiug.org]On > Behalf Of Thomas Tatum > Sent: Thursday, August 19, 1999 9:10 AM > To: ius-users@iiug.org > Cc: jingker cheng; informix-list@iiug.org; Bmo@Koz. Com > Subject: RE: Dynamically allocated new shared memory segment ???!!! > > > we have: web.3.32.UC4 > > > -----Original Message----- > > From: owner-ius-users@iiug.org [mailto:owner-ius-users@iiug.org]On > > Behalf Of Willow Williams > > Sent: Thursday, August 19, 1999 11:57 AM > > To: ius-users@iiug.org > > Cc: jingker cheng; informix-list@iiug.org; Ius-Users@Iiug. Org; Bmo@Koz. > > Com > > Subject: RE: Dynamically allocated new shared memory segment ???!!! > > > > > > What version of the web datablade are they using? > > > > Willow > > > > At 08:13 AM 8/19/99 , Thomas Tatum wrote: > > >Yes, we have seen this with IUS 9.14 and the Webdatablade. > Except in our > > >case it would keep allocating until the server ran out of > shared memory. > > > > > >In a web datablade page an MISQL statement tries to select from > > a table and > > >gets back too many results for the webdatablade to handle. We > would see > > >behavior similar to this. > > > > > >Another strange side effect when this would happen, is we would run > > >onstat -g seg and inspect the shared memory segments that were> > allocated and > > >on each of the ones that were created within seconds the blkused > > was only 5 > > >and blkfree was always very large. Until we rooted out the > problem (the > > >MISQL was too ambitious) we would run onmode -F to free these > > segments that > > >were just created. > > > > > >Does anyone know if this is an informix bug? and if there is a fix? > > > > > >> -----Original Message----- > > >> From: owner-informix-list@iiug.org > > >> [mailto:owner-informix-list@iiug.org]On Behalf Of jingker cheng > > >> Sent: Thursday, August 19, 1999 8:43 AM > > >> To: informix-list@iiug.org > > >> Subject: Dynamically allocated new shared memory segment ???!!! > > >> > > >> > > >> Dear ALL : > > >> > > >> Our system appear the following messages in seconds : > > >> > > >> 09:11:02 dynamically allocated new shared memory segment > > (size 8388608) > > >> > > >> 09:11:30 dynamically allocated new shared memory segment > > (size 8388608) > > >> > > >> 09:11:50 dynamically allocated new shared memory segment > > (size 8388608) > > >> > > >> 09:12:02 dynamically allocated new shared memory segment > > (size 8388608) > > >> > > >> 09:12:27 dynamically allocated new shared memory segment > > (size 8388608) > > >> > > >> 09:12:55 dynamically allocated new shared memory segment > > (size 8388608) > > >> > > >> 09:13:17 dynamically allocated new shared memory segment > > (size 8388608)> > >> > > >> ...... > > >> ..... > > >> ..... > > >> > > >> Does anyone know what kind of process will cause the results > ? How can > > >> I determine which process/session cause such results ? Thanks .... > > >> Our system is HP-UX 10.20 and Informix On-Line Dynamic Server 7.22UC3 > > >> > > >> Jung-Hui Cheng > > >> cheng@dbtel.com.tw > > >> > > >> > > > > > > >