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

server stall on sync index (insert into large innodb table with fulltext index)

    XMLWordPrintable

    Details

    • Sprint:
      10.0.26

      Description

      I encounter exactly the same issue as described in this mysql bug
      http://bugs.mysql.com/bug.php?id=73816
      "In an instance of ours, where we are using FULLTEXT indexes on InnoDB tables, we see occasional blocked DML operations on any table using any engine (InnoDB as well as MyISAM) for the duration of ~2 minutes. The SHOW INNODB STATUS reveals that the oldest running transaction is an INSERT into a table with a FULLTEXT index"

      As mariadb doesn't have the parameter binlog_order_commits the only workaround found so far was to disable binary logging.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              dschnall David Schnall
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: