Hello,
we are using percona xtradb cluster with 5 nodes.
Used software packages:
- Percona-XtraDB-Cluster-client-56-5.6.48-28.40.1.el7.x86_64
- percona-toolkit-3.2.0-1.el7.x86_64
- percona-xtrabackup-2.3.10-1.el7.x86_64
- Percona-XtraDB-Cluster-server-56-5.6.48-28.40.1.el7.x86_64
- Percona-XtraDB-Cluster-shared-56-5.6.48-28.40.1.el7.x86_64
- Percona-XtraDB-Cluster-galera-3-3.40-1.el7.x86_64
- wsrep_provider_options = “gcs.fc_limit=600; gcs.fc_master_slave=YES; gcs.fc_factor=0.8; gcache.size=5G;”
- wsrep_sst_method = xtrabackup-v2
- wsrep_provider = /usr/lib64/libgalera_smm.so
- wsrep_sync_wait = 1
- tmpdir = /var/lib/mysql-tmp
--------------------------------------------------
2020-08-03 13:50:36 4397 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘/var/lib/mysql-tmp/#sql_112d_1.MYI’; try to repair it
2020-08-03 13:50:37 4397 [ERROR] Slave SQL: Could not execute Update_rows event on table project_pps.emailmessage; Error writing file ‘/var/lib/mysql-tmp/MLGNEvmX’ (Errcode: 28 - No space left on device), Error_code: 3; Error writing file ‘/var/lib/mysql-tmp/MLGNEvmX’ (errno: 28 - No space left on device), Error_code: 1026; the event’s master log FIRST, end_log_pos 95402, Error_code: 1026
Retrying 2th time
2020-08-03 13:50:37 4397 [ERROR] Slave SQL: Could not execute Update_rows event on table project_pps.emailmessage; Error writing file ‘/var/lib/mysql-tmp/MLGNEvmX’ (Errcode: 28 - No space left on device), Error_code: 3; Error writing file ‘/var/lib/mysql-tmp/MLGNEvmX’ (errno: 28 - No space left on device), Error_code: 1026; the event’s master log FIRST, end_log_pos 95402, Error_code: 1026
…
2020-08-03 13:50:37 4397 [ERROR] WSREP: Failed to apply trx 5919417306 4 times
2020-08-03 13:50:37 4397 [ERROR] WSREP: Node consistency compromised, aborting…
2020-08-03 13:50:37 4397 [Note] WSREP: gcomm: closing backend
-----------------------------------------------------
I know that extending tmp directory and also adjust retry count can help but in my opinion this can ony be a workaround.
My question regarding this problem: Is there a possibility to separate xtradb internal tmp directory from user request tmp directory?
Thx for you help!
