Assert Failed: No Exception Handler

[rob...@my-deja.com]

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/

[Murray Wood]

What did Informix Tech Support say when you logged the case?

[rob...@my-deja.com]

That is the problem. They have no answer.

In article <916bhu$ihq$1...@news.xmission.com>,