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

TokuDB crashes during partition rotation

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Invalid
    • None
    • None
    • TokuDB
    • 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);

      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

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

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist