Valgrind warnings on select from INNODB_BUFFER_POOL_PAGES

[Elena Stepanova]

SET sort_buffer_size=1048576;
SET max_heap_table_size=1048576;
SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES ORDER BY space_id;

==18619== Conditional jump or move depends on uninitialised value(s)
==18619== at 0x945DB4: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:6571)
==18619== by 0x681C53: do_fill_table(THD*, TABLE_LIST*, st_join_table*) (sql_show.cc:7413)
==18619== by 0x68207B: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7519)
==18619== by 0x63932D: JOIN::exec() (sql_select.cc:1937)
==18619== by 0x63B834: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2610)
==18619== by 0x63398B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:313)
==18619== by 0x60C62C: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4741)
==18619== by 0x60502A: mysql_execute_command(THD*) (sql_parse.cc:2284)
==18619== by 0x60E90F: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5811)
==18619== by 0x602361: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1061)
==18619== by 0x6015FA: do_command(THD*) (sql_parse.cc:788)
==18619== by 0x6F49B7: do_handle_one_connection(THD*) (sql_connect.cc:1484)
==18619== by 0x6F4379: handle_one_connection (sql_connect.cc:1391)
==18619== by 0xAA95EE: pfs_spawn_thread (pfs.cc:1015)
==18619== by 0x5B19EFB: start_thread (pthread_create.c:304)
==18619== by 0x5E13F4C: clone (clone.S:112)

...

==18619== Invalid read of size 1
==18619== at 0xA42ED8: mach_read_from_2 (mach0data.ic:84)
==18619== by 0xA07A0C: fil_page_get_type (fil0fil.c:5888)
==18619== by 0x945DAF: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:6571)
==18619== by 0x681C53: do_fill_table(THD*, TABLE_LIST*, st_join_table*) (sql_show.cc:7413)
==18619== by 0x68207B: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7519)
==18619== by 0x63932D: JOIN::exec() (sql_select.cc:1937)
==18619== by 0x63B834: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2610)
==18619== by 0x63398B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:313)
==18619== by 0x60C62C: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4741)
==18619== by 0x60502A: mysql_execute_command(THD*) (sql_parse.cc:2284)
==18619== by 0x60E90F: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5811)
==18619== by 0x602361: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1061)
==18619== by 0x6015FA: do_command(THD*) (sql_parse.cc:788)
==18619== by 0x6F49B7: do_handle_one_connection(THD*) (sql_connect.cc:1484)
==18619== by 0x6F4379: handle_one_connection (sql_connect.cc:1391)
==18619== by 0xAA95EE: pfs_spawn_thread (pfs.cc:1015)

...

==18619== Use of uninitialised value of size 8
==18619== at 0x91A1E6: radixsort_for_str_ptr (mf_radix.c:39)
==18619== by 0x8F5B8A: my_string_ptr_sort (mf_sort.c:29)
==18619== by 0x77EF27: save_index(st_sort_param*, unsigned char**, unsigned int, st_filesort_info*) (filesort.cc:1050)
==18619== by 0x77CC7C: filesort(THD*, TABLE*, st_sort_field*, unsigned int, SQL_SELECT*, unsigned long long, bool, unsigned long long*) (filesort.cc:254)
==18619== by 0x658310: create_sort_index(THD*, JOIN*, st_order*, unsigned long long, unsigned long long, bool) (sql_select.cc:14216)
==18619== by 0x63AE90: JOIN::exec() (sql_select.cc:2371)
==18619== by 0x63B834: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2610)
==18619== by 0x63398B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:313)
==18619== by 0x60C62C: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4741)
==18619== by 0x60502A: mysql_execute_command(THD*) (sql_parse.cc:2284)
==18619== by 0x60E90F: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5811)
==18619== by 0x602361: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1061)
==18619== by 0x6015FA: do_command(THD*) (sql_parse.cc:788)
==18619== by 0x6F49B7: do_handle_one_connection(THD*) (sql_connect.cc:1484)
==18619== by 0x6F4379: handle_one_connection (sql_connect.cc:1391)
==18619== by 0xAA95EE: pfs_spawn_thread (pfs.cc:1015)
==18619== Conditional jump or move depends on uninitialised value(s)

etc.

branch: percona-server/5.5
revision-id: <email address hidden>
revno: 386

branch: percona-server/5.1
revision-id: <email address hidden>
revno: 509

[Elena Stepanova (elenst)]

Server was built with BUILD/compile-pentium-valgrind-max-no-ndb (on 5.1 as is, on 5.5 without embedded server as otherwise the build fails)

[Laurynas Biveinis (laurynas-biveinis)]

Very likely related to bug 1056581 and possibly to bug 1072573 too.

[Valerii Kravchuk (valerii-kravchuk)]

PS 5.6 does not have this INNODB_BUFFER_POOL_PAGES table at all - it uses INNODB_BUFFER_PAGE from upstream it seems.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2864