Shulou(Shulou.com)05/31 Report--

Today, I would like to talk to you about MySQL 5.7error and warnings there is no specific information to show what to do, many people may not understand, in order to make you better understand, the editor summed up the following content, I hope you can get something according to this article.

[problem description]:

Version: MySQL 5.7.18

Installation method: direct initialization after decompression of binary value package

Symptom: only error code, no error details, message cannot be obtained through show errors or show warings.

Mysql > USE ccadacdasc

ERROR 1049 (42000): Unknown error 1049

Mysql > SHOW ERRORS

+-+

| | Level | Code | Message | |

+-+

| | Error | 1064 |

+-+

1 row in set (0.00 sec)

Mysql > CREATE DATABASE mysql

ERROR 1007 (HY000): Unknown error 1007

Mysql > STOP SLAVE

Query OK, 0 rows affected, 1 warning (0.00 sec)

Mysql > SHOW WARNINGS

+-+

| | Level | Code | Message | |

+-+

| | Note | 3084 |

+-+

1 row in set (0.00 sec)

Although it does not affect the use, you can also go to the documentation manual to inquire about the specific situation, but it is always inconvenient.

Check the error log and find that:

2017-06-16T06:40:03.292520Z 0 [ERROR] Can't find error-message file'/ data/mysql57/bin/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.

It is found that the errmsg.sys cannot be found, and the discovery is found in the bin directory.

[solution]:

Check the profile and find:

# grep basedir my57.cnf

Basedir = / data/mysql57/bin

The location specified by basedir is incorrect. Modify it:

Basedir = / data/mysql57

Reboot and found no error reported.

If you manually generate some error and warning, you can already generate information normally.

Mysql > STOP SLAVE

Query OK, 0 rows affected, 1 warning (0.00 sec)

Mysql > SHOW WARNINGS

+-- +

| | Level | Code | Message | |

+-- +

| Note | 3084 | Replication thread (s) for channel''are already stopped. | |

+-- +

1 row in set (0.00 sec)

Mysql > fdsfas

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fdsfas' at line 1

Mysql > use afdasfds

ERROR 1049 (42000): Unknown database 'afdasfds'

Reason: an incorrect basedir was specified when the instance was started, so the errmsg.sys could not be found, so the details of the specific error or warning could not be displayed.

Fix my.cnf and restart mysqld.

This file is stored in $basedir/share with the name:

Errmsg-utf8.txt

Errmsg-utf8.txt: UTF-8 Unicode Pascal program text, with very long lines

Used to store details of various types of error and warning.

This problem currently exists only in later versions of MySQL, such as MySQL 5.7.

In MySQL version 5.6, if the errmsg.sys cannot be found because the wrong basedir is specified, an error will be reported at startup:

2017-06-16 15:02:49 11234 [ERROR] Can't find messagefile'/ data/mysql-base/mysql56/bin/share/errmsg.sys'

In MySQL version 5.7, although errors are reported and recorded in the error log at startup, mysqld can still be picked up.

After reading the above, do you have any further understanding of what to do when there is no specific information about MySQL 5.7error and warnings? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.