[XtraDB Cluster - 5.6] 1317 Query execution was interrupted

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello everyone !

We migrated our old Percona XtraDB servers to a new infrastructure (still on 5.6 but not the same physical network behind this), we created a cluster of 3 nodes with ClusterControl, geographically present all around the country (they communicate through an internal network, max ping between them is <10 ms, MTU is 9000, MTU of clients is 1500 - clients are CoreOS nodes working with Kubernetes).

Since this migration, when we use CREATE TEMP TABLE (and only this, we don’t have the issue for SELECT/INSERTS/etc) , we often get this error (and we get this error quite instantly, or 2/3 secs after executing the query) :

Client:
SQLSTATE[70100]: <<Unknown error>>: 1317 Query execution was interrupted
Server:
2017-02-08 12:13:30 18832 [Warning] Aborted connection 14910 to db: 'xxx' user: 'xxx' host: '1.2.3.4' (Got an error reading communication packets)

Any idea would be appreciated as it is driving us slowly crazy :slight_smile:

Thanks for your help !
Regards.