percona 5.7.17遇到bug了!!

简介: mysql bug
2017-03-01T02:06:28.098477Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17-11-log) starting as process 117548 ...
2017-03-01T02:06:28.101658Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
2017-03-01T02:06:28.101678Z 0 [Warning] InnoDB: Using innodb_file_format_max is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
2017-03-01T02:06:28.101722Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-03-01T02:06:28.101728Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-01T02:06:28.101730Z 0 [Note] InnoDB: Uses event mutexes
2017-03-01T02:06:28.101733Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-03-01T02:06:28.101736Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-03-01T02:06:28.101738Z 0 [Note] InnoDB: Using Linux native AIO
2017-03-01T02:06:28.102704Z 0 [Note] InnoDB: Number of pools: 1
2017-03-01T02:06:28.102791Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-03-01T02:06:28.105548Z 0 [Note] InnoDB: Initializing buffer pool, total size = 200G, instances = 16, chunk size = 128M
2017-03-01T02:06:28.105560Z 0 [Note] InnoDB: Setting NUMA memory policy to MPOL_INTERLEAVE
2017-03-01T02:06:33.567127Z 0 [Note] InnoDB: Setting NUMA memory policy to MPOL_DEFAULT
2017-03-01T02:06:33.567156Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-03-01T02:06:34.965669Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-03-01T02:06:34.977998Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2017-03-01T02:06:34.980687Z 0 [Note] InnoDB: Opened 3 undo tablespaces
2017-03-01T02:06:34.980696Z 0 [Note] InnoDB: 3 undo tablespaces made active
2017-03-01T02:06:34.980874Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-03-01T02:06:35.909477Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 43724088852
2017-03-01T02:06:36.036472Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43729331712
2017-03-01T02:06:36.197614Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43734574592
2017-03-01T02:06:36.338243Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43739817472
2017-03-01T02:06:36.503259Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43745060352
2017-03-01T02:06:37.542996Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43726710272
2017-03-01T02:06:37.728222Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43731953152
2017-03-01T02:06:37.875146Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43737196032
2017-03-01T02:06:38.053155Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43742438912
2017-03-01T02:06:38.206974Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43747681792
2017-03-01T02:06:38.372973Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43752924672
2017-03-01T02:06:38.544097Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43758167552
2017-03-01T02:06:38.689065Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43763410432
2017-03-01T02:06:38.822492Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 43767254868
2017-03-01T02:06:38.822957Z 0 [ERROR] [FATAL] InnoDB: Missing MLOG_FILE_NAME or MLOG_FILE_DELETE for redo log record 41 (page 4278124286:4278124286) at 43767234886.
2017-03-01 10:06:38 0x7ff88e714840  InnoDB: Assertion failure in thread 140705518405696 in file ut0ut.cc line 917
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
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/5.7/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
02:06:38 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
Please help us make Percona Server better by reporting any
bugs at http://bugs.percona.com/

key_buffer_size=8388608
read_buffer_size=16777216
max_used_connections=0
max_threads=2001
thread_count=0
connection_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 98340377 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

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 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x3b)[0xeff3ab]
/usr/sbin/mysqld(handle_fatal_signal+0x471)[0x79ff11]
/lib64/libpthread.so.0(+0xf100)[0x7ff88e2f9100]
/lib64/libc.so.6(gsignal+0x37)[0x7ff88c4835f7]
/lib64/libc.so.6(abort+0x148)[0x7ff88c484ce8]
/usr/sbin/mysqld[0x76e15c]
/usr/sbin/mysqld(_ZN2ib5fatalD1Ev+0xfd)[0x11a093d]
/usr/sbin/mysqld[0x106e7ff]
/usr/sbin/mysqld(_Z18recv_parse_log_recP9mlog_id_tPhS1_PmS2_bPS1_+0xe2)[0x1071ad2]
/usr/sbin/mysqld[0x107290e]
/usr/sbin/mysqld[0x1073259]
/usr/sbin/mysqld(_Z35recv_recovery_from_checkpoint_startm+0x1f52)[0x1075512]
/usr/sbin/mysqld(_Z34innobase_start_or_create_for_mysqlv+0x45af)[0x114cf1f]
/usr/sbin/mysqld[0x10067f0]
/usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x51)[0x801e61]
/usr/sbin/mysqld[0xcf5145]
/usr/sbin/mysqld(_Z11plugin_initPiPPci+0x610)[0xcfc5d0]
/usr/sbin/mysqld[0x7985cb]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x656)[0x799bc6]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7ff88c46fb15]
/usr/sbin/mysqld[0x78f505]
You may download the Percona Server operations manual by visiting
http://www.percona.com/software/percona-server/. You may find information
in the manual which will help you identify the cause of the crash.

相关实践学习
每个IT人都想学的“Web应用上云经典架构”实战
本实验从Web应用上云这个最基本的、最普遍的需求出发,帮助IT从业者们通过“阿里云Web应用上云解决方案”,了解一个企业级Web应用上云的常见架构,了解如何构建一个高可用、可扩展的企业级应用架构。
MySQL数据库入门学习
本课程通过最流行的开源数据库MySQL带你了解数据库的世界。   相关的阿里云产品:云数据库RDS MySQL 版 阿里云关系型数据库RDS(Relational Database Service)是一种稳定可靠、可弹性伸缩的在线数据库服务,提供容灾、备份、恢复、迁移等方面的全套解决方案,彻底解决数据库运维的烦恼。 了解产品详情: https://www.aliyun.com/product/rds/mysql 
目录
相关文章
|
9天前
|
存储 弹性计算 缓存
阿里云服务器租赁费用:新版租赁收费标准及活动报价参考
本文更新了2026年阿里云全系列云服务器租赁活动报价,所有特惠资源均可前往阿里云活动中心选购,整体覆盖从个人入门到企业级高性能场景的全梯度需求。其中轻量应用服务器主打极致性价比,2核2G峰值200M带宽配置每日10点、15点限时抢购价仅38元/年,2核4G配置379元/年起;高性价比的经济型e实例、通用算力型u2i实例覆盖2核4G至4核32G全档位,适配开发测试与中小型企业业务;搭载英特尔至强6处理器的第九代c9i企业级实例算力较上代提升20%,支撑高并发生产环境,不同实例规格价差清晰,用户可根据自身业务负载与预算灵活选型。
1910 119
阿里云服务器租赁费用:新版租赁收费标准及活动报价参考
|
10天前
|
人工智能 程序员 API
Codex 接入 DeepSeek-V4-Flash:还能补上识图,提供两套方案
Codex 接入 DeepSeek-V4-Flash 怎么配?本文覆盖 CLI 与桌面端,再用 qwen3-vl-flash 补识图,两套方案可直接照做
1463 13
|
16天前
|
云安全 人工智能 运维
阿里云联动百位企业安全专家,共识Agent防御最佳实践
当Agent成为新员工,你的安全边界在哪里?
1967 10
阿里云联动百位企业安全专家,共识Agent防御最佳实践
|
7天前
|
编解码 弹性计算 云计算
MiniMax-H3 视频生成模型 — 一键部署与使用指南
MiniMax-H3是MiniMax开源的33B全模态视频生成模型,支持文生视频、图生视频、参考生视频三种模式,原生输出2K/15秒带立体声音频视频,已原生适配ComfyUI,并可通过阿里云计算巢一键部署。(239字)
|
10天前
|
人工智能 JSON Shell
2026AI漫剧本地全开源方案(附各个软件模型链接),8G显卡也能流畅运行
这是一套完全本地化部署的AI漫剧生成技术链路:涵盖LLM剧本分镜生成、FLUX文生图(IP-Adapter人脸锁定)、StoryDiffusion时序连贯控制、LTX-2.3唇形同步视频生成,及ComfyUI全流程调度。零云端费用,仅耗硬件算力,单集2–4小时可产出竖屏短视频,适配抖音/B站分发。
|
8天前
|
人工智能 API 开发工具
2026 零基础本地 AI 漫剧完整实操教程(8G 笔记本显卡可用|附可直接复制命令与代码)
本方案提供完全离线、本地运行的漫剧全自动制作流程:RTX3060/4050 8G显卡即可驱动,涵盖Qwen写分镜→ComfyUI统一角色绘图→LTX2.3图生微动画→Qwen3-TTS本地配音→FFmpeg自动合成,全程无水印、免API、不限次。专为低显存优化,解决变脸、闪烁、爆内存三大痛点。(239字)
|
22天前
|
人工智能 前端开发 Linux
Codex 桌面版安装 + CC Switch 接入第三方 API 完整教程(2026 最新)
2026最新教程:手把手教你安装Codex桌面版,通过CC Switch v3.17.0一键接入Fenno等国产API(兼容OpenAI Responses格式),跳过账号登录,完整启用代码审查、多步任务与上下文感知功能。零基础友好,全程图文实操。(239字)
3444 5
|
10天前
|
编解码 人工智能 安全
2核4G/4核8G/8核16G阿里云服务器如何选择实例?经济型e、通用算力型u2i与计算型c9i选哪个?
本文介绍了阿里云2核4G、4核8G、8核16G三档主流配置下经济型e、通用算力型u2i和计算型c9i三种实例的最新活动价格与适用场景。同配置下三者价差显著,以2核4G为例,经济型e低至599.93元/年,计算型c9i则高达1742.08元/年。文章详细解析了各实例的性能定位:经济型e适合轻负载入门场景,u2i兼顾稳定算力与性价比,c9i凭借第9代至强处理器与芯片级安全能力支撑高性能业务。同时提示用户可叠加满减优惠券享受折上折,建议根据业务负载与预算综合决策。
555 113