Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5036

Upgrade to 5.5.33 breakes aria table and causes server crash

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 5.5.33
    • Fix Version/s: 5.5.33a
    • Component/s: None
    • Labels:
    • Environment:
      Debian squeeze

      Description

      Since the release of the version 5.5.33 yesterday I have upgraded 3 different servers and they all broke the same aria table. The servers started to crash on first call to that table and I see [ERROR] mysqld: Incorrect information in file in the servers logs.
      In order to recover I had to move the table files and recreate the table.

      I'm attaching the problematic frm file that is causing the crash.

      The table definition is: CREATE TABLE `man_logs` (
        `LOG_ID` bigint(32) unsigned NOT NULL AUTO_INCREMENT,
        `USER_ID` int(11) DEFAULT NULL,
        `LOG_TIME` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
        `ACTION` varchar(255) DEFAULT NULL,
        `IP_ADDRESS` varchar(25) DEFAULT NULL,
        `DESCR` varchar(255) DEFAULT NULL,
        `MEM` blob,
        `SUCCES` int(11) DEFAULT NULL,
        `OBJ_ID` int(11) DEFAULT NULL,
        `OBJ_TYPE` varchar(50) DEFAULT NULL,
        `REF_ID` int(11) DEFAULT NULL,
        `EXEC_TIME` decimal(18,9) DEFAULT NULL,
        `ENDPOINT` varchar(255) DEFAULT NULL,
        PRIMARY KEY (`LOG_ID`),
        KEY `LOG_TIME` (`LOG_TIME`),
        KEY `OBJ_TYPE` (`OBJ_TYPE`,`OBJ_ID`),
        KEY `MAN_LOGS_EXEC_TIME` (`EXEC_TIME`)
      ) ENGINE=Aria AUTO_INCREMENT=12000983 DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1 TRANSACTIONAL=1

      On my test servers I didn't experience that behavior so I cannot recreate the issue, except on the production servers.

      The table was upgraded from myisam to aria and then to transactional aria.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lukav Anton Avramov
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: