MariaDB Fails to log in error log

Posted on

Question :

I am using MariaDB Version 5.5.56
The database was restarted 2 days ago but I am not seeing any log entries in the error log except an error importing from a dmp file. The data seems complete and all processes and transactions are occuring correclt just no error logging. Is there a way to turn this on? I have tried “flush error logs” command but still no log entries.

Answer :

You can execute this to see where the error log file is supposed to be written:

show global variables like 'log_error';

This can (sometimes) show a relative path, relative to the datadir.

From the documentation:

The error log is active by default. The log-error=filename option determines where the output will be written. If no file name is specified, the log will be written to host-name.err. If no absolute path is specified, the file will be written to the data directory (determined by the value of the datadir system variable).

On Unix systems, if the –log-error option is not used, the errors are written to stderr (usually, the command line).

On Windows, if the –console option is specified, and –log-error is not used, the errors are written to the console. If –log-error is present, –console is ignored.

Additionally, for warning messages, the log_warnings variable need to be > 0. There are different warning levels, and the higher the value of log_warnings, the more kinds of warning messages are logged. For details, see the documentation for the log_warnings variable.

To see you current setting, run:

show global variables like 'log_warnings';  

Leave a Reply

Your email address will not be published. Required fields are marked *