Crash in hp_movelink in mysql-55-eb

Bug #783366 reported by Philip Stoev on 2011-05-16
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
percona-projects-qa
High
Valentine Gostev

Bug Description

Not reproducible on mysql-5.5.

Backtrace:

#4 <signal handler called>
#5 0x085fcfe0 in hp_movelink (pos=0xaea11748, next_link=0x0, newlink=0xaea11760) at /home/philips/bzr/mysql-55-eb/storage/heap/hp_hash.c:232
#6 0x086020c2 in hp_write_key (info=0xaea14160, keyinfo=0xaea11428, record=0xaea33fe0 "", recpos=0xaea4a840 "")
    at /home/philips/bzr/mysql-55-eb/storage/heap/hp_write.c:336
#7 0x086019f0 in heap_write (info=0xaea14160, record=0xaea33fe0 "") at /home/philips/bzr/mysql-55-eb/storage/heap/hp_write.c:63
#8 0x085fa6e0 in ha_heap::write_row (this=0xaea33ec0, buf=0xaea33fe0 "") at /home/philips/bzr/mysql-55-eb/storage/heap/ha_heap.cc:240
#9 0x08355a43 in handler::ha_write_row (this=0xaea33ec0, buf=0xaea33fe0 "") at /home/philips/bzr/mysql-55-eb/sql/handler.cc:4781
#10 0x081ed5ac in write_record (thd=0xa238fe0, table=0xaea136b8, info=0xb17b703c) at /home/philips/bzr/mysql-55-eb/sql/sql_insert.cc:1734
#11 0x081eb7ee in mysql_insert (thd=0xa238fe0, table_list=0xaea047c8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR,
    ignore=true) at /home/philips/bzr/mysql-55-eb/sql/sql_insert.cc:928
#12 0x08203178 in mysql_execute_command (thd=0xa238fe0) at /home/philips/bzr/mysql-55-eb/sql/sql_parse.cc:2787
#13 0x0820a92a in mysql_parse (thd=0xa238fe0, rawbuf=0xaea046d0 "INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' )", length=64,
    parser_state=0xb17b8034) at /home/philips/bzr/mysql-55-eb/sql/sql_parse.cc:5503
#14 0x081feffa in dispatch_command (command=COM_QUERY, thd=0xa238fe0, packet=0xa2d0919 "INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' )",
    packet_length=64) at /home/philips/bzr/mysql-55-eb/sql/sql_parse.cc:1034
#15 0x081fe4e8 in do_command (thd=0xa238fe0) at /home/philips/bzr/mysql-55-eb/sql/sql_parse.cc:771
#16 0x082cced5 in do_handle_one_connection (thd_arg=0xa238fe0) at /home/philips/bzr/mysql-55-eb/sql/sql_connect.cc:776
#17 0x082ccb98 in handle_one_connection (arg=0xa238fe0) at /home/philips/bzr/mysql-55-eb/sql/sql_connect.cc:724
#18 0x084d9648 in pfs_spawn_thread (arg=0xa2c07a0) at /home/philips/bzr/mysql-55-eb/storage/perfschema/pfs.cc:1015
#19 0x00821919 in start_thread () from /lib/libpthread.so.0
#20 0x0076acce in clone () from /lib/libc.so.6

test case:

CREATE TABLE t1 (
        f1 VARCHAR ( 128 ) ,
        f2 VARCHAR ( 32 ),
        PRIMARY KEY ( f2 ( 2 ) , f1 )
)
ENGINE=HEAP KEY_BLOCK_SIZE = 512;
INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' );
INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' );

Changed in percona-projects-qa:
assignee: nobody → Valentine Gostev (core-longbow)
Philip Stoev (pstoev-askmonty) wrote :

Also repeatable with single-part primary keys. Seems like it is important for the key to be a prefix key.

Valentine Gostev (longbow) wrote :

Commited test case

Changed in percona-projects-qa:
status: New → Triaged
importance: Undecided → High
assignee: Valentine Gostev (core-longbow) → Laurynas Biveinis (laurynas-biveinis)
milestone: none → 5.5.13-eb
Changed in percona-projects-qa:
status: Triaged → In Progress
Changed in percona-projects-qa:
status: In Progress → Triaged
status: Triaged → In Progress
Changed in percona-projects-qa:
status: In Progress → Fix Committed
Valentine Gostev (longbow) wrote :

Reproduced again. Laurynas,
please refer to /mnt/x25m/heap-blob-bin/mysql-test/var/log/master.err at r900

To reproduce run:

./runall.pl --basedir=/mnt/x25m/heap-blob-bin --grammar=conf/engines/heap/heap_ddl_multi.yy --mysqld=--max_heap_table_size=2Gb --threads=4 --queries=1000K --duration=3600 --validator=None --valgrind

Changed in percona-projects-qa:
status: Fix Committed → Triaged
Valentine Gostev (longbow) wrote :

randgen files are located at /mnt/x25m/randgen

Re-assigning to you as apparently it is not reproducible with the latest branches, please close or update/reassign as necessary.

Changed in percona-projects-qa:
assignee: Laurynas Biveinis (laurynas-biveinis) → Valentine Gostev (longbow)
Valentine Gostev (longbow) wrote :

Fix is ok.

Changed in percona-projects-qa:
status: Triaged → Fix Committed
summary: - Crash in hp_movelink in maria-55-eb
+ Crash in hp_movelink in mysql-55-eb
Changed in percona-projects-qa:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers