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

ERROR 1180 (HY000): Got error 5 "Input/output error" during COMMIT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • 10.4.10
    • N/A
    • None
    • Open Source MariaDB Version 10.4.12-MariaDB , WSREP_PROVIDER_NAME Galera , WSREP_PROVIDER_VERSION | 26.4.3(r4535)

    Description

      I have received 3.5 GB data csv file to be loaded into MariaDB Table. While loading data I am getting error

      MariaDB [sibra]> LOAD DATA LOCAL INFILE '/tmp/task.csv' INTO TABLE TEST1 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';SET bulk_insert_buffer_size =1024*1024*1024*256;set global wsrep_max_ws_size=2147483647;

      ERROR 1180 (HY000): Got error 5 "Input/output error" during COMMIT
      Query OK, 0 rows affected (0.00 sec)

      Query OK, 0 rows affected (0.00 sec)

      I have checked on MariaDB Website , wsrep_max_ws_size parameter Maximum Value : 2147483647 which can be set.

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            tarun Tarun
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.