IDS 11.5 - repeated index corruption
Posted in 2008
I have a new install of 11.5 fc2. I am trying to run a set of stored procedures to load data from one table to 6 separate tables in a database. This works fine on my ID10 fc8 instance, but on the new instance the indexes are constantly being corrupted. I run the onchecks... drop and rebuild the indexes... I have even rebuilt the entire database on a different part of the file system. At his last attempt, the first failure comes about 380,000 records in.. after the assert failure, I ran oncheck as recommended, dropped and rebuilt the indexes, ran update statistics just for good measure.. and then restarted the stored procedure (it picks up where it left off)....
13:57:11 Assert Failed: Page Check Error in btusearch:bad btree node
13:57:11 IBM Informix Dynamic Server Version 11.50.FC2
13:57:11 Who: Session(74, informix@psas07spr, 18391, 0x5b46de48)
Thread(2135, sqlexec, 5b436668, 5)
File: rsdebug.c Line: 1091
13:57:11 Results: Possible inconsistencies in an index of 'masterindex2:"informix".ssn'
13:57:11 Action: Run 'oncheck -cI masterindex2:"informix".ssn'
13:57:11 stack trace for pid 23045 written to /home/informix/tmp/af.c3f6e97
13:57:11 See Also: /home/informix/tmp/af.c3f6e97, shmem.c3f6e97.0
13:57:16 Page Check Error in btusearch:bad btree node
after the assert failure, I ran oncheck as recommended, dropped and rebuilt the indexes and ran update statistics just for good measure.. and got another failure
14:17:02 Assert Failed: Page Check Error in rsidxinfo:bad btree node3
14:17:02 IBM Informix Dynamic Server Version 11.50.FC2
14:17:02 Who: Session(87, informix@psas07spr, 27162, 0x5b46cd08)
Thread(2388, sqlexec, 5b433da0, 3)
File: rsdebug.c Line: 1091
14:17:02 Results: Possible inconsistencies in an index of 'masterindex2:"informix".address'
14:17:02 Action: Run 'oncheck -cI masterindex2:"informix".address'
14:17:02 stack trace for pid 23043 written to /home/informix/tmp/af.d3cc4be
14:17:02 See Also: /home/informix/tmp/af.d3cc4be, shmem.d3cc4be.0
14:17:07 Page Check Error in rsidxinfo:bad btree node3
so I ran oncheck... and there didnt seem to be any errors... so I tried update stats again - - got another failure (anybody see a pattern here?)
14:22:26 Assert Failed: Page Check Error in btpnext:bad page
14:22:26 IBM Informix Dynamic Server Version 11.50.FC2
14:22:26 Who: Session(90, informix@psas07spr, 32295, 0x5b46cd08)
Thread(2440, sqlexec, 5b433da0, 4)
File: rsdebug.c Line: 1117
14:22:26 Results: Possible inconsistencies in 'masterindex2:"informix".systemrecord'
14:22:26 Action: Run 'oncheck -cDI masterindex2:"informix".systemrecord'
14:22:26 stack trace for pid 23044 written to /home/informix/tmp/af.d70c601
14:22:26 See Also: /home/informix/tmp/af.d70c601, shmem.d70c601.0
14:22:31 Page Check Error in btpnext:bad page
ran the oncheck.. no problems.. thats as far as I am going to go with this it just goes on the same way - each time with another table (there are 6 tables..)
I have opened a PMR with IBM, but Im not getting much response so I am asking if anyone has seen this? I would hope it is in the way I have set up the new instance and not a bug... it would be a really bad bug..
IDS 11.5 fc2
linux
cooked files on a OCFS2 filesystem - we used a clustered FS to enable SDS... obviously not to that point yet...
THANKS!!!
Laurie
Laurie Gustin
IT Programmer Analyst
Department of Public Safety
lgustin@utah.gov
801-965-4410