[MDEV-18889] Long unique on virtual fields crashes server Created: 2019-03-11  Updated: 2019-03-17  Resolved: 2019-03-17

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: None
Fix Version/s: 10.4.4

Type: Bug Priority: Major
Reporter: Sachin Setiya (Inactive) Assignee: Sachin Setiya (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

All


Issue Links:
Problem/Incident
is caused by MDEV-371 Unique indexes for blobs Closed

 Description   

create table t2(a blob , b blob as (a), unique(b))engine=innodb;
insert into t2 values(1, default);
--error ER_DUP_ENTRY
insert into t2 values(1, default);

Thread pointer: 0x7fce60000d60                                                                                                                                 
Attempting backtrace. You can use the following information to find out                                                                                        
where mysqld died. If you see no messages after this, something went                                                                                           
terribly wrong...                                                                                                                                              
stack_bottom = 0x7fceb271edd0 thread_stack 0x49000                                                                                                             
/home/sachin/server/sql/mysqld(my_print_stacktrace+0x40)[0x55e208237518]                                                                                       
mysys/stacktrace.c:269(my_print_stacktrace)[0x55e207a7d8b0]                                                                                                    
sigaction.c:0(__restore_rt)[0x7fcebe6c73c0]
:0(__memcmp_avx2_movbe)[0x7fcebd829e83]
/home/sachin/server/sql/mysqld(+0x12a1020)[0x55e208261020]
strings/ctype-bin.c:85(my_strnncoll_binary)[0x55e2082610a3]
strings/ctype-bin.c:125(my_strnncollsp_binary)[0x55e207a608ab]
sql/field.cc:8400(Field_blob::cmp(unsigned char const*, unsigned int, unsigned char const*, unsigned int))[0x55e207a6095e]
sql/field.cc:8412(Field_blob::cmp_max(unsigned char const*, unsigned char const*, unsigned int))[0x55e207a70a63]
sql/field.h:3900(Field_blob::cmp(unsigned char const*, unsigned char const*))[0x55e207a6c3f6]
sql/field.h:1087(Field::cmp_offset(long long))[0x55e207a916ed]
sql/handler.cc:6571(check_duplicate_long_entry_key(TABLE*, handler*, unsigned char*, unsigned int))[0x55e207a91ab2]
sql/handler.cc:6620(check_duplicate_long_entries(TABLE*, handler*, unsigned char*))[0x55e207a91dac]
sql/handler.cc:6699(handler::ha_write_row(unsigned char*))[0x55e2076fd7eb]
sql/sql_insert.cc:2021(write_record(THD*, TABLE*, st_copy_info*))[0x55e2076fabd5]
sql/sql_insert.cc:1067(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool))[0x55e207746224]
sql/sql_parse.cc:4767(mysql_execute_command(THD*))[0x55e207752286]
sql/sql_parse.cc:8137(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55e20773d8a0]
sql/sql_parse.cc:1828(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55e20773c065]
sql/sql_parse.cc:1357(do_command(THD*))[0x55e2078b2bc8]
sql/sql_connect.cc:1399(do_handle_one_connection(CONNECT*))[0x55e2078b292c]
sql/sql_connect.cc:1303(handle_one_connection)[0x55e2081cf2e8]
pthread_create.c:0(start_thread)[0x7fcebe6bca9d]
:0(__GI___clone)[0x7fcebd7c9b23]



 Comments   
Comment by Sachin Setiya (Inactive) [ 2019-03-11 ]

bb-10.4-sachin

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