Client requested master to start replication from
发现数据库同步失败，但没有sql错误，查看错误日志，得到类似错误 ERROR Error reading packet from server: Client requested master to start replication from impossible position ( server_errno=1236) 主服务器发生过一次断电，这个是会导致这个问题。
发现数据库同步失败，但没有sql错误，查看错误日志，得到类似错误[ERROR] Error reading packet from server: Client requested master to start replication from impossible position ( server_errno=1236)
主服务器发生过一次断电，这个是会导致这个问题。
这个错误必须人工干涉，因为发生这样的错误，不确定是否会产生数据问题，或者发生了别的不可预知的问题。
简单恢复这个问题是重新指定开始的位置，因为上一个日志文件应该是同步完了，没有正常关闭日志，所以不确定是否应该开始从下一个日志开始，我们可以告诉slave从下一个日志开始，记得前后应该停止和开始同步：
CHANGE MASTER TO MASTER_LOG_FILE='下一个日志', MASTER_LOG_POS=4;
参考阅读：
http://www.skysql.com/blogs/adam-donnison/client-requested-master-start-replication-impossible-position
原文地址：Client requested master to start replication from , 感谢原作者分享。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
What is the difference between master and host
Sep 28, 2023 pm 01:34 PM
The differences between master and host are: 1. Host can play the role of client or server, while master is the central server responsible for coordinating and managing other slave servers in a distributed system; 2. Host is an ordinary computer device, and master usually has Higher processing power and resources are used to process and distribute tasks, manage data, and maintain the stability of the entire system; 3. The host is a node in the network, and the master is the server that plays a core role in the distributed system.
What should I do if docker start cannot start?
Oct 21, 2022 pm 03:43 PM
Solution to docker start failure: 1. Check the running status, and then release the occupied memory through the "echo 3 > /proc/sys/vm/drop_caches" command; 2. Use "$netstat -nltp|grep .. ." command to check whether the port has been occupied. If it is found to be occupied after going online, change it to an available port and restart.
Firewalld Linux firewall
Feb 19, 2024 pm 06:24 PM
The firewall firewall firewalld service has two working modes: CLI and GUI. Compared with iptables, firewall supports dynamic updates and introduces the concept of zone. In short, a zone refers to a set of firewall policies predefined by the firewall, which allows these policies to be quickly switched between firewalls, thereby significantly improving the switching efficiency and application speed of the firewall. The zone default policy rule trusted allows all packets home to deny incoming traffic, but the ssh, mdns, ipp-client, and dhcpv6-client services are allowed to pass through the internal equivalent of the home zone work and deny incoming traffic, but
What to do if node start reports an error
Dec 29, 2022 pm 01:55 PM
Solution to node start error: 1. Execute "node xx.js" directly in the terminal; 2. Add start startup item "scripts": {"test": "echo \"Error: no test specified\" && exit 1 ","start":"node service.js"}"; 3. Re-execute "npm start".
What is master in linux
Jul 18, 2023 pm 01:23 PM
The master in Linux refers to the master node or master server in the Linux system. In a distributed system, the master refers to the main node that controls the entire system. In a Linux cluster, the master node is responsible for coordinating and managing the work of the entire cluster. It is the central controller of all nodes and is responsible for allocating tasks, monitoring cluster status, handling failures, and maintaining the normal operation of the cluster.
How to use the start method and run method in Java thread
Apr 20, 2023 am 08:58 AM
start method and run method The $start()$ method is used to start a thread. At this time, the thread is in the ready (runnable) state and is not running. Once the $cpu$ time slice is obtained, the $run()$ method starts to be executed. . Directly calling the $run()$ method only calls a method in a class, which is essentially executed in the current thread. Therefore, it can only be achieved by using the $start()$ method to call the $run()$ method. True multithreading. Sample code@Slf4j(topic="c.Test4")publicclassTest4{publicstaticvoidmain(Strin
How to build CAS Client based on springboot
May 14, 2023 am 10:46 AM
1. Create a new springboot project and introduce the dependency org.jasig.cas.clientcas-client-support-springboot3.6.22. Configure the @EnableCasClient annotation packagecom.codetiler.demo;importorg.jasig.cas.client.boot.configuration.EnableCasClient;importorg. springframework.boot.SpringApplication;importorg.spring
How to start a session using the session_start function in PHP
Jun 26, 2023 pm 01:33 PM
The session_start() function is one of the functions that opens a session in PHP. Session is a very common technology in web development, and the basis of session is to assign a unique session ID to the user when he visits the website, and to use this session ID to identify the user in subsequent visits. Sessions can be used to save the user's login status, shopping cart contents, and other user information, and can also be used to implement permission control for some functions on the website. The way to open a session in PHP is very simple, just use sess
