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!'

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.