Repeated Assertion Failure and caused the IDS down.
Posted in 2000
Hi all,
IDS 7.30.UC5
SUN Solaris 2.6
After created additional 2 temp dbspace, I'm getting the assertion failure
when one of the batch file is running. I did run the oncheck command to
check the database consistency, but no error was found. However, the problem
was eliminated when I drop the additional 2 temp dbspace and re-run the
batch file. WHY? Is it because of BUG?????
p/s: the batch file was running on daily basic since day one and never given
any problem at all before creating additional temp dbspace.
onstat -m:13:01:21 Assert Failed: read_record: deleted rowid = 101, partnum = 300684
13:01:21 Informix Dynamic Server Version 7.30.UC5
13:01:21 Who: Session(7336, cronadm@infimacs, 29593, 0)
Thread(15367, xchg_3.0, 0, 8)
File: rsread.c Line: 2260
13:01:21 Results: Record not read
13:01:21 Action: Please notify Informix Technical Support.
13:01:48 See Also: /tmp/af.3c075121
13:01:48 See Also: /tmp/af.3bd650db
13:01:48 See Also: /tmp/af.3baa50cb
13:01:48 Assert Failed: Page Check Error in read_record:bad slot
13:01:48 Assert Failed: Page Check Error in read_record:bad slot
13:01:48 Informix Dynamic Server Version 7.30.UC5
13:01:48 Informix Dynamic Server Version 7.30.UC5
13:01:48 Who: Session(7336, cronadm@infimacs, 29593, 0)
Thread(15367, xchg_3.0, 0, 8)
File: rsdebug.c Line: 943
13:01:48 Who: Session(7292, cronadm@infimacs, 29482, 0)
Thread(15274, xchg_3.0, 0, 3)
File: rsdebug.c Line: 943
13:01:48 Results: Possible inconsistencies in 'dataware:"".'
13:01:48 Results: Possible inconsistencies in 'dataware:"".'
13:01:48 Action: Run 'oncheck -cD 3147396'
13:01:48 Action: Run 'oncheck -cD 8388790'
13:01:48 Assert Failed: Page Check Error in read_record:bad slot
13:01:48 Informix Dynamic Server Version 7.30.UC5
13:01:48 Who: Session(7312, cronadm@infimacs, 29490, 0)
Thread(15318, xchg_3.0, 0, 6)
File: rsdebug.c Line: 943
13:01:48 Results: Possible inconsistencies in 'dataware:"".'
13:01:48 Action: Run 'oncheck -cD 3147383'
13:01:48 See Also: /tmp/af.3bf750eb
/usr/informix7/bin/onstat -g ses 7336:
Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 1 days 05:36:11
-- 1587776 Kbytes
session #RSAM total used
id user tty pid hostname threads memory memory
7319 cronadm - 29551 infimacs 4 2113536 1922176
tid name rstcb flags curstk status
10250 sqlexec 61acf888 Y--P--- 4408 61acf888 cond wait(opened_up)
17000 xchg_1.0 61ae8d00 Y------ 768 61ae8d00 cond wait(opened_up)
17001 xchg_2.0 57b0bb4c Y------ 696 57b0bb4c cond wait(packet_cond)
17002 xchg_3.0 5e9130b0 ----R-- 2840 5e9130b0 running
Memory pools count 2
name class addr totalsize freesize #allocfrag #freefrag
7319 V 60038018 2080768 175504 2112 70
7319_SORT_0 V 622dc018 32768 15856 7 2
name free used name free used
overhead 0 240 scb 0 216
opentable 0 56288 filetable 0 5208
ru 0 224 misc 0 5928
log 0 8608 temprec 0 13200
keys 0 3656 ralloc 0 1633776
gentcb 0 10224 ostcb 0 2008
sort 0 17024 sqscb 0 19232
srtmembuf 0 72 rdahead 0 832
xchg_desc 0 920 xchg_port 0 528
xchg_packet 0 296 xchg_group 0 384
xchg_priv 0 224 scan_desc 0 840
sort_desc 0 672 btmrg_desc 0 304
hashfiletab 0 1120 osenv 0 1736
buft_buffer 0 114720 sqtcb 0 15072
fragman 0 8088 light_scan 0 72
lt_scan_rbuff 0 128 lt_scan_bufs 0 72
shmblklist 0 264
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
7319 CREATE INDEX dataware DR Wait 300 0 0 7.20
Current SQL statement :
create index tmpdnstxt_0 on tmpdnstxt ( projno , resp , itemno , firm_sts
, po_number )
Last parsed SQL statement :
create index tmpdnstxt_0 on tmpdnstxt ( projno , resp , itemno , firm_sts
, po_number )
User-created Temp tables :
partnum tabname rowsize
900094 tmppir2 36
800063 tmpondiwd2 36
900089 tmpondiwd1 40
900074 tmppos5 117
90006c tmppos4 67
90005f tmppos3 58
800055 tmpiws2 66
800027 tmppos2 62
800022 tmpima4 284
90004e tmpima1 164
90004e tmpima1 164
Thanks/Regards,
Jason