I’m having an issue with a new 3 node PXC 5.6 cluster we set up for migration testing. I’ve got everything up and running, but for some reason I can’t get any of the nodes to write to the error log. Everything else (SSL, wsrep config, binlog, cache config, slow query log) works, but not the error log. It was never created by mysql, so I even created it myself and set the right permissions, but no go. I tried just setting log-error with no filename so that it would create one with the hostname, and that did not work either. FLUSH LOGS has no effect. I searched the entire filesystem for files name *.err or mysql-error.log just to see if they were being created elsewhere, but did not find any matches.
Anyone have any ideas? I’m at a loss here.
Log directive (verbatim from [mysqld] in my.cnf):
log-error = /var/lib/mysql/mysql-error.log
Binaries:
Percona-XtraDB-Cluster-galera-3-3.9-1.3494.rhel6.x86_64
percona-xtrabackup-2.2.10-1.el6.x86_64
Percona-XtraDB-Cluster-56-5.6.22-25.8.978.el6.x86_64
Percona-XtraDB-Cluster-client-56-5.6.22-25.8.978.el6.x86_64
Percona-XtraDB-Cluster-shared-56-5.6.22-25.8.978.el6.x86_64
Percona-XtraDB-Cluster-server-56-5.6.22-25.8.978.el6.x86_64