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

This article shows you the mysql synchronization error Last_Errno: 1677 how to do, the content is concise and easy to understand, absolutely can make your eyes bright, through the detailed introduction of this article, I hope you can get something.

Background report error from the database

Because a field is added to the test.users on one of the servers A, the table structure after adding the field is as follows:

Because a large amount of data in table test.users is not fully synchronized to A when adding fields, and the previous data needs to be synchronized after adding fields. Parse the insert sql format in the binlog of mysql as follows:

INSERTINTOtest.users VALUES (1,2,1,99,6)

As you can see from the sql above, the value of the fifth field is 6. Originally, this 6 corresponds to the value of fav_times. The number of fields in the table is different from the type of the fifth field, so synchronization will go wrong.

Solution method

Delete the newly added field last_chapter_title from A first, and add the new field again after the table data has been fully synchronized.

The reason for the online error: there is a click field in the slave library than in the master library. The data originally inserted into another datetime type needs to be inserted into this click int type, so an error was reported. It should be that the field was added to the slave library at that time.

The above content is mysql synchronization error Last_Errno: 1677 what to do, have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.