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

void trx_flush_log_if_needed(lsn_t, trx_t*): Assertion srv_flush_log_at_trx_commit' failed

    XMLWordPrintable

Details

    Description

      Assertion found on debug build
      Leads to :-

      GIT_SHOW: HEAD -> 10.11, origin/bb-10.11-MDEV-26115, origin/10.11 852e4510fa662c571a42f550278d4abd09e3c5cf 2025-07-23T09:34:47+07:00

      # 2025-07-23T15:28:07 [1944694] | mariadbd: /data/Server/10.11_new/storage/innobase/trx/trx0trx.cc:1244: void trx_flush_log_if_needed(lsn_t, trx_t*): Assertion `srv_flush_log_at_trx_commit' failed.
      

      Stacktrace

      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=140085222266432) at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=140085222266432) at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=140085222266432, signo=6) at ./nptl/pthread_kill.c:89
      #3  my_write_core (sig=6) at /data/Server/10.11_new/mysys/stacktrace.c:424
      #4  handle_fatal_signal (sig=6) at /data/Server/10.11_new/sql/signal_handler.cc:298
      #5  <signal handler called>
      #6  __pthread_kill_implementation (no_tid=0, signo=6, threadid=140085222266432) at ./nptl/pthread_kill.c:44
      #7  __pthread_kill_internal (signo=6, threadid=140085222266432) at ./nptl/pthread_kill.c:78
      #8  __GI___pthread_kill (threadid=140085222266432, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
      #9  __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      #10 __GI_abort () at ./stdlib/abort.c:79
      #11 __assert_fail_base (fmt="%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion="srv_flush_log_at_trx_commit", file="/data/Server/10.11_new/storage/innobase/trx/trx0trx.cc",
          line=1244, function=<optimized out>) at ./assert/assert.c:92
      #12 __GI___assert_fail (assertion="srv_flush_log_at_trx_commit", file="/data/Server/10.11_new/storage/innobase/trx/trx0trx.cc", line=1244,
          function="void trx_flush_log_if_needed(lsn_t, trx_t*)") at ./assert/assert.c:101
      #13 trx_flush_log_if_needed (lsn=4109993, trx=) at /data/Server/10.11_new/storage/innobase/trx/trx0trx.cc:1244
      #14 trx_commit_complete_for_mysql (trx=trx@entry=) at /data/Server/10.11_new/storage/innobase/trx/trx0trx.cc:1745
      #15 innobase_commit (hton=<optimized out>, thd=thd@entry=, commit_trx=commit_trx@entry=true) at /data/Server/10.11_new/storage/innobase/handler/ha_innodb.cc:4591
      #16 ha_innobase::external_lock (this=, thd=, lock_type=2) at /data/Server/10.11_new/storage/innobase/handler/ha_innodb.cc:16355
      #17 handler::ha_external_lock (this=, thd=thd@entry=, lock_type=lock_type@entry=2) at /data/Server/10.11_new/sql/handler.cc:7282
      #18 handler::ha_external_unlock (thd=, this=<optimized out>) at /data/Server/10.11_new/sql/handler.h:3476
      #19 unlock_external (thd=thd@entry=, table=table@entry=, count=count@entry=1) at /data/Server/10.11_new/sql/lock.cc:744
      #20 mysql_unlock_read_tables (thd=, sql_lock=) at /data/Server/10.11_new/sql/lock.cc:497
      #21 JOIN::join_free (this=this@entry=) at /data/Server/10.11_new/sql/sql_select.cc:15881
      #22 do_select (join=join@entry=, procedure=<optimized out>) at /data/Server/10.11_new/sql/sql_select.cc:22587
      #23 JOIN::exec_inner (this=this@entry=) at /data/Server/10.11_new/sql/sql_select.cc:4985
      #24 JOIN::exec (this=this@entry=) at /data/Server/10.11_new/sql/sql_select.cc:4769
      #25 mysql_select (thd=thd@entry=, tables=, fields=..., conds=, og_num=1, order=, group=, having=, proc_param=, select_options=2164525825, result=, unit=, select_lex=)
          at /data/Server/10.11_new/sql/sql_select.cc:5243
      #26 handle_select (thd=thd@entry=, lex=lex@entry=, result=result@entry=, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/Server/10.11_new/sql/sql_select.cc:600
      #27 execute_sqlcom_select (thd=thd@entry=, all_tables=) at /data/Server/10.11_new/sql/sql_parse.cc:6425
      #28 mysql_execute_command (thd=thd@entry=, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/10.11_new/sql/sql_parse.cc:4008
      #29 mysql_parse (thd=thd@entry=, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=) at /data/Server/10.11_new/sql/sql_parse.cc:8178
      #30 dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=, packet=packet@entry="", packet_length=packet_length@entry=119, blocking=blocking@entry=true)
          at /data/Server/10.11_new/sql/sql_parse.cc:1906
      #31 do_command (thd=thd@entry=, blocking=blocking@entry=true) at /data/Server/10.11_new/sql/sql_parse.cc:1419
      #32 do_handle_one_connection (connect=<optimized out>, connect@entry=, put_in_cache=put_in_cache@entry=true) at /data/Server/10.11_new/sql/sql_connect.cc:1386
      #33 handle_one_connection (arg=) at /data/Server/10.11_new/sql/sql_connect.cc:1298
      #34 start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #35 clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Core dump is present on pluto :-
      /data/results/1753268478/TBR-2308

      Attachments

        Activity

          People

            marko Marko Mäkelä
            saahil Saahil Alam
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: