Error Message :
When a system stops and you see “Shrink of MQ tables causes system stop” it is not the actual cause of the error.
Shrinking of the MQ tables is not the root cause of the system stop rather it is a “SELECT FOR UPDATE SKIP LOCKED” on the MQ tables.
Root Cause: “SELECT FOR UPDATE SKIP LOCKED” causes the system to stop but the “Shrink of MQ tables causes system stop” message follows that error and is displayed. The actual cause is due to the MQ table being locked.
Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
1) DBA should kill the locking session.
2) Disable UC_REORG and do the reorganization manually.
Fix Status: No Fix