Informix 9.40 crash.
Posted in 2003
Hi all,
today the informix instance crashed.
The machine configuration is the following:
Informix Dynamic Server Version 9.40.FC1
Compaq Tru64 UNIX V5.1B (Rev. 2650)
And this is a part of online.log...
16:59:33 DR: Reservation of the last logical log for log backup turned on
16:59:33 Physical Recovery Started at Page (1:102061).
16:59:33 Physical Recovery Complete: 527 Pages Examined, 527 Pages
Restored.
16:59:33 Logical Recovery Started.
16:59:33 10 recovery worker threads will be started.
16:59:43 Fast Recovery Switching to Log 1008
16:59:46 Logical Recovery has reached the transaction cleanup phase.
16:59:46 Assert Failed: Rollback error 126
16:59:46 Informix Dynamic Server Version 9.40.FC1
16:59:46 Who: Session(17, root@deimos.icrcosmetics.local, 0, 22c3fec78)
Thread(34, fast_rec, 22c3baa58, 1)
File: rstrans.c Line: 2378
16:59:46 Results: Log record (OLDRSAM:HDELETE) in log 1008, offset0xd867f0 was not rolled back
16:59:46 Action: Use 'onlog' to view the transaction and repair manually.
16:59:46 stack trace for pid 650335 written to /tmp/af.40a1e72
16:59:46 See Also: /tmp/af.40a1e72
16:59:51 Rollback error 126
16:59:52 Assert Failed: Rollback error 126
16:59:52 Informix Dynamic Server Version 9.40.FC1
16:59:52 Who: Session(17, root@deimos.icrcosmetics.local, 0, 22c3fec78)
Thread(34, fast_rec, 22c3baa58, 1)
File: rsextlog.c Line: 1636
16:59:52 Results: Log record (OLDRSAM:HDELETE) in log 1008, offset0xd867f0 was not rolled back
16:59:52 Action: Use 'onlog' to view the transaction and repair manually.
16:59:52 stack trace for pid 650335 written to /tmp/af.40a1e72
16:59:52 See Also: /tmp/af.40a1e72
16:59:57 Rollback error 126
16:59:57 Assert Failed: Dynamic Server must abort
We cannot bring the system online: during the fast recovery it crash.
Is it possible to restart the system without the log 1008 or to drop this
log?
What does it means 'repair manually'? How can I do?
Can someone help to bring up the sistem however?
Thanks in advance.
Ciao.
Marino Decaro