Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.4.7
-
None
-
Ubuntu 18.04 running Mariadb 10.4.7 Galera Cluster
Description
Loading a delimited text file fails in mysql LOAD DATA INFILE query or using the mysqlimport program. Test file is 17 million rows and 4.7GiB. Error thrown is
[Warning] WSREP: transaction size limit (2147483647) exceeded: 2147483648
[ERROR] WSREP: rbr write fail, data_len: 2147483648
I can fix it by setting the wsrep_load_data_splitting='ON' variable, but the documentation says this was deprecated in 10.4.3 because of a new continuous replication change. I'm on 10.4.7 and having this set to off does not work. Not sure if I have a setting in my config breaking this feature, or if it is not yet running fully.
My mariadb.cnf:
[mysqld]
#mysql settings
datadir = /var/lib/mysql
innodb_buffer_pool_size = 15GB
innodb_buffer_pool_instances = 35
innodb_log_file_size = 2G
innodb_log_buffer_size = 16M
innodb_read_io_threads = 64
innodb_write_io_threads = 64
innodb_stats_on_metadata = 0
sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
character-set-client-handshake = false
ft_min_word_len = 3
long_query_time = 5
lower_case_table_names = 1
[galera]
- Mandatory settings
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address=gcomm://10.10.10.11,10.10.10.12
wsrep_node_address=10.10.10.11
wsrep_sst_receive_address=10.10.10.11
wsrep_node_name=Galera-Node1
binlog_format=row
wsrep_load_data_splitting= ON
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=1
wsrep_retry_autocommit=10
wsrep_slave_threads=32
wsrep_provider_options=gcache.size=2G - Custom settings
wsrep_cluster_name="Galera-Cluster1"
wsrep_sst_method = mariabackup
bind-address=10.10.10.11
skip-name-resolve
performance_schema = ON
innodb_flush_log_at_trx_commit = 0
wsrep_notify_cmd = notify
Attachments
Issue Links
- is caused by
-
MDEV-18564 Change wsrep_load_data_splitting off by default
- Closed