Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
10.4.10
-
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.