I have only recently become familiar with the Percona XtraDB cluster and am trying to set up a cluster for my app. I was already able to do this - the servers are synchronized and doing their job in multi-master mode (3 nodes).
After importing my backup, I found out by testing my application that I had defined two Triggers (BI & BU) for a single table. After I could finally delete them, I now get an error message before each insert in the earlier mentioned table (“MySQL Server has gone away”) and one of my nodes says goodbye.
I was able to get the following from the logfile:
2021-01-08T17:28:55.823567Z 0 [Note] [MY-000000] [WSREP] Initiating SST cancellation 17:28:55 UTC - mysqld got signal 11 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Build ID: 5db8d861b54b2ccfe4ce14befed66f20e02cc707 Server Version: 8.0.21-12.1 Percona XtraDB Cluster (GPL), Release rel12, Revision 4d973e2, WSREP version 26.4.3, wsrep_26.4.3 Thread pointer: 0x7fbd6c813e10 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7fbde862bd90 thread_stack 0x46000 /usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x564dabedee51] /usr/sbin/mysqld(handle_fatal_signal+0x393) [0x564daaf01143] /lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0) [0x7fbe004803c0] /usr/lib/galera4/libgalera_smm.so(+0x22fcce) [0x7fbdf404fcce] /usr/sbin/mysqld(wsrep::wsrep_provider_v26::replay(wsrep::ws_handle const&, wsrep::high_priority_service*)+0x3c) [0x564dac67b02c] /usr/sbin/mysqld(Wsrep_client_service::replay()+0xbb) [0x564daaf0f03b] /usr/sbin/mysqld(wsrep::transaction::after_statement()+0x13d) [0x564dac6797ed] /usr/sbin/mysqld(wsrep::client_state::after_statement()+0x136) [0x564dac665226] /usr/sbin/mysqld(+0x12006ca) [0x564daadac6ca] /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x38ce) [0x564daadb0c1e] /usr/sbin/mysqld(do_command(THD*)+0x27f) [0x564daadb130f] /usr/sbin/mysqld(+0x1345048) [0x564daaef1048] /usr/sbin/mysqld(+0x28a9ed2) [0x564dac455ed2] /lib/x86_64-linux-gnu/libpthread.so.0(+0x9609) [0x7fbe00474609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7fbdffc18293] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): Connection ID (thread ID): 0 Status: NOT_KILLED You may download the Percona XtraDB Cluster operations manual by visiting http://www.percona.com/software/percona-xtradb-cluster/. You may find information in the manual which will help you identify the cause of the crash.
Since I already have my system active, I would be very happy about any help!
Many thanks in advance!