Not the answer you need?
Register and ask your own question!

Nodes will not write to error log?

gabeguillengabeguillen ContributorInactive User Role Beginner
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

Comments

  • gabeguillengabeguillen Contributor Inactive User Role Beginner
    Well, checked the server variables and the log error file is shown as:


    I have always been able to set this in my.cnf before.... What am I doing wrong here?

    Thanks.
  • gabeguillengabeguillen Contributor Inactive User Role Beginner
    Ugh, wow, I feel like a newb now... I got tunnel visioned and didn't notice that the log file was also configured in [mysqld_safe] and that was taking precedence.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.