Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4339

TokuDB crashes during partition rotation

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: TokuDB
    • Labels:
      None

      Description

      Hello!

      This bug was already reported to MariaDB:
      https://jira.mariadb.org/browse/MDEV-11143

      As Percona is upstream, reporting here as well.

      Logs are attached.

      Both times this happened when daily repartitioning event was running.

      Here are the logs from repartitioning script (db and table names changed):

      DO localhost alter table `database1`.`table1` drop partition p20161011;
      [ERR]: localhost Can't execute SQL statement: alter table `database1`.`table1` drop partition p20161011; on DB database1 : Lost connection to MySQL server during query
      READY localhost alter table `database1`.`table1` drop partition p20161011;
      DO localhost alter table `database1`.`table1` reorganize partition pmax into (partition p20161117 VALUES LESS THAN(1479420000),PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = TokuDB);
      [ERR]: localhost Can't execute SQL statement: alter table `database1`.`table1` reorganize partition pmax into (partition p20161117 VALUES LESS THAN(1479420000),PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = TokuDB); on DB database1 : MySQL server has gone away
      READY localhost alter table `database1`.`table1` reorganize partition pmax into (partition p20161117 VALUES LESS THAN(1479420000),PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = TokuDB);

        Smart Checklist

          Attachments

          1. my.cnf
            2 kB
          2. table1.sql
            3 kB
          3. tokudb_crash.log
            23 kB
          4. tokudb_crash2.log
            22 kB

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                george.lorch George Lorch
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: