Not the answer you need?
Register and ask your own question!

[XtraDB Cluster - 5.6] 1317 Query execution was interrupted

NyrkkiNyrkki EntrantCurrent User Role Beginner
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 :)

Thanks for your help !
Regards.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.