Meituan-Dianping / Meituan-Dianping/MyFlash
mysqlbinlog恢复数据报错ERROR 1105 (HY000) at line 17: Unknown error
Nobody has claimed this yet.
- Dominant language
- C
- Stars
- 1.2k
- Forks
- 313
- PR merge metrics
- No merged PRs in 30d
Description
使用以下命令时报错mysqlbinlog --skip-gtids binlog_output_base.flashback -d jjc | mysql -hlocalhost -P3308 -uroot
错误信息为ERROR 1105 (HY000) at line 17: Unknown error
15行 #230824 15:59:47 server id 23042158 end_log_pos 374 CRC32 0xe4e9d7df Write_rows: table id 152 flags: STMT_END_F
16行 （空白）
17行 BINLOG '
服务器版本centos6.9
数据库版本mysql5.7.29
请教下这种问题需要如何处理
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the mysqlbinlog command against binlog_output_base.flashback and MySQL 5.7.29 on the reported environment. Inspect the generated output around line 17, including the BINLOG block, and compare the behavior with the CentOS 6.9 setup. Done means identifying the cause of ERROR 1105 or documenting a verified recovery workaround.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100