[MDEV-18720] Assertion `inited==NONE' failed in ha_index_init upon update on versioned table with key on blob Created: 2019-02-24  Updated: 2020-05-26  Resolved: 2019-02-28

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Data types, Versioned Tables
Affects Version/s: 10.4
Fix Version/s: 10.4.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-371 Unique indexes for blobs Closed
Relates
relates to MDEV-22722 Assertion "inited==NONE" failed in h... Closed

 Description   

Note: The failure became possible after MDEV-371, without it the key without a length in the table definition is rejected.

CREATE TABLE t1 (
  pk INT,
  f TEXT,
  PRIMARY KEY (pk),
  KEY(f)
) WITH SYSTEM VERSIONING;
 
INSERT INTO t1 VALUES (1,'foo');
UPDATE t1 SET f = 'bar';
 
# Cleanup
DROP TABLE t1;

10.4 fb01193c

mysqld: /data/src/10.4/sql/handler.h:3175: int handler::ha_index_init(uint, bool): Assertion `inited==NONE' failed.
190224 19:19:15 [ERROR] mysqld got signal 6 ;
 
#7  0x00007fedfe632ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x000055b91c552329 in handler::ha_index_init (this=0x7fede812ef98, idx=1, sorted=false) at /data/src/10.4/sql/handler.h:3175
#9  0x000055b91c94f191 in check_duplicate_long_entry_key (table=0x7fede812e130, h=0x7fede812ef98, new_rec=0x7fede8008e80 "\374\001", key_no=1) at /data/src/10.4/sql/handler.cc:6512
#10 0x000055b91c94f750 in check_duplicate_long_entries (table=0x7fede812e130, h=0x7fede812ef98, new_rec=0x7fede8008e80 "\374\001") at /data/src/10.4/sql/handler.cc:6583
#11 0x000055b91c94fa27 in handler::ha_write_row (this=0x7fede812ef98, buf=0x7fede8008e80 "\374\001") at /data/src/10.4/sql/handler.cc:6660
#12 0x000055b91c5b6b2e in vers_insert_history_row (table=0x7fede812e130) at /data/src/10.4/sql/sql_insert.cc:1653
#13 0x000055b91c703f52 in mysql_update (thd=0x7fede8000b00, table_list=0x7fede8015580, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7fedf87ab840, updated_return=0x7fedf87ab900) at /data/src/10.4/sql/sql_update.cc:1032
#14 0x000055b91c5ff795 in mysql_execute_command (thd=0x7fede8000b00) at /data/src/10.4/sql/sql_parse.cc:4647
#15 0x000055b91c60bc72 in mysql_parse (thd=0x7fede8000b00, rawbuf=0x7fede80154a8 "UPDATE t1 SET f = 'bar'", length=23, parser_state=0x7fedf87ac180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8157
#16 0x000055b91c5f7360 in dispatch_command (command=COM_QUERY, thd=0x7fede8000b00, packet=0x7fede800a761 "UPDATE t1 SET f = 'bar'", packet_length=23, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1829
#17 0x000055b91c5f5b34 in do_command (thd=0x7fede8000b00) at /data/src/10.4/sql/sql_parse.cc:1358
#18 0x000055b91c76f837 in do_handle_one_connection (connect=0x55b91f234bb0) at /data/src/10.4/sql/sql_connect.cc:1399
#19 0x000055b91c76f5a8 in handle_one_connection (arg=0x55b91f234bb0) at /data/src/10.4/sql/sql_connect.cc:1302
#20 0x000055b91cc66979 in pfs_spawn_thread (arg=0x55b91f327220) at /data/src/10.4/storage/perfschema/pfs.cc:1862
#21 0x00007fee00309494 in start_thread (arg=0x7fedf87ad700) at pthread_create.c:333
#22 0x00007fedfe6ef93f in clone () from /lib/x86_64-linux-gnu/libc.so.6


Generated at Thu Feb 08 08:46:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.