IDS 7.31.UC2 Crashed...

Dear all, OS = Solaris 2.7 IDS = 7.31.UC2 My database server crashed with the following error from online.log and it was back to operation after the reboot. The attached onstat -g sql output was the SQL session that causing the crash. I did performed the oncheck -cID on those tables used by that particularSQL session, and no error reported. Anybody encounter this type of error on the same version?? All reply are highly appreciated. Thanks & regards, Miyaki ##### online.log ##### 02:59:17 Assert Failed: read_record: bad page 02:59:17 Informix Dynamic Server Version 7.31.UC2X602:59:17 Who: Session(196368, informix@kfacdc, 27446, 1584423476)Thread(304434, sqlexec, 5d7f44f4, 1)File: rsread.c Line: 2436 02:59:17 Results: Record not read02:59:17 02:59:26 See Also: /var/tmp/af.a91ad705, shmem.a91ad705.003:00:05 read_record: invalid rowid = 4e4d4100, partnum = 700122 03:00:05 Assert Failed: No Exception Handler 03:00:05 Informix Dynamic Server Version 7.31.UC2X6 03:00:05 Who: Session(196368, informix@kfacdc, 27446, 1584423476)Thread(304434, sqlexec, 5d7f44f4, 3)File: mtex.c Line: 446 03:00:05 Results: Exception Caught. Type: MT_EX_OS, Context: mem 03:00:13 See Also: /var/tmp/af.a91ad705, shmem.a91ad705.103:00:46 mtex.c, line 446, thread 304434, proc id 1142, No Exception Handler. 03:00:46 PANIC: Attempting to bring system down =================================================== /usr/informix/bin/onstat -g sql 196368: Informix Dynamic Server Version 7.31.UC2 -- On-Line (Prim) -- Up 71 days 14:45 :48 -- 275248 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 196368 SELECT ificsdc DR Not Wait 0 0 7.20 Current statement name : i0001e0b2_045c3b53 Current SQL statement : SELECT max(orgdate) FROM o_failure, outer (r_prodrollup, r_prodassc ) WHERE orgdate < ? AND opid = ? AND (item = ? OR fmly_nm = ?) AND defitem = ? AND defdesc = ? AND r_prodrollup.sales_item = r_prodassc.sales_item AND r_prodassc.mrp_item = item Last parsed SQL statement : select mrp_item from r_prodassc a , r_prodrollup p where a . sales_item = p . sales_item and p . fmly_nm = ? __________________________________ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com

This appears to be either a Bad Data or Index Page. I would check to find out what table/space is "partnum = 700122". Use the following query to find the dbsname and tabname: select * from systabnames where partnum = 700122 This is where the Bad Page is. It could be in a TEMP dbspace that is used when the Query is executed. The other thing to due is to run the onchecks for the entire database. Bill miyaki <lcib@yahoo.com> wrote in message news:<b9anrg$hga$1@terabinaries.xmission.com>... > Dear all, > > OS = Solaris 2.7 > IDS = 7.31.UC2 > > My database server crashed with the following error > from online.log and it was back to operation after the > reboot. The attached onstat -g sql output was the SQL > session that causing the crash. I did performed the > oncheck -cID on those tables used by that particular> SQL session, and no error reported. Anybody encounter > this type of error on the same version?? > > All reply are highly appreciated. > > Thanks & regards, > Miyaki > > ##### online.log ##### > 02:59:17 Assert Failed: read_record: bad page > 02:59:17 Informix Dynamic Server Version > 7.31.UC2X602:59:17 Who: Session(196368, > informix@kfacdc, 27446, 1584423476)Thread(304434, > sqlexec, 5d7f44f4, 1)File: rsread.c Line: 2436 > 02:59:17 Results: Record not read02:59:17 > 02:59:26 See Also: /var/tmp/af.a91ad705, > shmem.a91ad705.003:00:05 read_record: invalid rowid = > 4e4d4100, partnum = 700122 > 03:00:05 Assert Failed: No Exception Handler > 03:00:05 Informix Dynamic Server Version 7.31.UC2X6 > 03:00:05 Who: Session(196368, informix@kfacdc, 27446, > 1584423476)Thread(304434, sqlexec, 5d7f44f4, 3)File: > mtex.c Line: 446 > 03:00:05 Results: Exception Caught. Type: MT_EX_OS, > Context: mem > 03:00:13 See Also: /var/tmp/af.a91ad705, > shmem.a91ad705.103:00:46 mtex.c, line 446, thread > 304434, proc id 1142, No Exception Handler. > 03:00:46 PANIC: Attempting to bring system down > > =================================================== > /usr/informix/bin/onstat -g sql 196368: > > Informix Dynamic Server Version 7.31.UC2 -- On-Line > (Prim) -- Up 71 days 14:45 > :48 -- 275248 Kbytes > > Sess SQL Current Iso Lock > SQL ISAM F.E. > Id Stmt type Database Lvl Mode > ERR ERR Vers > 196368 SELECT ificsdc DR Not Wait > 0 0 7.20 > > Current statement name : i0001e0b2_045c3b53 > > Current SQL statement : > SELECT max(orgdate) FROM o_failure, outer > (r_prodrollup, r_prodassc ) > WHERE orgdate < ? AND opid = ? AND (item = ? > OR fmly_nm = ?) AND > defitem = ? AND defdesc = ? AND > r_prodrollup.sales_item = > r_prodassc.sales_item AND r_prodassc.mrp_item = > item > > Last parsed SQL statement : > select mrp_item from r_prodassc a , r_prodrollup p > where a . sales_item = > p . sales_item and p . fmly_nm = ?> > > __________________________________ > Do you Yahoo!? > The New Yahoo! Search - Faster. Easier. Bingo. > http://search.yahoo.com

Hi, > shmem.a91ad705.003:00:05 read_record: invalid rowid = > 4e4d4100, partnum = 700122 The mentioned rowid "4e4d4100" is an invalid rowid, because it identifies a page and not a row. I would contact the Informix Support or any guru from this NG, because this might be a problem on disk ( but you've checked that already ), might be a problem inside your RAM or might be an ordinary bug. BR Stefan