Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
11.8, 12.0
-
None
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t (id INT KEY,v VECTOR (1) NOT NULL,VECTOR INDEX (v)) ENGINE=INNODB; |
FLUSH TABLES t FOR EXPORT; |
SELECT VEC_DISTANCE_EUCLIDEAN (v,0x30303030) d FROM t ORDER BY d LIMIT 1; |
SELECT VEC_DISTANCE_EUCLIDEAN (v,0x30303030) d FROM t ORDER BY d LIMIT 1; |
Leads to:
CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Optimized) Build 19/02/2025 |
InnoDB: Failing assertion: prebuilt->select_lock_type != LOCK_NONE || srv_read_only_mode || trx->read_view.is_open()
|
CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Optimized) Build 19/02/2025 |
Core was generated by `/test/MD190225-mariadb-12.0.0-linux-x86_64-opt/bin/mariadbd --no-defaults --max'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
|
[Current thread is 1 (Thread 0x1502297696c0 (LWP 2173814))]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
|
#3 0x000015023784527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x00001502378288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00005557852ae224 in ut_dbg_assertion_failed (expr=0x555785e04206 "prebuilt->select_lock_type != LOCK_NONE || srv_read_only_mode || trx->read_view.is_open()", file=0x555785e04059 "/test/12.0_opt/storage/innobase/row/row0sel.cc", line=4708) at /test/12.0_opt/storage/innobase/ut/ut0dbg.cc:60
|
#6 0x0000555785a077fd in row_search_mvcc (buf=buf@entry=0x1501d002eb20 "", mode=PAGE_CUR_L, prebuilt=0x1501d0030308, match_mode=0, direction=direction@entry=0)at /test/12.0_opt/storage/innobase/row/row0sel.cc:4707
|
#7 0x000055578593c841 in ha_innobase::index_read (this=0x1501d002e2c8, buf=0x1501d002eb20 "", key_ptr=key_ptr@entry=0x0, key_len=key_len@entry=0, find_flag=find_flag@entry=HA_READ_BEFORE_KEY)at /test/12.0_opt/storage/innobase/handler/ha_innodb.cc:9020
|
#8 0x000055578593cbb3 in ha_innobase::index_last (this=0x2124e0, buf=0x212b76 <error: Cannot access memory at address 0x212b76>)at /test/12.0_opt/storage/innobase/handler/ha_innodb.cc:9390
|
#9 0x0000555785670280 in handler::ha_index_last (this=0x1501d002e2c8, buf=0x1501d002eb20 "") at /test/12.0_opt/sql/handler.cc:3980
|
#10 0x00005557857ac9d5 in MHNSW_Share::acquire (ctx=ctx@entry=0x150229767318, table=table@entry=0x1501d0027fa8, for_update=<optimized out>)at /test/12.0_opt/sql/vector_mhnsw.cc:725
|
#11 0x00005557857afc3b in mhnsw_read_first (table=0x1501d0027fa8, keyinfo=<optimized out>, dist=<optimized out>, limit=1)at /test/12.0_opt/sql/vector_mhnsw.cc:1308
|
#12 0x0000555785474eb8 in join_read_first (tab=<optimized out>)at /test/12.0_opt/sql/sql_select.cc:25298
|
#13 0x0000555785434a07 in sub_select (join=0x1501d0019080, join_tab=0x1501d001a840, end_of_records=<optimized out>)at /test/12.0_opt/sql/sql_select.cc:24183
|
#14 0x000055578544fce3 in do_select (join=join@entry=0x1501d0019080, procedure=<optimized out>) at /test/12.0_opt/sql/sql_select.cc:23697
|
#15 0x000055578544f5f2 in JOIN::exec_inner (this=this@entry=0x1501d0019080)at /test/12.0_opt/sql/sql_select.cc:5059
|
#16 0x0000555785435297 in JOIN::exec (this=0x1501d0019080)at /test/12.0_opt/sql/sql_select.cc:4842
|
#17 mysql_select (thd=thd@entry=0x1501d0000c68, tables=<optimized out>, fields=@0x1501d00178d8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1501d0017e08, last = 0x1501d0017e08, elements = 1}, <No data fields>}, conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x1501d0019058, unit=0x1501d0004fc0, select_lex=0x1501d0017620)at /test/12.0_opt/sql/sql_select.cc:5375
|
#18 0x0000555785434f19 in handle_select (thd=thd@entry=0x1501d0000c68, lex=lex@entry=0x1501d0004ee0, result=result@entry=0x1501d0019058, setup_tables_done_option=setup_tables_done_option@entry=0)at /test/12.0_opt/sql/sql_select.cc:633
|
#19 0x000055578540250e in execute_sqlcom_select (thd=thd@entry=0x1501d0000c68, all_tables=0x1501d0017e60) at /test/12.0_opt/sql/sql_parse.cc:6191
|
#20 0x0000555785400a00 in mysql_execute_command (thd=thd@entry=0x1501d0000c68, is_called_from_prepared_stmt=false) at /test/12.0_opt/sql/sql_parse.cc:3979
|
#21 0x00005557853f9261 in mysql_parse (thd=thd@entry=0x1501d0000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x150229768430)at /test/12.0_opt/sql/sql_parse.cc:7915
|
#22 0x00005557853f76f0 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1501d0000c68, packet=packet@entry=0x1501d00088a9 "", packet_length=packet_length@entry=72, blocking=true)at /test/12.0_opt/sql/sql_parse.cc:1902
|
#23 0x00005557853f9671 in do_command (thd=thd@entry=0x1501d0000c68, blocking=true) at /test/12.0_opt/sql/sql_parse.cc:1415
|
#24 0x0000555785524e8d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55578ecfac28, put_in_cache=true)at /test/12.0_opt/sql/sql_connect.cc:1415
|
#25 0x0000555785524c4f in handle_one_connection (arg=arg@entry=0x55578ecfac28)at /test/12.0_opt/sql/sql_connect.cc:1327
|
#26 0x00005557858a9d29 in pfs_spawn_thread (arg=0x55578eca7518)at /test/12.0_opt/storage/perfschema/pfs.cc:2198
|
#27 0x000015023789caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#28 0x0000150237929c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Debug build assertion is similar to MDEV-29120, but the stack is slightly different.
CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Debug) Build 19/02/2025 |
mariadbd: /test/12.0_dbg/storage/innobase/row/row0sel.cc:4657: dberr_t row_search_mvcc(byte *, page_cur_mode_t, row_prebuilt_t *, ulint, ulint): Assertion `prebuilt->sql_stat_start || prebuilt->table->no_rollback()' failed.
|
CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Debug) Build 19/02/2025 |
Core was generated by `/test/MD190225-mariadb-12.0.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
|
[Current thread is 1 (Thread 0x150a17fff6c0 (LWP 2177061))]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
|
#3 0x0000150a24e4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x0000150a24e288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x0000150a24e2881b in __assert_fail_base (fmt=0x150a24fd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x555e1527b173 "prebuilt->sql_stat_start || prebuilt->table->no_rollback()", file=file@entry=0x555e1527a932 "/test/12.0_dbg/storage/innobase/row/row0sel.cc", line=line@entry=4657, function=function@entry=0x555e1527b0ab "dberr_t row_search_mvcc(byte *, page_cur_mode_t, row_prebuilt_t *, ulint, ulint)") at ./assert/assert.c:96
|
#6 0x0000150a24e3b517 in __assert_fail (assertion=0x555e1527b173 "prebuilt->sql_stat_start || prebuilt->table->no_rollback()", file=0x555e1527a932 "/test/12.0_dbg/storage/innobase/row/row0sel.cc", line=4657, function=0x555e1527b0ab "dberr_t row_search_mvcc(byte *, page_cur_mode_t, row_prebuilt_t *, ulint, ulint)") at ./assert/assert.c:105
|
#7 0x0000555e14b85152 in row_search_mvcc (buf=0x1509c40376d0 '\245' <repeats 64 times>, "Xx\003\304\t\025", mode=PAGE_CUR_L, prebuilt=0x1509c4038eb8, match_mode=0, direction=0)at /test/12.0_dbg/storage/innobase/row/row0sel.cc:4656
|
#8 0x0000555e1494539d in ha_innobase::index_read (this=0x1509c4036e78, buf=0x1509c40376d0 '\245' <repeats 64 times>, "Xx\003\304\t\025", key_ptr=0x0, key_len=0, find_flag=HA_READ_BEFORE_KEY)at /test/12.0_dbg/storage/innobase/handler/ha_innodb.cc:9020
|
#9 0x0000555e14945f09 in ha_innobase::index_last (this=0x1509c4036e78, buf=0x1509c40376d0 '\245' <repeats 64 times>, "Xx\003\304\t\025")at /test/12.0_dbg/storage/innobase/handler/ha_innodb.cc:9390
|
#10 0x0000555e14569633 in handler::ha_index_last (this=0x1509c4036e78, buf=0x1509c40376d0 '\245' <repeats 64 times>, "Xx\003\304\t\025")at /test/12.0_dbg/sql/handler.cc:3980
|
#11 0x0000555e14748686 in MHNSW_Share::acquire (ctx=0x150a17ffb3b8, table=0x1509c4030478, for_update=false)at /test/12.0_dbg/sql/vector_mhnsw.cc:725
|
#12 0x0000555e1474c7aa in mhnsw_read_first (table=0x1509c4030478, keyinfo=0x1509c4028120, dist=0x1509c401a530, limit=1)at /test/12.0_dbg/sql/vector_mhnsw.cc:1308
|
#13 0x0000555e14098e53 in TABLE::hlindex_read_first (this=0x1509c4030478, nr=1, item=0x1509c401a530, limit=1) at /test/12.0_dbg/sql/sql_base.cc:9999
|
#14 0x0000555e14201fa1 in join_read_first (tab=0x1509c401d078)at /test/12.0_dbg/sql/sql_select.cc:25298
|
#15 0x0000555e141a9941 in sub_select (join=0x1509c401b870, join_tab=0x1509c401d078, end_of_records=false)at /test/12.0_dbg/sql/sql_select.cc:24183
|
#16 0x0000555e141d0e34 in do_select (join=0x1509c401b870, procedure=0x0)at /test/12.0_dbg/sql/sql_select.cc:23697
|
#17 0x0000555e141d01a3 in JOIN::exec_inner (this=0x1509c401b870)at /test/12.0_dbg/sql/sql_select.cc:5059
|
#18 0x0000555e141cf04e in JOIN::exec (this=0x1509c401b870)at /test/12.0_dbg/sql/sql_select.cc:4842
|
#19 0x0000555e141aa2bd in mysql_select (thd=0x1509c4000d58, tables=0x1509c401a650, fields=@0x1509c401a0c8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1509c401a5f8, last = 0x1509c401a5f8, elements = 1}, <No data fields>}, conds=0x0, og_num=1, order=0x1509c401b728, group=0x0, having=0x0, proc_param=0x0, select_options=2166622976, result=0x1509c401b848, unit=0x1509c4005080, select_lex=0x1509c4019e10)at /test/12.0_dbg/sql/sql_select.cc:5375
|
#20 0x0000555e141a9d45 in handle_select (thd=0x1509c4000d58, lex=0x1509c4004fa0, result=0x1509c401b848, setup_tables_done_option=0)at /test/12.0_dbg/sql/sql_select.cc:633
|
#21 0x0000555e14151721 in execute_sqlcom_select (thd=0x1509c4000d58, all_tables=0x1509c401a650) at /test/12.0_dbg/sql/sql_parse.cc:6191
|
#22 0x0000555e14146600 in mysql_execute_command (thd=0x1509c4000d58, is_called_from_prepared_stmt=false) at /test/12.0_dbg/sql/sql_parse.cc:3979
|
#23 0x0000555e1413e784 in mysql_parse (thd=0x1509c4000d58, rawbuf=0x1509c4019d20 "SELECT VEC_DISTANCE_EUCLIDEAN (v,0x30303030) d FROM t ORDER BY d LIMIT 1", length=72, parser_state=0x150a17ffda20)at /test/12.0_dbg/sql/sql_parse.cc:7915
|
#24 0x0000555e1413bb54 in dispatch_command (command=COM_QUERY, thd=0x1509c4000d58, packet=0x1509c400b099 "", packet_length=72, blocking=true) at /test/12.0_dbg/sql/sql_parse.cc:1902
|
#25 0x0000555e1413f333 in do_command (thd=0x1509c4000d58, blocking=true)at /test/12.0_dbg/sql/sql_parse.cc:1415
|
#26 0x0000555e14328989 in do_handle_one_connection (connect=0x555e263c0c58, put_in_cache=true) at /test/12.0_dbg/sql/sql_connect.cc:1415
|
#27 0x0000555e1432872e in handle_one_connection (arg=0x555e26454228)at /test/12.0_dbg/sql/sql_connect.cc:1327
|
#28 0x0000150a24e9caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#29 0x0000150a24f29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Bug confirmed present in:
MariaDB: 11.7.2 (dbg), 11.7.2 (opt), 11.8.1 (dbg), 11.8.1 (opt), 12.0.0 (dbg), 12.0.0 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.6.21 (dbg), 10.6.21 (opt), 10.11.12 (dbg), 10.11.12 (opt), 11.4.6 (dbg), 11.4.6 (opt)