# \[Note\] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
**URL:** https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229
**Category:** Percona XtraDB Cluster 5.x
**Created:** [May 19, 2015, 9:56am UTC](https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229 "2015-05-19T09:56:01Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Xibu](https://forums.percona.com/u/Xibu)
#### Post date: [May 19, 2015, 9:56am UTC](https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229/1 "2015-05-19T09:56:01Z")
Percona-Server-shared-51.x86\_64 5.1.73-rel14.12.624.rhel6 @percona-release-x86\_64
Percona-XtraDB-Cluster-56.x86\_64 1:5.6.22-25.8.978.el6 @percona-release-x86\_64
Percona-XtraDB-Cluster-client-56.x86\_64 1:5.6.22-25.8.978.el6 @percona-release-x86\_64
Percona-XtraDB-Cluster-galera-3.x86\_64 3.9-1.3494.rhel6 @percona-release-x86\_64
Percona-XtraDB-Cluster-server-56.x86\_64 1:5.6.22-25.8.978.el6 @percona-release-x86\_64
Percona-XtraDB-Cluster-shared-56.x86\_64 1:5.6.22-25.8.978.el6 @percona-release-x86\_64
percona-release.noarch 0.1-3 @percona
percona-toolkit.noarch 2.2.14-1 @percona-release-noarch
percona-xtrabackup.x86\_64 2.2.10-1.el6 @percona-release-x86\_64
percona-zabbix-templates.noarch 1.1.4-1 @percona-release-noarch
Following a crash of my cluster ( 2 nodes corrupted on the cluster of 3 nodes ) after a double hard disk failure
(No luck this time … the I am not able to restore a copy of the database at the right point in time)
So I turn to community to seek for advice with this issue
My mysql error log get filled with such message … and I wonder if there is a way to clean this.
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: SELECT dv.mandatory,dv.optional FROM dbversion dv
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: SELECT n.\* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: SELECT p.\* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: SELECT p.\* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: SELECT c.\* FROM config c
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: SELECT p.\* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: SELECT p.\* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: SELECT p.\* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: SELECT COUNT(DISTINCT t.triggerid) AS cnt,t.status,t.value FROM triggers t WHERE NOT EXISTS (SELECT f.functionid FROM functions f JOIN items i ON f.itemid=i.itemid JOIN hosts h ON i.hostid=h.hostid WHERE f.triggerid=t.triggerid AND (i.status\<\>0 OR h.status\<\>0)) AND t.flags IN (0,4) GROUP BY t.status,t.value
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
---
### Author:  [@umarzuki](https://forums.percona.com/u/umarzuki)
#### Post date: [May 20, 2015, 7:57pm UTC](https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229/2 "2015-05-20T19:57:29Z")
build a new node, bootstrap the one that still functioning.
“mysqldump --all-databases \> alldb.sql” first 😉
---
### Author:  [@wagnerbianchi](https://forums.percona.com/u/wagnerbianchi)
#### Post date: [May 21, 2015, 1:54pm UTC](https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229/3 "2015-05-21T13:54:24Z")
Have you checked if SHOW PROCESSLIST showed up threads in “pre-commit” state? Have you built the failed node? Next time, try to check if it’s a problems related to the Flow-Control, [url][https://www.percona.com/blog/2013/05/02/galera-flow-control-in-percona-xtradb-cluster-for-mysql/[/url]](https://www.percona.com/blog/2013/05/02/galera-flow-control-in-percona-xtradb-cluster-for-mysql/%5B/url%5D)
---
### Author:  [@Xibu](https://forums.percona.com/u/Xibu)
#### Post date: [May 22, 2015, 3:50am UTC](https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229/4 "2015-05-22T03:50:37Z")
> [@wagnerbianchi;38976](#):
>
> Have you checked if SHOW PROCESSLIST showed up threads in “pre-commit” state? Have you built the failed node? Next time, try to check if it’s a problems related to the Flow-Control, [https://www.percona.com/blog/2013/05/02/galera-flow-control-in-percona-xtradb-cluster-for-mysql/](https://www.percona.com/blog/2013/05/02/galera-flow-control-in-percona-xtradb-cluster-for-mysql/)
Thank you for your comment
unfortunately SHOW PROCESSLIST does not show any process in pre-commit state
mysql\> SHOW PROCESSLIST;
±-------±------------±----------±-----±--------±-------±-------------------±-----------------±----------±--------------+
| Id | User | Host | db | Command | Time | State | Info | Rows\_sent | Rows\_examined |
±-------±------------±----------±-----±--------±-------±-------------------±-----------------±----------±--------------+
| 1 | system user | | NULL | Sleep | 321889 | wsrep aborter idle | NULL | 0 | 0 |
| 2 | system user | | NULL | Sleep | 321889 | NULL | NULL | 0 | 0 |
| 3 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 4 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 5 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 6 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 7 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 8 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 9 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 10 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 11 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 12 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 13 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 14 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 15 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 16 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 17 | system user | | NULL | Sleep | 321884 | NULL | NULL | 0 | 0 |
| 326157 | root | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0 | 0 |
±-------±------------±----------±-----±--------±-------±-------------------±-----------------±----------±--------------+
The failed node is finally built, but when I start the service, the second node give me the same problem …
WSREP: cleanup transaction for LOCAL\_STATE: COMMIT
---
### Author:  [@Xibu](https://forums.percona.com/u/Xibu)
#### Post date: [May 22, 2015, 5:52am UTC](https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229/5 "2015-05-22T05:52:43Z")
Even restoring the dump on a fresh installation of mysql server … provide me with the same results
---
### Author:  [@Xibu](https://forums.percona.com/u/Xibu)
#### Post date: [May 27, 2015, 12:37am UTC](https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229/6 "2015-05-27T00:37:11Z")
Yesterday I enabled wsrep\_debug
" SET GLOBAL wsrep\_debug=1;"
Today one of my server crashed with this error messages
2015-05-27 04:05:20 311567 [Note] WSREP: MDL conflict
request: (10 seqno 25968 wsrep (1, 1, 0) cmd 0 144 (null))
granted: (64954 seqno -1 wsrep (0, 0, 0) cmd 0 34 (null))
2015-05-27 04:05:20 311567 [Note] WSREP: MDL ticket: type: shared space: UNKNOWN db: name:
2015-05-27 04:05:20 311567 [Note] WSREP: MDL conflict-\> BF abort
request: (10 seqno 25968 wsrep (1, 1, 0) cmd 0 144 (null))
granted: (64954 seqno -1 wsrep (0, 0, 0) cmd 0 34 (null))
2015-05-27 04:05:20 311567 [Note] WSREP: MDL ticket: type: shared space: UNKNOWN db: name:
2015-05-27 04:05:20 311567 [Note] WSREP: wsrep\_abort\_thd, by: 140646226708224, victim: 140646221924096
2015-05-27 04:05:20 311567 [Note] WSREP: abort transaction: BF: (null) victim: (null)
2015-05-27 04:05:20 311567 [Note] WSREP: victim does not have transaction
2015-05-27 04:05:20 311567 [Note] WSREP: MDL conflict
request: (10 seqno 25968 wsrep (1, 1, 0) cmd 0 144 (null))
granted: (64954 seqno -1 wsrep (0, 0, 1) cmd 0 34 (null))
2015-05-27 04:05:20 311567 [Note] WSREP: MDL ticket: type: shared space: UNKNOWN db: name:
2015-05-27 04:05:20 311567 [Note] WSREP: MDL conflict-\> BF abort
request: (10 seqno 25968 wsrep (1, 1, 0) cmd 0 144 (null))
granted: (64954 seqno -1 wsrep (0, 0, 1) cmd 0 34 (null))
2015-05-27 04:05:20 311567 [Note] WSREP: MDL ticket: type: shared space: UNKNOWN db: name:
2015-05-27 04:05:20 311567 [Note] WSREP: wsrep\_abort\_thd, by: 140646226708224, victim: 140646221924096
2015-05-27 04:05:20 311567 [Note] WSREP: abort transaction: BF: (null) victim: (null)
2015-05-27 04:05:20 311567 [Note] WSREP: victim does not have transaction
2015-05-27 04:05:20 311567 [Note] WSREP: MDL victim killed at add\_ticket
2015-05-27 04:05:23 311567 [Note] WSREP: client rollback due to BF abort for (64954), query: (null)
2015-05-27 04:05:23 311567 [Note] WSREP: Deadlock error for: (null)
02:05:23 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Please help us make Percona XtraDB Cluster better by reporting any
bugs at [url][https://bugs.launchpad.net/percona-xtradb-cluster[/url]](https://bugs.launchpad.net/percona-xtradb-cluster%5B/url%5D)
key\_buffer\_size=8388608
read\_buffer\_size=131072
max\_used\_connections=4
max\_threads=2050
thread\_count=18
connection\_count=1
It is possible that mysqld could use up to
key\_buffer\_size + (read\_buffer\_size + sort\_buffer\_size)\*max\_threads = 826591 K bytes of memory
Hope that’s ok; if not, decrease some variables in the equation.
Thread pointer: 0x2bd37a60
Attempting backtrace. You can use the following information to find out
---
### Author:  [@Xibu](https://forums.percona.com/u/Xibu)
#### Post date: [May 27, 2015, 12:54am UTC](https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229/7 "2015-05-27T00:54:12Z")
This is produced during the backup phase 1
150527 04:05:23 innobackupex: Finished backing up non-InnoDB tables and files
150527 04:05:23 innobackupex: Executing LOCK BINLOG FOR BACKUP…
DBD::mysql::db do failed: Deadlock found when trying to get lock; try restarting transaction at /usr/bin/innobackupex line 3044.
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3047
main::mysql\_query(‘HASH(0x2abd178)’, ‘LOCK BINLOG FOR BACKUP’) called at /usr/bin/innobackupex line 3529
main::mysql\_lock\_binlog(‘HASH(0x2abd178)’) called at /usr/bin/innobackupex line 2008
main::backup() called at /usr/bin/innobackupex line 1601
innobackupex: Error:
Error executing ‘LOCK BINLOG FOR BACKUP’: DBD::mysql::db do failed: Deadlock found when trying to get lock; try restarting transaction at /usr/bin/innobackupex line 3044.
150527 04:05:23 innobackupex: Waiting for ibbackup (pid=416149) to finish
05/27/2015 04:06:09
but that’s strange as the configuration file state
inno-backup-opts=‘–no-backup-locks’
…
---
### Author:  [@sergeym](https://forums.percona.com/u/sergeym)
#### Post date: [September 14, 2015, 3:36am UTC](https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229/8 "2015-09-14T03:36:20Z")
> [@wagnerbianchi;38976](#):
>
> Have you checked if SHOW PROCESSLIST showed up threads in “pre-commit” state? Have you built the failed node? Next time, try to check if it’s a problems related to the Flow-Control, [https://www.percona.com/blog/2013/05/02/galera-flow-control-in-percona-xtradb-cluster-for-mysql/](https://www.percona.com/blog/2013/05/02/galera-flow-control-in-percona-xtradb-cluster-for-mysql/)
Hi, I have the same issue with "
---
### Author:  [@jason.i](https://forums.percona.com/u/jason.i)
#### Post date: [April 1, 2016, 11:18pm UTC](https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229/9 "2016-04-01T23:18:48Z")
Me too . Our 3 node Mariadb also more “” in our log , how do ?
e.g
160402 12:47:32 [Note] WSREP: cleanup transaction for LOCAL\_STATE: select barcodeID, scanType, couponVer from coupon\_log\_2016 where deviceToke n = ‘XXXXXXXXXX’ and barcodeID = ‘214’ and scanType = ‘0’
---
### Author:  [@jason.i](https://forums.percona.com/u/jason.i)
#### Post date: [April 4, 2016, 9:12pm UTC](https://forums.percona.com/t/note-wsrep-cleanup-transaction-for-local-state-commit/4229/10 "2016-04-04T21:12:41Z")
Still have many warning abut the cleanup transaction show up , any body can help me know what problem ,
[Note] WSREP: cleanup transaction for LOCAL\_STATE: SELECT b.title FROM daily\_hl\_news AS a INNER JOIN news\_main\_2016 AS b ON a.XXXXX = b.XXXXXX INNER JOIN news\_XXXXXX AS c ON a.newsCat = c.newsCatID WHERE a.XXXXXXX = ‘1’ AND b.XXXXXX\<= ‘2016-04-05 10:40:43’ AND a.XXXXXXXX \<= ‘2016-04-05 10:40:43’ AND a.year = ‘2016’
Many thanks