mysql Pacemaker resource fails to start with "please check your installation" error

Solution Verified - Updated -

Issue

  • mysql resource failing to start on pcs cluster
  • After fencing, mysql resource fails to start.
  • ERROR: MySQL server failed to start (pid=16644) (rc=0), please check your installation
  • mysqld.log shows failure to open log file.

    180308 13:53:35 [ERROR] mysqld: File './mysql-bin.000145' not found (Errcode: 2)
    180308 13:53:35 [ERROR] Failed to open log (file './mysql-bin.000145', errno 2)
    180308 13:53:35 [ERROR] Could not open log file
    180308 13:53:35 [ERROR] Can't init tc log
    180308 13:53:35 [ERROR] Aborting
    

Environment

  • Red Hat Enterprise Linux Server 7 (with the High Availability Add-on)

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

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content