Adding sufficient extent space will allow recovery to complete.
During tranlog restore, unlike during recovery, space can be reclaimed,
so restoring from backup and tranlogs will succeed.
To avoid this problem, the best way is to avoid the commit record backlog
and resulting shutdown in the first place. Be especially careful about
commit record backlogs in the period following an MFC or other operation
that will cause a large amount of reclaim.
The default for STN_FREE_SPACE_THRESHOLD is 1MB which is much too small;
we suggest configuring this to be 1/1000 of the repository size. Depending
on the rate of page use it would be likely to allow the session holding
the CRB to be terminated, avoiding a shutdown, and increases the chance
that the checkpoint can complete.
However, note that if the repository is large, with a large amount of changes
that need to be written out as part of the checkpoint, it may take significant
time for a checkpoint to complete. See also bug #41809.