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

Running connections hang forever when all tables are flushed and locked for a few seconds

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.1.19
    • N/A
    • None
    • Windows Server 2008 R2 Enterprise

    Description

      For the backup of MariaDB we use VSShadow and therefore the following commands are executed:

      DROP TABLE IF EXISTS ibbackup_binlog_marker;
      CREATE TABLE ibbackup_binlog_marker(a INT) ENGINE=INNODB;
      SET AUTOCOMMIT=0;
      INSERT INTO ibbackup_binlog_marker VALUES (1);
      USE mysql;
      FLUSH TABLES WITH READ LOCK;
      COMMIT;

      With MariaDB 5.5 we didn't have any problems. But with MariaDB 10.1 all running connections hang forever and didn't return anymore when the commands above are executed. I have attachted the response of "show full processlist" and the minidump of MariaDB and the my.ini.

      Attachments

        1. my.ini
          4 kB
          Michael Graf
        2. mysqld.exe_161129_100345.001
          10.00 MB
          Michael Graf
        3. mysqld.exe_161129_100345.002
          7.45 MB
          Michael Graf
        4. mysqld.exe_161129_100345.crc
          0.1 kB
          Michael Graf
        5. show_full_processlist.csv
          148 kB
          Michael Graf

        Activity

          People

            Unassigned Unassigned
            migra Michael Graf
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.