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