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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
