Information Schema WSREP_BF_ABORTS

The Information Schema WSREP_BF_ABORTS table provides statistics on Galera Cluster brute force aborts, detailing the victim and transaction IDs.

This plugin is used in MariaDB Galera Cluster.

This plugin is available as of MariaDB Enterprise Server 11.8.

This table contains execution state information for Galera threads. The respective plugin is not installed by default — you have to install it.

The table displays the history of BF aborts. It has these columns:

TIME - Datetime when bf abort happened
VICTIM_TRX_ID - Victim trx ID or NULL
VICTIM_THREAD_ID - Victim thread
THD ID VICTIM_QUERY_ID - Victim query id
VICTIM_SEQNO - Victim TO seqno associated with victim transaction
VICTIM_CLIENT_STATE - Victim thread wsrep client state at the moment when BF abort attempt happened
VICTIM_CLIENT_MODE - Victim thread wsrep client mode
VICTIM_TRX_STATE - Victim thread wsrep transaction state at the moment when BF abort attempt happened
VICTIM_LOCK - Victim lock information
BF_TRX_ID - BF thread transaction ID
BF_THREAD_ID - BF thread THD ID
BF_QUERY_ID - BF query id
BF_SEQNO - TO sequence number associated with BF transaction
BF_CLIENT_STATE - BF thread wsrep client state
BF_CLIENT_MODE - BF thread wsrep client mode
BF_TRX_STATE - BF thread wsrep transaction state
BF_LOCK - Information about the lock which BF thread tried to acquire
SPACE_ID - Lock space_id in case of record or table lock
PAGE_NO - Lock page_no in case of record lock
INDEX_NAME - Record lock index name
TABLE_NAME - Lock table name

Example output:

SELECT * FROM INFORMATION_SCHEMA.WSREP_BF_ABORT_HISTORY LIMIT 100;   
+----------------------------+---------------+------------------+-----------------+--------------+---------------------+--------------------+------------------+----------------------------+-----------+--------------+-------------+----------+-----------------+----------------+--------------+----------------------------+----------+---------+------------+------------------+
| TIME                       | VICTIM_TRX_ID | VICTIM_THREAD_ID | VICTIM_QUERY_ID | VICTIM_SEQNO | VICTIM_CLIENT_STATE | VICTIM_CLIENT_MODE | VICTIM_TRX_STATE | VICTIM_LOCK                | BF_TRX_ID | BF_THREAD_ID | BF_QUERY_ID | BF_SEQNO | BF_CLIENT_STATE | BF_CLIENT_MODE | BF_TRX_STATE | BF_LOCK                    | SPACE_ID | PAGE_NO | INDEX_NAME | TABLE_NAME       |
+----------------------------+---------------+------------------+-----------------+--------------+---------------------+--------------------+------------------+----------------------------+-----------+--------------+-------------+----------+-----------------+----------------+--------------+----------------------------+----------+---------+------------+------------------+
| 2025-05-14 09:48:31.539207 |        378998 |               94 |         2365214 |         NULL | exec                | local              | executing        | REC|LOCK_X|NOT_GAP|WAITING |    379010 |            1 |     2365229 |   174271 | exec            | high priority  | executing    | REC|LOCK_X|NOT_GAP|WAITING |       12 |       4 | PRIMARY    | `test`.`sbtest1` |
| 2025-05-14 09:48:31.597005 |        379044 |               81 |         2365344 |         NULL | exec                | local              | certifying       | REC|LOCK_X|NOT_GAP         |    379060 |            1 |     2365419 |   174284 | exec            | high priority  | executing    | REC|LOCK_X|NOT_GAP|WAITING |       12 |       4 | PRIMARY    | `test`.`sbtest1` |
| 2025-05-14 09:48:31.609301 |        379055 |              104 |         2365412 |         NULL | exec                | local              | certifying       | REC|LOCK_X|NOT_GAP         |    379070 |            1 |     2365445 |   174289 | exec            | high priority  | executing    | REC|LOCK_X|NOT_GAP|WAITING |       12 |       4 | PRIMARY    | `test`.`sbtest1` |
| 2025-05-14 09:48:31.725899 |        379134 |              101 |         2366437 |         NULL | exec                | local              | executing        | REC|LOCK_X|NOT_GAP         |    379164 |            1 |     2366536 |   174307 | exec            | high priority  | executing    | REC|LOCK_X|NOT_GAP|WAITING |       12 |  147008 | PRIMARY    | `test`.`sbtest1` |
| 2025-05-14 09:48:31.789128 |        379094 |              131 |         2366355 |         NULL | exec                | local              | certifying       | REC|LOCK_X|NOT_GAP         |    379195 |            1 |     2366599 |   174323 | exec            | high priority  | executing    | REC|LOCK_X|NOT_GAP|WAITING |       12 |       4 | PRIMARY    | `test`.`sbtest1` |
| 2025-05-14 09:48:31.789140 |        379101 |              124 |         2366103 |         NULL | exec                | local              | executing        | REC|LOCK_X|NOT_GAP|WAITING |    379195 |            1 |     2366599 |   174323 | exec            | high priority  | executing    | REC|LOCK_X|NOT_GAP|WAITING |       12 |       4 | PRIMARY    | `test`.`sbtest1` |
| 2025-05-14 09:48:31.789145 |        379093 |               82 |         2366113 |         NULL | exec                | local              | executing        | REC|LOCK_X|NOT_GAP|WAITING |    379195 |            1 |     2366599 |   174323 | exec            | high priority  | executing    | REC|LOCK_X|NOT_GAP|WAITING |       12 |       4 | PRIMARY    | `test`.`sbtest1` |
| 2025-05-14 09:48:31.789148 |        379110 |              117 |         2366193 |         NULL | exec                | local              | executing        | REC|LOCK_X|NOT_GAP|WAITING |    379195 |            1 |     2366599 |   174323 | exec            | high priority  | executing    | REC|LOCK_X|NOT_GAP|WAITING |       12 |       4 | PRIMARY    | `test`.`sbtest1` |
| 2025-05-14 09:48:31.789152 |        379126 |              111 |         2366201 |         NULL | exec                | local              | executing        | REC|LOCK_X|NOT_GAP|WAITING |    379195 |            1 |     2366599 |   174323 | exec            | high priority  | executing    | REC|LOCK_X|NOT_GAP|WAITING |       12 |       4 | PRIMARY    | `test`.`sbtest1` |
| 2025-05-14 09:48:31.789156 |        379100 |              134 |         2366318 |         NULL | exec                | local              | executing        | REC|LOCK_X|NOT_GAP|WAITING |    379195 |            1 |     2366599 |   174323 | exec            | high priority  | executing    | REC|LOCK_X|NOT_GAP|WAITING |       12 |       4 | PRIMARY    | `test`.`sbtest1` |
| 2025-05-14 09:48:31.789159 |        379109 |               93 |         2366334 |         NULL | exec                | local              | executing        | REC|LOCK_X|NOT_GAP|WAITING |    379195 |            1 |     2366599 |   174323 | exec            | high priority  | executing    | REC|LOCK_X|NOT_GAP|WAITING |       12 |       4 | PRIMARY    | `test`.`sbtest1` |
| 2025-05-14 09:48:31.789163 |        379119 |               90 |         2366384 |         NULL | exec                | local              | executing       +----------------------------+---------------+------------------+-----------------+--------------+---------------------+--------------------+------------------+----------------------------+-----------+--------------+-------------+----------+-----------------+----------------+--------------+----------------------------+----------+---------+------------+------------------+
...

PreviousInformation Schema USERS Table NextInformation Schema WSREP_CERT_KEYS

Last updated 1 month ago

Was this helpful?

SELECT * FROM INFORMATION_SCHEMA.WSREP_BF_ABORT_HISTORY LIMIT 100; +----------------------------+---------------+------------------+-----------------+--------------+---------------------+--------------------+------------------+----------------------------+-----------+--------------+-------------+----------+-----------------+----------------+--------------+----------------------------+----------+---------+------------+------------------+ | TIME | VICTIM_TRX_ID | VICTIM_THREAD_ID | VICTIM_QUERY_ID | VICTIM_SEQNO | VICTIM_CLIENT_STATE | VICTIM_CLIENT_MODE | VICTIM_TRX_STATE | VICTIM_LOCK | BF_TRX_ID | BF_THREAD_ID | BF_QUERY_ID | BF_SEQNO | BF_CLIENT_STATE | BF_CLIENT_MODE | BF_TRX_STATE | BF_LOCK | SPACE_ID | PAGE_NO | INDEX_NAME | TABLE_NAME | +----------------------------+---------------+------------------+-----------------+--------------+---------------------+--------------------+------------------+----------------------------+-----------+--------------+-------------+----------+-----------------+----------------+--------------+----------------------------+----------+---------+------------+------------------+ | 2025-05-14 09:48:31.539207 | 378998 | 94 | 2365214 | NULL | exec | local | executing | REC|LOCK_X|NOT_GAP|WAITING | 379010 | 1 | 2365229 | 174271 | exec | high priority | executing | REC|LOCK_X|NOT_GAP|WAITING | 12 | 4 | PRIMARY | `test`.`sbtest1` | | 2025-05-14 09:48:31.597005 | 379044 | 81 | 2365344 | NULL | exec | local | certifying | REC|LOCK_X|NOT_GAP | 379060 | 1 | 2365419 | 174284 | exec | high priority | executing | REC|LOCK_X|NOT_GAP|WAITING | 12 | 4 | PRIMARY | `test`.`sbtest1` | | 2025-05-14 09:48:31.609301 | 379055 | 104 | 2365412 | NULL | exec | local | certifying | REC|LOCK_X|NOT_GAP | 379070 | 1 | 2365445 | 174289 | exec | high priority | executing | REC|LOCK_X|NOT_GAP|WAITING | 12 | 4 | PRIMARY | `test`.`sbtest1` | | 2025-05-14 09:48:31.725899 | 379134 | 101 | 2366437 | NULL | exec | local | executing | REC|LOCK_X|NOT_GAP | 379164 | 1 | 2366536 | 174307 | exec | high priority | executing | REC|LOCK_X|NOT_GAP|WAITING | 12 | 147008 | PRIMARY | `test`.`sbtest1` | | 2025-05-14 09:48:31.789128 | 379094 | 131 | 2366355 | NULL | exec | local | certifying | REC|LOCK_X|NOT_GAP | 379195 | 1 | 2366599 | 174323 | exec | high priority | executing | REC|LOCK_X|NOT_GAP|WAITING | 12 | 4 | PRIMARY | `test`.`sbtest1` | | 2025-05-14 09:48:31.789140 | 379101 | 124 | 2366103 | NULL | exec | local | executing | REC|LOCK_X|NOT_GAP|WAITING | 379195 | 1 | 2366599 | 174323 | exec | high priority | executing | REC|LOCK_X|NOT_GAP|WAITING | 12 | 4 | PRIMARY | `test`.`sbtest1` | | 2025-05-14 09:48:31.789145 | 379093 | 82 | 2366113 | NULL | exec | local | executing | REC|LOCK_X|NOT_GAP|WAITING | 379195 | 1 | 2366599 | 174323 | exec | high priority | executing | REC|LOCK_X|NOT_GAP|WAITING | 12 | 4 | PRIMARY | `test`.`sbtest1` | | 2025-05-14 09:48:31.789148 | 379110 | 117 | 2366193 | NULL | exec | local | executing | REC|LOCK_X|NOT_GAP|WAITING | 379195 | 1 | 2366599 | 174323 | exec | high priority | executing | REC|LOCK_X|NOT_GAP|WAITING | 12 | 4 | PRIMARY | `test`.`sbtest1` | | 2025-05-14 09:48:31.789152 | 379126 | 111 | 2366201 | NULL | exec | local | executing | REC|LOCK_X|NOT_GAP|WAITING | 379195 | 1 | 2366599 | 174323 | exec | high priority | executing | REC|LOCK_X|NOT_GAP|WAITING | 12 | 4 | PRIMARY | `test`.`sbtest1` | | 2025-05-14 09:48:31.789156 | 379100 | 134 | 2366318 | NULL | exec | local | executing | REC|LOCK_X|NOT_GAP|WAITING | 379195 | 1 | 2366599 | 174323 | exec | high priority | executing | REC|LOCK_X|NOT_GAP|WAITING | 12 | 4 | PRIMARY | `test`.`sbtest1` | | 2025-05-14 09:48:31.789159 | 379109 | 93 | 2366334 | NULL | exec | local | executing | REC|LOCK_X|NOT_GAP|WAITING | 379195 | 1 | 2366599 | 174323 | exec | high priority | executing | REC|LOCK_X|NOT_GAP|WAITING | 12 | 4 | PRIMARY | `test`.`sbtest1` | | 2025-05-14 09:48:31.789163 | 379119 | 90 | 2366384 | NULL | exec | local | executing +----------------------------+---------------+------------------+-----------------+--------------+---------------------+--------------------+------------------+----------------------------+-----------+--------------+-------------+----------+-----------------+----------------+--------------+----------------------------+----------+---------+------------+------------------+ ...

Good evening