Failing assertion: trx->active_trans

[Alexey Kopytov]

PS 5.1 fails with a debug assertion failure on the following SQL:

CREATE TABLE p (
  a int
) ENGINE=InnoDB
PARTITION BY RANGE (a)
(PARTITION p0 VALUES LESS THAN (100),
 PARTITION p1 VALUES LESS THAN (200),
 PARTITION p2 VALUES LESS THAN (300),
 PARTITION p3 VALUES LESS THAN (400));

INSERT INTO p VALUES (1), (101), (201), (301);

ALTER TABLE p DROP PARTITION p0;

ALTER TABLE p DROP PARTITION p1;

ALTER TABLE p ADD PARTITION (PARTITION p4 VALUES LESS THAN (500));

ALTER TABLE p ADD PARTITION (PARTITION p5 VALUES LESS THAN (600));

Error log:

InnoDB: Assertion failure in thread 4539224064 in file handler/ha_innodb.cc line 10933
InnoDB: Failing assertion: trx->active_trans

Debug PS 5.5 and 5.6 builds are not affected. A debug build of upstream 5.1 is not affected.

[Shahriyar Rzayev (rzayev-sehriyar)]

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