Conditional jump or move depends on uninitialised value(s) in create_tmp_table

[Roel Van de Paar]

130122 8:40:42 [Note] /ssd/Percona-Server-5.5.28-rel29.3-415.Linux.x86_64/bin/mysqld: ready for connections.
Version: '5.5.29-rel29.3-log' socket: '/ssd/775838/vardir1_98/tmp/master.sock' port: 18633 Percona Server with XtraDB (GPL), Release rel29.3, Revision 415
==29712== Thread 19:
==29712== Conditional jump or move depends on uninitialised value(s)
==29712== at 0x5CDD16: create_tmp_table(THD*, TMP_TABLE_PARAM*, List<Item>&, st_order*, bool, bool, unsigned long long, unsigned long long, char const*) (sql_select.cc:10311)
==29712== by 0x5E4588: create_schema_table(THD*, TABLE_LIST*) (sql_show.cc:7048)
==29712== by 0x5F7A96: mysql_schema_table(THD*, LEX*, TABLE_LIST*) (sql_show.cc:7266)
==29712== by 0x56E36D: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4451)
==29712== by 0x56EFB6: open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) (sql_base.cc:5547)
==29712== by 0x599DB0: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_base.h:475)
==29712== by 0x5A1EF2: mysql_execute_command(THD*) (sql_parse.cc:2284)
==29712== by 0x5A5CA1: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5844)
==29712== by 0x5A71DC: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1061)
==29712== by 0x63FD6E: do_handle_one_connection(THD*) (sql_connect.cc:1497)
==29712== by 0x63FE30: handle_one_connection (sql_connect.cc:1404)
==29712== by 0x3DA1807D13: start_thread (in /usr/lib64/libpthread-2.15.so)
==29712== by 0x3DA14F168C: clone (in /usr/lib64/libc-2.15.so)
==29712==
130122 8:40:42 [Note] /ssd/Percona-Server-5.5.28-rel29.3-415.Linux.x86_64/bin/mysqld: Normal shutdown

[Roel Van de Paar (roel11)]

Testcase is easy:

$ cat start_mtr98
cd /ssd/Percona-Server-5.5.28-rel29.3-415.Linux.x86_64/mysql-test/
perl lib/v1/mysql-test-run.pl --start-and-exit --valgrind --vardir=/ssd/775838/vardir1_98 --master_port=18633 --mysqld="--innodb-max-bitmap-file-size=4095" --mysqld="--innodb-changed-pages-limit=-1" 1st 2>&1
$ cat stop_mtr98
/ssd/Percona-Server-5.5.28-rel29.3-415.Linux.x86_64/bin/mysqladmin -uroot -S/ssd/775838/vardir1_98/tmp/master.sock shutdown
$ ./start_mtr98;./stop_mtr98
$ vi /ssd/775838/vardir1_98/log/master.err # And see Valgrind error

Not repeatable on mysql-5.5.29-linux2.6-x86_64 (with --innodb-max-bitmap-file-size=4095 and --innodb-changed-pages-limit=-1 removed as it's not applicable to MS)

[Laurynas Biveinis (laurynas-biveinis)]

Cannot reproduce on the trunk nor on 16274 QA branch with

MTR_VERSION=1
and
$ cat start_mtr99
perl mysql-test-run.pl --start-and-exit --valgrind --vardir=/home/laurynas/percona/src/tmp9 --master_port=17001 --mysqld="--innodb-max-bitmap-file-size=4095" --mysqld="--innodb-changed-pages-limit=-1" 1st

Also, please add --track-origins=yes to your Valgrind options.

[Launchpad Janitor (janitor)]

[Expired for Percona Server 5.6 because there has been no activity for 60 days.]

[Launchpad Janitor (janitor)]

[Expired for Percona Server because there has been no activity for 60 days.]

[Launchpad Janitor (janitor)]

[Expired for Percona Server 5.5 because there has been no activity for 60 days.]

[Shahriyar Rzayev (rzayev-sehriyar)]

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