首页 > 其他分享 >xtrabackup 恢复报错:Assertion failure: log0files_finder.cc:322:format >= Log_format

xtrabackup 恢复报错:Assertion failure: log0files_finder.cc:322:format >= Log_format

时间:2023-07-10 16:56:14浏览次数:48  
标签:00 Log format 33 08 xtrabackup InnoDB 报错 07

 

2023-07-10T15:33:46.614144+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2023-07-10T15:33:46.647712+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 229 files.
2023-07-10T15:33:46.648265+08:00 0 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2023-07-10T15:33:46.655470+08:00 0 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2023-07-10T15:33:46.794961+08:00 0 [Note] [MY-011951] [InnoDB] page_cleaner coordinator priority: -20
2023-07-10T15:33:46.818424+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-07-10T15:33:46.841662+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-07-10T15:33:46.865034+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
InnoDB: Assertion failure: log0files_finder.cc:322:format >= Log_format::VERSION_8_0_30
InnoDB: thread 139874471463616InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.percona.com/projects/PXB.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
2023-07-10T07:33:46Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x100000
xtrabackup(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x25de83d]
xtrabackup(print_fatal_signal(int)+0x393) [0x13402a3]
xtrabackup(handle_fatal_signal+0x95) [0x1340385]
/lib64/libpthread.so.0(+0xf630) [0x7f370fedf630]
/lib64/libc.so.6(gsignal+0x37) [0x7f370dacb387]
/lib64/libc.so.6(abort+0x148) [0x7f370dacca78]
xtrabackup(my_abort()+0xa) [0x25d800a]
xtrabackup(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0xf7) [0x1864677]
xtrabackup(log_files_find_and_analyze(bool, Encryption_metadata&, Log_files_dict&, Log_format&, std::string&, unsigned int&, unsigned int&)+0x1841) [0x16f6371]
xtrabackup(log_sys_init(bool, unsigned long, unsigned long&)+0x2407) [0x170d757]
xtrabackup(srv_start(bool, unsigned long)+0x1397) [0x180b467]
xtrabackup() [0xda592d]
xtrabackup(main+0x1823) [0xd52243]
/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f370dab7555]
xtrabackup() [0xd89f07]

Please report a bug at https://jira.percona.com/projects/PXB

环境是centos 7  ,percona-xtrabackup-80-8.0.32-25.1.el7.x86_64

用语句   xtrabackup --defaults-file=/data/mysql13619/conf/my.cnf --prepare --apply-log-only --target-dir=/data/backup/base/   恢复全备报上面的错,考虑可能是log-bin的问题,修改语句为 xtrabackup --defaults-file=/data/mysql13619/conf/my.cnf --prepare  --target-dir=/data/backup/base/       

之后正常恢复。全备的数据库是20CPU,240g内存的云服务器,一开始用一般的虚拟机,几核几G的来做恢复测试,会报错,后面是找了到哪10CPU,128G内存做的恢复测试。

标签:00,Log,format,33,08,xtrabackup,InnoDB,报错,07
From: https://www.cnblogs.com/tree123281/p/17541608.html

相关文章

  • 使用加密算法时报错:ModuleNotFoundError: No module named ‘Crypto‘
    解决办法:安装Crypto模块,执行 pipinstallCrypto ,安装成功后,再执行命令,还是报上面的错误第一步:在python3(或者python虚拟环境)目录下的/Lib/site-packages/目录下找到crypto、crypto-1.4.1.dist-info目录,将crypto首字母改为大写,即修改名称为Crypto、Crypto-1.4.1.d......
  • 运行 Spring6 报错 Internal error: (java.lang.ExceptionInInitializerError)
    问题描述:使用2019.3.5版本的IDEA构建Spring6项目。因为Spring6要求JDK的版本最低是Java17,我就直接在2019.3.5版本的IDEA中创建新的项目时使用了JDK17。 运行项目时IDEA 出现如下报错信息:Error:Internalerror:(java.lang.ExceptionInInitializerErro......
  • 基于FPGA的信号发生器,使用VHDL或Verilog语言进行开发,可以提供相关的仿真和设计说资料
    基于FPGA的信号发生器,使用VHDL或Verilog语言进行开发,可以提供相关的仿真和设计说资料。ID:3150646782307233......
  • winform openFileDialog 多个文件上传
       ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------privatevoidbutton1_Click(objectsender,EventArgse){......
  • js/ts文件中,导入i18n报错:Must be called at the top of a `setup` function
    import{useI18n}from'vue-i18n';const{t}=useI18n(); 会在非组件情况下报错: 此时我们需要将上述导入方式改为:importi18nfrom'@/lang/i18n';//@/lang/i18n为语言包位置const{t}=i18n.global;......
  • 基于FPGA的2DPSK调制解调程序,verilog实现,含仿真和说明。
    基于FPGA的2DPSK调制解调程序,verilog实现,含仿真和说明。ID:36300630866693502......
  • java项目 报错 maven jdk.tools 缺失 解决方法
    一、解决方法配置文件pom.xml<dependency><groupId>jdk.tools</groupId><artifactId>jdk.tools</artifactId><version>1.7</version><scope>system</scope><systemPath>${......
  • 标小智AI智能Logo生成器,免费设计logo生成,堪称神站!
    1.标小智是什么?标小智LOGO神器是国内最早自研的一款logo生成器产品,受到很多朋友喜欢的智能logo创建工具。只需要输入logo名称,即可智能生成上百款不重样的logo设计方案,以及配套企业VI助您打造个性品牌。 拥有极其丰富的Logo创意,它最厉害的一点是把设计行业里普通人难以理解......
  • Docker CLI docker login和logout 常用命令
    Docker是一个开源的应用容器引擎,让开发者可以打包他们的应用以及依赖包到一个可移植的镜像中,然后发布到任何流行的Linux或Windows操作系统的机器上,也可以实现虚拟化。Docker是内核虚拟化,不使用Hypervisor是不完全虚拟化,依赖内核的特性实现资源隔离。本文主要介绍DockerCLI中d......
  • hyperloglog
    hyperloglog应用场景统计某个网站的UV(UniqueVisitor,独立访客,一般理解为客户端IP(要考虑去重))例如qq空间,还有bilibili视频的点击量用户搜索网站关键词的数量统计用户每天搜索不同词条个数只保存对应的基数估计值(一个集合内不同元素的个数)而不保存对应的数据为什么......