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

InnoDB: Failing assertion: ib_vector_size(optim->words) > 0

    XMLWordPrintable

Details

    • Can result in hang or crash
    • This issue is no more reproducible in latest commit , hence closing the bug

    Description

      Assertion found on debug build while testing MDEV-28730

      origin/main-MDEV-28730 1ee1317ddd1103587eb9625729b0fb425da1bb50

      # 2025-11-23T23:58:32 [2493647] | 2025-11-23 23:58:07 0x77204e7b46c0  InnoDB: Assertion failure in file /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc line 1404
      # 2025-11-23T23:58:32 [2493647] | InnoDB: Failing assertion: ib_vector_size(optim->words) > 0
      

      StackTrace

      # 2025-11-23T23:59:39 [2493647] #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
      # 2025-11-23T23:59:39 [2493647] #1  __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
      # 2025-11-23T23:59:39 [2493647] #2  __GI___pthread_kill (threadid=<optimized out>, signo=6) at ./nptl/pthread_kill.c:89
      # 2025-11-23T23:59:39 [2493647] #3  0x0000583a0c4b5be4 in my_write_core (sig=6) at /data/Server/MDEV-28730/mysys/stacktrace.c:424
      # 2025-11-23T23:59:39 [2493647] #4  0x0000583a0bf1c164 in handle_fatal_signal (sig=6) at /data/Server/MDEV-28730/sql/signal_handler.cc:298
      # 2025-11-23T23:59:39 [2493647] #5  <signal handler called>
      # 2025-11-23T23:59:39 [2493647] #6  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
      # 2025-11-23T23:59:39 [2493647] #7  __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
      # 2025-11-23T23:59:39 [2493647] #8  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
      # 2025-11-23T23:59:39 [2493647] #9  0x0000772057a4526e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      # 2025-11-23T23:59:39 [2493647] #10 0x0000772057a288ff in __GI_abort () at ./stdlib/abort.c:79
      # 2025-11-23T23:59:39 [2493647] #11 0x0000583a0c343f1f in ut_dbg_assertion_failed (expr=expr@entry=0x583a0c743400 "ib_vector_size(optim->words) > 0", file=file@entry=0x583a0c742fa0 "/data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc", line=line@entry=1404) at /data/Server/MDEV-28730/storage/innobase/ut/ut0dbg.cc:60
      # 2025-11-23T23:59:39 [2493647] #12 0x0000583a0c421d7b in fts_optimize_words (optim=optim@entry=0x771fe046db38, index=index@entry=0x771fd4485998, word=word@entry=0x77204e7b2100) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1404
      # 2025-11-23T23:59:39 [2493647] #13 0x0000583a0c422018 in fts_optimize_index (optim=optim@entry=0x771fe046db38, index=0x771fd4485998) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1569
      # 2025-11-23T23:59:39 [2493647] #14 0x0000583a0c42217b in fts_optimize_indexes (optim=optim@entry=0x771fe046db38) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1772
      # 2025-11-23T23:59:39 [2493647] #15 0x0000583a0c422325 in fts_optimize_table (table=0x771fcc0751b8) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1952
      # 2025-11-23T23:59:39 [2493647] #16 0x0000583a0c176568 in ha_innobase::optimize (this=0x771fc815e610, thd=<optimized out>) at /data/Server/MDEV-28730/storage/innobase/handler/ha_innodb.cc:15168
      # 2025-11-23T23:59:39 [2493647] #17 0x0000583a0bf26cc0 in handler::ha_optimize (this=0x771fc815e610, thd=thd@entry=0x771fe0000d58, check_opt=check_opt@entry=0x771fe0006500) at /data/Server/MDEV-28730/sql/handler.cc:5626
      # 2025-11-23T23:59:39 [2493647] #18 0x0000583a0bdbcea8 in mysql_admin_table (thd=thd@entry=0x771fe0000d58, tables=tables@entry=0x771fe0015c08, check_opt=check_opt@entry=0x771fe0006500, operator_name=operator_name@entry=0x583a0ceb1760 <msg_optimize>, lock_type=lock_type@entry=TL_WRITE, org_open_for_modify=org_open_for_modify@entry=true, no_errors_from_open=false, extra_open_options=0, prepare_func=0x0, operator_func=<optimized out>, view_operator_func=0x0, is_cmd_replicated=true) at /data/Server/MDEV-28730/sql/sql_admin.cc:949
      # 2025-11-23T23:59:39 [2493647] #19 0x0000583a0bdbeb2e in Sql_cmd_optimize_table::execute (this=<optimized out>, thd=0x771fe0000d58) at /data/Server/MDEV-28730/sql/sql_admin.cc:1707
      # 2025-11-23T23:59:39 [2493647] #20 0x0000583a0bc74c5f in mysql_execute_command (thd=thd@entry=0x771fe0000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/MDEV-28730/sql/sql_parse.cc:5861
      # 2025-11-23T23:59:39 [2493647] #21 0x0000583a0bc7580b in mysql_parse (thd=thd@entry=0x771fe0000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x77204e7b33d0) at /data/Server/MDEV-28730/sql/sql_parse.cc:7888
      # 2025-11-23T23:59:39 [2493647] #22 0x0000583a0bc76ded in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x771fe0000d58, packet=packet@entry=0x771fe000b319 "", packet_length=packet_length@entry=82, blocking=blocking@entry=true) at /data/Server/MDEV-28730/sql/sql_parse.cc:1878
      # 2025-11-23T23:59:39 [2493647] #23 0x0000583a0bc78343 in do_command (thd=thd@entry=0x771fe0000d58, blocking=blocking@entry=true) at /data/Server/MDEV-28730/sql/sql_parse.cc:1417
      # 2025-11-23T23:59:39 [2493647] #24 0x0000583a0bdacc0f in do_handle_one_connection (connect=<optimized out>, connect@entry=0x583a0f8a1158, put_in_cache=put_in_cache@entry=true) at /data/Server/MDEV-28730/sql/sql_connect.cc:1503
      # 2025-11-23T23:59:39 [2493647] #25 0x0000583a0bdace2c in handle_one_connection (arg=0x583a0f8a1158) at /data/Server/MDEV-28730/sql/sql_connect.cc:1415
      # 2025-11-23T23:59:39 [2493647] #26 0x0000772057a9ca94 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
      # 2025-11-23T23:59:39 [2493647] #27 0x0000772057b29c3c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Core dump is present on SDP:-
      /data/results/1763966833/TBR-2109

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              saahil Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.