mysql error log not being updated
search cancel

mysql error log not being updated

book

Article ID: 395769

calendar_today

Updated On: 04-29-2025

Products

CA API Gateway

Issue/Introduction

In production environment nothing is being logged in the error log for mysql

Difficult to troubleshooting mysql issues without warning message a error log 

my.cnf:

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

Environment

Gateway 11.1 

Cause

The error log location is defined in the mysql variables 

Resolution

The error log location is defined in the mysql variables 

Example:

mysql> SHOW VARIABLES LIKE '%error%';

+-------------------------------+----------------------------------------+

| Variable_name                 | Value                                  |

+-------------------------------+----------------------------------------+

| binlog_error_action           | ABORT_SERVER                           |

| error_count                   | 0                                      |

| log_error                     | /var/log/mysql/error.log               |

| log_error_services            | log_filter_internal; log_sink_internal |

| log_error_suppression_list    |                                        |

| log_error_verbosity           | 2                                      |

| max_connect_errors            | 2000000                                |

| max_error_count               | 1024                                   |

| performance_schema_error_size | 5309                                   |

| replica_skip_errors           | 126,1053,1105,1129,1158,1159,1160,1161 |

| slave_skip_errors             | 126,1053,1105,1129,1158,1159,1160,1161 |

+-------------------------------+----------------------------------------+

11 rows in set (0.01 sec)

 

Additional Information

The level is determined by log_error_verbosity

log_error_verbosity Value

Permitted Message Priorities

1

ERROR

2

ERROR, WARNING

3

ERROR, WARNING, INFORMATION