# Pxc 8.0.32-24.1 corrupted

**URL:** <https://forums.percona.com/t/pxc-8-0-32-24-1-corrupted/23079>\
**Category:** Percona XtraDB Cluster\
**Created:** [June 23, 2023, 4:25pm UTC](https://forums.percona.com/t/pxc-8-0-32-24-1-corrupted/23079 "2023-06-23T16:25:14Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![xiaolllll](https://avatars.discourse-cdn.com/v4/letter/x/e274bd/32.png) [@xiaolllll](https://forums.percona.com/u/xiaolllll)\
**Post date:** [June 23, 2023, 4:25pm UTC](https://forums.percona.com/t/pxc-8-0-32-24-1-corrupted/23079/1 "2023-06-23T16:25:14Z")

</div>

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](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.

have a check pls！  
best regards！

---

<div class="post-metadata">

**Author:** ![Pep\_Pla](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pep_pla/32/9735_2.png) [@Pep\_Pla](https://forums.percona.com/u/Pep_Pla)\
**Post date:** [June 28, 2023, 8:43pm UTC](https://forums.percona.com/t/pxc-8-0-32-24-1-corrupted/23079/2 "2023-06-28T20:43:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![xiaolllll](https://avatars.discourse-cdn.com/v4/letter/x/e274bd/32.png) [@xiaolllll](https://forums.percona.com/u/xiaolllll)\
**Post date:** [July 2, 2023, 3:18pm UTC](https://forums.percona.com/t/pxc-8-0-32-24-1-corrupted/23079/3 "2023-07-02T15:18:59Z")

</div>

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’.

---

<div class="post-metadata">

**Author:** ![Evgeniy\_Patlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/evgeniy_patlan/32/41_2.png) [@Evgeniy\_Patlan](https://forums.percona.com/u/Evgeniy_Patlan)\
**Post date:** [July 3, 2023, 10:38am UTC](https://forums.percona.com/t/pxc-8-0-32-24-1-corrupted/23079/4 "2023-07-03T10:38:18Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![xiaolllll](https://avatars.discourse-cdn.com/v4/letter/x/e274bd/32.png) [@xiaolllll](https://forums.percona.com/u/xiaolllll)\
**Post date:** [July 7, 2023, 12:53am UTC](https://forums.percona.com/t/pxc-8-0-32-24-1-corrupted/23079/5 "2023-07-07T00:53:31Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![xiaolllll](https://avatars.discourse-cdn.com/v4/letter/x/e274bd/32.png) [@xiaolllll](https://forums.percona.com/u/xiaolllll)\
**Post date:** [July 7, 2023, 7:16am UTC](https://forums.percona.com/t/pxc-8-0-32-24-1-corrupted/23079/6 "2023-07-07T07:16:00Z")

</div>

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](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.

---

<div class="post-metadata">

**Author:** ![Evgeniy\_Patlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/evgeniy_patlan/32/41_2.png) [@Evgeniy\_Patlan](https://forums.percona.com/u/Evgeniy_Patlan)\
**Post date:** [December 22, 2023, 9:34am UTC](https://forums.percona.com/t/pxc-8-0-32-24-1-corrupted/23079/7 "2023-12-22T09:34:02Z")

</div>

I have tried to reproduce this issue but wasn’t able to do this.  
What is the configuration of your VM?

---

<div class="post-metadata">

**Author:** ![meyerder](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/meyerder/32/16994_2.png) [@meyerder](https://forums.percona.com/u/meyerder)\
**Post date:** [December 29, 2023, 2:36pm UTC](https://forums.percona.com/t/pxc-8-0-32-24-1-corrupted/23079/8 "2023-12-29T14:36:52Z")

</div>

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