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

Mysqld crash in alter_stats_rebuild

    XMLWordPrintable

Details

    Description

      Please check this  crash if its related:-
      Commit id:-origin/MDEV-37152 366233ebd3135c52d93f41623db1f8e1f984e97f
       
      # 2025-09-24T02:08:23 [3165712] Thread 1 (Thread 0x7c012c22d6c0 (LWP 3172473)):
      # 2025-09-24T02:08:23 [3165712] #0  __pthread_kill_implementation (no_tid=0, signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
      # 2025-09-24T02:08:23 [3165712] #1  __pthread_kill_internal (signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
      # 2025-09-24T02:08:23 [3165712] #2  __GI___pthread_kill (threadid=<optimized out>, signo=11) at ./nptl/pthread_kill.c:89
      # 2025-09-24T02:08:23 [3165712] #3  0x00005cf46bd2112c in my_write_core (sig=11) at /data/Server/MDEV-37152/mysys/stacktrace.c:424
      # 2025-09-24T02:08:23 [3165712] #4  0x00005cf46b7c3262 in handle_fatal_signal (sig=11) at /data/Server/MDEV-37152/sql/signal_handler.cc:298
      # 2025-09-24T02:08:23 [3165712] #5  <signal handler called>
      # 2025-09-24T02:08:23 [3165712] #6  THD::get_stmt_da (this=0x0) at /data/Server/MDEV-37152/sql/sql_class.h:4680
      # 2025-09-24T02:08:23 [3165712] #7  THD::raise_condition (this=this@entry=0x0, sql_errno=sql_errno@entry=1088, sqlstate=sqlstate@entry=0x5cf46bfc5437 "", level=level@entry=Sql_state_errno_level::WARN_LEVEL_WARN, msg=msg@entry=0x7c012c228220 "Error updating stats for table 't9' after table rebuild: Lock wait timeout") at /data/Server/MDEV-37152/sql/sql_class.h:5169
      # 2025-09-24T02:08:23 [3165712] #8  0x00005cf46b4fc510 in push_warning (thd=thd@entry=0x0, level=level@entry=Sql_state_errno_level::WARN_LEVEL_WARN, code=code@entry=1088, msg=msg@entry=0x7c012c228220 "Error updating stats for table 't9' after table rebuild: Lock wait timeout") at /data/Server/MDEV-37152/sql/sql_error.cc:755
      # 2025-09-24T02:08:23 [3165712] #9  0x00005cf46b4fc719 in push_warning_printf (thd=0x0, level=level@entry=Sql_state_errno_level::WARN_LEVEL_WARN, code=code@entry=1088, format=format@entry=0x5cf46beb23b8 "Error updating stats for table '%s' after table rebuild: %s") at /data/Server/MDEV-37152/sql/sql_error.cc:790
      # 2025-09-24T02:08:23 [3165712] #10 0x00005cf46ba1b048 in alter_stats_rebuild (table=0x7c0070182490, table_name=0x7c00681f8195 "t9", trx=trx@entry=0x7c0116c03a00) at /data/Server/MDEV-37152/storage/innobase/handler/handler0alter.cc:11277
      # 2025-09-24T02:08:23 [3165712] #11 0x00005cf46ba2d8f5 in ha_innobase::commit_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>, commit=<optimized out>) at /data/Server/MDEV-37152/storage/innobase/handler/handler0alter.cc:11959
      # 2025-09-24T02:08:23 [3165712] #12 0x00005cf46b7cde81 in handler::ha_commit_inplace_alter_table (this=0x7c00680b20e8, altered_table=altered_table@entry=0x7c012c2290f0, ha_alter_info=ha_alter_info@entry=0x7c012c229030, commit=commit@entry=true) at /data/Server/MDEV-37152/sql/handler.cc:5628
      # 2025-09-24T02:08:23 [3165712] #13 0x00005cf46b5ffad5 in mysql_inplace_alter_table (thd=thd@entry=0x7c0068000d58, table_list=0x7c00680138f8, table=table@entry=0x7c00682b56d8, altered_table=altered_table@entry=0x7c012c2290f0, ha_alter_info=ha_alter_info@entry=0x7c012c229030, target_mdl_request=target_mdl_request@entry=0x7c012c229920, ddl_log_state=0x7c012c228ff0, trigger_param=0x7c012c2294e0, alter_ctx=0x7c012c22a560, partial_alter=@0x7c012c228f6e: false, start_alter_id=@0x7c012c228f78: 0, if_exists=false) at /data/Server/MDEV-37152/sql/sql_table.cc:8189
      # 2025-09-24T02:08:23 [3165712] #14 0x00005cf46b603c2a in mysql_alter_table (thd=thd@entry=0x7c0068000d58, new_db=new_db@entry=0x7c00680058e0, new_name=<optimized out>, create_info=create_info@entry=0x7c012c22b400, table_list=<optimized out>, table_list@entry=0x7c00680138f8, recreate_info=recreate_info@entry=0x7c012c22b250, alter_info=<optimized out>, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /data/Server/MDEV-37152/sql/sql_table.cc:11558
      # 2025-09-24T02:08:23 [3165712] #15 0x00005cf46b6736db in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7c0068000d58) at /data/Server/MDEV-37152/sql/sql_alter.cc:701
      # 2025-09-24T02:08:23 [3165712] #16 0x00005cf46b53e5eb in mysql_execute_command (thd=thd@entry=0x7c0068000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/MDEV-37152/sql/sql_parse.cc:5876
      # 2025-09-24T02:08:23 [3165712] #17 0x00005cf46b53f177 in mysql_parse (thd=thd@entry=0x7c0068000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7c012c22c400) at /data/Server/MDEV-37152/sql/sql_parse.cc:7899
      # 2025-09-24T02:08:23 [3165712] #18 0x00005cf46b5407ec in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7c0068000d58, packet=packet@entry=0x7c006800b049 "ALTER TABLE t9 /*!100301 NOWAIT */ FORCE, LOCK=NONE  /* E_R Thread9 QNO 288153 CON_ID 22 */ ", packet_length=packet_length@entry=92, blocking=blocking@entry=true) at /data/Server/MDEV-37152/sql/sql_parse.cc:1905
      # 2025-09-24T02:08:23 [3165712] #19 0x00005cf46b541c8a in do_command (thd=thd@entry=0x7c0068000d58, blocking=blocking@entry=true) at /data/Server/MDEV-37152/sql/sql_parse.cc:1418
      # 2025-09-24T02:08:23 [3165712] #20 0x00005cf46b66c3b5 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5cf46f36bdf8, put_in_cache=put_in_cache@entry=true) at /data/Server/MDEV-37152/sql/sql_connect.cc:1497
      # 2025-09-24T02:08:23 [3165712] #21 0x00005cf46b66c5c6 in handle_one_connection (arg=0x5cf46f36bdf8) at /data/Server/MDEV-37152/sql/sql_connect.cc:1409
      # 2025-09-24T02:08:23 [3165712] #22 0x00007c012c69ca94 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
      # 2025-09-24T02:08:23 [3165712] #23 0x00007c012c729c3c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Core dump is present on SDP:-
      /data/results/1758703102/000486

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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