Problem with the Rolled back transaction in Informix Engine

Posted in 2003

Jiten Thakkar — Thu, 11 Sep 2003 02:54:43 — source: IIUG Forums & Mailing Lists

I had a database crash and when I try to start the engine I get following error . Any help /info will be useful . Informix Version : 9 .30FC2 OS : SunOS panaka 5.8 Thanks . Jiten 18:51:20 Rollback error 172 18:51:21 Assert Failed: Rollback error 172 18:51:21 Informix Dynamic Server Version 9.30.F 18:51:21 Who: Session(13, informix@panaka, 0, 741971384) Thread(66, fast_rec, 12c35a918, 3) File: rsextlog.c Line: 1635 18:51:21 Results: Log record (OLDRSAM:ALTERDONE) in log 80995, offset 0x997328 was not rolled back 18:51:21 Action: Use 'onlog' to view the transaction and repair manually. 18:51:21 stack trace for pid 1549 written to /export1/home/informix/log/af.42ad4fe 18:51:21 See Also: /export1/home/informix/log/af.42ad4fe 18:51:27 Rollback error 172 18:51:27 Assert Failed: Dynamic Server must abort 18:51:27 Informix Dynamic Server Version 9.30.F 18:51:27 Who: Session(13, informix@panaka, 0, 741971384) Thread(66, fast_rec, 12c35a918, 3) File: rslog.c Line: 3319 18:51:27 Results: Dynamic Server must abort 18:51:27 Action: Reinitialize shared memory 18:51:27 stack trace for pid 1549 written to /export1/home/informix/log/af.42ad4fe 18:51:27 See Also: /export1/home/informix/log/af.42ad4fe

↪ replying to Jiten Thakkar

Murray Wood \\\\(IList\\\\) — Thu, 11 Sep 2003 03:55:17 — source: IIUG Forums & Mailing Lists

Was there any problem when the system was (not) shutdown? 1. Restore from archive and roll forward your transactions. or 2. Log a call with Tech Support. (They may tell you to do 1). or 3. Reinitialise and rebuild your instance. MW > -----Original Message----- > From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On > Behalf Of Jiten Thakkar > Sent: Thursday, 11 September 2003 2:55 p.m. > To: ids@iiug.org > Subject: Problem with the Rolled back transaction in Informix Engine > [1827] > > > I had a database crash and when I try to start the engine I get > following error . Any help /info will be useful . > > Informix Version : 9 .30FC2 > OS : SunOS panaka 5.8 > > Thanks . > Jiten > > 18:51:20 Rollback error 172 > 18:51:21 Assert Failed: Rollback error 172 > 18:51:21 Informix Dynamic Server Version 9.30.F > 18:51:21 Who: Session(13, informix@panaka, 0, 741971384) > Thread(66, fast_rec, 12c35a918, 3) > File: rsextlog.c Line: 1635 > 18:51:21 Results: Log record (OLDRSAM:ALTERDONE) in log > 80995, offset > 0x997328 was not rolled back > 18:51:21 Action: Use 'onlog' to view the transaction and repair > manually. > 18:51:21 stack trace for pid 1549 written to > /export1/home/informix/log/af.42ad4fe > 18:51:21 See Also: /export1/home/informix/log/af.42ad4fe > 18:51:27 Rollback error 172 > 18:51:27 Assert Failed: Dynamic Server must abort > 18:51:27 Informix Dynamic Server Version 9.30.F > 18:51:27 Who: Session(13, informix@panaka, 0, 741971384) > Thread(66, fast_rec, 12c35a918, 3) > File: rslog.c Line: 3319 > 18:51:27 Results: Dynamic Server must abort > 18:51:27 Action: Reinitialize shared memory > 18:51:27 stack trace for pid 1549 written to > /export1/home/informix/log/af.42ad4fe > 18:51:27 See Also: /export1/home/informix/log/af.42ad4fe > > > >

Glossary

shared memory