ida11.5 FC5 help

14:25:04 Maximum server connections 168 14:25:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 5545, Llog used 4538 14:30:40 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 14:30:40 IBM Informix Dynamic Server Version 11.50.FC4 14:30:40 Who: Session(4050482, yhadmin@10.10.1.9, -1, 0xf81f0838) Thread(4729844, sqlexec, f5ec4388, 3) File: mtex.c Line: 417 14:30:40 Action: Please notify IBM Informix Technical Support. 14:30:40 stack trace for pid 29003 written to /home/informix/tmp/af.2fdc290f 14:30:40 See Also: /home/informix/tmp/af.2fdc290f, shmem.2fdc290f.0 ############## /home/informix/bin/onstat -g ses 4050482: IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 43 days 14:56:56 -- 4532148 Kbytes session effective #RSAM total used dynamic id user user tty pid hostname threads memory memory explain 4050482 yhadmin - - -1 10.10.1. 1 2482176 2396080 off tid name rstcb flags curstk status 4729844 sqlexec f5ec4388 --BP--- -141970528 running- Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 4050482 V f5314040 2478080 85288 3227 108 4050482*O0 V dfaab040 4096 808 1 1 name free used name free used overhead 0 6576 mtmisc 0 3424 scb 0 144 opentable 0 139912 filetable 0 20400 ru 0 600 log 0 16536 temprec 0 21664 keys 0 1408 ralloc 0 1907920 gentcb 0 1752 ostcb 0 2920 sqscb 0 108584 sql 0 72 rdahead 0 1120 hashfiletab 0 552 osenv 0 2656 buft_buffer 0 48032 sqtcb 0 31032 fragman 0 75464 shmblklist 0 344 udr 0 4968 sqscb info scb sqscb optofc pdqpriority sqlstats optcompind directives f4303028 f41a6028 0 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 4050482 dbdms CR Wait 5 0 0 9.28 Off Stored procedure stack : context proc-counter opcode name ------------------------------------------------------------------ 0x00000000dfa00058 0xe32f40f0+0x0010 SQL dbdms:tl_getnewserial 0x00000000f4aca058 0xdf8b4568+0x0010 EXPR dbdms:tl_wastebook_avg 0x00000000f454e638 0xe2cef370+0x0010 EXPR dbdms:tl_exeaccountlist 0x00000000f7d00058 0xdf944c30+0x0010 EXPR dbdms:tl_crtaccountlist 0x00000000f6ff0058 0xe112d990+0x0010 EXPR dbdms:dms_account 0x00000000f6fefb50 0xf53cabb8+0x0010 EXPR dbdms:if_receiptjob Current SQL statement in procedure dbdms:tl_getnewserial proc-counter 0x0xe32f40f0 opcode SQL set lock mode to wait 5; Last parsed SQL statement : execute procedure IF_ReceiptJOB('CQWL010909150764') User-created Temp tables : partnum tabname rowsize b0006b tmp_accwastebook 192 400029 tmp_accwastebook 192 500069 tmp_accwastebook 192 600169 tmp_accwastebook 192 700029 tmp_accwastebook 192 8002cb tmp_accwastebook 192 90014b tmp_accwastebook 192 a0028b tmp_accwastebook 192 b0006a tmp_accountlist 157 ===========------------- - - - - - - /home/informix/bin/onstat -g env 4050482: IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 43 days 14:56:56 -- 4532148 Kbytes Environment for session 4050482: Variable Value [values-list] CLIENT_LOCALE zh_CN.GB18030-2000 DBDATE Y4MD0 DBDELIMITER | DBPATH . DBPRINT lp -s DBTEMP /tmp DB_LOCALE zh_CN.GB18030-2000 IFX_UPDDESC 1 INFORMIXDIR /home/informix [/home/informix] [/usr/informix] INFORMIXSERVER oncq INFORMIXTERM termcap LANG en_US.819 LC_COLLATE en_US.819 LC_CTYPE en_US.819 LC_MONETARY en_US.819 LC_NUMERIC en_US.819 LC_TIME en_US.819 LKNOTIFY yes LOCKDOWN no NODEFDAC no ONCONFIG oncq.cfg PATH /usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin :/usr/bin:/home/informix/bin:/home/informix/bin:/sbin:/usr /bin:/usr/sbin:/etc/:/bin SERVER_LOCALE zh_CN.GB18030-2000 SHELL /bin/bash SKINHIBIT 0 SQLPID 4095369256 TERM vt100 [vt100] [dumb] TERMCAP /home/informix/etc/termcap [/home/informix/etc/termcap] [/etc/termcap] ===========------------- - - - - - - /home/informix/bin/onstat -g sql 4050482: IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 43 days 14:56:56 -- 4532148 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 4050482 dbdms CR Wait 5 0 0 9.28 Off Stored procedure stack : context proc-counter opcode name ------------------------------------------------------------------ 0x00000000dfa00058 0xe32f40f0+0x0010 SQL dbdms:tl_getnewserial 0x00000000f4aca058 0xdf8b4568+0x0010 EXPR dbdms:tl_wastebook_avg 0x00000000f454e638 0xe2cef370+0x0010 EXPR dbdms:tl_exeaccountlist 0x00000000f7d00058 0xdf944c30+0x0010 EXPR dbdms:tl_crtaccountlist 0x00000000f6ff0058 0xe112d990+0x0010 EXPR dbdms:dms_account 0x00000000f6fefb50 0xf53cabb8+0x0010 EXPR dbdms:if_receiptjob Current SQL statement in procedure dbdms:tl_getnewserial proc-counter 0x0xe32f40f0 opcode SQL set lock mode to wait 5; Last parsed SQL statement : execute procedure IF_ReceiptJOB('CQWL010909150764') User-created Temp tables : partnum tabname rowsize b0006b tmp_accwastebook 192 400029 tmp_accwastebook 192 500069 tmp_accwastebook 192 600169 tmp_accwastebook 192 700029 tmp_accwastebook 192 8002cb tmp_accwastebook 192 90014b tmp_accwastebook 192 a0028b tmp_accwastebook 192 b0006a tmp_accountlist 157

what is the stack in af file? = From: "WANG XIAOMING" <15059176362@139.com> = = To: ids@iiug.org = = Date: 09/18/2009 08:56 AM = = Subject: ida11.5 FC5 help [17086] = = Sent by: ids-bounces@iiug.org = = 14:25:04 Maximum server connections 168 14:25:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns bloc= ked 0, Plog used 5545, Llog used 4538 14:30:40 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 14:30:40 IBM Informix Dynamic Server Version 11.50.FC4 14:30:40 Who: Session(4050482, yhadmin@10.10.1.9, -1, 0xf81f0838) Thread(4729844, sqlexec, f5ec4388, 3) File: mtex.c Line: 417 14:30:40 Action: Please notify IBM Informix Technical Support. 14:30:40 stack trace for pid 29003 written to /home/informix/tmp/af.2fdc290f 14:30:40 See Also: /home/informix/tmp/af.2fdc290f, shmem.2fdc290f.0 ############## /home/informix/bin/onstat -g ses 4050482: IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 43 days 14:56:56 -- 4532148 Kbytes session effective #RSAM total used dynamic id user user tty pid hostname threads memory memory explain 4050482 yhadmin - - -1 10.10.1. 1 2482176 2396080 off tid name rstcb flags curstk status 4729844 sqlexec f5ec4388 --BP--- -141970528 running- Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 4050482 V f5314040 2478080 85288 3227 108 4050482*O0 V dfaab040 4096 808 1 1 name free used name free used overhead 0 6576 mtmisc 0 3424 scb 0 144 opentable 0 139912 filetable 0 20400 ru 0 600 log 0 16536 temprec 0 21664 keys 0 1408 ralloc 0 1907920 gentcb 0 1752 ostcb 0 2920 sqscb 0 108584 sql 0 72 rdahead 0 1120 hashfiletab 0 552 osenv 0 2656 buft_buffer 0 48032 sqtcb 0 31032 fragman 0 75464 shmblklist 0 344 udr 0 4968 sqscb info scb sqscb optofc pdqpriority sqlstats optcompind directives f4303028 f41a6028 0 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 4050482 dbdms CR Wait 5 0 0 9.28 Off Stored procedure stack : context proc-counter opcode name ------------------------------------------------------------------ 0x00000000dfa00058 0xe32f40f0+0x0010 SQL dbdms:tl_getnewserial 0x00000000f4aca058 0xdf8b4568+0x0010 EXPR dbdms:tl_wastebook_avg 0x00000000f454e638 0xe2cef370+0x0010 EXPR dbdms:tl_exeaccountlist 0x00000000f7d00058 0xdf944c30+0x0010 EXPR dbdms:tl_crtaccountlist 0x00000000f6ff0058 0xe112d990+0x0010 EXPR dbdms:dms_account 0x00000000f6fefb50 0xf53cabb8+0x0010 EXPR dbdms:if_receiptjob Current SQL statement in procedure dbdms:tl_getnewserial proc-counter 0x0xe32f40f0 opcode SQL set lock mode to wait 5; Last parsed SQL statement : execute procedure IF_ReceiptJOB('CQWL010909150764') User-created Temp tables : partnum tabname rowsize b0006b tmp_accwastebook 192 400029 tmp_accwastebook 192 500069 tmp_accwastebook 192 600169 tmp_accwastebook 192 700029 tmp_accwastebook 192 8002cb tmp_accwastebook 192 90014b tmp_accwastebook 192 a0028b tmp_accwastebook 192 b0006a tmp_accountlist 157 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D------------- - - - - - - /home/informix/bin/onstat -g env 4050482: IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 43 days 14:56:56 -- 4532148 Kbytes Environment for session 4050482: Variable Value [values-list] CLIENT_LOCALE zh_CN.GB18030-2000 DBDATE Y4MD0 DBDELIMITER | DBPATH . DBPRINT lp -s DBTEMP /tmp DB_LOCALE zh_CN.GB18030-2000 IFX_UPDDESC 1 INFORMIXDIR /home/informix [/home/informix] [/usr/informix] INFORMIXSERVER oncq INFORMIXTERM termcap LANG en_US.819 LC_COLLATE en_US.819 LC_CTYPE en_US.819 LC_MONETARY en_US.819 LC_NUMERIC en_US.819 LC_TIME en_US.819 LKNOTIFY yes LOCKDOWN no NODEFDAC no ONCONFIG oncq.cfg PATH /usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin :/usr/bin:/home/informix/bin:/home/informix/bin:/sbin:/usr /bin:/usr/sbin:/etc/:/bin SERVER_LOCALE zh_CN.GB18030-2000 SHELL /bin/bash SKINHIBIT 0 SQLPID 4095369256 TERM vt100 [vt100] [dumb] TERMCAP /home/informix/etc/termcap [/home/informix/etc/termcap] [/etc/termcap] =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D------------- - - - - - - /home/informix/bin/onstat -g sql 4050482: IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 43 days 14:56:56 -- 4532148 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 4050482 dbdms CR Wait 5 0 0 9.28 Off Stored procedure stack : context proc-counter opcode name ------------------------------------------------------------------ 0x00000000dfa00058 0xe32f40f0+0x0010 SQL dbdms:tl_getnewserial 0x00000000f4aca058 0xdf8b4568+0x0010 EXPR dbdms:tl_wastebook_avg 0x00000000f454e638 0xe2cef370+0x0010 EXPR dbdms:tl_exeaccountlist 0x00000000f7d00058 0xdf944c30+0x0010 EXPR dbdms:tl_crtaccountlist 0x00000000f6ff0058 0xe112d990+0x0010 EXPR dbdms:dms_account 0x00000000f6fefb50 0xf53cabb8+0x0010 EXPR dbdms:if_receiptjob Current SQL statement in procedure dbdms:tl_getnewserial proc-counter 0x0xe32f40f0 opcode SQL set lock mode to wait 5; Last parsed SQL statement : execute procedure IF_ReceiptJOB('CQWL010909150764') User-created Temp tables : partnum tabname rowsize b0006b tmp_accwastebook 192 400029 tmp_accwastebook 192 500069 tmp_accwastebook 192 600169 tmp_accwastebook 192 700029 tmp_accwastebook 192 8002cb tmp_accwastebook 192 90014b tmp_accwastebook 192 a0028b tmp_accwastebook 192 b0006a tmp_accountlist 157 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

/home/informix/bin/onstat -g sts: IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 43 days 14:56:59 -- 4532148 Kbytes Stack usage: TID Total Max Current Thread Name bytes % bytes % 2 65536 2671 4 1616 2 lio vp 0 3 65536 2671 4 1616 2 pio vp 0 4 65536 4455 6 1616 2 aio vp 0 5 131072 10646 8 1616 1 msc vp 0 6 65536 4231 6 1616 2 aio vp 1 7 65536 13031 19 3120 4 main_loop() 8 65536 65535 99 3707365792 5656991 soctcppoll 9 65536 65535 99 3707668896 5657453 soctcppoll 10 65536 65535 99 3707738528 5657560 soctcppoll 11 65536 13111 20 4400 6 soctcplst 12 65536 4135 6 1280 1 flush_sub(0) 13 65536 4135 6 1280 1 flush_sub(1) 14 65536 4135 6 1280 1 flush_sub(2) 15 65536 4135 6 1280 1 flush_sub(3) 16 65536 3719 5 1280 1 flush_sub(4) 17 65536 3719 5 1280 1 flush_sub(5) 18 65536 3719 5 1280 1 flush_sub(6) 19 65536 3719 5 1280 1 flush_sub(7) 20 65536 3271 4 720 1 kaio 25 65536 3271 4 720 1 kaio 28 65536 2823 4 784 1 aslogflush 29 65536 5523 8 720 1 btscanner_0 53 65536 8495 12 2096 3 onmode_mon 54 65536 3607 5 656 1 periodic 58 65536 3271 4 720 1 kaio 69 65536 3271 4 720 1 kaio 1000 65536 2759 4 416 0 bf_priosweep() 1963 65536 3271 4 720 1 kaio 5888 65536 3271 4 720 1 kaio 5889 65536 3271 4 720 1 kaio 3386460 131072 24391 18 6048 4 sqlexec 3386515 131072 24259 18 6048 4 sqlexec 3387878 131072 24391 18 6048 4 sqlexec 3716659 131072 24391 18 6048 4 sqlexec 3716662 131072 24147 18 6048 4 sqlexec 3716663 131072 23751 18 6048 4 srvinfx 3716841 131072 23751 18 6048 4 srvinfx 3717587 131072 24391 18 6048 4 sqlexec 3984851 131072 24259 18 6048 4 sqlexec 4291778 131072 28215 21 6048 4 sqlexec 4291831 131072 34671 26 6048 4 sqlexec 4559081 131072 36675 27 6048 4 sqlexec 4597486 131072 24087 18 6048 4 srvinfx 4598507 131072 37839 28 6048 4 sqlexec 4688707 131072 32359 24 6048 4 sqlexec 4692771 131072 27575 21 6048 4 sqlexec 4692807 131072 36255 27 6048 4 sqlexec 4694612 131072 37463 28 6048 4 sqlexec 4695139 131072 35903 27 6048 4 sqlexec 4695658 131072 34671 26 6048 4 sqlexec 4695902 131072 36255 27 6048 4 sqlexec 4697402 131072 30343 23 6048 4 sqlexec 4700075 131072 26327 20 6048 4 sqlexec 4701429 131072 17499 13 6048 4 srvinfx 4701741 131072 34647 26 6048 4 sqlexec 4703219 131072 35823 27 6048 4 sqlexec 4703414 131072 27463 20 6048 4 sqlexec 4705437 131072 17499 13 6048 4 srvinfx 4709877 131072 26327 20 6048 4 sqlexec 4710481 131072 37047 28 6048 4 sqlexec 4710556 131072 20663 15 6048 4 sqlexec 4711568 131072 34671 26 6048 4 sqlexec 4712043 131072 26791 20 6048 4 sqlexec 4712639 131072 27479 20 6048 4 sqlexec 4712925 131072 26791 20 6048 4 sqlexec 4719332 131072 34647 26 6048 4 sqlexec 4720097 131072 32343 24 6048 4 sqlexec 4720531 131072 34671 26 6048 4 sqlexec 4722112 131072 24391 18 6048 4 sqlexec 4722122 131072 22483 17 6048 4 sqlexec 4722181 131072 53991 41 6048 4 sqlexec 4724073 131072 20663 15 6048 4 sqlexec 4724975 131072 37463 28 6048 4 sqlexec 4725049 131072 27287 20 6048 4 sqlexec 4725298 131072 34671 26 6048 4 sqlexec 4725777 131072 34671 26 6048 4 sqlexec 4725802 131072 20151 15 6048 4 sqlexec 4726000 131072 31303 23 6048 4 sqlexec 4726480 131072 24231 18 6048 4 sqlexec 4726892 131072 24391 18 6048 4 sqlexec 4727440 131072 24391 18 6048 4 sqlexec 4727805 131072 24391 18 6048 4 sqlexec 4728872 131072 32607 24 6048 4 sqlexec 4729464 131072 20663 15 6048 4 sqlexec 4729465 131072 26327 20 6048 4 sqlexec 4729719 131072 20151 15 6048 4 sqlexec 4729801 131072 28363 21 6048 4 sqlexec 4729802 131072 32607 24 6048 4 sqlexec 4729843 131072 20151 15 6048 4 sqlexec 4729844 131072 131071 99 4152996768 3168485 sqlexec