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

Got error 5 "Input/output error" during COMMIT;

    XMLWordPrintable

Details

    Description

      The environment is a mixed of Mysql5.6 and MariaDB 10.0. RBR replication from 5.6 to 10.0 is working fine except we have a large volume of data copy from one innodb table into another innodb table.

      example.

      INSERT into lgV3_Report.T_Report_Copy
      select * from lgV3_Report.T_Report where Date >='2015-2-20' AND Date < '2015-2-25';

      Which could be a few million of rows. All MySQL 5.6 salves are committed this query without problem. However, on a MariaDB 10.0.17 salve, the SQL_Slave thread stopped with this error

      "Got error 5 "Input/output error" during COMMIT;"

      Attachments

        Activity

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            leomkkwan Leo Kwan
            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.