Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
Description
Test case 1, myisampack/chk run only on the main .MYI |
--source include/have_sequence.inc
|
|
create table t (pk int primary key, v vector(1) not null, vector(v)) engine=MyISAM; |
insert into t select seq, 0x00000000 from seq_1_to_1000; |
|
select pk from t order by vec_distance_euclidean(v,0x00000000) limit 1; |
flush tables;
|
|
--let $datadir= `select @@datadir`
|
--echo # Running myisampack
|
--exec $MYISAMPACK $datadir/test/t.MYI
|
--echo # Running myisamchk
|
--exec $MYISAMCHK -rq $datadir/test/t.MYI
|
select pk from t order by vec_distance_euclidean(v,0x00000000) limit 1; |
|
# Cleanup
|
drop table t; |
bb-11.6-MDEV-32887-vector a919a7de0ef3d7a11a7a529eb9043e51c577b6d6 |
# Running myisampack
|
Remember to run myisamchk -rq on compressed tables
|
# Running myisamchk
|
- check record delete-chain
|
- recovering (with sort) MyISAM-table '/mnt8t/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/mysql-test/var/mysqld.1/data//test/t.MYI'
|
Data records: 1000
|
- Fixing index 1
|
select pk from t order by vec_distance_euclidean(v,0x00000000) limit 1;
|
bug.t [ fail ]
|
Test ended at 2024-10-18 01:05:54
|
|
CURRENT_TEST: bug.t
|
mysqltest: At line 14: query 'select pk from t order by vec_distance_euclidean(v,0x00000000) limit 1' failed: ER_CRASHED_ON_USAGE (1194): Table 't' is marked as crashed and should be repaired
|
Test case 2, myisampack/chk on both .MYI files |
--source include/have_sequence.inc
|
|
create table t (pk int primary key, v vector(1) not null, vector(v)) engine=MyISAM; |
insert into t select seq, 0x00000000 from seq_1_to_1000; |
|
select pk from t order by vec_distance_euclidean(v,0x00000000) limit 1; |
flush tables;
|
|
--let $datadir= `select @@datadir`
|
--echo # Running myisampack
|
--exec $MYISAMPACK $datadir/test/t*.MYI
|
--echo # Running myisamchk
|
--exec $MYISAMCHK -rq $datadir/test/t*.MYI
|
select pk from t order by vec_distance_euclidean(v,0x00000000) limit 1; |
|
# Cleanup
|
drop table t; |
# Running myisampack
|
Remember to run myisamchk -rq on compressed tables
|
# Running myisamchk
|
- check record delete-chain
|
- recovering (with sort) MyISAM-table '/mnt8t/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/mysql-test/var/mysqld.1/data//test/t#i#01.MYI'
|
Data records: 1000
|
- Fixing index 1
|
- Fixing index 2
|
|
---------
|
|
- check record delete-chain
|
- recovering (with sort) MyISAM-table '/mnt8t/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/mysql-test/var/mysqld.1/data//test/t.MYI'
|
Data records: 1000
|
- Fixing index 1
|
select pk from t order by vec_distance_euclidean(v,0x00000000) limit 1;
|
bug.t [ fail ]
|
Test ended at 2024-10-18 01:08:38
|
|
CURRENT_TEST: bug.t
|
mysqltest: At line 14: query 'select pk from t order by vec_distance_euclidean(v,0x00000000) limit 1' failed: <Unknown> (2013): Lost connection to server during query
|
mariadbd: /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/handler.cc:7609: int handler::ha_external_lock(THD*, int): Assertion `inited == NONE || table->open_by_handler' failed.
|
241018 1:08:36 [ERROR] mysqld got signal 6 ;
|
|
#9 0x00007fbaebc53e32 in __GI___assert_fail (assertion=0x56334c06eb00 "inited == NONE || table->open_by_handler", file=0x56334c064120 "/data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/handler.cc", line=7609, function=0x56334c06e960 "int handler::ha_external_lock(THD*, int)") at ./assert/assert.c:101
|
#10 0x000056334a13c8af in handler::ha_external_lock (this=0x61d00016f8b8, thd=0x62c0000c0218, lock_type=2) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/handler.cc:7609
|
#11 0x00005633494555ce in handler::ha_external_unlock (this=0x61d00016f8b8, thd=0x62c0000c0218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/handler.h:3599
|
#12 0x00005633495eb688 in TABLE::reset_hlindexes (this=0x61900009a698) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_base.cc:9909
|
#13 0x000056334a13d94b in handler::ha_reset (this=0x61d0001cd4b8) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/handler.cc:7706
|
#14 0x00005633495b6476 in close_thread_table (thd=0x62c0000c0218, table_ptr=0x62c0000c0310) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_base.cc:1044
|
#15 0x00005633495b58da in close_thread_tables (thd=0x62c0000c0218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_base.cc:982
|
#16 0x00005633495b49b5 in close_thread_tables_for_query (thd=0x62c0000c0218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_base.cc:798
|
#17 0x000056334978ebfe in mysql_execute_command (thd=0x62c0000c0218, is_called_from_prepared_stmt=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:5936
|
#18 0x000056334979b576 in mysql_parse (thd=0x62c0000c0218, rawbuf=0x6290000e6238 "select pk from t order by vec_distance_euclidean(v,0x00000000) limit 1", length=70, parser_state=0x7fbae06c29f0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:7873
|
#19 0x0000563349772598 in dispatch_command (command=COM_QUERY, thd=0x62c0000c0218, packet=0x629000253219 "", packet_length=70, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1892
|
#20 0x000056334976f2ac in do_command (thd=0x62c0000c0218, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1405
|
#21 0x0000563349c5e755 in do_handle_one_connection (connect=0x6080000034b8, put_in_cache=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1448
|
#22 0x0000563349c5e116 in handle_one_connection (arg=0x608000003438) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1350
|
#23 0x000056334a903c8a in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/perfschema/pfs.cc:2198
|
#24 0x00007fbaebca8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#25 0x00007fbaebd2861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
Attachments
Issue Links
- is caused by
-
MDEV-34939 vector search in 11.7
- Closed