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

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

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      origin/10.11 f3002155ed84ef53fcf89aaecf1d762e5855ba4a

      # 2026-09-07T03:23:10 [2668936] | 2026-09-07 03:23:05 0x139b046056c0  InnoDB: Assertion failure in file /data/Server/10.11N/storage/innobase/fts/fts0opt.cc line 1810
      # 2026-09-07T03:23:10 [2668936] | InnoDB: Failing assertion: ib_vector_size(optim->words) > 0
      

      StackTrace

      # 2026-09-07T03:26:11 [2668936] | #0  0x0000000070000002 in syscall_traced ()
      # 2026-09-07T03:26:11 [2668936] | #1  0x00003fc609b37018 in _raw_syscall () at /home/ubuntu/rr/src/preload/raw_syscall.S:120
      # 2026-09-07T03:26:11 [2668936] | #2  0x00003fc609b30909 in traced_raw_syscall (call=0x7f602e3fffa0) at /home/ubuntu/rr/src/preload/syscallbuf.c:379
      # 2026-09-07T03:26:11 [2668936] | #3  0x00003fc609b340bc in sys_futex (call=<optimized out>) at /home/ubuntu/rr/src/preload/syscallbuf.c:2085
      # 2026-09-07T03:26:11 [2668936] | #4  syscall_hook_internal (call=call@entry=0x7f602e3fffa0) at /home/ubuntu/rr/src/preload/syscallbuf.c:4203
      # 2026-09-07T03:26:11 [2668936] | #5  0x00003fc609b36da4 in syscall_hook (call=0x7f602e3fffa0) at /home/ubuntu/rr/src/preload/syscallbuf.c:4387
      # 2026-09-07T03:26:11 [2668936] | #6  syscall_hook (call=0x7f602e3fffa0) at /home/ubuntu/rr/src/preload/syscallbuf.c:4371
      # 2026-09-07T03:26:11 [2668936] | #7  0x00003fc609b30323 in _syscall_hook_trampoline () at /home/ubuntu/rr/src/preload/syscall_hook.S:308
      # 2026-09-07T03:26:11 [2668936] | #8  0x00003fc609b3038d in __morestack () at /home/ubuntu/rr/src/preload/syscall_hook.S:443
      # 2026-09-07T03:26:11 [2668936] | #9  0x00003fc609b303a9 in _syscall_hook_trampoline_48_3d_00_f0_ff_ff () at /home/ubuntu/rr/src/preload/syscall_hook.S:462
      # 2026-09-07T03:26:11 [2668936] | #10 0x00001d14568e47b2 in __GI_fdatasync (fd=8) at ../sysdeps/unix/sysv/linux/fdatasync.c:28
      # 2026-09-07T03:26:11 [2668936] | #11 0x00005c72b18d6bc3 in os_file_sync_posix (file=8) at /data/Server/10.11N/storage/innobase/os/os0file.cc:816
      # 2026-09-07T03:26:11 [2668936] | #12 0x00005c72b18d703e in os_file_flush_func (file=<optimized out>) at /data/Server/10.11N/storage/innobase/os/os0file.cc:893
      # 2026-09-07T03:26:11 [2668936] | #13 0x00005c72b1895638 in log_file_t::flush (this=0x5c72b2f338c0 <log_sys+128>) at /data/Server/10.11N/storage/innobase/include/log0log.h:128
      # 2026-09-07T03:26:11 [2668936] | #14 log_t::flush (this=this@entry=0x5c72b2f33840 <log_sys>, lsn=lsn@entry=23082220) at /data/Server/10.11N/storage/innobase/log/log0log.cc:1096
      # 2026-09-07T03:26:11 [2668936] | #15 0x00005c72b18956be in log_flush (lsn=23082220) at /data/Server/10.11N/storage/innobase/log/log0log.cc:1114
      # 2026-09-07T03:26:11 [2668936] | #16 0x00005c72b1896a07 in log_write_up_to (lsn=lsn@entry=23082220, durable=durable@entry=true, callback=<optimized out>, callback@entry=0x0) at /data/Server/10.11N/storage/innobase/log/log0log.cc:1176
      # 2026-09-07T03:26:11 [2668936] | #17 0x00005c72b19bf6ef in trx_flush_log_if_needed (lsn=23082220, trx=trx@entry=0x4d2c11b10f00) at /data/Server/10.11N/storage/innobase/trx/trx0trx.cc:1273
      # 2026-09-07T03:26:11 [2668936] | #18 0x00005c72b19c32c6 in trx_t::commit_in_memory (mtr=0x3e866d9b8ab0, this=0x4d2c11b10f00) at /data/Server/10.11N/storage/innobase/trx/trx0trx.cc:1487
      # 2026-09-07T03:26:11 [2668936] | #19 trx_t::commit_low (this=this@entry=0x4d2c11b10f00, mtr=0x3e866d9b8ab0) at /data/Server/10.11N/storage/innobase/trx/trx0trx.cc:1593
      # 2026-09-07T03:26:11 [2668936] | #20 0x00005c72b19c33c3 in trx_t::commit_persist (this=this@entry=0x4d2c11b10f00) at /data/Server/10.11N/storage/innobase/trx/trx0trx.cc:1607
      # 2026-09-07T03:26:11 [2668936] | #21 0x00005c72b19c3420 in trx_t::commit (this=this@entry=0x4d2c11b10f00) at /data/Server/10.11N/storage/innobase/trx/trx0trx.cc:1616
      # 2026-09-07T03:26:11 [2668936] | #22 0x00005c72b19c36fd in trx_commit_for_mysql (trx=0x4d2c11b10f00) at /data/Server/10.11N/storage/innobase/trx/trx0trx.cc:1731
      # 2026-09-07T03:26:11 [2668936] | #23 0x00005c72b1aa9970 in fts_optimize_words (optim=optim@entry=0x52345461dca0, index=index@entry=0x1d144803ddd0, word=word@entry=0x3e866d9b90f0) at /data/Server/10.11N/storage/innobase/fts/fts0opt.cc:1817
      # 2026-09-07T03:26:11 [2668936] | #24 0x00005c72b1aa9cff in fts_optimize_index (optim=optim@entry=0x52345461dca0, index=0x1d144803ddd0) at /data/Server/10.11N/storage/innobase/fts/fts0opt.cc:1998
      # 2026-09-07T03:26:11 [2668936] | #25 0x00005c72b1aa9e70 in fts_optimize_indexes (optim=optim@entry=0x52345461dca0) at /data/Server/10.11N/storage/innobase/fts/fts0opt.cc:2300
      # 2026-09-07T03:26:11 [2668936] | #26 0x00005c72b1aaa011 in fts_optimize_table (table=0x1d144807ad10) at /data/Server/10.11N/storage/innobase/fts/fts0opt.cc:2477
      # 2026-09-07T03:26:11 [2668936] | #27 0x00005c72b18027a3 in ha_innobase::optimize (this=0x5234545b5f28, thd=<optimized out>) at /data/Server/10.11N/storage/innobase/handler/ha_innodb.cc:15250
      # 2026-09-07T03:26:11 [2668936] | #28 0x00005c72b15d7431 in handler::ha_optimize (this=0x5234545b5f28, thd=thd@entry=0x523454000d58, check_opt=check_opt@entry=0x523454006360) at /data/Server/10.11N/sql/handler.cc:5381
      # 2026-09-07T03:26:11 [2668936] | #29 0x00005c72b149c4c8 in mysql_admin_table (thd=thd@entry=0x523454000d58, tables=tables@entry=0x523454015d10, check_opt=check_opt@entry=0x523454006360, operator_name=operator_name@entry=0x5c72b24730a0 <msg_optimize>, lock_type=lock_type@entry=TL_WRITE, org_open_for_modify=org_open_for_modify@entry=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=<optimized out>, view_operator_func=0x0, is_cmd_replicated=true) at /data/Server/10.11N/sql/sql_admin.cc:918
      # 2026-09-07T03:26:11 [2668936] | #30 0x00005c72b149e05f in Sql_cmd_optimize_table::execute (this=<optimized out>, thd=0x523454000d58) at /data/Server/10.11N/sql/sql_admin.cc:1646
      # 2026-09-07T03:26:11 [2668936] | #31 0x00005c72b1363cb8 in mysql_execute_command (thd=thd@entry=0x523454000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/10.11N/sql/sql_parse.cc:6190
      # 2026-09-07T03:26:11 [2668936] | #32 0x00005c72b1364871 in mysql_parse (thd=thd@entry=0x523454000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x3e866d9ba2f0) at /data/Server/10.11N/sql/sql_parse.cc:8210
      # 2026-09-07T03:26:11 [2668936] | #33 0x00005c72b1365f44 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x523454000d58, packet=packet@entry=0x52345400b0b9 "", packet_length=packet_length@entry=75, blocking=blocking@entry=true) at /data/Server/10.11N/sql/sql_parse.cc:1924
      # 2026-09-07T03:26:11 [2668936] | #34 0x00005c72b1367445 in do_command (thd=thd@entry=0x523454000d58, blocking=blocking@entry=true) at /data/Server/10.11N/sql/sql_parse.cc:1434
      # 2026-09-07T03:26:11 [2668936] | #35 0x00005c72b148dc3b in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5c72bb6869f8, put_in_cache=put_in_cache@entry=true) at /data/Server/10.11N/sql/sql_connect.cc:1486
      # 2026-09-07T03:26:11 [2668936] | #36 0x00005c72b148de4c in handle_one_connection (arg=0x5c72bb6869f8) at /data/Server/10.11N/sql/sql_connect.cc:1398
      # 2026-09-07T03:26:11 [2668936] | #37 0x00001d1456862aa4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
      # 2026-09-07T03:26:11 [2668936] | #38 0x00001d14568efa64 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      

      RQG startup options used

      # $RQG_HOME/rqg.pl \
      # --gendata=conf/mariadb/innodb_blob_edges.zz \
      # --gendata_sql=conf/mariadb/table_stress.sql \
      # --grammar=conf/mariadb/innodb_online_ddl.yy \
      # --redefine=conf/mariadb/redefine_innodb_fts_churn.yy \
      # --mysqld=--loose-innodb_lock_schedule_algorithm=fcfs \
      # --mysqld=--loose-idle_write_transaction_timeout=0 \
      # --mysqld=--loose-idle_transaction_timeout=0 \
      # --mysqld=--loose-idle_readonly_transaction_timeout=0 \
      # --mysqld=--connect_timeout=60 \
      # --mysqld=--interactive_timeout=28800 \
      # --mysqld=--slave_net_timeout=60 \
      # --mysqld=--net_read_timeout=30 \
      # --mysqld=--net_write_timeout=60 \
      # --mysqld=--loose-table_lock_wait_timeout=50 \
      # --mysqld=--wait_timeout=28800 \
      # --no_mask \
      # --queries=10000000 \
      # --seed=random \
      # --reporters=None \
      # --reporters=ErrorLog \
      # --reporters=Deadlock \
      # --validators=None \
      # --mysqld=--log_output=none \
      # --mysqld=--log_bin_trust_function_creators=1 \
      # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
      # --engine=InnoDB \
      # --restart_timeout=240 \ 
      # --mysqld=--plugin-load-add=file_key_management.so \
      # --mysqld=--loose-file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \
      # --mysqld=--plugin-load-add=provider_lzo.so \
      # --mysqld=--plugin-load-add=provider_bzip2.so \
      # --mysqld=--plugin-load-add=provider_lzma.so \
      # --mysqld=--plugin-load-add=provider_snappy.so \
      # --mysqld=--plugin-load-add=provider_lz4.so \
      # --mysqld=--loose-innodb_compression_level=1 \
      # --duration=300 \
      # --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \
      # --mysqld=--loose-innodb_data_file_path=ibdata1:1M:autoextend:autoshrink \
      # --mysqld=--lock-wait-timeout=86400 \
      # --mysqld=--innodb-lock-wait-timeout=50 \
      # --mysqld=--sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION \
      # --mysqld=--loose-innodb_read_only_compressed=OFF \
      # --mysqld=--innodb_stats_persistent=off \
      # --mysqld=--innodb_adaptive_hash_index=on \
      # --mysqld=--innodb_random_read_ahead=OFF \
      # --mysqld=--log-bin \
      # --mysqld=--sync-binlog=1 \
      # --mysqld=--loose-innodb_evict_tables_on_commit_debug=off \
      # --mysqld=--loose-max-statement-time=30 \
      # --threads=9 \
      # --rr=rr record --chaos --wait \
      # --mysqld=--innodb_undo_log_truncate=ON \
      # --mysqld=--innodb_rollback_on_timeout=OFF \
      # --mysqld=--innodb_page_size=16K \
      # --mysqld=--innodb-buffer-pool-size=8M \
      # --vardir_type=slow \
      # --mysqld=--innodb_instant_alter_column_allowed=add_last \
      # --mysqld=--innodb_deadlock_detect=OFF \
      # --mysqld=--innodb_max_purge_lag=100000 \
      # --mysqld=--innodb_encrypt_temporary_tables=OFF \
      # --mysqld=--innodb_ft_min_token_size=1 \
      # --no_mask \
      # --batch \
      # --basedir1=/Server_bin/10.11N_debug_Og \
      # --basedir2=/Server_bin/10.11N_debug_Og \
      # --script_debug=_nix_ \
      # --major_runid=1788776339 \
      # --minor_runid=217
      

      RR trace is present on SDP :-
      /data/results/1788776339/TBR-2462

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            saahil Saahil Alam
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 2.5h
                2.5h

                Git Integration

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