惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

小众软件
小众软件
C
Check Point Blog
Vercel News
Vercel News
Y
Y Combinator Blog
G
Google Developers Blog
P
Proofpoint News Feed
WordPress大学
WordPress大学
MongoDB | Blog
MongoDB | Blog
博客园 - 司徒正美
Last Week in AI
Last Week in AI
博客园 - 【当耐特】
N
Netflix TechBlog - Medium
L
LangChain Blog
V
V2EX
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
大猫的无限游戏
大猫的无限游戏
D
DataBreaches.Net
博客园_首页
B
Blog RSS Feed
The Cloudflare Blog
MyScale Blog
MyScale Blog
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
Microsoft Security Blog
Microsoft Security Blog

博客园 - digdeep

javax.imageio.IIOException: Invalid icc profile: duplicate sequence numbers Tomcat配置支持软连接 记一例DNS解析导致的系统卡顿问题 nginx配置透传自定义文件头 访问RustFS中的图片时,浏览器报错 (failed)net::ERR_BLOCKED_BY_ORB mysql主从复制报错:Last_Errno: 1872 Last_Error: Slave failed to initialize relay log info structure from the repository 华为云平台的操作系统因为OOM而重启的解决方法 passwd 修改密码报错“passwd: 鉴定令牌操作错误” mysql主从复制报错:Last_SQL_Errno: 1114 Last_SQL_Error: Coordinator stopped because there were error(s) in the worker(s) 解决Linux下生成PDF中文乱码的问题 mysql主从复制从库报错:Last_Errno: 1594 centos编译安装opencv mysql搭建主从复制时一直报错 Last_IO_Errno: 2026 kswapd0进程占用cpu非常高 ./configure: error: SSL modules require the OpenSSL library. maven mvn install 报错: unable to find valid certification path to requested target 错误 升级Nginx,--with-openssl踩坑记录 Name or service not known Kernel panic - not syncing: Out of memory: system-wide panic_on_oom is enabled ERROR 2059 (HY000): Plugin caching_sha2_password could not be loaded
gh-ost 报错 ERROR 1236 (HY000): A slave with the same ser...
digdeep · 2023-12-12 · via 博客园 - digdeep

使用 gh-ost 对表在线加索引时,第一次发生了下面的报错(使用gh-ost很长时间了,第一次遇到这个报错):

[2023/12/12 11:48:08] [error] binlogstreamer.go:77 close sync with err: ERROR 1236 (HY000): A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-bin.061382' at 4, the last event read from './mysql-bin.061382' at 230229886, the last byte read from './mysql-bin.061382' at 230229886.

报错说是 和其中的一个slave 发生了 server_uuid 冲突了。

查看帮助:

gh-ost -h | grep server

 看到了一个参数 -replica-server-id=xxxx 可以指定 gh-ost使用的server-id,gh-ost 默认的server-id 是 99999.

加上该参数后正常。