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

Got error 2 "No such file or directory" when querying TokuDB_fractal_tree_info

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.17, 5.5, 10.0
    • Fix Version/s: 5.5.44, 10.0.20
    • Labels:
      None
    • Environment:
      CentOS release 6.6 (Final)
      Kernel: 2.6.32-358.23.2.el6.x86_64
    • Sprint:
      5.5.45

      Description

      We were running a very large insert (500M rows) from an innodb table to a tokudb table.
      The insert failed and the mariadb crashed. Which came 1st is still unknown at this point.

      The tokudb table has 700 partitions with 4 indexes.

      After the failures anything regarding TokuDB metadata was returning that error: No such file or directory. Whether we were looking at this table or another.
      show table status...
      Select * from TokuDB_fractal_tree_info;

      Using sysdig, we found out that no mater what table you would be looking at, tokudb opens all tokudb related files. And in this case, the file it was looking for, existed but had a different name.
      The file it was looking for was:
      /data/mysql/tokudb_data/_MYDB_MYTAB_P_day_20140101_key_idx1_9a60c_2_1b_B_3.tokudb
      But the file was named:
      /data/mysql/tokudb_data/_MYDB_MYTAB_P_day_20140101_key_idx1_99906_5_1b.tokudb

      We shutdown the database, and renamed the file, and all worked after that.

      We tried many thing to get around the problem, one was to drop the table, which wasn't possible as it was giving us the same error.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                ynaguib Younes Naguib
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: