What is MariaDB error code 1053

Solution Verified - Updated -

Environment

  • Red Hat Enterprise Linux 8
  • Red Hat Enterprise Linux 9
  • MariaDB 10

Issue

  • Error code 1053 has been logged in MariaDB's audit logs.
  • In MariaDB data file directory, files with the #sql-xxx prefix is found, and some table objects can not be accessed normally.

Resolution

  • MariaDB error 1053 can lead to data loss. Before shutting down service, it is best to check whether there are any tasks being executed to prevent abnormal termination. In addition, if need to manually terminate an operation that has been running for a long time without any response, use the kill command to prevent data inconsistency.

Root Cause

  • MariaDB error 1053 ER_SERVER_SHUTDOWN indicates that the MariaDB server has been shut down. This error code appears if an operation of database being executed ends abnormally.
  • If the audit log function of MariaDB is enabled, the abnormal interrupted operation will be displayed in the audit log.
  • Some online DDL operations that rebuild the table create a temporary intermediate table file in the same directory as the original table. An intermediate table file may require space equal to the size of the original table. Intermediate table file names begin with #sql-xxx prefix and only appear briefly during the online DDL operation.
  • If the operation of creating a temporary table is abnormally interrupted, the temporary table may be retained and the object table may not be accessed normally.

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments