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

Key corruption on upgrade to v10.0.13

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Cannot Reproduce
    • 10.0.13
    • N/A
    • Storage Engine - Aria
    • None
    • Ubuntu "Trusty" 14.04
      x86_64
      Kernel 3.13.0-33

    Description

      Running MariaDB from the deb repository. Have been running v10.0.x for 6 months or so. This week, I updated the server to 10.0.13.

      We immediately started seeing problems at the application layer with apparent bad or missing data. Downgrading back to 10.0.12 (and .11, and .10) did not fix the issue, which seemed to indicate the data itself was bad. I saw indications that the server was possibly corrupting keys, such as:

      MariaDB [dbname]> select * from invoices where date="20140819" order by id desc;
      [...]
      46 rows in set (0.02 sec)
       
      MariaDB [dbname]> select * from invoices where date="20140819" order by id desc limit 1;
      Empty set (0.00 sec)

      Still running 10.0.10, I then dumped the table contents via mysqldump and reloaded them, and the problems disappeared.

      i.e. merely applying a limit caused the query to return no rows (id is the primary key on this table).

      We're using Aria for most of the tables, including the above.

      Attachments

        Activity

          People

            elenst Elena Stepanova
            cazabon Charles C
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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