[MDEV-4794] Assertion `bitmap_is_set(&m_partitions_to_reset, m_part_spec.start_part)' fails on UPDATE .. PARTITION Created: 2013-07-18  Updated: 2013-07-31  Resolved: 2013-07-31

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 10.0.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-4798 Assertion `table_share->tmp_table != ... Closed

 Description   

mysqld: /home/elenst/bzr/10.0-monty/sql/ha_partition.cc:7106: void ha_partition::prepare_extra_cache(uint): Assertion `bitmap_is_set(&m_partitions_to_reset, m_part_spec.start_part)' failed.
130718 22:03:45 [ERROR] mysqld got signal 6 ;

#7  0x00007f4f288d5192 in __GI___assert_fail (assertion=0x102fb00 "bitmap_is_set(&m_partitions_to_reset, m_part_spec.start_part)", file=0x102dc58 "/home/elenst/bzr/10.0-monty/sql/ha_partition.cc", line=7106, function=0x10308e0 "void ha_partition::prepare_extra_cache(uint)") at assert.c:103
#8  0x0000000000d9bad1 in ha_partition::prepare_extra_cache (this=0x7f4f101453f8, cachesize=131072) at /home/elenst/bzr/10.0-monty/sql/ha_partition.cc:7105
#9  0x0000000000d9b9f6 in ha_partition::extra_opt (this=0x7f4f101453f8, operation=HA_EXTRA_CACHE, cachesize=131072) at /home/elenst/bzr/10.0-monty/sql/ha_partition.cc:7080
#10 0x0000000000919fff in init_read_record (info=0x7f4f29f9f900, thd=0x3708180, table=0x7f4f10144a00, select=0x7f4f100084a0, use_record_cache=0, print_error=true, disable_rr_cache=false) at /home/elenst/bzr/10.0-monty/sql/records.cc:286
#11 0x00000000006e532c in mysql_update (thd=0x3708180, table_list=0x7f4f10007950, fields=..., values=..., conds=0x7f4f10008298, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f4f29fa0000, updated_return=0x7f4f29fa0008) at /home/elenst/bzr/10.0-monty/sql/sql_update.cc:546
#12 0x0000000000628728 in mysql_execute_command (thd=0x3708180) at /home/elenst/bzr/10.0-monty/sql/sql_parse.cc:3195
#13 0x0000000000630e3c in mysql_parse (thd=0x3708180, rawbuf=0x7f4f100077f8 "UPDATE t1 PARTITION (p0) SET i = 9 WHERE i = 8", length=46, parser_state=0x7f4f29fa04e0) at /home/elenst/bzr/10.0-monty/sql/sql_parse.cc:6190
#14 0x0000000000623d7b in dispatch_command (command=COM_QUERY, thd=0x3708180, packet=0x370d561 "UPDATE t1 PARTITION (p0) SET i = 9 WHERE i = 8", packet_length=46) at /home/elenst/bzr/10.0-monty/sql/sql_parse.cc:1266
#15 0x0000000000622efa in do_command (thd=0x3708180) at /home/elenst/bzr/10.0-monty/sql/sql_parse.cc:982
#16 0x00000000007351aa in do_handle_one_connection (thd_arg=0x3708180) at /home/elenst/bzr/10.0-monty/sql/sql_connect.cc:1379
#17 0x0000000000734b78 in handle_one_connection (arg=0x3708180) at /home/elenst/bzr/10.0-monty/sql/sql_connect.cc:1293
#18 0x00000000009aed14 in pfs_spawn_thread (arg=0x362e060) at /home/elenst/bzr/10.0-monty/storage/perfschema/pfs.cc:1853
#19 0x00007f4f296a5e9a in start_thread (arg=0x7f4f29fa1700) at pthread_create.c:308
#20 0x00007f4f28999cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

bzr version-info

revision-id: sergii@pisem.net-20130717165112-i9klgxk4enpvc09a
revno: 3637
branch-nick: 10.0-monty

Could not reproduce on MySQL 5.6.10.

Test case:

--source include/have_partition.inc
 
CREATE TABLE t1 (i INT) ENGINE = MYISAM PARTITION BY LIST (i) ( PARTITION p0 VALUES IN (0, 9), PARTITION p1 VALUES IN (6, 8) );
INSERT INTO t1 VALUES (8),(6),(0);
UPDATE t1 PARTITION (p0) SET i = 9 WHERE i = 8;



 Comments   
Comment by Igor Babaev [ 2013-07-31 ]

This bug is the result of a bad merge in prune_partitions()

Generated at Thu Feb 08 06:59:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.