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

Server crash in row_ins_foreign_report_add_err

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      Server crash found on release build

      origin/11.8 e0428264d0095472c015eb58c46be68ca1a320ee

      Thread 3 received signal SIGSEGV, Segmentation fault.
      [Switching to Thread 1165486.1169076]
      0x0000555556301e7d in fprintf (__fmt=0x5555566d3738 ", in index %s,\nthe closest match we can find is record:\n", __stream=0x472f04406710) at /usr/include/x86_64-linux-gnu/bits/stdio2.h:79
      79        return __fprintf_chk (__stream, __USE_FORTIFY_LEVEL - 1, __fmt,
      (rr) set print addr off
      (rr) bt
      #0  fprintf (__fmt=", in index %s,\nthe closest match we can find is record:\n", __stream=) at /usr/include/x86_64-linux-gnu/bits/stdio2.h:79
      #1  row_ins_foreign_report_add_err (trx=trx@entry=, foreign=foreign@entry=, rec=rec@entry="\200", entry=entry@entry=) at /data/Server/11.8_new/storage/innobase/row/row0ins.cc:841
      #2  row_ins_check_foreign_constraint (check_ref=check_ref@entry=1, foreign=foreign@entry=, table=table@entry=, entry=<optimized out>, thr=thr@entry=) at /data/Server/11.8_new/storage/innobase/row/row0ins.cc:1799
      #3  row_ins_check_foreign_constraints (table=, index=index@entry=, pk=pk@entry=true, entry=entry@entry=, thr=thr@entry=) at /data/Server/11.8_new/storage/innobase/row/row0ins.cc:1956
      #4  row_ins_clust_index_entry (index=, entry=entry@entry=, thr=thr@entry=, n_ext=n_ext@entry=0) at /data/Server/11.8_new/storage/innobase/row/row0ins.cc:3281
      #5  row_ins_index_entry (thr=, entry=<optimized out>, index=<optimized out>) at /data/Server/11.8_new/storage/innobase/row/row0ins.cc:3466
      #6  row_ins_index_entry_step (thr=<optimized out>, node=<optimized out>) at /data/Server/11.8_new/storage/innobase/row/row0ins.cc:3632
      #7  row_ins (thr=, node=<optimized out>) at /data/Server/11.8_new/storage/innobase/row/row0ins.cc:3749
      #8  row_ins_step (thr=thr@entry=) at /data/Server/11.8_new/storage/innobase/row/row0ins.cc:3878
      #9  row_insert_for_mysql (mysql_rec=mysql_rec@entry="\342\a", prebuilt=, ins_mode=ROW_INS_NORMAL) at /data/Server/11.8_new/storage/innobase/row/row0mysql.cc:1300
      #10 ha_innobase::write_row (this=, record="\342\a") at /data/Server/11.8_new/storage/innobase/handler/ha_innodb.cc:7773
      #11 handler::ha_write_row (this=, buf="\342\a") at /data/Server/11.8_new/sql/handler.cc:8234
      #12 Write_record::single_insert (this=this@entry=, inserted=inserted@entry=) at /data/Server/11.8_new/sql/sql_insert.cc:2370
      #13 Write_record::write_record (this=this@entry=) at /data/Server/11.8_new/sql/sql_insert.cc:2412
      #14 mysql_insert (thd=thd@entry=, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=<optimized out>, result=)
          at /data/Server/11.8_new/sql/sql_insert.cc:1230
      #15 mysql_execute_command (thd=thd@entry=, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/11.8_new/sql/sql_parse.cc:4480
      #16 mysql_parse (thd=, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/Server/11.8_new/sql/sql_parse.cc:7909
      #17 dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=, 
          packet=packet@entry=" INSERT INTO test.t1_c (col1,col2, col_int, col_string, col_text) VALUES ( 7, 7, 7, REPEAT(SUBSTR(CAST( 7 AS CHAR),1,1), 10), REPEAT(SUBSTR(CAST( 7 AS CHAR),1,1), @fill_amount) ) /* E_R Th
      read4 QNO 52"..., packet_length=packet_length@entry=215, blocking=blocking@entry=true) at /data/Server/11.8_new/sql/sql_parse.cc:2002
      #18 do_command (thd=thd@entry=, blocking=blocking@entry=true) at /data/Server/11.8_new/sql/sql_parse.cc:1416
      #19 do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /data/Server/11.8_new/sql/sql_connect.cc:1504
      #20 handle_one_connection (arg=) at /data/Server/11.8_new/sql/sql_connect.cc:1416
      #21 start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
      #22 clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      

      RR trace is present on SDP:
      /data/results/1762768446/TBR-2342

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              saahil Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.