hello:
I am running the pxc in bootstrap mode on my local virtual machine，the pxc occasionally corrupted，log below:
2023-06-23T15:15:07.333407Z 965 [Note] [MY-000000] [WSREP] MDL conflict db=wpdb table=d_wolmart_search_log ticket=1 solved by abort
2023-06-23T15:51:41.119077Z 0 [ERROR] [MY-000000] [Galera] Corrupt buffer header: addr: 0x7f29dc0f2f30, seqno: 6715530545543537524, size: 1970433894, ctx: 0x223a31343a733b22, flags: 29549. store: 47, type: 116
2023-06-23T15:51:41.305572Z 0 [Note] [MY-000000] [WSREP] Initiating SST cancellation
2023-06-23T15:51:41Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=efb141f0fe6c96872a88cf66e7208cbe9408521b
Server Version: 8.0.32-24.1 Percona XtraDB Cluster (GPL), Release rel24, Revision 793b5d9, WSREP version 26.1.4.3, wsrep_26.1.4.3
Thread pointer: 0x0
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 = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x55dea7d5d49e]
/usr/sbin/mysqld(print_fatal_signal(int)+0x38b) [0x55dea6e1d10b]
/usr/sbin/mysqld(handle_fatal_signal+0xc8) [0x55dea6e1d1d8]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x13140) [0x7f29ef96a140]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x141) [0x7f29ef047ce1]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x123) [0x7f29ef031537]
/usr/lib/galera4/libgalera_smm.so(+0x21927) [0x7f29e2677927]
/usr/lib/galera4/libgalera_smm.so(+0xca3e9) [0x7f29e27203e9]
/usr/lib/galera4/libgalera_smm.so(+0xca619) [0x7f29e2720619]
/usr/lib/galera4/libgalera_smm.so(+0xd7e9f) [0x7f29e272de9f]
/usr/lib/galera4/libgalera_smm.so(+0x196a66) [0x7f29e27eca66]
/usr/lib/galera4/libgalera_smm.so(+0x1a9853) [0x7f29e27ff853]
/usr/lib/galera4/libgalera_smm.so(+0x1b44c7) [0x7f29e280a4c7]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7ea7) [0x7f29ef95eea7]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f29ef10aa2f]
You may download the Percona XtraDB Cluster operations manual by visiting
Percona XtraDB Cluster: Top MySQL Clustering Alternative. You may find information
in the manual which will help you identify the cause of the crash.
have a check pls！
best regards！
Hi @xiaolllll
Thank you for joining our community.
Regarding your problem, I’m missing something. You say you are running PXC in bootstrap mode in your local virtual machine, but it looks like it is trying to perform an SST. A bootstrap node should not perform an SST at all.
Could you provide a more detailed description of your architecture?
Thanks!
Pep
hi 
I dont know why there is some log about the sst, my architect is only one node on bootstrap mode booted on command ‘systemctl start mysql@bootstrap.service’.
Hey @xiaolllll
I tried the same setup and everything worked well for me.
Could you please provide us with exact set of commands that you have been executed?
hello:
cause this happens accidentally when my host machine wakeup from hibernate,and corrupt suddenly, so I cant supply the exact command, if there is anything else I can supply I’ll be happy to,I know it’s very hard to debug, anyway thanks for your reply!
BR!
Hi:
this is a new log ,hope it can help:
2023-07-07T05:10:38.443341Z 0 [Warning] [MY-000000] [Galera] last inactive check more than PT1.5S (3*evs.inactive_check_period) ago (PT1.55772S), skipping check
2023-07-07T07:07:19.699310Z 0 [ERROR] [MY-000000] [Galera] Corrupt buffer header: addr: 0x7fc8f4a346b8, seqno: 1560281088, size: 1600391424, ctx: 0x6264707704000100, flags: 28783. store: 116, type: 105
2023-07-07T07:07:19.887984Z 0 [Note] [MY-000000] [WSREP] Initiating SST cancellation
2023-07-07T07:07:19Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=aee888b31b25932f1b9fe075ad0a8f2562b64e05
Server Version: 8.0.32-24.2 Percona XtraDB Cluster (GPL), Release rel24, Revision 2119e75, WSREP version 26.1.4.3, wsrep_26.1.4.3
Thread pointer: 0x0
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 = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x5566d200d4de]
/usr/sbin/mysqld(print_fatal_signal(int)+0x38b) [0x5566d10cd12b]
/usr/sbin/mysqld(handle_fatal_signal+0xc8) [0x5566d10cd1f8]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x13140) [0x7fc909cdb140]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x141) [0x7fc9093b8ce1]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x123) [0x7fc9093a2537]
/usr/lib/galera4/libgalera_smm.so(+0x21927) [0x7fc8fc9e8927]
/usr/lib/galera4/libgalera_smm.so(+0xca3e9) [0x7fc8fca913e9]
/usr/lib/galera4/libgalera_smm.so(+0xca619) [0x7fc8fca91619]
/usr/lib/galera4/libgalera_smm.so(+0xd7e9f) [0x7fc8fca9ee9f]
/usr/lib/galera4/libgalera_smm.so(+0x196a66) [0x7fc8fcb5da66]
/usr/lib/galera4/libgalera_smm.so(+0x1a9853) [0x7fc8fcb70853]
/usr/lib/galera4/libgalera_smm.so(+0x1b44c7) [0x7fc8fcb7b4c7]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7ea7) [0x7fc909ccfea7]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7fc90947ba2f]
You may download the Percona XtraDB Cluster operations manual by visiting
Percona XtraDB Cluster: Top MySQL Clustering Alternative. You may find information
in the manual which will help you identify the cause of the crash.
I have tried to reproduce this issue but wasn’t able to do this.
What is the configuration of your VM?
Problem 1 I can not think of ANY good reason to run ANY database on a machine that goes into hibernate mode… 50$ says get rid of this and your issue goes away