[MDEV-22433] ERROR 1180 (HY000): Got error 5 "Input/output error" during COMMIT Created: 2020-05-01  Updated: 2020-08-12  Resolved: 2020-08-12

Status: Closed
Project: MariaDB Server
Component/s: Galera, Storage Engine - InnoDB
Affects Version/s: 10.4.10
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Tarun Assignee: Jan Lindström (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

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.

 Comments   
Comment by Alice Sherepa [ 2020-05-04 ]

wsrep_max_ws_size is max 2Gb, otherwise please consider using streaming replication https://galeracluster.com/library/documentation/streaming-replication.html

Comment by Tarun [ 2020-05-04 ]

Hello Alice,

We are using Galera 4 , where I have checked wsrep_provider , here I can
see it using Streaming Replication

show global status like 'wsrep_provider%';

MariaDB [stccdc]> show global status like 'wsrep_provider%';
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
:MULTI_MASTER:CERTIFICATION:PARALLEL_APPLYING:TRX_REPLAY:ISOLATION:PAUSE:CAUSAL_READS:INCREMENTAL_WRITESET:UNORDERED:PREORDERED:STREAMING:NBO:

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.01 sec)

Regards
Tarun

On Mon, May 4, 2020 at 1:54 PM Alice Sherepa (Jira) <jira@mariadb.org>
wrote:

Comment by Tarun [ 2020-05-09 ]

Referring to comments by Alice Sherapa ,

Is it not possible to load CSV files more than 2 GB using LOAD DATA LOCAL INFILE command in MariaDB 10.4.11 using Galera 4.0

Is this the limitation in MariaDB Open Source Software as we have downloaded from Repository

If we purchase Enterprise Edition MariaDB Software , will it be possible to load more than 2 GB data by csv files using LOAD DATA LOCAL INFILE command.

Comment by Jan Lindström (Inactive) [ 2020-08-12 ]

Based on documentation https://galeracluster.com/library/documentation/galera-parameters.html#repl-max-ws-size max value is 2G.

Generated at Thu Feb 08 09:14:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.