QA - iad03 [jgagne@na1-jgagne-dbdeployer06 jgagne_sandboxes]$ gdb /home/jgagne/opt/mysql/mysql_8.0.33/bin/mysqld GNU gdb (GDB) Red Hat Enterprise Linux 8.2-19.el8 Copyright (C) 2018 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-redhat-linux-gnu". Type "show configuration" for configuration details. For bug reporting instructions, please see: . Find the GDB manual and other documentation resources online at: . For help, type "help". Type "apropos word" to search for commands related to "word"... Reading symbols from /home/jgagne/opt/mysql/mysql_8.0.33/bin/mysqld... done. (gdb) break page_zip_compress Breakpoint 1 at 0x4120b7d: file ../../../mysql-8.0.33/storage/innobase/page/page0zip.cc, line 928. (gdb) run --defaults-file=/home/jgagne/sandboxes/msb_mysql_8_0_33/my.sandbox.cnf --basedir=/home/jgagne/opt/mysql/mysql_8.0.33 --datadir=/home/jgagne/sandboxes/msb_mysql_8_0_33/data --plugin-dir=/home/j gagne/opt/mysql/mysql_8.0.33/lib/plugin --log-error=/home/jgagne/sandboxes/msb_mysql_8_0_33/data/msandbox.err --pid-file=/home/jgagne/sandboxes/msb_mysql_8_0_33/data/mysql_sandbox8033.pid --socket=/tmp/ mysql_sandbox8033.sock --port=8033 Starting program: /mnt/jgagne_opt/mysql/mysql_8.0.33_full/bin/mysqld --defaults-file=/home/jgagne/sandboxes/msb_mysql_8_0_33/my.sandbox.cnf --basedir=/home/jgagne/opt/mysql/mysql_8.0.33 --datadir=/home/ jgagne/sandboxes/msb_mysql_8_0_33/data --plugin-dir=/home/jgagne/opt/mysql/mysql_8.0.33/lib/plugin --log-error=/home/jgagne/sandboxes/msb_mysql_8_0_33/data/msandbox.err --pid-file=/home/jgagne/sandboxes /msb_mysql_8_0_33/data/mysql_sandbox8033.pid --socket=/tmp/mysql_sandbox8033.sock --port=8033 [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". [New Thread 0x7fffe8657700 (LWP 298018)] [New Thread 0x7fffe72a8700 (LWP 298019)] [Thread 0x7fffe72a8700 (LWP 298019) exited] [New Thread 0x7fffe72a8700 (LWP 298020)] [New Thread 0x7fffe602c700 (LWP 298021)] [New Thread 0x7fffe582b700 (LWP 298022)] [New Thread 0x7fffe502a700 (LWP 298023)] [New Thread 0x7fffe4829700 (LWP 298024)] [New Thread 0x7fffcfa6e700 (LWP 298025)] [New Thread 0x7fffcf26d700 (LWP 298026)] [New Thread 0x7fffcea6c700 (LWP 298027)] [New Thread 0x7fffce26b700 (LWP 298028)] [New Thread 0x7fffcda6a700 (LWP 298029)] [New Thread 0x7fffcb267700 (LWP 298030)] [New Thread 0x7fffcaa66700 (LWP 298031)] [New Thread 0x7fffca265700 (LWP 298032)] [New Thread 0x7fffc9a64700 (LWP 298033)] [New Thread 0x7fffc9263700 (LWP 298034)] [New Thread 0x7fffc8a62700 (LWP 298035)] [New Thread 0x7fffc8261700 (LWP 298036)] [New Thread 0x7fffc7a60700 (LWP 298037)] [New Thread 0x7fffc725f700 (LWP 298038)] [New Thread 0x7fffc6a5e700 (LWP 298039)] [Thread 0x7fffc7a60700 (LWP 298037) exited] [Thread 0x7fffc8261700 (LWP 298036) exited] [Thread 0x7fffc6a5e700 (LWP 298039) exited] [Thread 0x7fffc725f700 (LWP 298038) exited] [New Thread 0x7fffc725f700 (LWP 298040)] [New Thread 0x7fffc6a5e700 (LWP 298042)] [New Thread 0x7fffc8261700 (LWP 298043)] [New Thread 0x7fffc7a60700 (LWP 298045)] [New Thread 0x7fffc625d700 (LWP 298046)] [New Thread 0x7fffc5a5c700 (LWP 298047)] [New Thread 0x7fffc525b700 (LWP 298048)] [Thread 0x7fffe8657700 (LWP 298018) exited] [New Thread 0x7fffe6843700 (LWP 298049)] [New Thread 0x7fffc4a5a700 (LWP 298050)] [New Thread 0x7fffc4959700 (LWP 298051)] [New Thread 0x7fffe8657700 (LWP 298053)] [Thread 0x7fffe8657700 (LWP 298053) exited] [New Thread 0x7fffe8657700 (LWP 298054)] [Thread 0x7fffe8657700 (LWP 298054) exited] [New Thread 0x7fffe8657700 (LWP 298055)] [Thread 0x7fffe8657700 (LWP 298055) exited] [New Thread 0x7fffe8657700 (LWP 298056)] [New Thread 0x7fffc4858700 (LWP 298057)] [New Thread 0x7fffc4057700 (LWP 298058)] [New Thread 0x7fffc3856700 (LWP 298059)] [New Thread 0x7fffc3055700 (LWP 298060)] [New Thread 0x7fffc2854700 (LWP 298061)] [New Thread 0x7fffc2053700 (LWP 298062)] [New Thread 0x7fffc1f51700 (LWP 298063)] [New Thread 0x7fffc1e4f700 (LWP 298064)] [New Thread 0x7fffc1d4e700 (LWP 298065)] [New Thread 0x7fffc1c4d700 (LWP 298066)] [New Thread 0x7fffc144c700 (LWP 298134)] [Switching to Thread 0x7fffc144c700 (LWP 298134)] -- Here, I run this: -- ./use test_jfg <<< "begin; delete from fake where id = :id; rollback;" Thread 48 "connection" hit Breakpoint 1, page_zip_compress (page_zip=page_zip@entry=0x7fffcfb1bc40, page=page@entry=0x7fffd0f70000 "T\216\315x", index=index@entry=0x7fffd8734768, level=level@entry=6, mtr=mtr@entry=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/page/page0zip.cc:928 928 ../../../mysql-8.0.33/storage/innobase/page/page0zip.cc: No such file or directory. Missing separate debuginfos, use: yum debuginfo-install glibc-2.28-209.el8.x86_64 libaio-0.3.112-1.el8.x86_64 libgcc-8.5.0-18.el8.x86_64 libstdc++-8.5.0-18.el8.x86_64 numactl-libs-2.0.12-13.el8.x86_64 sssd-client-2.8.2-1.el8.x86_64 (gdb) backtrace #0 page_zip_compress (page_zip=page_zip@entry=0x7fffcfb1bc40, page=page@entry=0x7fffd0f70000 "T\216\315x", index=index@entry=0x7fffd8734768, level=level@entry=6, mtr=mtr@entry=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/page/page0zip.cc:928 #1 0x000000000426d79b in btr_page_reorganize_low (recovery=recovery@entry=false, z_level=6, cursor=cursor@entry=0x7fffd8663b00, index=index@entry=0x7fffd8734768, mtr=mtr@entry=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0btr.cc:1229 #2 0x000000000426dcba in btr_page_reorganize (cursor=cursor@entry=0x7fffd8663b00, index=index@entry=0x7fffd8734768, mtr=mtr@entry=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0btr.cc:1370 #3 0x000000000427c1e1 in btr_cur_update_alloc_zip_func (page_zip=page_zip@entry=0x7fffcfb1bc40, cursor=0x7fffd8663b00, index=index@entry=0x7fffd8734768, offsets=offsets@entry=0x7fffd867d988, length=length@entry=8051, create=create@entry=false, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc:3278 #4 0x000000000405e992 in btr_cur_update_alloc_zip (page_zip=page_zip@entry=0x7fffcfb1bc40, cursor=, index=index@entry=0x7fffd8734768, offsets=offsets@entry=0x7fffd867d988, len=len@entry=8051, cr=cr@entry=false, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/include/btr0cur.h:305 #5 0x000000000427f1ec in btr_cur_update_in_place (flags=flags@entry=15, cursor=cursor@entry=0x7fffd8663af8, offsets=0x7fffd867d988, update=update@entry=0x7fffd86640a8, cmpl_info=cmpl_info@entry=0, thr=thr@entry=0x7fffd86638a8, trx_id=2321, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc:3366 #6 0x00000000042802a2 in btr_cur_optimistic_update (flags=flags@entry=15, cursor=cursor@entry=0x7fffd8663af8, offsets=offsets@entry=0x7fffc14473f0, heap=heap@entry=0x7fffc14473f8, update=0x7fffd86640a8, cmpl_info=0, thr=0x7fffd86638a8, trx_id=2321, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc:3549 #7 0x0000000004436055 in row_undo_mod_clust_low (node=node@entry=0x7fffd8663a88, offsets=offsets@entry=0x7fffc14473f0, offsets_heap=offsets_heap@entry=0x7fffc14473f8, heap=, heap@entry=0x7fffd8664430, rebuilt_old_pk=rebuilt_old_pk@entry=0x7fffc14473e8, sys=sys@entry=0x7fffc14473db "", thr=0x7fffd86638a8, mtr=0x7fffc1447400, mode=2) at ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc:136 #8 0x00000000044371e1 in row_undo_mod_clust (node=node@entry=0x7fffd8663a88, thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc:296 #9 0x000000000443855c in row_undo_mod (node=node@entry=0x7fffd8663a88, thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc:1322 #10 0x00000000041a6e2a in row_undo (node=node@entry=0x7fffd8663a88, thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/row/row0undo.cc:301 #11 0x00000000041a7962 in row_undo_step (thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/row/row0undo.cc:362 #12 0x000000000412b1e3 in que_thr_step (thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/que/que0que.cc:913 #13 0x000000000412b3d6 in que_run_threads_low (thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/que/que0que.cc:966 #14 0x000000000412b536 in que_run_threads (thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/que/que0que.cc:1001 #15 0x000000000420af10 in trx_rollback_to_savepoint_low (trx=trx@entry=0x7fffe734dff8, savept=savept@entry=0x0) at ../../../mysql-8.0.33/storage/innobase/trx/trx0roll.cc:114 #16 0x000000000420b400 in trx_rollback_for_mysql_low (trx=trx@entry=0x7fffe734dff8) at ../../../mysql-8.0.33/storage/innobase/trx/trx0roll.cc:168 #17 0x000000000420b5bb in trx_rollback_low (trx=trx@entry=0x7fffe734dff8) at ../../../mysql-8.0.33/storage/innobase/trx/trx0roll.cc:204 #18 0x000000000420b7d6 in trx_rollback_for_mysql (trx=trx@entry=0x7fffe734dff8) at ../../../mysql-8.0.33/storage/innobase/trx/trx0roll.cc:277 #19 0x0000000003fde1ee in innobase_rollback (hton=, thd=0x7fffd8658a50, rollback_trx=) at ../../../mysql-8.0.33/storage/innobase/handler/ha_innodb.cc:5934 #20 0x0000000003354d1f in ha_rollback_low (thd=thd@entry=0x7fffd8658a50, all=all@entry=true) at ../../mysql-8.0.33/sql/handler.cc:2002 #21 0x00000000031dd93a in trx_coordinator::rollback_in_engines (thd=0x7fffd8658a50, all=) at ../../mysql-8.0.33/sql/tc_log.cc:158 #22 0x0000000003c9a5fd in MYSQL_BIN_LOG::rollback (this=0x713bfe0 , thd=0x7fffd8658a50, all=) at ../../mysql-8.0.33/sql/binlog.cc:2528 #23 0x0000000003350073 in ha_rollback_trans (thd=thd@entry=0x7fffd8658a50, all=all@entry=true) at ../../mysql-8.0.33/sql/handler.cc:2083 #24 0x00000000031e0909 in trans_rollback (thd=thd@entry=0x7fffd8658a50) at ../../mysql-8.0.33/sql/transaction.cc:405 #25 0x00000000030c3e14 in mysql_execute_command (thd=thd@entry=0x7fffd8658a50, first_level=first_level@entry=true) at ../../mysql-8.0.33/sql/sql_parse.cc:4305 #26 0x00000000030c5dc9 in dispatch_sql_command (thd=0x7fffd8658a50, parser_state=parser_state@entry=0x7fffc144ad10) at ../../mysql-8.0.33/sql/sql_parse.cc:5363 #27 0x00000000030c752b in dispatch_command (thd=, thd@entry=0x7fffd8658a50, com_data=com_data@entry=0x7fffc144bb40, command=COM_QUERY) at ../../mysql-8.0.33/sql/sql_parse.cc:2050 #28 0x00000000030c926e in do_command (thd=thd@entry=0x7fffd8658a50) at ../../mysql-8.0.33/sql/sql_parse.cc:1439 #29 0x0000000003227bb7 in handle_connection (arg=arg@entry=0x9e3cae0) at ../../mysql-8.0.33/sql/conn_handler/connection_handler_per_thread.cc:302 #30 0x0000000004743af9 in pfs_spawn_thread (arg=0x9e1eb00) at ../../../mysql-8.0.33/storage/perfschema/pfs.cc:3042 #31 0x00007ffff7bb71ca in start_thread () from /lib64/libpthread.so.0 #32 0x00007ffff5cf0e73 in clone () from /lib64/libc.so.6 (gdb) finish Run till exit from #0 page_zip_compress (page_zip=page_zip@entry=0x7fffcfb1bc40, page=page@entry=0x7fffd0f70000 "T\216\315x", index=index@entry=0x7fffd8734768, level=level@entry=6, mtr=mtr@entry=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/page/page0zip.cc:928 0x000000000426d79b in btr_page_reorganize_low (recovery=recovery@entry=false, z_level=6, cursor=cursor@entry=0x7fffd8663b00, index=index@entry=0x7fffd8734768, mtr=mtr@entry=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0btr.cc:1229 1229 ../../../mysql-8.0.33/storage/innobase/btr/btr0btr.cc: No such file or directory. Value returned is $1 = true (gdb) finish Run till exit from #0 0x000000000426d79b in btr_page_reorganize_low (recovery=recovery@entry=false, z_level=6, cursor=cursor@entry=0x7fffd8663b00, index=index@entry=0x7fffd8734768, mtr=mtr@entry=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0btr.cc:1229 0x000000000426dcba in btr_page_reorganize (cursor=cursor@entry=0x7fffd8663b00, index=index@entry=0x7fffd8734768, mtr=mtr@entry=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0btr.cc:1370 1370 in ../../../mysql-8.0.33/storage/innobase/btr/btr0btr.cc Value returned is $2 = true (gdb) finish Run till exit from #0 0x000000000426dcba in btr_page_reorganize (cursor=cursor@entry=0x7fffd8663b00, index=index@entry=0x7fffd8734768, mtr=mtr@entry=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0btr.cc:1370 0x000000000427c1e1 in btr_cur_update_alloc_zip_func (page_zip=page_zip@entry=0x7fffcfb1bc40, cursor=0x7fffd8663b00, index=index@entry=0x7fffd8734768, offsets=offsets@entry=0x7fffd867d988, length=length@entry=8051, create=create@entry=false, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc:3278 3278 ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc: No such file or directory. Value returned is $3 = true (gdb) finish Run till exit from #0 0x000000000427c1e1 in btr_cur_update_alloc_zip_func (page_zip=page_zip@entry=0x7fffcfb1bc40, cursor=0x7fffd8663b00, index=index@entry=0x7fffd8734768, offsets=offsets@entry=0x7fffd867d988, length=length@entry=8051, create=create@entry=false, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc:3278 0x000000000405e992 in btr_cur_update_alloc_zip (page_zip=page_zip@entry=0x7fffcfb1bc40, cursor=, index=index@entry=0x7fffd8734768, offsets=offsets@entry=0x7fffd867d988, len=len@entry=8051, cr=cr@entry=false, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/include/btr0cur.h:305 305 ../../../mysql-8.0.33/storage/innobase/include/btr0cur.h: No such file or directory. Value returned is $4 = false (gdb) finish Run till exit from #0 0x000000000405e992 in btr_cur_update_alloc_zip (page_zip=page_zip@entry=0x7fffcfb1bc40, cursor=, index=index@entry=0x7fffd8734768, offsets=offsets@entry=0x7fffd867d988, len=len@entry=8051, cr=cr@entry=false, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/include/btr0cur.h:305 0x000000000427f1ec in btr_cur_update_in_place (flags=flags@entry=15, cursor=cursor@entry=0x7fffd8663af8, offsets=0x7fffd867d988, update=update@entry=0x7fffd86640a8, cmpl_info=cmpl_info@entry=0, thr=thr@entry=0x7fffd86638a8, trx_id=2321, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc:3366 3366 ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc: No such file or directory. Value returned is $5 = false (gdb) finish Run till exit from #0 0x000000000427f1ec in btr_cur_update_in_place (flags=flags@entry=15, cursor=cursor@entry=0x7fffd8663af8, offsets=0x7fffd867d988, update=update@entry=0x7fffd86640a8, cmpl_info=cmpl_info@entry=0, thr=thr@entry=0x7fffd86638a8, trx_id=2321, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc:3366 0x00000000042802a2 in btr_cur_optimistic_update (flags=flags@entry=15, cursor=cursor@entry=0x7fffd8663af8, offsets=offsets@entry=0x7fffc14473f0, heap=heap@entry=0x7fffc14473f8, update=0x7fffd86640a8, cmpl_info=0, thr=0x7fffd86638a8, trx_id=2321, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc:3549 3549 in ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc Value returned is $6 = DB_ZIP_OVERFLOW (gdb) finish Run till exit from #0 0x00000000042802a2 in btr_cur_optimistic_update (flags=flags@entry=15, cursor=cursor@entry=0x7fffd8663af8, offsets=offsets@entry=0x7fffc14473f0, heap=heap@entry=0x7fffc14473f8, update=0x7fffd86640a8, cmpl_info=0, thr=0x7fffd86638a8, trx_id=2321, mtr=0x7fffc1447400) at ../../../mysql-8.0.33/storage/innobase/btr/btr0cur.cc:3549 0x0000000004436055 in row_undo_mod_clust_low (node=node@entry=0x7fffd8663a88, offsets=offsets@entry=0x7fffc14473f0, offsets_heap=offsets_heap@entry=0x7fffc14473f8, heap=, heap@entry=0x7fffd8664430, rebuilt_old_pk=rebuilt_old_pk@entry=0x7fffc14473e8, sys=sys@entry=0x7fffc14473db "", thr=0x7fffd86638a8, mtr=0x7fffc1447400, mode=2) at ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc:136 136 ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc: No such file or directory. Value returned is $7 = DB_ZIP_OVERFLOW (gdb) finish Run till exit from #0 0x0000000004436055 in row_undo_mod_clust_low (node=node@entry=0x7fffd8663a88, offsets=offsets@entry=0x7fffc14473f0, offsets_heap=offsets_heap@entry=0x7fffc14473f8, heap=, heap@entry=0x7fffd8664430, rebuilt_old_pk=rebuilt_old_pk@entry=0x7fffc14473e8, sys=sys@entry=0x7fffc14473db "", thr=0x7fffd86638a8, mtr=0x7fffc1447400, mode=2) at ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc:136 0x00000000044371e1 in row_undo_mod_clust (node=node@entry=0x7fffd8663a88, thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc:296 296 in ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc Value returned is $8 = DB_ZIP_OVERFLOW (gdb) finish Run till exit from #0 0x00000000044371e1 in row_undo_mod_clust (node=node@entry=0x7fffd8663a88, thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc:296 0x000000000443855c in row_undo_mod (node=node@entry=0x7fffd8663a88, thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc:1322 1322 in ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc Value returned is $9 = DB_SUCCESS (gdb) finish Run till exit from #0 0x000000000443855c in row_undo_mod (node=node@entry=0x7fffd8663a88, thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/row/row0umod.cc:1322 0x00000000041a6e2a in row_undo (node=node@entry=0x7fffd8663a88, thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/row/row0undo.cc:301 301 ../../../mysql-8.0.33/storage/innobase/row/row0undo.cc: No such file or directory. Value returned is $10 = DB_SUCCESS (gdb) finish Run till exit from #0 0x00000000041a6e2a in row_undo (node=node@entry=0x7fffd8663a88, thr=thr@entry=0x7fffd86638a8) at ../../../mysql-8.0.33/storage/innobase/row/row0undo.cc:301 Thread 48 "connection" received signal SIGABRT, Aborted. 0x00007ffff5d05aff in raise () from /lib64/libc.so.6