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

s390x: galera.galera_FK_duplicate_client_insert fails on assertion "thr_get_trx(thr)->error_state == DB_SUCCESS" in que_thr_step

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.8
    • 11.8
    • None
    • Linux rhel-10-0-5 6.12.0-55.9.1.el10_0.s390x #1 SMP Tue Mar 25 15:23:49 EDT 2025 s390x GNU/Linux
      gcc (GCC) 14.2.1 20250110 (Red Hat 14.2.1-7)

    Description

      11.8 01ff5ae6b677bead4c41d91bf5afb25c593a1d02 debug, galera-enterprise-26.4.24

      perl ./mtr galera.galera_FK_duplicate_client_insert
      ...
       
      #7  0x000002aa250a53cc in ut_dbg_assertion_failed (expr=0x2aa2594693e "thr_get_trx(thr)->error_state == DB_SUCCESS", file=0x2aa2594660c "/home/cloud-user/11.8/storage/innobase/que/que0que.cc", line=577) at /home/cloud-user/11.8/storage/innobase/ut/ut0dbg.cc:60
      #8  0x000002aa24ef67c8 in que_thr_step (thr=0x3ff400226d0) at /home/cloud-user/11.8/storage/innobase/que/que0que.cc:577
      #9  0x000002aa24ef6970 in que_run_threads_low (thr=0x3ff400226d0) at /home/cloud-user/11.8/storage/innobase/que/que0que.cc:609
      #10 0x000002aa24ef6af4 in que_run_threads (thr=0x3ff400226d0) at /home/cloud-user/11.8/storage/innobase/que/que0que.cc:629
      #11 0x000002aa2506eb44 in trx_t::rollback_low (this=0x3ffa69fde00, savept=0x0) at /home/cloud-user/11.8/storage/innobase/trx/trx0roll.cc:119
      #12 0x000002aa2506f316 in trx_t::rollback (this=0x3ffa69fde00, savept=0x0) at /home/cloud-user/11.8/storage/innobase/trx/trx0roll.cc:183
      #13 0x000002aa24f8f136 in row_mysql_handle_errors (new_err=0x3ffa44b1a3c, trx=0x3ffa69fde00, thr=0x3ff4003aae8, savept=0x3ffa44b1a48) at /home/cloud-user/11.8/storage/innobase/row/row0mysql.cc:714
      #14 0x000002aa24f91074 in row_insert_for_mysql (mysql_rec=0x3ff400305a8 "\371\002", prebuilt=0x3ff4003a400, ins_mode=ROW_INS_NORMAL) at /home/cloud-user/11.8/storage/innobase/row/row0mysql.cc:1311
      #15 0x000002aa24cd52f2 in ha_innobase::write_row (this=0x3ff4002fd50, record=0x3ff400305a8 "\371\002") at /home/cloud-user/11.8/storage/innobase/handler/ha_innodb.cc:7757
      #16 0x000002aa2475990e in handler::ha_write_row (this=0x3ff4002fd50, buf=0x3ff400305a8 "\371\002") at /home/cloud-user/11.8/sql/handler.cc:8260
      #17 0x000002aa241a0db0 in Write_record::single_insert (this=0x3ffa44b2368, inserted=0x3ffa44b20b8) at /home/cloud-user/11.8/sql/sql_insert.cc:2370
      #18 0x000002aa241a102a in Write_record::write_record (this=0x3ffa44b2368) at /home/cloud-user/11.8/sql/sql_insert.cc:2412
      #19 0x000002aa2419c856 in mysql_insert (thd=0x3ff400020b8, table_list=0x3ff40017f28, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /home/cloud-user/11.8/sql/sql_insert.cc:1230
      #20 0x000002aa24211006 in mysql_execute_command (thd=0x3ff400020b8, is_called_from_prepared_stmt=false) at /home/cloud-user/11.8/sql/sql_parse.cc:4496
      #21 0x000002aa2421e1a8 in mysql_parse (thd=0x3ff400020b8, rawbuf=0x3ff40017e00 "insert into user_session(id,fk1,fk2) values (2, 2, 2)", length=53, parser_state=0x3ffa44b3078) at /home/cloud-user/11.8/sql/sql_parse.cc:7953
      #22 0x000002aa2421d730 in wsrep_mysql_parse (thd=0x3ff400020b8, rawbuf=0x3ff40017e00 "insert into user_session(id,fk1,fk2) values (2, 2, 2)", length=53, parser_state=0x3ffa44b3078) at /home/cloud-user/11.8/sql/sql_parse.cc:7763
      #23 0x000002aa2420798e in dispatch_command (command=COM_QUERY, thd=0x3ff400020b8, packet=0x3ff4000d139 "insert into user_session(id,fk1,fk2) values (2, 2, 2)", packet_length=53, blocking=true) at /home/cloud-user/11.8/sql/sql_parse.cc:1908
      #24 0x000002aa24206096 in do_command (thd=0x3ff400020b8, blocking=true) at /home/cloud-user/11.8/sql/sql_parse.cc:1431
      #25 0x000002aa2446db78 in do_handle_one_connection (connect=0x2aa2999e2c8, put_in_cache=true) at /home/cloud-user/11.8/sql/sql_connect.cc:1504
      #26 0x000002aa2446d784 in handle_one_connection (arg=0x2aa2999e2c8) at /home/cloud-user/11.8/sql/sql_connect.cc:1416
      #27 0x000002aa24b83e06 in pfs_spawn_thread (arg=0x2aa29a11e08) at /home/cloud-user/11.8/storage/perfschema/pfs.cc:2198
      #28 0x000003ffb42aba68 in start_thread () from /lib64/libc.so.6
      

      It fails for me most of the time, but I've seen it pass at least once, so the failure is non-deterministic.
      I didn't check other versions so far.

      Attachments

        Activity

          People

            Unassigned Unassigned
            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.