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

REPAIR on ARCHIVE Database destroys TEXT Data

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.25, 10.3(EOL), 10.4(EOL), 10.5
    • 10.5
    • Storage Engine - Archive
    • None
    • Debian 10
      mariadb-server-10.3/stable,now 1:10.3.25-0+deb10u1 amd64

    Description

      After Repairing a Tabel due to power loss I detected all Text fields seem to be corrupted.

      For reproduction I minified everything:

      CREATE TABLE `TEST` ( 
      	`text` TEXT NULL DEFAULT NULL
      		 
      )
      		 
      COLLATE='utf8_general_ci'
      		 
      ENGINE=ARCHIVE
      		 
      ;
      		 
       
      		 
      INSERT INTO `TEST` (`text`) VALUES ('Testtext');
      		 
       
      		 
      REPAIR TABLE `TEST`;

      Reading the Row before the REPAIR is fine.
      When I try to read the Inserted row after the repair there is corrupted data.
      This is also the case with OPTIMIZE

      I can reproduce this on all my Debian 10 Machines.

      Is it possible to reproduce this error for someone else.

      Best regards

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            3dmedium Johannes Grieb
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.