Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15487

[Draft] Server crashed in TABLE::init

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2(EOL)
    • None
    • Server
    • None

    Description

      10.2 8f98835bb86550

      #3  <signal handler called>
      #4  0x0000562a88f59dae in TABLE::init (this=0x7fe3980ffe00, thd=0x7fe364000b00, tl=0x7fe364027c30) at /home/elenst/10.2/sql/table.cc:4503
      #5  0x0000562a88de3360 in open_table (thd=0x7fe364000b00, table_list=0x7fe364027c30, ot_ctx=0x7fe3ec0c9260) at /home/elenst/10.2/sql/sql_base.cc:1938
      #6  0x0000562a88de5bb2 in open_and_process_table (thd=0x7fe364000b00, lex=0x7fe3640045e0, tables=0x7fe364027c30, counter=0x7fe3ec0c92f4, flags=0, prelocking_strategy=0x7fe3ec0c9378, has_prelocking_list=false, ot_ctx=0x7fe3ec0c9260) at /home/elenst/10.2/sql/sql_base.cc:3409
      #7  0x0000562a88de6d55 in open_tables (thd=0x7fe364000b00, options=..., start=0x7fe3ec0c92d8, counter=0x7fe3ec0c92f4, flags=0, prelocking_strategy=0x7fe3ec0c9378) at /home/elenst/10.2/sql/sql_base.cc:3926
      #8  0x0000562a88de8506 in open_and_lock_tables (thd=0x7fe364000b00, options=..., tables=0x7fe364027c30, derived=true, flags=0, prelocking_strategy=0x7fe3ec0c9378) at /home/elenst/10.2/sql/sql_base.cc:4682
      #9  0x0000562a88ddb9f7 in open_and_lock_tables (thd=0x7fe364000b00, tables=0x7fe364027c30, derived=true, flags=0) at /home/elenst/10.2/sql/sql_base.h:494
      #10 0x0000562a88e2f2d1 in mysql_insert (thd=0x7fe364000b00, table_list=0x7fe364027c30, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /home/elenst/10.2/sql/sql_insert.cc:758
      #11 0x0000562a88e574a3 in mysql_execute_command (thd=0x7fe364000b00) at /home/elenst/10.2/sql/sql_parse.cc:4416
      #12 0x0000562a88e626fc in mysql_parse (thd=0x7fe364000b00, rawbuf=0x7fe3640279a8 "INSERT INTO `table1_innodb_key_pk_parts_2_int_autoinc` ( `col_int_unsigned_key_default_null` ) VALUES ( 3 )  /* QNO 176 CON_ID 21 */", length=132, parser_state=0x7fe3ec0ca250, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:7902
      #13 0x0000562a88e50386 in dispatch_command (command=COM_QUERY, thd=0x7fe364000b00, packet=0x7fe364008a51 "INSERT INTO `table1_innodb_key_pk_parts_2_int_autoinc` ( `col_int_unsigned_key_default_null` ) VALUES ( 3 )  /* QNO 176 CON_ID 21 */", packet_length=132, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:1806
      #14 0x0000562a88e4ed22 in do_command (thd=0x7fe364000b00) at /home/elenst/10.2/sql/sql_parse.cc:1359
      #15 0x0000562a88f9c17d in do_handle_one_connection (connect=0x562a8beee660) at /home/elenst/10.2/sql/sql_connect.cc:1335
      #16 0x0000562a88f9befd in handle_one_connection (arg=0x562a8beee660) at /home/elenst/10.2/sql/sql_connect.cc:1241
      #17 0x00007fe40b96b6da in start_thread (arg=0x7fe3ec0cb700) at pthread_create.c:456
      #18 0x00007fe40adfdd7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105
      

      180306 16:03:34 [ERROR] mysqld got signal 11 ;
       
      Query (0x7fe3640279a8): INSERT INTO `table1_innodb_key_pk_parts_2_int_autoinc` ( `col_int_unsigned_key_default_null` ) VALUES ( 3 )  /* QNO 176 CON_ID 21 */
      Connection ID (thread ID): 23
      Status: NOT_KILLED
      

      I got it while running the attached test as

      /home/elenst/10.2/mysql-test/mysql-test-run.pl  --default-server-options --mem --mysqld=--sql-mode= --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --nowarnings --repeat=20 --suite=bug local3
      

      Attachments

        1. local3.test
          960 kB
          Elena Stepanova
        2. threads
          48 kB
          Elena Stepanova

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.