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

Server crashes after upgrade when running sysbench OLTP data load.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4
    • Fix Version/s: 10.4
    • Component/s: Upgrades
    • Labels:

      Description

      my.cnf
      [mysqld]
      innodb_file_per_table
      innodb_autoinc_lock_mode=2
      innodb_flush_log_at_trx_commit=0
      core-file
      general_log=ON
      #log-output=none
      #wsrep_slave_threads=10
      binlog_format=ROW
      gtid_domain_id=10
      slave_parallel_threads=4
      #general_log
      port=5300
      datadir = /home/ramesh/framework/data
      socket = /home/ramesh/framework/data/mysql.sock
      log_error = /home/ramesh/framework/data/node1.err
      server_id=11
       
       
      LOWER_BASE=/home/ramesh/framework/MD050922-mariadb-10.3.37-linux-x86_64-dbg
      UPPER_BASE=/home/ramesh/framework/MD050922-mariadb-10.4.27-linux-x86_64-dbg
       
      ${LOWER_BASE}/scripts/mysql_install_db --no-defaults --force --auth-root-authentication-method=normal --basedir=${LOWER_BASE} --datadir=/home/ramesh/framework/data
       
       
      ${LOWER_BASE}/bin/mysqld --defaults-file=/home/ramesh/framework/conf/my.cnf  --basedir=${LOWER_BASE} &
       
      ${LOWER_BASE}/bin/mysql --user=root --socket=/home/ramesh/framework/data/mysql.sock -e"drop database if exists test; create database test;" > /dev/null 2>&1
      ${LOWER_BASE}/bin/mysql --user=root --socket=/home/ramesh/framework/data/mysql.sock -e"create user if not exists sysbench@'localhost' identified  by 'sysbench';grant all on *.* to sysbench@'localhost';" > /dev/null 2>&1
       
      sysbench /usr/share/sysbench/oltp_insert.lua --table-size=1000 --tables=10 --threads=10 --mysql-db=test  --mysql-user=sysbench --mysql-password=sysbench --db-driver=mysql  --mysql-socket=/home/ramesh/framework/data/mysql.sock prepare 
       
      ${LOWER_BASE}/bin/mysqladmin --user=root --socket=/home/ramesh/framework/data/mysql.sock shutdown
       
      ${UPPPER_BASE}/bin/mysqld --defaults-file=/home/ramesh/framework/conf/my.cnf  --basedir=${UPPPER_BASE} 2>&1 &
       
      ${UPPPER_BASE}/bin/mysql_upgrade -uroot --socket=/home/ramesh/framework/data/mysql.sock --skip-write-binlog 
       
      sysbench /usr/share/sysbench/oltp_read_write.lua --table-size=1000 --tables=10 --threads=10 --mysql-db=test  --mysql-user=sysbench --mysql-password=sysbench --db-driver=mysql  --mysql-socket=/home/ramesh/framework/data/mysql.sock --time=100 --db-ps-mode=disable run 
      

      Leads to

      10.4.27 2917bd0d2cf417cbf9c83b64ae2b7806bdb2f34e (Debug)

      Core was generated by `/home/ramesh/framework/MD050922-mariadb-10.4.27-linux-x86_64-dbg/bin/mysqld --d'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      [Current thread is 1 (Thread 0x153b513ab700 (LWP 2369850))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x0000153b6c064859 in __GI_abort () at abort.c:79
      #2  0x0000153b6c064729 in __assert_fail_base (fmt=0x153b6c1fa588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55de21fa3570 "!rec_get_deleted_flag(rec, comp)", file=0x55de21fa1c88 "/test/10.4_dbg/storage/innobase/row/row0sel.cc", line=4510, function=<optimized out>) at assert.c:92
      #3  0x0000153b6c075fd6 in __GI___assert_fail (assertion=assertion@entry=0x55de21fa3570 "!rec_get_deleted_flag(rec, comp)", file=file@entry=0x55de21fa1c88 "/test/10.4_dbg/storage/innobase/row/row0sel.cc", line=line@entry=4510, function=function@entry=0x55de21fa33c0 "dberr_t row_search_mvcc(byte*, page_cur_mode_t, row_prebuilt_t*, ulint, ulint)") at assert.c:101
      #4  0x000055de218ed6ec in row_search_mvcc (buf=buf@entry=0x153b00102248 "\377", mode=mode@entry=PAGE_CUR_GE, prebuilt=0x153b001a2fc0, match_mode=match_mode@entry=1, direction=direction@entry=0) at /test/10.4_dbg/storage/innobase/row/row0sel.cc:4510
      #5  0x000055de2170827e in ha_innobase::index_read (this=0x153b00177dd0, buf=0x153b00102248 "\377", key_ptr=<optimized out>, key_len=<optimized out>, find_flag=<optimized out>) at /test/10.4_dbg/storage/innobase/handler/ha_innodb.cc:9396
      #6  0x000055de213d9b7d in handler::index_read_map (this=0x153b00177dd0, buf=0x153b00102248 "\377", key=0x153adc015b30 "\364\001", keypart_map=<optimized out>, find_flag=HA_READ_KEY_EXACT) at /test/10.4_dbg/sql/handler.h:3599
      #7  0x000055de213c4b1d in handler::index_read_idx_map (this=0x153b00177dd0, buf=0x153b00102248 "\377", index=0, key=0x153adc015b30 "\364\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /test/10.4_dbg/sql/handler.cc:6149
      #8  0x000055de213cab31 in handler::ha_index_read_idx_map (this=0x153b00177dd0, buf=0x153b00102248 "\377", index=0, key=0x153adc015b30 "\364\001", keypart_map=1, find_flag=find_flag@entry=HA_READ_KEY_EXACT) at /test/10.4_dbg/sql/handler.cc:2976
      #9  0x000055de211a03e5 in join_read_const (tab=tab@entry=0x153adc0148c8) at /test/10.4_dbg/sql/sql_select.cc:21265
      #10 0x000055de211a056a in join_read_const_table (thd=0x153adc000d28, tab=tab@entry=0x153adc0148c8, pos=0x153adc014e78) at /test/10.4_dbg/sql/sql_select.cc:21143
      #11 0x000055de211ab42e in make_join_statistics (join=join@entry=0x153adc013f60, tables_list=@0x153adc0127d0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x153adc0144d0, last = 0x153adc0144d0, elements = 1}, <No data fields>}, keyuse_array=keyuse_array@entry=0x153adc014250) at /test/10.4_dbg/sql/sql_select.cc:5368
      #12 0x000055de211bb58e in JOIN::optimize_inner (this=this@entry=0x153adc013f60) at /test/10.4_dbg/sql/sql_select.cc:2333
      #13 0x000055de211bb9e8 in JOIN::optimize (this=this@entry=0x153adc013f60) at /test/10.4_dbg/sql/sql_select.cc:1676
      #14 0x000055de211bc38c in mysql_select (thd=thd@entry=0x153adc000d28, tables=0x153adc012b80, wild_num=0, fields=@0x153adc0126e0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x153adc012b38, last = 0x153adc012b38, elements = 1}, <No data fields>}, conds=0x153adc013410, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x153adc013f38, unit=0x153adc004ac0, select_lex=0x153adc012598) at /test/10.4_dbg/sql/sql_select.cc:4772
      #15 0x000055de211bc68d in handle_select (thd=thd@entry=0x153adc000d28, lex=lex@entry=0x153adc004a00, result=result@entry=0x153adc013f38, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.4_dbg/sql/sql_select.cc:436
      #16 0x000055de21137795 in execute_sqlcom_select (thd=thd@entry=0x153adc000d28, all_tables=0x153adc012b80) at /test/10.4_dbg/sql/sql_parse.cc:6450
      #17 0x000055de21141c08 in mysql_execute_command (thd=thd@entry=0x153adc000d28) at /test/10.4_dbg/sql/sql_parse.cc:3964
      #18 0x000055de2114c081 in mysql_parse (thd=thd@entry=0x153adc000d28, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x153b513aa3f0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:7996
      #19 0x000055de2114eb7b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x153adc000d28, packet=packet@entry=0x153adc00a189 "SELECT c FROM sbtest5 WHERE id=500", packet_length=packet_length@entry=34, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_class.h:1207
      #20 0x000055de211515f5 in do_command (thd=0x153adc000d28) at /test/10.4_dbg/sql/sql_parse.cc:1378
      #21 0x000055de212721c3 in do_handle_one_connection (connect=<optimized out>) at /test/10.4_dbg/sql/sql_connect.cc:1420
      #22 0x000055de21272283 in handle_one_connection (arg=<optimized out>) at /test/10.4_dbg/sql/sql_connect.cc:1316
      #23 0x0000153b6c575609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #24 0x0000153b6c161133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            ramesh Ramesh Sivaraman
            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.