After power reset for all servers, galera-master db services fail to start in a RHOSP 7 High Availability cluster due to '[ERROR] Found 1 prepared transactions!'
Issue
- After power reset for all servers, galera-master db services fail to start
- Galera fails with
[ERROR] Found 1 prepared transactions!
- Message found in logs:
You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
Environment
- Red Hat OpenStack Platform (RHOSP) 7 with High Availability
- Galera Cluster with one or more nodes (not all) showing the errors in Diagnostic section
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.