Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4801

[PS8QA] CREATE COMPRESSION_DICTIONARY d0(@data) crash | InnoDB: Assertion failure: ha_innodb.cc:4926:0

Details

    • Bug
    • Status: Done
    • Critical
    • Resolution: Duplicate
    • None
    • None
    • None

    Description

      CREATE COMPRESSION_DICTIONARY d0(@data);
      

      or

      CREATE COMPRESSION_DICTIONARY dict('');
      

      Leads to

      2018-09-01T00:16:06.317688Z 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-01T00:16:26.384338Z 9 [ERROR] [MY-000000] [InnoDB] InnoDB: Assertion failure: ha_innodb.cc:4926:0
      
      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.
      [Current thread is 1 (Thread 0x7fb9a153d700 (LWP 30927))]
      (gdb) bt
      #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1 0x000055d033018797 in my_write_core (sig=sig@entry=6) at stacktrace.cc:278
      #2 0x000055d0321ef825 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 0x00007fb9a157e801 in __GI_abort () at abort.c:79
      #6 0x000055d03338dcb3 in ut_dbg_assertion_failed (expr=expr@entry=0x55d0337193cc "0", 
      file=file@entry=0x55d033746d40 "handler/ha_innodb.cc", line=line@entry=4926) at ut/ut0dbg.cc:90
      #7 0x000055d03318390c in innobase_create_zip_dict (hton=<optimized out>, thd=<optimized out>, name=<optimized out>, 
      name_len=<optimized out>, data=<optimized out>, data_len=<optimized out>) at handler/ha_innodb.cc:4926
      #8 0x000055d03218f284 in mysql_create_zip_dict (thd=thd@entry=0x7fb91fc17000, name=0x7fb91fc639e0 "d0", name_len=2, 
      data=0x55d033714328 "", data_len=0, if_not_exists=<optimized out>) at sql_zip_dict.cc:71
      #9 0x000055d0320c3d08 in mysql_execute_command (thd=thd@entry=0x7fb91fc17000, first_level=first_level@entry=true)
      at sql_parse.cc:3565
      #10 0x000055d0320c917b in mysql_parse (thd=thd@entry=0x7fb91fc17000, parser_state=parser_state@entry=0x7fb9a153bd40, 
      update_userstat=update_userstat@entry=false) at sql_parse.cc:5139
      #11 0x000055d0320cbf42 in dispatch_command (thd=thd@entry=0x7fb91fc17000, com_data=com_data@entry=0x7fb9a153cc60, 
      command=COM_QUERY) at sql_parse.cc:1654
      #12 0x000055d0320ccc79 in do_command (thd=thd@entry=0x7fb91fc17000) at sql_parse.cc:1262
      #13 0x000055d0321e0ec0 in handle_connection (arg=arg@entry=0x7fb91f45e730) at conn_handler/connection_handler_per_thread.cc:317
      #14 0x000055d0330e113f in pfs_spawn_thread (arg=0x7fb958bd2a20) at pfs.cc:2836
      #15 0x00007fb9a31876db in start_thread (arg=0x7fb9a153d700) at pthread_create.c:463
      #16 0x00007fb9a165f88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      At commit

      3090827ad35245f98c2054afbac6eb6293852924

      In optimized/release build

      Attachments

        Issue Links

          Activity

            People

              satya.bodapati Satya Bodapati
              roel.vandepaar Roel Van de Paar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 26 minutes
                  26m

                  Smart Checklist