Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

[PS8QA] DROP COMPRESSION_DICTIONARY leads to crash on optimized | sig6 | Assertion failure: ha_innodb.cc:4974:0

Description

DROP COMPRESSION_DICTIONARY a;

On an optimized build of PS 8.0.12 leads to:

2018-09-15T04:22:12.329818Z 0 [System] [MY-010931] [Server] /sda/PS010918-percona-server-8.0.12-1-linux-x86_64-opt/bin/mysqld: ready for connections. Version: '8.0.12-1' socket: '/sda/PS010918-percona-server-8.0.12-1-linux-x86_64-opt/socket.sock' port: 11531 MySQL Community Server (GPL). 2018-09-15T04:22:24.884636Z 9 [ERROR] [MY-000000] [InnoDB] InnoDB: Assertion failure: ha_innodb.cc:4974:0
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `/sda/PS010918-percona-server-8.0.12-1-linux-x86_64-opt/bin/mysqld --no-defaults'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 [Current thread is 1 (Thread 0x7f8ac79fc700 (LWP 25220))] (gdb) bt #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57#1 0x000055c6078e3797 in my_write_core (sig=sig@entry=6) at stacktrace.cc:278 #2 0x000055c606aba825 in handle_fatal_signal (sig=6) at signal_handler.cc:254 #3 <signal handler called> #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51 #5 0x00007f8ac7a3d801 in __GI_abort () at abort.c:79 #6 0x000055c607c58cb3 in ut_dbg_assertion_failed (expr=expr@entry=0x55c607fe43cc "0", file=file@entry=0x55c608011d40 "handler/ha_innodb.cc", line=line@entry=4974) at ut/ut0dbg.cc:90 #7 0x000055c607a4e8d8 in innobase_drop_zip_dict (hton=<optimized out>, thd=<optimized out>, name=<optimized out>, name_len=<optimized out>) at handler/ha_innodb.cc:4974 #8 0x000055c606a5a49c in mysql_drop_zip_dict (thd=thd@entry=0x7f8a46417000, name=0x7f8a464639d0 "a", name_len=1, if_exists=<optimized out>) at sql_zip_dict.cc:159 #9 0x000055c60698fdd1 in mysql_execute_command (thd=thd@entry=0x7f8a46417000, first_level=first_level@entry=true) at sql_parse.cc:3571 #10 0x000055c60699417b in mysql_parse (thd=thd@entry=0x7f8a46417000, parser_state=parser_state@entry=0x7f8ac79fad40, update_userstat=update_userstat@entry=false) at sql_parse.cc:5139 #11 0x000055c606996f42 in dispatch_command (thd=thd@entry=0x7f8a46417000, com_data=com_data@entry=0x7f8ac79fbc60, command=COM_QUERY) at sql_parse.cc:1654 #12 0x000055c606997c79 in do_command (thd=thd@entry=0x7f8a46417000) at sql_parse.cc:1262 #13 0x000055c606aabec0 in handle_connection (arg=arg@entry=0x7f8a45c5e730) at conn_handler/connection_handler_per_thread.cc:317 #14 0x000055c6079ac13f in pfs_spawn_thread (arg=0x7f8a7f3d2a20) at pfs.cc:2836 #15 0x00007f8ac96466db in start_thread (arg=0x7f8ac79fc700) at pthread_create.c:463 #16 0x00007f8ac7b1e88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Likely another "duplicate" of  https://perconadev.atlassian.net/browse/PS-4805#icft=PS-4805, but logging for completeness. Also, I note that status of  https://perconadev.atlassian.net/browse/PS-4805#icft=PS-4805 is 'New' instead of 'Open' - i.e. this needs to be fixed before GA. Updated the same. Feel free to mark as dup, provided https://perconadev.atlassian.net/browse/PS-4805#icft=PS-4805 remains as 'open' and triaged as blocker.

Environment

None

Smart Checklist

Activity

Show:
Duplicate

Details

Assignee

Reporter

Time tracking

20m logged

Priority

Smart Checklist

Created September 15, 2018 at 4:28 AM
Updated March 6, 2024 at 12:50 PM
Resolved September 17, 2018 at 6:48 AM

Flag notifications