Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.4
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/6374
10.4 f9e53a659c87f1147d4f6d004702077d |
gcol.innodb_virtual_purge 'innodb' w3 [ fail ]
|
Test ended at 2020-06-12 06:59:09
|
|
CURRENT_TEST: gcol.innodb_virtual_purge
|
mysqltest: At line 170: query 'TRUNCATE TABLE t2' failed: 1205: Lock wait timeout exceeded; try restarting transaction
|
|
The result from queries just before the failure was:
|
< snip >
|
CREATE TABLE t1 (a VARCHAR(30), b INT, a2 VARCHAR(30) GENERATED ALWAYS AS (a) VIRTUAL);
|
CREATE INDEX idx ON t1(a2(10), b, a2(20));
|
ERROR 42S21: Duplicate column name 'a2'
|
DROP TABLE t1;
|
#
|
# MDEV-17540 Server crashes in row_purge after TRUNCATE TABLE
|
#
|
CREATE TABLE t1 (a BIT(14)) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES
|
(b'01110110101011'),(b'01100111111000'),(b'00001011110100'),
|
(b'01110110111010'),(b'10001010101011'),(b'01100111001111');
|
CREATE TABLE t2 (
|
pk INT DEFAULT 1,
|
b YEAR,
|
c BIT(14),
|
d YEAR AS (b),
|
e BIT(14) AS (c),
|
UNIQUE(pk),
|
KEY(e)
|
) ENGINE=InnoDB;
|