GreatSQL社区

搜索

[待回复] Server Version: 8.0.32-25 断言失败 导致服务器 crash

211 4 2024-7-12 15:35
2024-07-12T15:08:52.663024+08:00 401336 [ERROR] [MY-013183] [InnoDB] Assertion failure: row0pread.cc:1350:is_queue_empty() thread 140160146601728
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/ ... nnodb-recovery.html
InnoDB: about forcing recovery.
2024-07-12T07:08:52Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=029072ec4fefcea616d05fa2631b046215e2e6dc

Build ID: 029072ec4fefcea616d05fa2631b046215e2e6dc
Server Version: 8.0.32-25 GreatSQL, Release 25, Revision 79f57097e3f

Thread pointer: 0x7f7994a00070
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 = 7f7993bfd1f0 thread_stack 0x80000
/usr/local/GreatSQL/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x2322cdd]
/usr/local/GreatSQL/bin/mysqld(print_fatal_signal(int)+0x3cf) [0x135b0cf]
/usr/local/GreatSQL/bin/mysqld(my_server_abort()+0x7e) [0x135b27e]
/usr/local/GreatSQL/bin/mysqld(my_abort()+0xa) [0x231ca0a]
/usr/local/GreatSQL/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x31f) [0x25ea7ef]
/usr/local/GreatSQL/bin/mysqld(Parallel_reader::dispatch_ctx(row_prebuilt_t*)+0x405) [0x25603f5]
/usr/local/GreatSQL/bin/mysqld(ha_innobase::pq_worker_scan_next(void*, unsigned char*)+0x12b) [0x24488cb]
/usr/local/GreatSQL/bin/mysqld(handler::ha_pq_next(unsigned char*, void*)+0x270) [0xdcdfe0]
/usr/local/GreatSQL/bin/mysqld(PQblockScanIterator::Read()+0x25) [0x102c645]
/usr/local/GreatSQL/bin/mysqld(FilterIterator::Read()+0x14) [0x14d5124]
/usr/local/GreatSQL/bin/mysqld(Query_expression::ExecuteIteratorQuery(THD*)+0xa72) [0x12a45b2]
/usr/local/GreatSQL/bin/mysqld(pq_worker_exec(void*)+0x90) [0x1170990]
/usr/local/GreatSQL/bin/mysqld() [0x27f8905]
/usr/lib64/libpthread.so.0(+0x7ea5) [0x7fb0b95ebea5]
/usr/lib64/libc.so.6(clone+0x6d) [0x7fb0b7bccb0d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f7b23ab2830): SELECT id,uid,openid,unionid,session_key,phone_number,pure_phone_number,country_code,nick_name,gender,language,country,province,city,avatar_url,status,createTime,updateTime  FROM edu_wechat_user_info  WHERE  openid = 'o7OWs647O_4MWjnIlF4Ig9CLcFBA'
Connection ID (thread ID): 401336
Status: NOT_KILLED




Please help us make Percona Server better by reporting any
bugs at https://bugs.percona.com/

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.



全部回复(4)
yejr 2024-7-12 16:08:44
已知的老问题了哈,请关闭InnoDB PQ特性,参见:https://greatsql.cn/docs/8.0.32- ... E%E4%B9%88%E5%8A%9E
mabai 2024-7-12 16:45:43
yejr 发表于 2024-7-12 16:08
已知的老问题了哈,请关闭InnoDB PQ特性,参见:https://greatsql.cn/docs/8.0.32-25/11-faq/5-faq-others. ...

嗯 确实是开了PQ特性
reddey 2024-7-12 17:04:16
mabai 发表于 2024-7-12 16:45
嗯 确实是开了PQ特性

如果这样,PQ特性不要轻易使用。
一个学艺不精的国产数据库爱好者
yejr 2024-7-12 18:08:45
reddey 发表于 2024-7-12 17:04
如果这样,PQ特性不要轻易使用。

是的,较早前我已经把 my.cnf 的配置默认关了
mabai

13

主题

0

博客

73

贡献

注册会员

Rank: 2

积分
127

助人为乐(铜)勤学好问(铜)

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2024-9-8 11:20 , Processed in 0.022770 second(s), 13 queries , Redis On.
快速回复 返回顶部 返回列表