Valgrind warning in MyISAM in mysql-55-eb-blobs
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
percona-projects-qa |
Invalid
|
Undecided
|
Alexey Kopytov |
Bug Description
The test case below causes the following warning to be produced. It seems that a blob field is required for the warning to occur. Maybe the INSERT ... SELECT statement is executed via a temporary MyISAM table, which in turn gets invalid data from the heap storage engine?
Warnings:
==22774== Thread 3:
==22774== Syscall param write(buf) points to uninitialised byte(s)
==22774== at 0x35A720E48D: ??? (in /lib64/
==22774== by 0x8D717D: my_write (my_write.c:41)
==22774== by 0x8B900C: inline_
==22774== by 0x8BC0E7: my_b_flush_io_cache (mf_iocache.c:1775)
==22774== by 0x8BC383: end_io_cache (mf_iocache.c:1846)
==22774== by 0x90E450: mi_extra (mi_extra.c:156)
==22774== by 0x8EC229: ha_myisam:
==22774== by 0x64050A: do_select(JOIN*, List<Item>*, TABLE*, Procedure*) (sql_select.
==22774== by 0x6269B0: JOIN::exec() (sql_select.
==22774== by 0x628A86: 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_
==22774== by 0x621093: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297)
==22774== by 0x5F7835: mysql_execute_
==22774== by 0x5FEDFA: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5503)
==22774== by 0x5F2D74: dispatch_
==22774== by 0x5F1FD1: do_command(THD*) (sql_parse.cc:771)
==22774== by 0x6D7C7E: do_handle_
==22774== Address 0x774fd18 is 8 bytes inside a block of size 131,072 alloc'd
==22774== at 0x4A0515D: malloc (vg_replace_
==22774== by 0x8D3379: my_malloc (my_malloc.c:38)
==22774== by 0x8B986C: init_io_cache (mf_iocache.c:232)
==22774== by 0x90E3B6: mi_extra (mi_extra.c:137)
==22774== by 0x8EC229: ha_myisam:
==22774== by 0x640176: do_select(JOIN*, List<Item>*, TABLE*, Procedure*) (sql_select.
==22774== by 0x6269B0: JOIN::exec() (sql_select.
==22774== by 0x628A86: 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_
==22774== by 0x621093: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297)
==22774== by 0x5F7835: mysql_execute_
==22774== by 0x5FEDFA: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5503)
==22774== by 0x5F2D74: dispatch_
==22774== by 0x5F1FD1: do_command(THD*) (sql_parse.cc:771)
==22774== by 0x6D7C7E: do_handle_
==22774== by 0x6D78C5: handle_
==22774== by 0x95B229: pfs_spawn_thread (pfs.cc:1015)
bzr version-info:
revision-id: <email address hidden>
date: 2011-05-27 13:09:02 +0400
build-date: 2011-05-27 16:18:16 +0300
revno: 3475
branch-nick: mysql-55-eb-blobs
test case:
CREATE TABLE IF NOT EXISTS t1 ( f1 VARCHAR ( 128 ) NOT NULL , f2 VARCHAR ( 128 ) NOT NULL DEFAULT 'uhopqdvzwlasck
INSERT IGNORE INTO t1 VALUES ( 'o' , REPEAT( 'fadihqxaombnrb
INSERT IGNORE INTO t1 SELECT * FROM t1;
Changed in percona-projects-qa: | |
assignee: | nobody → Alexey Kopytov (akopytov) |
Changed in percona-projects-qa: | |
milestone: | none → 5.5.13-eb |
Changed in percona-projects-qa: | |
status: | New → Fix Committed |
Not reproducible if the table is MyISAM. Not reproducible if f4 is VARCHAR(255)