Hi All,
Firstly thanks for walking me through this journey.
This is linked to “SSL issue with async replication between 2 pxc”
Context has changed hence creating a new thread.
Looks like it’s a bug! as per the error message on line 18,
This happens when the security team tries to scan MySQL using root for scanning vulnerabilities, the SSL error occurs and PXC node on which scan is running crashes, log message says it’s a bug and my my.cnf and other outputs shared above look fine.
After they try to login multiple times still mysql service should not crash, correct? or is it a safety feature in PXC if to many attempts are made service will crash??
The scanning tool attempts connecting approx 160 times and every second it connects 6 times after which mysql services crash.
In the general query log out of above mentioned 160 entries 99% of them are just connect and quit on repeat in each new line of the general log file, the scan tool also tries to scan if root and anonymous users are enabled without password.
Does the PXC cluster get overloaded and crashes??
Can you please help here.
Handshake failed: wrong version number
Handshake failed: unsupported protocol
Handshake failed: version too low
Handshake failed: unexpected message
Handshake failed: peer did not return a certificate
[libprotobuf ERROR /mnt/jenkins/workspace/pxc80-autobuild-RELEASE/test/rpmbuild/BUILD/Percona-XtraDB-Cluster-8.0.28/extra/protobuf/protobuf-3.11.4/src/google/protobuf/message_lite.cc:123] Can't parse message of type "Mysqlx.Connection.CapabilitiesSet" because it is missing required fields: (cannot determine missing fields for lite message)
Handshake failed: peer did not return a certificate
[libprotobuf ERROR /mnt/jenkins/workspace/pxc80-autobuild-RELEASE/test/rpmbuild/BUILD/Percona-XtraDB-Cluster-8.0.28/extra/protobuf/protobuf-3.11.4/src/google/protobuf/message_lite.cc:123] Can't parse message of type "Mysqlx.Prepare.Prepare" because it is missing required fields: (cannot determine missing fields for lite message)
Handshake failed: wrong version number
[libprotobuf ERROR /mnt/jenkins/workspace/pxc80-autobuild-RELEASE/test/rpmbuild/BUILD/Percona-XtraDB-Cluster-8.0.28/extra/protobuf/protobuf-3.11.4/src/google/protobuf/message_lite.cc:123] Can't parse message of type "Mysqlx.Crud.DropView" because it is missing required fields: (cannot determine missing fields for lite message)
Handshake failed: unknown protocol
Handshake failed: version too low
Handshake failed: no shared cipher
Terminate called after throwing an instance of 'boost::exception_detail::clone_impl<boost::exception_detail::error_info_injector<std::system_error> >'
what(): remote_endpoint: Transport endpoint is not connected
2022-10-09T09:26:40.868149Z 0 [Note] [MY-000000] [WSREP] Initiating SST cancellation
09:26:40 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Build ID: 5aaeb8aff2f9757ae471361dbf4fa4ba945f6104
Server Version: 8.0.28-19.1 Percona XtraDB Cluster (GPL), Release rel19, Revision f544540, WSREP version 26.4.3, wsrep_26.4.3
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out