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: <<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: '22.214.171.124' (Got an error reading communication packets)
Any idea would be appreciated as it is driving us slowly crazy
Thanks for your help !