Can't import dump file to Percona Cluster with 3 node (actually 1 node is active)

  1. I see you are importing plain mysqldump fileinto PXC that involes cluster-unsafe statement like LOCK TABLES, etc…
    Cleaning up wsrep-transaction for local query: LOCK TABLES agents_realtime_statuses WRITE

  2. Failure suggests certification failure. Are you trying to load the files through multiple nodes at same time ?

  3. I would suggest you can enable wsrep-debug=1 to get more information about failure. (Note: wsrep-debug is only for investigation and shouldn’t be used for production load).

  4. If you can reduce the test-case and share it here we can help it investigate further and directly more about it.