Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 5.7.x
    • Fix Version/s: None
    • Component/s: TokuDB
    • Labels:
      None

      Description

      sql:

      # mysqld options required for replay: --plugin-load=TokuDB=ha_tokudb.so
      CREATE DATABASE test;
      USE test;
      set @@global.max_user_connections=@@local.max_join_size,@@local.max_join_size=@@global.max_user_connections;
      set session default_storage_engine='TokuDB';
      CREATE TABLE t1(a int,b int,KEY (a));
      SELECT 1 as foo FROM t1 WHERE a<SOME(SELECT a FROM t1 WHERE a<=>(SELECT a FROM t1 where a is null));
      

      gdb:

      Core was generated by `/sdc/PS071119-percona-server-5.7.28-31-linux-x86_64-debug/bin/mysqld --no-defau'.
      Program terminated with signal 6, Aborted.
      #0  0x00007f4f59307a61 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:59
      59        val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
      (gdb) bt
      +bt
      #0  0x00007f4f59307a61 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:59
      #1  0x000000000191dbc2 in my_write_core (sig=6) at /sdc/release-5.7.28-31_dbg/mysys/stacktrace.c:261
      #2  0x000000000169474b in handle_fatal_signal (sig=6) at /sdc/release-5.7.28-31_dbg/sql/signal_handler.cc:230
      #3  <signal handler called>
      #4  0x00007f4f57409337 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:55
      #5  0x00007f4f5740aa28 in __GI_abort () at abort.c:90
      #6  0x00007f4f57402156 in __assert_fail_base (fmt=0x7f4f5755dbe0 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x20316dc "join == __null", file=file@entry=0x2031420 "/sdc/release-5.7.28-31_dbg/sql/sql_select.cc", line=line@entry=1011, function=function@entry=0x2032360 <st_select_lex::optimize
      (THD*)::__PRETTY_FUNCTION__> "bool st_select_lex::optimize(THD*)") at assert.c:92
      #7  0x00007f4f57402202 in __GI___assert_fail (assertion=0x20316dc "join == __null", file=0x2031420 "/sdc/release-5.7.28-31_dbg/sql/sql_select.cc", line=1011, function=0x2032360 <st_select_lex::optimize(THD*)::__PRETTY_FUNCTION__> "bool st_select_lex::optimize(THD*)") at assert.c:101
      #8  0x000000000159752e in st_select_lex::optimize (this=0x7f4ec7ccd3b8, thd=0x7f4ec7c19000) at /sdc/release-5.7.28-31_dbg/sql/sql_select.cc:1011
      #9  0x00000000015fc4bd in st_select_lex_unit::optimize (this=0x7f4ec7ccd6a0, thd=0x7f4ec7c19000) at /sdc/release-5.7.28-31_dbg/sql/sql_union.cc:711
      #10 0x0000000001597608 in st_select_lex::optimize (this=0x7f4ec7c28c90, thd=0x7f4ec7c19000) at /sdc/release-5.7.28-31_dbg/sql/sql_select.cc:1024
      #11 0x00000000015fc4bd in st_select_lex_unit::optimize (this=0x7f4ec7ccc5b8, thd=0x7f4ec7c19000) at /sdc/release-5.7.28-31_dbg/sql/sql_union.cc:711
      #12 0x0000000001597608 in st_select_lex::optimize (this=0x7f4ec7c27100, thd=0x7f4ec7c19000) at /sdc/release-5.7.28-31_dbg/sql/sql_select.cc:1024
      #13 0x0000000001595cda in handle_query (thd=0x7f4ec7c19000, lex=0x7f4ec7c1b6b0, result=0x7f4ec7ccdfc8, added_options=0, removed_options=0) at /sdc/release-5.7.28-31_dbg/sql/sql_select.cc:172
      #14 0x000000000154998b in execute_sqlcom_select (thd=0x7f4ec7c19000, all_tables=0x7f4ec7ccc030) at /sdc/release-5.7.28-31_dbg/sql/sql_parse.cc:5490
      #15 0x000000000154297d in mysql_execute_command (thd=0x7f4ec7c19000, first_level=true) at /sdc/release-5.7.28-31_dbg/sql/sql_parse.cc:3016
      #16 0x000000000154a918 in mysql_parse (thd=0x7f4ec7c19000, parser_state=0x7f4f598f7440, update_userstat=false) at /sdc/release-5.7.28-31_dbg/sql/sql_parse.cc:5927
      #17 0x000000000153f2a2 in dispatch_command (thd=0x7f4ec7c19000, com_data=0x7f4f598f7c70, command=COM_QUERY) at /sdc/release-5.7.28-31_dbg/sql/sql_parse.cc:1539
      #18 0x000000000153e0c3 in do_command (thd=0x7f4ec7c19000) at /sdc/release-5.7.28-31_dbg/sql/sql_parse.cc:1060
      #19 0x00000000016710f2 in handle_connection (arg=0x7f4f3cffeac0) at /sdc/release-5.7.28-31_dbg/sql/conn_handler/connection_handler_per_thread.cc:325
      #20 0x00000000019418ae in pfs_spawn_thread (arg=0x7f4f55418b20) at /sdc/release-5.7.28-31_dbg/storage/perfschema/pfs.cc:2198
      #21 0x00007f4f59302e65 in start_thread (arg=0x7f4f598f8700) at pthread_create.c:307
      #22 0x00007f4f574d188d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      (gdb) quit
      

      Reproduced with 5.7.28-31 debug build (can't reproduce on the release build).

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                hrvoje.matijakovic Hrvoje Matijakovic
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: