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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In