Valgrind: bytes lost in operator new[] | Table_node::Table_node

[Roel Van de Paar]

==11149== 56 bytes in 1 blocks are still reachable in loss record 211 of 474
==11149== at 0x4A07152: operator new[](unsigned long) (vg_replace_malloc.c:363)
==11149== by 0x71AA37: Table_node::Table_node(TABLE const*) (sql_base.cc:9487)
==11149== by 0x71AB6E: Const_ordered_table_node::Const_ordered_table_node(TABLE const*) (sql_base.cc:9573)
==11149== by 0x72B186: Join_node::add_table(TABLE const*) (sql_base.cc:9627)
==11149== by 0x72B32E: Join_node::add_join_list(List<TABLE_LIST>*) (sql_base.cc:9621)
==11149== by 0x72B3BC: Join_node::Join_node(List<TABLE_LIST>*, Item*, st_order const*) (sql_base.cc:9638)
==11149== by 0x71ACC7: is_order_deterministic(List<TABLE_LIST>*, Item*, st_order*) (sql_base.cc:9837)
==11149== by 0x8E6B37: JOIN::optimize() (sql_optimizer.cc:276)
==11149== by 0x79F59B: mysql_execute_select(THD*, st_select_lex*, bool) (sql_select.cc:1087)
==11149== by 0x79FDC3: mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, SQL_I_List<st_order>*, SQL_I_List<st_order>*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:1222)
==11149== by 0x79FF77: handle_select(THD*, select_result*, unsigned long) (sql_select.cc:111)
==11149== by 0x77B282: mysql_execute_command(THD*) (sql_parse.cc:3727)
==11149== by 0x77BC87: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6477)
==11149== by 0x77C81E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1374)
==11149== by 0x77D4F4: do_command(THD*) (sql_parse.cc:1049)
==11149== by 0x746ECE: do_handle_one_connection(THD*) (sql_connect.cc:1615)
==11149==
==11149== 840 bytes in 15 blocks are definitely lost in loss record 378 of 474
==11149== at 0x4A07152: operator new[](unsigned long) (vg_replace_malloc.c:363)
==11149== by 0x71AA37: Table_node::Table_node(TABLE const*) (sql_base.cc:9487)
==11149== by 0x71AB6E: Const_ordered_table_node::Const_ordered_table_node(TABLE const*) (sql_base.cc:9573)
==11149== by 0x72B186: Join_node::add_table(TABLE const*) (sql_base.cc:9627)
==11149== by 0x72B32E: Join_node::add_join_list(List<TABLE_LIST>*) (sql_base.cc:9621)
==11149== by 0x72B3BC: Join_node::Join_node(List<TABLE_LIST>*, Item*, st_order const*) (sql_base.cc:9638)
==11149== by 0x71ACC7: is_order_deterministic(List<TABLE_LIST>*, Item*, st_order*) (sql_base.cc:9837)
==11149== by 0x8E6B37: JOIN::optimize() (sql_optimizer.cc:276)
==11149== by 0x79F59B: mysql_execute_select(THD*, st_select_lex*, bool) (sql_select.cc:1087)
==11149== by 0x79FDC3: mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, SQL_I_List<st_order>*, SQL_I_List<st_order>*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:1222)
==11149== by 0x79FF77: handle_select(THD*, select_result*, unsigned long) (sql_select.cc:111)
==11149== by 0x77B282: mysql_execute_command(THD*) (sql_parse.cc:3727)
==11149== by 0x77BC87: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6477)
==11149== by 0x77C81E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1374)
==11149== by 0x77D4F4: do_command(THD*) (sql_parse.cc:1049)
==11149== by 0x746ECE: do_handle_one_connection(THD*) (sql_connect.cc:1615)
==11149==
==11149== 896 bytes in 16 blocks are definitely lost in loss record 382 of 474
==11149== at 0x4A07152: operator new[](unsigned long) (vg_replace_malloc.c:363)
==11149== by 0x71AA37: Table_node::Table_node(TABLE const*) (sql_base.cc:9487)
==11149== by 0x71AB90: Const_ordered_table_node::Const_ordered_table_node(TABLE const*) (sql_base.cc:9573)
==11149== by 0x72B186: Join_node::add_table(TABLE const*) (sql_base.cc:9627)
==11149== by 0x72B32E: Join_node::add_join_list(List<TABLE_LIST>*) (sql_base.cc:9621)
==11149== by 0x72B3BC: Join_node::Join_node(List<TABLE_LIST>*, Item*, st_order const*) (sql_base.cc:9638)
==11149== by 0x71ACC7: is_order_deterministic(List<TABLE_LIST>*, Item*, st_order*) (sql_base.cc:9837)
==11149== by 0x8E6B37: JOIN::optimize() (sql_optimizer.cc:276)
==11149== by 0x79F59B: mysql_execute_select(THD*, st_select_lex*, bool) (sql_select.cc:1087)
==11149== by 0x79FDC3: mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, SQL_I_List<st_order>*, SQL_I_List<st_order>*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:1222)
==11149== by 0x79FF77: handle_select(THD*, select_result*, unsigned long) (sql_select.cc:111)
==11149== by 0x77B282: mysql_execute_command(THD*) (sql_parse.cc:3727)
==11149== by 0x77BC87: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6477)
==11149== by 0x77C81E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1374)
==11149== by 0x77D4F4: do_command(THD*) (sql_parse.cc:1049)
==11149== by 0x746ECE: do_handle_one_connection(THD*) (sql_connect.cc:1615)

[Roel Van de Paar (roel11)]

Issues only seen after server shutdown, so any query or other param could have caused it

[Roel Van de Paar (roel11)]

[roel@qaserver 209184]$ cat cmd311
ps -ef | grep 'cmdrun_311' | grep -v grep | awk '{print $2}' | xargs sudo kill -9
rm -Rf /ssd/209184/cmdrun_311
mkdir /ssd/209184/cmdrun_311
cd /ssd/randgen
bash -c "set -o pipefail; perl /ssd/randgen/runall.pl --queries=100000000 --seed=28224 --sqltrace --duration=600 --querytimeout=60 --reporter=Shutdown,Backtrace,QueryTimeout,ErrorLog,ErrorLogAlarm --mysqld=--log-output=none --mysqld=--sql_mode=ONLY_FULL_GROUP_BY --mysqld=--slow_query_log --mysqld=--userstat --threads=25 --notnull --basedir=/ssd/Percona-Server-5.6.12-rc60.4-405-debug-valgrind.Linux.x86_64 --valgrind --reporter=ValgrindErrors --validator=MarkErrorLog --grammar=/tmp/976291/92.yy --gendata=/ssd/randgen/conf/percona/outer_join_percona.zz --mtr-build-thread=751 --mask=29771 --vardir1=/ssd/209184/cmdrun_311 > /ssd/209184/cmdrun311.log 2>&1"

[Laurynas Biveinis (laurynas-biveinis)]

100% upstream.

[Sergei Glushchenko (sergei.glushchenko)]

Not an upstream

[Shahriyar Rzayev (rzayev-sehriyar)]

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