Errors 3773, 5350, and 3774 trying to start a database with after image archiver enabled
RecTrac 3.1.10.21.00
Table of Contents
Problem
After running an update from 3.1.10.04.03 to 3.1.10.22.00 the live database would not start up and produce the following errors.
Note: This customer is using AI (After Image).
Error Message
BROKER ** This process terminated with exit code 1 (8619)
BROKER 0: Backup after-image extent and mark it as empty (3774)
BROKER 0: Database Server shutting down as a result of after-image extent switch failure (5350)
BROKER 0: Can't switch to after-image C:\vsi3\rectrac\data\live\rectrac.a3 it is full (3773)
BROKER 0: Begin Physical Undo 1 transactions at block 1095 offset 1014 (7163)
BROKER 0: At end of Physical redo, transaction table size is 256 (13547)
BROKER 0: Physical Redo Phase Completed at blk 1095 of 1014 upd 13680 (7161)
BROKER 0: Begin Physical Redo Phase at 7168 (5326)
BROKER 0: Multi-user session begin (333)
BROKER 0: The startup of this database requires 465MB of shared memory. Maximum segment size is 1024mb \r\nBroker startup failed for LIVE\r\nAgent startup failed for LIVE
Solution
Empty FULL After Image extents by disabling AIMGT temporarily.
Steps For Solution
- Disable the ai archiver.
- $ rfutil dbname -C aiarchiver disable
- Report on the current status of AI files.
- $ rfutil dbname -C aimage list >> ailist.out
- OS copy the FULL extents noted from the output in step 2.
- Mark the FULL extents as EMPTY.
- $ rfutil dbname -C aimage empty
- Re-enable ai archiving.
- $ rfutil dbname -C mark backedup
- $ rfutil dbname -C aiarchiver enable
- Restart the database with the appropriate AI Archiver database startup parameters: -aiarcdir -aiarcinterval -aistall -aibufs.
The database should now start without error.