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

This article mainly introduces "how to solve the problem of Last_SQL_Error: 1594 error report in Mysql". In the daily operation, I believe many people have doubts about how to solve the problem of Last_SQL_Error: 1594 error report in Mysql. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt of "how to solve the problem of Last_SQL_Error: 1594 error report in Mysql". Next, please follow the editor to study!

Gtid mode is not turned on

You can skip errors in the following ways:

In addition to errors that may lead to duplicate primary keys, abnormal power outages and shutdowns may also lead to damage to the relay log

To solve this problem, first of all, find the location of the master binlog execution.

Position

Then reconnect to the Master server (you need to stop slave first)

Finally, check the replication situation, and it is normal.

If gitd mode is enabled

You can use change master to fix it.

> stop slave

Query OK, 0 rows affected (0.02 sec)

If the previous repair can be manually corresponding to the subscript and log to specify the fix, but in the gtid scenario, this is not necessary.

> change master to Master_Log_File='mysql-bin.000226', Master_Log_Pos=884805205

ERROR 1776 (HY000): Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when MASTER_AUTO_POSITION is active.

> change master to master_host='10.127.0.xxx',master_port = 3306 mastery usernames replicated centremasters passwordboxes xxxxxclass1 masterpieces autopositions position1

Query OK, 0 rows affected, 2 warnings (0.51 sec)

Then check again and found that the log gap began to narrow, and after waiting for about ten minutes, the log gap was leveled.

At this point, the study on "how to solve the problem of Last_SQL_Error: 1594 error reporting in Mysql" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.