assert failure and bug no. 115077

Based on the entries from the system message log below, can anyone tell whether the problem that caused the assert failure is the same as the problem described by bug no. 11507 (reportedly fixed in 7.31UC6)? We don't see assert failures often with 7.31UC2X6, but this one shows up once in a while. BTW, we are planning to upgrade to 7.31UD7x5 soon. Thanks, John 115077 ASSERT FAILED: READ_RECORD: BAD PAGE, INVALID ROWID DURING DIRTY READ SELECTS. See also: http://www-306.ibm.com/software/data/informix/pubs/library/notes/relnote s/ids0731a7.txt system message log: 02:35:49 Assert Failed: read_record: bad page 02:35:49 Informix Dynamic Server Version 7.31.UC2X6 02:35:49 Who: Session(92394, xxx@xxxx, 6286, 1675224948) Thread(133181, sqlexec, 62483d88, 3) File: rsread.c Line: 2436 02:35:49 Results: Record not read 02:35:49 Action: Please notify Informix Technical Support. 02:35:54 Logical Log 74807 - Backup Started 02:35:56 Logical Log 74807 - Backup Completed 02:36:00 See Also: .../af.c25e605, shmem.c25e605.0 02:36:27 read_record: invalid rowid = 43583135, partnum = 700129 02:36:27 Assert Failed: No Exception Handler 02:36:27 Informix Dynamic Server Version 7.31.UC2X6 02:36:27 Who: Session(92394, xxx@xxxx, 6286, 1675224948) Thread(133181, sqlexec, 62483d88, 3) File: mtex.c Line: 446 02:36:27 Results: Exception Caught. Type: MT_EX_OS, Context: mem 02:36:27 Action: Please notify Informix Technical Support. sending to informix-list

It looks very likely that it is 115077. If you can paste the stack and SQL statement from the af.c25e605 file it should be possible to confirm with greater certainty. Regards Guy Spurgeon, John P wrote: > Based on the entries from the system message log below, can anyone tell > whether the problem that caused the assert failure is the same as the > problem described by bug no. 11507 (reportedly fixed in 7.31UC6)? We > don't see assert failures often with 7.31UC2X6, but this one shows up > once in a while. BTW, we are planning to upgrade to 7.31UD7x5 soon. > > Thanks, > John > > 115077 ASSERT FAILED: READ_RECORD: BAD PAGE, INVALID ROWID DURING > DIRTY READ SELECTS. > > See also: > http://www-306.ibm.com/software/data/informix/pubs/library/notes/relnote > s/ids0731a7.txt > > system message log: > > 02:35:49 Assert Failed: read_record: bad page > 02:35:49 Informix Dynamic Server Version 7.31.UC2X6 > 02:35:49 Who: Session(92394, xxx@xxxx, 6286, 1675224948) > Thread(133181, sqlexec, 62483d88, 3) > File: rsread.c Line: 2436 > 02:35:49 Results: Record not read > 02:35:49 Action: Please notify Informix Technical Support. > 02:35:54 Logical Log 74807 - Backup Started > 02:35:56 Logical Log 74807 - Backup Completed > 02:36:00 See Also: .../af.c25e605, shmem.c25e605.0 > 02:36:27 read_record: invalid rowid = 43583135, partnum = 700129 > 02:36:27 Assert Failed: No Exception Handler > 02:36:27 Informix Dynamic Server Version 7.31.UC2X6 > 02:36:27 Who: Session(92394, xxx@xxxx, 6286, 1675224948) > Thread(133181, sqlexec, 62483d88, 3) > File: mtex.c Line: 446 > 02:36:27 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 02:36:27 Action: Please notify Informix Technical Support.> > sending to informix-list