crash seen with update query on a partition table having compressed column

General

Escalation

General

Escalation

Description

It is noticed that both Percona server 5.7.x and 8.0.x are crashing with an update query executed against partition table having compressed columns. The crash is seen only with debug builds.

Please refer to the attachment section for the SQL testcase:

Stacktrace:

#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
#1  0x0000562ed6a6f65f in my_write_core (sig=6) at /home/mohit.joshi/mysql-8.0/mysys/stacktrace.cc:409
#2  0x0000562ed5776019 in handle_fatal_signal (sig=6) at /home/mohit.joshi/mysql-8.0/sql/signal_handler.cc:194
#3  <signal handler called>
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#5  0x00007f74758ca859 in __GI_abort () at abort.c:79
#6  0x0000562ed6f5e2ca in ut_dbg_assertion_failed (expr=0x562ed8d0b02b "0", 
    file=0x562ed8d0d7f8 "/home/mohit.joshi/mysql-8.0/storage/innobase/row/row0upd.cc", line=2358)
    at /home/mohit.joshi/mysql-8.0/storage/innobase/ut/ut0dbg.cc:98
#7  0x0000562ed6e94ef7 in row_upd_sec_index_entry_low (node=0x7f73a8574618, old_entry=0x0, thr=0x7f73a8574fd8)
    at /home/mohit.joshi/mysql-8.0/storage/innobase/row/row0upd.cc:2358
#8  0x0000562ed6e951eb in row_upd_sec_index_entry (node=0x7f73a8574618, thr=0x7f73a8574fd8)
    at /home/mohit.joshi/mysql-8.0/storage/innobase/row/row0upd.cc:2418
#9  0x0000562ed6e956e4 in row_upd_sec_step (node=0x7f73a8574618, thr=0x7f73a8574fd8)
    at /home/mohit.joshi/mysql-8.0/storage/innobase/row/row0upd.cc:2491
#10 0x0000562ed6e9772f in row_upd (node=0x7f73a8574618, thr=0x7f73a8574fd8)
    at /home/mohit.joshi/mysql-8.0/storage/innobase/row/row0upd.cc:3202
#11 0x0000562ed6e97a95 in row_upd_step (thr=0x7f73a8574fd8) at /home/mohit.joshi/mysql-8.0/storage/innobase/row/row0upd.cc:3307
#12 0x0000562ed6e19c56 in row_update_for_mysql_using_upd_graph (mysql_rec=0x7f73a855fb18 "", prebuilt=0x7f73a8568b00)
    at /home/mohit.joshi/mysql-8.0/storage/innobase/row/row0mysql.cc:2827
#13 0x0000562ed6e1a07c in row_update_for_mysql (mysql_rec=0x7f73a855fb18 "", prebuilt=0x7f73a8568b00)
    at /home/mohit.joshi/mysql-8.0/storage/innobase/row/row0mysql.cc:2923
#14 0x0000562ed6bbed84 in ha_innobase::update_row (this=0x7f73a8562648, old_row=0x7f73a855fb18 "", new_row=0x7f73a855f9d8 "")
    at /home/mohit.joshi/mysql-8.0/storage/innobase/handler/ha_innodb.cc:10291
#15 0x0000562ed6c21228 in ha_innopart::update_row_in_part (this=0x7f73a8562648, part_id=4, old_row=0x7f73a855fb18 "", 
    new_row=0x7f73a855f9d8 "") at /home/mohit.joshi/mysql-8.0/storage/innobase/handler/ha_innopart.cc:1477
#16 0x0000562ed53b9ea4 in Partition_helper::ph_update_row (this=0x7f73a8563ef8, old_data=0x7f73a855fb18 "", new_data=0x7f73a855f9d8 "", 
    lookup_rows=true) at /home/mohit.joshi/mysql-8.0/sql/partitioning/partition_handler.cc:610
#17 0x0000562ed6c2c1c2 in ha_innopart::update_row (this=0x7f73a8562648, old_record=0x7f73a855fb18 "", new_record=0x7f73a855f9d8 "")
    at /home/mohit.joshi/mysql-8.0/storage/innobase/handler/ha_innopart.h:1039
#18 0x0000562ed50bd301 in handler::ha_update_row (this=0x7f73a8562648, old_data=0x7f73a855fb18 "", new_data=0x7f73a855f9d8 "")
    at /home/mohit.joshi/mysql-8.0/sql/handler.cc:8247
#19 0x0000562ed569815b in Sql_cmd_update::update_single_table (this=0x7f73a839f4f8, thd=0x7f73a8001040)
    at /home/mohit.joshi/mysql-8.0/sql/sql_update.cc:943
#20 0x0000562ed569b1db in Sql_cmd_update::execute_inner (this=0x7f73a839f4f8, thd=0x7f73a8001040)
    at /home/mohit.joshi/mysql-8.0/sql/sql_update.cc:1729
#21 0x0000562ed55d2d2e in Sql_cmd_dml::execute (this=0x7f73a839f4f8, thd=0x7f73a8001040) at /home/mohit.joshi/mysql-8.0/sql/sql_select.cc:612
#21 0x0000562ed55d2d2e in Sql_cmd_dml::execute (this=0x7f73a839f4f8, thd=0x7f73a8001040) at /home/mohit.joshi/mysql-8.0/sql/sql_select.cc:612
#22 0x0000562ed554d856 in mysql_execute_command (thd=0x7f73a8001040, first_level=true) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:3611
#23 0x0000562ed555310c in dispatch_sql_command (thd=0x7f73a8001040, parser_state=0x7f745025faa0, update_userstat=false)
    at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:5256
#24 0x0000562ed5548740 in dispatch_command (thd=0x7f73a8001040, com_data=0x7f7450260b70, command=COM_QUERY)
    at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:1929
#25 0x0000562ed5546ac6 in do_command (thd=0x7f73a8001040) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:1382
#26 0x0000562ed575d3fc in handle_connection (arg=0x562ede42e760)
    at /home/mohit.joshi/mysql-8.0/sql/conn_handler/connection_handler_per_thread.cc:307
#27 0x0000562ed72e9454 in pfs_spawn_thread (arg=0x562ede526890) at /home/mohit.joshi/mysql-8.0/storage/perfschema/pfs.cc:2901
#28 0x00007f7476289609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#29 0x00007f74759c7293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95