Bug #94552 innodb.virtual_basic fails when valgrind is enabled
Submitted: 4 Mar 2019 18:15 Modified: 3 Dec 2019 5:26
Reporter: Manuel Ung Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:8.0.15 OS:Any
Assigned to: CPU Architecture:Any

[4 Mar 2019 18:15] Manuel Ung 
Description:
When compiled with WITH_VALGRIND, the innodb.virtual_basic test fails with the following:

==1113929== Conditional jump or move depends on uninitialised value(s)
==1113929==    at 0x341F995: my_lengthsp_utf32 (ctype-ucs2.cc:2167)
==1113929==    by 0x23E28FD: Field_string::val_str(String*, String*) (field.cc:6316)
==1113929==    by 0x245E170: Item_func_like::val_int() (item_cmpfunc.cc:5380)
==1113929==    by 0x243EE40: Item::send(Protocol*, String*) (item.cc:6603)
==1113929==    by 0x21E3883: THD::send_result_set_row(List<Item>*) (sql_class.cc:2546)
==1113929==    by 0x254AD78: Query_result_send::send_data(THD*, List<Item>&) (query_result.cc:94)
==1113929==    by 0x22010BB: end_send(JOIN*, QEP_TAB*, bool) (sql_executor.cc:3185)
==1113929==    by 0x2205544: evaluate_join_record(JOIN*, QEP_TAB*) (sql_executor.cc:1901)
==1113929==    by 0x2208772: sub_select(JOIN*, QEP_TAB*, bool) (sql_executor.cc:1563)
==1113929==    by 0x220274E: do_select(JOIN*) (sql_executor.cc:1166)
==1113929==    by 0x2202DC5: JOIN::exec() (sql_executor.cc:282)
==1113929==    by 0x2275D9F: Sql_cmd_dml::execute_inner(THD*) (sql_select.cc:695)
==1113929==    by 0x227968F: Sql_cmd_dml::execute(THD*) (sql_select.cc:593)
==1113929==    by 0x2234D4D: mysql_execute_command(THD*, bool) (sql_parse.cc:4354)
==1113929==    by 0x2236F21: mysql_parse(THD*, Parser_state*, bool) (sql_parse.cc:5105)
==1113929==    by 0x2237D3C: dispatch_command(THD*, COM_DATA const*, enum_server_command) (sql_parse.cc:1715)

This test succeeds if WITH_VALGRIND isn't specified, but mtr is run with --valgrind.

How to repeat:
Compile mysql with the valgrind cmake options: -DWITH_VALGRIND=1

Run ./mtr --valgrind innodb.virtual_basic
[5 Mar 2019 7:18] MySQL Verification Team 
Hello Manuel,

Thank you for the report and feedback.

regards,
Umesh
[20 Sep 2019 13:13] Jon Olav Hauglid 
Posted by developer:
 
No longer repeatable. Closing as a duplicate of 
Bug #28184025	UNEXPECTED PADDING TRAILING SPACES FOR VIRTUAL COLUMN ON PREFIX INDEX
[3 Dec 2019 5:26] Erlend Dahl 
Fixed in 8.0.17 under the heading of the above bug.