Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1715

LP #1358264: Mtr against a standalone mysql-codership: innodb.innodb_prefix_index_restart_server

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Esa Kettunen last update 09-02-2015 22:57:41

      Running mysql standard test suite mtr against a standalone mysql with
      codership patches:

      ./mtr --reorder --report-features --comment="Trying reorder, report-features" --mem --suite innodb --debug-server --no-warnings --force --max-test-fail=100 | tee /home/egge/mtr-run-2014-08-14-a.txt

      Amongst the bugs we find the following:

      CURRENT_TEST: innodb.innodb_prefix_index_restart_server
      mysqltest: At line 85: query 'INSERT INTO worklog5743 VALUES(REPEAT("b", 3500) , REPEAT("o", 3500))' failed: 1062: Duplicate entry 'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb' for key 'PRIMARY'

      The result from queries just before the failure was:
      < snip >
      START TRANSACTION;
      "In connection default ....restarting the server"
      SELECT COUNT FROM worklog5743;
      COUNT
      2
      SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
      worklog5743;
      col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500)
      1 1
      0 1
      "In connection 1"
      SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
      worklog5743;
      col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500)
      1 1
      0 1
      SELECT COUNT FROM worklog5743;
      COUNT
      2
      START TRANSACTION;

      More results from queries before failure can be found in /home/egge/aug/codership-mysql/mysql-test/var/log/innodb_prefix_index_restart_server.log

      Analysis:
      ---------
      Duplicate primary key where the keys should be UNIQUE.
      Might have somethings to do with a shutdown/crash & restart?

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: