Troubleshooting
Problem
Guardium 11.5 using MySQL 8.0 where undo log design allows for more undo logs, dynamic log creation, and automatic truncation to be always on. Undo logs should be automatically truncated when there are no active transactions that use them and they exceed the minimum size for automatic truncation. However, in some cases, the level of activity on the appliance can cause all logs to fill up without automatic truncation taking place.
undo log files size can be identified by using the following command:
support show large 1000 0
Unlike older Guardium versions (11.4 and before) that using MySQL 5.7, which has only two undo log files, in Guardium 11.5 there are five:
/var/IBM/Guardium/data/mysql/undo_001: 53G
/var/IBM/Guardium/data/mysql/undo_002: 54G
/var/IBM/Guardium/data/mysql/undo_003.ibu: 54G
/var/IBM/Guardium/data/mysql/undo_004.ibu: 54G
/var/IBM/Guardium/data/mysql/undo_005.ibu: 54G
/var/IBM/Guardium/data/mysql/undo_002: 54G
/var/IBM/Guardium/data/mysql/undo_003.ibu: 54G
/var/IBM/Guardium/data/mysql/undo_004.ibu: 54G
/var/IBM/Guardium/data/mysql/undo_005.ibu: 54G
As in a case of a low disk space due to large undo logs before Guardium 11.5 version, submit a case to the IBM Technical Support and provide the output of command "support must_gather system_db_info".
For low disk space due to MySQL undo logs in older Guardium versions (11.4 and before) refer following link:
https://www.ibm.com/support/pages/guardium-64-bit-low-disk-space-due-mysql-undo-files
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z000000Gp0PAAS","label":"DATABASE"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5.0"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
12 December 2023
UID
ibm17096352