Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
5.5(EOL), 10.0(EOL)
-
None
Description
The problem MDEV-7139 is happening again, observed 4 times over the last 2 months on p8-rhel71-bintar-debug and p8-rhel7-bintar-debug, 5.5 and 10.0.
Latest occasion: http://buildbot.askmonty.org/buildbot/builders/p8-rhel71-bintar-debug/builds/699/steps/test/logs/stdio
innodb.innodb_corrupt_bit 'xtradb' w2 [ fail ]
|
Test ended at 2016-01-15 04:07:57
|
|
CURRENT_TEST: innodb.innodb_corrupt_bit
|
mysqltest: At line 79: query 'INSERT INTO corrupt_bit_test_ā VALUES(13000,'x',1,1)' failed: 1062: Duplicate entry '1-x' for key 'idxā'
|
|
The result from queries just before the failure was:
|
< snip >
|
@@unique_checks
|
0
|
select @@innodb_change_buffering_debug;
|
@@innodb_change_buffering_debug
|
1
|
INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+1,z+1 FROM corrupt_bit_test_ā;
|
INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+10,z+10 FROM corrupt_bit_test_ā;
|
INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+20,z+20 FROM corrupt_bit_test_ā;
|
INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+50,z+50 FROM corrupt_bit_test_ā;
|
INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+100,z+100 FROM corrupt_bit_test_ā;
|
INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+200,z+200 FROM corrupt_bit_test_ā;
|
INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+400,z+400 FROM corrupt_bit_test_ā;
|
INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+800,z+800 FROM corrupt_bit_test_ā;
|
INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+1600,z+1600 FROM corrupt_bit_test_ā;
|
INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+4000,z+4000 FROM corrupt_bit_test_ā;
|
select count(*) from corrupt_bit_test_ā;
|
count(*)
|
1024
|
CREATE INDEX idx3 ON corrupt_bit_test_ā(b, c);
|
INSERT INTO corrupt_bit_test_ā VALUES(13000,'x',1,1);
|
Duplicate of
MDEV-7139.commit 0f252702b15dfb5d90446fd49c9e28aa93424eb1
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Wed Jun 8 08:40:10 2016 +0300
MDEV-7139: Sporadic failure in innodb.innodb_corrupt_bit on P8Use direct persistent index corruption set on InnoDB dictionary
for this test. Do not allow creating new indexes if one of the
existing indexes is already marked as corrupted.