HEEELLP!!! Online 7.1 on DEC Alpha 2100 Hang
Posted in 1996
Topics: Error Codes & Troubleshooting, Logging & Checkpoints, Jobs, Consulting & Announcements
Sorry folks, I should have done this to the Informix Tech Support here. I have
done it and they not able to bring up my system yet and no proper explanation
to the problem.
FYI We are running Financial Application and about to close February A/C last
Tuesday. The system is Digital Alpha 2100 OSF/1 3.2A using INFORMIX Online
7.11UC. That evening the whole system hang and the following message appear:
10:44:10 dodelitem: Node 0x8a, match 2
10:44:10 Could not delete item, rowid 0x26f01, key:
KEY:"CD":"01045103":"LA ":"C-SELANGOR ":"NONE ":"1-1-8-10-0-161014 ":
10:44:10 Node
Node 8a Prev 1ef Next 232
KEY:"CD":"01044908":"DIRECT ":"C-WILAYAH ":"RESTAURANT ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ 54103
KEY:"CD":"01044973":"DIRECT ":"C-SELANGOR ":"RESTAURANT ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ 1e801
KEY:"CD":"01045103":"DIRECT ":"C-SELANGOR ":"NONE ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ 26f01
KEY:"CD":"01045244":"DIRECT ":"C-WILAYAH ":"CONSULTANT ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ a6602
KEY:"CD":"01045319":"DIRECT ":"S-JOHORE ":"NONE ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ 2c003
KEY:"CD":"01045327":"STAFF-SEN ":"C-WILAYAH ":"NONE ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ aed02
KEY:"CD":"01045368":"DIRECT ":"C-P.JAYA ":"INDIVIDUAL ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ 34703
KEY:"CD":"01045467":"DIRECT ":"N-PENANG ":"NONE ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ 8eb03
KEY:"CD":"01045483":"DIRECT ":"N-PENANG ":"NONE ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ d6e02
KEY:"CD":"01045582":"DIRECT ":"C-WILAYAH ":"INDIVIDUAL ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ d1c03
KEY:"CD":"01045616":"DIRECT ":"C-WILAYAH ":"NONE ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ 64f03
KEY:"CD":"01045624":"DIRECT ":"C-WILAYAH ":"NONE ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ e7c01
KEY:"CD":"01045707":"DIRECT ":"C-WILAYAH ":"NONE ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ 6d602
KEY:"CD":"01045715":"DIRECT ":"C-WILAYAH ":"INDIVIDUAL ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ 78e01
KEY:"CD":"01045723":"DIRECT ":"E-KELANTAN ":"NONE ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ 60001
KEY:"CD":"01045749":"DIRECT ":"OTHER ":"NONE ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ e2a02
KEY:"CD":"01045798":"STAFF-SEN ":"C-WILAYAH ":"NONE ":"1-1-8-10-0-161014 ":
Fragids/Rowids: 400202/ 8903
----------------------------------------------------------------------
10:44:10
10:44:10 Assert Failed: WARNING! Error during recovery left index inconsistent.
10:44:10 Who: Session(6, informix@, 0, 175)
Thread(45, xchg_1.0, b445460, 1)
10:44:10 Results: Index 'nstp:"misdan".ar_customer03-Key#1' is now unusable
10:44:10 Action: Run 'oncheck -cI 4194820'
10:44:10 See Also: /ifas/informix/dump/af.45ee5092
10:44:10
------------------ End of assertion failure 0 -----------------
10:44:11 bf_onwtlist: already buffer ownerbuffer header
06f40440: 0005f406 00000000 8003f406 00000000 ..'..... '.'.....
06f40450: 01000000 00000000 00000000 00000000 ........ ........
06f40460: 00000000 00000000 00000000 00000000 ........ ........
06f40470 *
06f40480: 204d0f0f 00000000 00000000 00000000 M...... ........
06f40490: d9830200 d1070100 00006266 5b393534 ك..'... ..bf[954
06f404a0: 5d000000 00000000 00000000 00000000 ]....... ........
06f404b0: 4062b606 00000000 4062b606 00000000 @b'..... @b'.....
06f404c0: a8298100 00000000 0005f406 00000000 ')'..... ..'.....
06f404d0: 03000000 000a0000 530a4000 00000000 ........ S.@.....
06f404e0: 0038b707 00000000 6054440b 00000000 .8'..... `TD.....
06f404f0: 00000000 00000000 00008000 00000000 ........ ..'.....
page header
07b73800: 530a4000 9151ee45 00000000 1800e407 S.@.'Q'E ......'.
07b73810: 00000000 00000000 ........
10:44:11
10:44:11 Assert Failed: Buffer manager internal error
10:44:11 Who: Session(6, informix@, 0, 11)
Thread(45, xchg_1.0, b445460, 1)
10:44:11 Results: OnLine must abort
10:44:11 Action: Reinitialize shared memory
10:44:11 See Also: /ifas/informix/dump/af.45ee5092
Even the Console hang. We have no choice but to rebbot system. But when we try
to startup Informix engine the whole system hang again. We even try to restore
but when we try to rollforward the logical logs again the system hang. Without
rolling forward the online restore will complete still in recovery mode. When
we take the engine offline we can't bring the online up again complaining not
able to initialize shared memory. Still waiting for Tech Support torectify the
problem.
If there are anybody out there had experienced the same problem would very
much oblige for your wise advice before somebody head roll.
Thank you in advance and regards.