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