search
HomeDatabaseMysql TutorialClient 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
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
master和host的区别是什么master和host的区别是什么Sep 28, 2023 pm 01:34 PM

master和host的区别有:1、host可以扮演客户端或服务器的角色,而master是分布式系统中负责协调和管理其他从服务器的中央服务器;2、host是普通的计算机设备,而master通常具有更高的处理能力和资源,用于处理和分发任务、管理数据和维护整个系统的稳定性;3、host是网络中的一个节点,而master是在分布式系统中担任核心角色的服务器。

docker start起不来怎么办docker start起不来怎么办Oct 21, 2022 pm 03:43 PM

docker start起不来的解决办法:1、检查运行状态,然后通过“echo 3 > /proc/sys/vm/drop_caches”命令释放被占用的内存;2、通过“$netstat -nltp|grep ...”命令检查端口是否已经被占用,如果上线后发现占有,则改为可用端口再重启即可。

Linux防火墙之FirewalldLinux防火墙之FirewalldFeb 19, 2024 pm 06:24 PM

firewall防火墙firewalld服务有CLI和GUI两种工作模式。相较于iptables,firewall支持动态更新,并引入了区域(zone)的概念。简而言之,区域是指防火墙预先定义的一组防火墙策略,使得防火墙之间可以快速切换这些策略,从而显著提高了防火墙的切换效率和应用速度。区域默认策略规则trusted允许所有数据包home拒绝流入流量,但是与ssh,mdns,ipp-client,dhcpv6-client服务则允许通过internal等同于home区域work拒绝流入流量,但是

node start 报错怎么办node start 报错怎么办Dec 29, 2022 pm 01:55 PM

node start报错的解决办法:1、直接在终端执行“node xx.js”;2、添加start启动项“ "scripts": {"test": "echo \"Error: no test specified\" && exit 1","start":"node service.js"}”;3、重新执行“npm start”即可。

linux中的master是什么linux中的master是什么Jul 18, 2023 pm 01:23 PM

linux中的master是指Linux系统中的主节点或主服务器,在分布式系统中,master是指控制整个系统的主要节点。在Linux集群中,master节点负责协调和管理整个集群的工作,它是所有节点的中心控制器,负责分配任务、监控集群状态、处理故障和维护集群的正常运行。

Java线程中的start方法和run方法怎么使用Java线程中的start方法和run方法怎么使用Apr 20, 2023 am 08:58 AM

start方法和run方法$start()$方法用来启动一个线程,这时此线程处于就绪(可运行)状态,并没有运行,一旦得到$cpu$时间片,就开始执行$run()$方法。而直接调用$run()$方法,仅仅只是调用了一个类里的方法,其本质上还是在当前线程中执行的,因此只有使用$start()$方法来调用$run()$方法才能实现真正的多线程。示例代码@Slf4j(topic="c.Test4")publicclassTest4{publicstaticvoidmain(Strin

基于springboot怎么搭建CAS Client客户端基于springboot怎么搭建CAS Client客户端May 14, 2023 am 10:46 AM

1.新建springboot项目并引入依赖org.jasig.cas.clientcas-client-support-springboot3.6.22.配置@EnableCasClient注解packagecom.codetiler.demo;importorg.jasig.cas.client.boot.configuration.EnableCasClient;importorg.springframework.boot.SpringApplication;importorg.spring

Linux中master是什么意思?有哪些重要的功能?Linux中master是什么意思?有哪些重要的功能?Mar 02, 2024 am 08:00 AM

  在Linux系统中,master指主节点或主服务器,其有着十分重要的作用,且提供了十分重要的功能。那么Linux系统中master是什么意思?有哪些重要的功能?我们来介绍一下。  Linux的Master是指Linux系统中的主节点或主服务器。在分布式系统中,Master节点是指负责协调和监督整个系统运作的核心节点。在Linux集群中,Master节点扮演着集群的中央控制器的角色,其主要职责包括任务分配、监控集群状态、处理故障,并确保集群的正常运行。Master节点的重要性在于它能够确保整个

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

Repo: How To Revive Teammates
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
1 months agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),