这篇博客详细记录了一次MySQL数据库中InnoDB引擎遇到的断言失败问题，具体涉及到btr0pcur.c文件的435行。错误表明在不同页面之间比较时出现了不匹配，导致内存陷阱。这可能是由于数据页的压缩状态不一致引发的。博客内容深入到MySQL的执行过程，包括rr_sequential、sub_select等多个内部函数，分析了可能的触发因素和调用栈。
18011718:49:55InnoDB:Assertionfailureinthread139742026176256infilebtr0pcur.cline435InnoDB:Failingassertion:page_is_comp(next_page)==page_is_comp(page)InnoDB:Weintentional...
180117 18:49:55 InnoDB: Assertion failure in thread 139742026176256 in file btr0pcur.c line 435
InnoDB: Failing assertion: page_is_comp(next_page) == page_is_comp(page)
InnoDB: We intentionally generate a memory trap.
./DATA/mysql3306/bin/mysqld(_Z13rr_sequentialP11READ_RECORD+0x1d)[0x741c6d]
./DATA/mysql3306/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x79)[0x59ba99]
./DATA/mysql3306/bin/mysqld[0x5a13b8]
./DATA/mysql3306/bin/mysqld(_ZN4JOIN4execEv+0x8d5)[0x5b54c5]
./DATA/mysql3306/bin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x1c3)[0x5b1263]
./DATA/mysql3306/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x179)[0x5b6ff9]
./DATA/mysql3306/bin/mysqld[0x574a81]
./DATA/mysql3306/bin/mysqld(_Z21mysql_execute_commandP3THD+0x250b)[0x57a43b]
./DATA/mysql3306/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x18a)[0x57c77a]
./DATA/mysql3306/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1363)[0x57e363]
./DATA/mysql3306/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x167)[0x615ac7]
./DATA/mysql3306/bin/mysqld(handle_one_connection+0x54)[0x615b34]
/lib64/libpthread.so.0[0x3a3c0079d1]
/lib64/libc.so.6(clone+0x6d)[0x3a3bce88fd]
展开
4798
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
