RE: Assert Failed: No Exception Handler

What did Informix Tech Support say when you logged the case? -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of robmcq@my-deja.com Sent: Wednesday, December 13, 2000 8:07 AM To: informix-list@iiug.org Subject: Assert Failed: No Exception Handler For the past couple of months we have been getting an Assert Failure on one of 9 Distribution Center Risc Servers. However, this assert is random in its occurence. In that it can occur a month apart or a couple of weeks apart ... there seems to be no consistency. In fact ... the only thing I have found to be consistent is where it is failing within the application. At first we thought it may be application driven ... but the code is the same at all other DCs. The SQL it is failing on is performing a "Select COUNT (UNIQUE <table>.<column>)". One thing we do get is a -229 Error. However we are running 7.31.UC5 and that error refrences a problem with the DBTEMP variable and space. We have DBSPACETEMP set and I feel they are large enough (as is the rootdbspace and dbspace the database was built in) to handle any temp table creation that is going on. The assert file shows nothing of any use nor does the stack trace on the thread ... It is not much to go on I know, but any help would be greatly appreciated. The Assert is as follows: 19:04:43 Assert Failed: No Exception Handler 19:04:43 Informix Dynamic Server Version 7.31.UC5 19:04:43 Who: Session(10059, cronuser@whschl1, 94338, 1342699604) Thread(10367, sqlexec, 53450284, 4) File: mtex.c Line: 446 19:04:43 Results: Exception Caught. Type: MT_EX_OS, Context: mem 19:04:43 Action: Please notify Informix Technical Support. 19:04:44 See Also: /tmp/af.2c676b9b 19:04:44 Invoking debugger on oninit pid 11364 19:04:44 Thread(10367, sqlexec, 0, 4) 19:04:44 oninit pid 11364 waiting for debugger Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 3 days 07:35:36 -- 812896 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 10059 cronuser - 94338 whschl1 1 90112 85124 tid name rstcb flags curstk status 10367 sqlexec 53450284 ---P--- 4536 53450284 running Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 10059 V 50c16014 90112 4988 416 12 name free used name free used overhead 0 108 scb 0 80 opentable 0 5244 filetable 0 1192 ru 0 220 log 0 4196 temprec 0 1596 keys 0 356 ralloc 0 44956 gentcb 0 7712 ostcb 0 2692 sqscb 0 9180 rdahead 0 1588 hashfiletab 0 276 osenv 0 1652 buft_buffer 0 184 sqtcb 0 2420 fragman 0 568 shmblklist 0 904 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 10059 SELECT system DR Wait 5 0 0 9.24 Current SQL statement : select count ( unique iprod . prod_id ) from iprod , iplas whereiplas . dc_id between ? and ? and iplas . wusg_id = "SE" and iplas . dc_id = iprod . dc_id and iplas . prod_id = iprod . prod_id and iprod . psta_id in ( "AC" , "DE" ) Last parsed SQL statement : select count ( unique iprod . prod_id ) from iprod , iplas whereiplas . dc_id between ? and ? and iplas . wusg_id = "SE" and iplas . dc_id = iprod . dc_id and iplas . prod_id = iprod . prod_id and iprod . psta_id in ( "AC" , "DE" ) User-created Temp tables : partnum tabname rowsize 900021 t_rec_rpt 19 Version Info: Engine: 7.31.UC5 OS: AIX 4.3.3 Sent via Deja.com http://www.deja.com/

That is the problem. They have no answer. In article <916bhu$ihq$1@news.xmission.com>, <murray@quanta.co.nz> wrote: > > What did Informix Tech Support say when you logged the case? > > -----Original Message----- > From: owner-informix-list@iiug.iiug.org > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of > robmcq@my-deja.com > Sent: Wednesday, December 13, 2000 8:07 AM > To: informix-list@iiug.org > Subject: Assert Failed: No Exception Handler > > For the past couple of months we have been getting an Assert Failure on > one of 9 Distribution Center Risc Servers. However, this assert is > random in its occurence. In that it can occur a month apart or a > couple of weeks apart ... there seems to be no consistency. In > fact ... the only thing I have found to be consistent is where it is > failing within the application. At first we thought it may be > application driven ... but the code is the same at all other DCs. The > SQL it is failing on is performing a "Select COUNT (UNIQUE > <table>.<column>)". One thing we do get is a -229 Error. However we > are running 7.31.UC5 and that error refrences a problem with the DBTEMP > variable and space. We have DBSPACETEMP set and I feel they are large > enough (as is the rootdbspace and dbspace the database was built in) to > handle any temp table creation that is going on. The assert file shows > nothing of any use nor does the stack trace on the thread ... It is > not much to go on I know, but any help would be greatly appreciated. > > The Assert is as follows: > 19:04:43 Assert Failed: No Exception Handler > 19:04:43 Informix Dynamic Server Version 7.31.UC5 > 19:04:43 Who: Session(10059, cronuser@whschl1, 94338, 1342699604) > Thread(10367, sqlexec, 53450284, 4) > File: mtex.c Line: 446 > 19:04:43 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 19:04:43 Action: Please notify Informix Technical Support. > 19:04:44 See Also: /tmp/af.2c676b9b > 19:04:44 Invoking debugger on oninit pid 11364 > 19:04:44 > Thread(10367, sqlexec, 0, 4) > 19:04:44 oninit pid 11364 waiting for debugger> > Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 3 days > 07:35:36 -- 812896 Kbytes > > session #RSAM total used > id user tty pid hostname threads memory memory > 10059 cronuser - 94338 whschl1 1 90112 85124 > > tid name rstcb flags curstk status > 10367 sqlexec 53450284 ---P--- 4536 53450284 running > > Memory pools count 1 > name class addr totalsize freesize #allocfrag #freefrag > 10059 V 50c16014 90112 4988 416 12 > > name free used name free > used > overhead 0 108 scb 0 > 80 > opentable 0 5244 filetable 0 > 1192 > ru 0 220 log 0 > 4196 > temprec 0 1596 keys 0 > 356 > ralloc 0 44956 gentcb 0 > 7712 > ostcb 0 2692 sqscb 0 > 9180 > rdahead 0 1588 hashfiletab 0 > 276 > osenv 0 1652 buft_buffer 0 > 184 > sqtcb 0 2420 fragman 0 > 568 > shmblklist 0 904 > > Sess SQL Current Iso Lock SQL ISAM F.E. > Id Stmt type Database Lvl Mode ERR ERR Vers > 10059 SELECT system DR Wait 5 0 0 9.24 > > Current SQL statement : > select count ( unique iprod . prod_id ) from iprod , iplas where> iplas . > dc_id between ? and ? and iplas . wusg_id = "SE" and iplas . dc_id > = iprod > . dc_id and iplas . prod_id = iprod . prod_id and iprod . psta_id > in ( > "AC" , "DE" ) > > Last parsed SQL statement : > select count ( unique iprod . prod_id ) from iprod , iplas where> iplas . > dc_id between ? and ? and iplas . wusg_id = "SE" and iplas . dc_id > = iprod > . dc_id and iplas . prod_id = iprod . prod_id and iprod . psta_id > in ( > "AC" , "DE" ) > > User-created Temp tables : > partnum tabname rowsize > 900021 t_rec_rpt 19 > > Version Info: > Engine: 7.31.UC5 > OS: AIX 4.3.3 > > Sent via Deja.com > http://www.deja.com/ > Sent via Deja.com http://www.deja.com/