Percona MySQL Version 8.4.8.8
All my tables are InnoDB.
All have ROW_FORMAT = COMPRESSED KEY_BLOCK_SIZE = 8
Since my upgrade to 8.4.8.8 across my fleet, I am getting random assertion errors in error.log causing crash loops which sometimes recover and sometimes does not recover at all. I initially thought of hardware issue, so I moved to different VMs, different datacenters etc, but nothing worked. Crashes do keep happening randomly. Just today, I got hit with new assertions.
2026-06-11T04:44:20Z UTC - mysqld got signal 11 ;
Signal SIGSEGV (unknown siginfo_t::si_code) at address 0x0
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=2ff35c61c148662a19b28fcb9036154643e867e6
Server Version: 8.4.8-8 Percona Server (GPL), Release '8', Revision '1c288264'
Thread pointer: 0x74cda0187130
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 = 74cd3611bc00 thread_stack 0x100000
#0 0x6149e95cffc1
#1 0x6149e95d058b _Z19handle_fatal_signaliP9siginfo_tPv
#2 0x74d35a24532f
#3 0x6149e9f58812 _Z32page_cur_search_with_match_bytesPK11buf_block_tPK12dict_index_tPK8dtuple_t15page_cur_mode_tPmS9_S9_S9_P10page_cur_t
#4 0x6149ea03551f _Z27btr_cur_search_to_nth_levelP12dict_index_tmPK8dtuple_t15page_cur_mode_tmP9btr_cur_tmPKcmP5mtr_t
#5 0x6149e9ef62f4
#6 0x6149e9fa3c70 _ZN31Row_sel_get_clust_rec_for_mysqlclEP14row_prebuilt_tP12dict_index_tPKhP9que_thr_tPS5_PPmPP16mem_block_info_tPPK8dtuple_tP5mtr_tPN3lob11undo_vers_tE
#7 0x6149e9fa7596 _Z15row_search_mvccPh15page_cur_mode_tP14row_prebuilt_tmm
#8 0x6149e9e707b4 _ZN11ha_innobase10index_readEPhPKhj16ha_rkey_function
#9 0x6149e9199eb7 _ZN7handler17ha_index_read_mapEPhPKhm16ha_rkey_function
#10 0x6149e96ff3a8 _ZN11RefIteratorILb0EE4ReadEv
#11 0x6149e96e9167 _ZN14FilterIterator4ReadEv
#12 0x6149e96e9211 _ZN18NestedLoopIterator4ReadEv
#13 0x6149e96e979e _ZN17AggregateIterator4ReadEv
#14 0x6149e954d267 _ZN16Query_expression20ExecuteIteratorQueryEP3THD
#15 0x6149e954d53f _ZN16Query_expression7executeEP3THD
#16 0x6149e94cb14a _ZN11Sql_cmd_dml13execute_innerEP3THD
#17 0x6149e94ca540 _ZN11Sql_cmd_dml7executeEP3THD
#18 0x6149e947ca03 _Z21mysql_execute_commandP3THDb
#19 0x6149e94ac7ee _ZN18Prepared_statement7executeEP3THDP6Stringb
#20 0x6149e94b4fd8 _ZN18Prepared_statement12execute_loopEP3THDP6Stringb
#21 0x6149e94b5515 _Z19mysqld_stmt_executeP3THDP18Prepared_statementbmP8PS_PARAM
#22 0x6149e9481920 _Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command
#23 0x6149e9483316 _Z10do_commandP3THD
#24 0x6149e95d1ffe
#25 0x6149ea1c787f
#26 0x74d35a29caa3
#27 0x74d35a329c6b
#28 0xffffffffffffffff
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (74cda025e238): SELECT SUM(CASE WHEN (CASE WHEN icl.attempted_amtp > 0 AND icl.amount_matched = 1 THEN CASE WHEN icl.attempted_amtp = c.total_amtp THEN 'MATCHED' ELSE 'UNMATCHED' END ELSE 'UNVERIFIED' END) = 'MATCHED' THEN c.total_amtp ELSE 0 END) AS verified_challan_amtp, SUM(CASE WHEN (CASE WHEN icl.attempted_amtp > 0 AND icl.amount_matched = 1 THEN CASE WHEN icl.attempted_amtp = c.total_amtp THEN 'MATCHED' ELSE 'UNMATCHED' END ELSE 'UNVERIFIED' END) <> 'MATCHED' THEN c.total_amtp ELSE 0 END) AS unverified_challan_amtp FROM challan AS c INNER JOIN bsr_code AS bc ON bc.bsr_code_id = c.bsr_code_id LEFT JOIN import_challan_log AS icl ON icl.deductor_id = c.deductor_id AND icl.challan_no = c.challan_no AND icl.deposit_date = c.deposit_date AND icl.bsr_code = bc.bsr_code WHERE c.deductor_id = 68731 AND c.deposit_date BETWEEN '2026-04-01' AND '2027-03-31'
Connection ID (thread ID): 638
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.
2026-06-11T10:14:25.600533+05:30 0 [System] [MY-015015] [Server] MySQL Server - start.
2026-06-11T10:14:25.817357+05:30 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
Since I cannot attach files. You can access the complete error log at: Error Log - Pastes.io
and mysql conf file at: MySQL Conf - Pastes.io
This is happening across the fleet randomly. Is it something to do with composite indexes ? OR, compressed tables ?
…