Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/3235/steps/mtr/logs/stdio
innodb.innodb_zip_innochecksum3 '16k,innodb' w4 [ fail ]
|
Test ended at 2017-11-14 17:37:32
|
|
CURRENT_TEST: innodb.innodb_zip_innochecksum3
|
Error: Unable to lock file:: /dev/shm/var/4/mysqld.1/data//test/tab1.ibd
|
fcntl: Resource temporarily unavailable
|
mysqltest: At line 109: exec of '/usr/bin/innochecksum --write=CRC32 /dev/shm/var/4/mysqld.1/data//test/tab1.ibd' failed, error: 256, status: 1, errno: 32
|
Output from before failure:
|
[1(b)]: Rewrite into new checksum=crc32 for all *.ibd file and ibdata1
|
|
|
|
The result from queries just before the failure was:
|
< snip >
|
VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,1);
|
SELECT * FROM tab2 ORDER BY col_7;
|
# stop the server
|
[1(a)]: Rewrite into new checksum=InnoDB for all *.ibd file and ibdata1
|
: start the server with innodb_checksum_algorithm=strict_innodb
|
INSERT INTO tab1 (pk, linestring_key, linestring_nokey)
|
VALUES (2, ST_GeomFromText('LINESTRING(10 10,20 20,30 30)'), ST_GeomFromText('LINESTRING(10 10,20 20,30 30)'));
|
SET @col_1 = repeat('a', 5);
|
SET @col_2 = repeat('b', 20);
|
SET @col_3 = repeat('c', 100);
|
SET @col_4 = repeat('d', 100);
|
SET @col_5 = repeat('e', 100);
|
SET @col_6 = repeat('f', 100);
|
INSERT INTO tab2(col_1,col_2,col_3,col_4,col_5,col_6,col_7)
|
VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,6);
|
SELECT pk,ST_AsText(linestring_key),ST_AsText(linestring_nokey)
|
FROM tab1 ORDER BY pk;
|
SELECT * FROM tab2 ORDER BY col_7;
|
# stop the server
|
[1(b)]: Rewrite into new checksum=crc32 for all *.ibd file and ibdata1
|
|
More results from queries before failure can be found in /dev/shm/var/4/log/innodb_zip_innochecksum3.log
|
Attachments
Issue Links
- is duplicated by
-
MDEV-20158 innodb_zip.innochecksum failed in buildbot, server didn't shut down
- Closed
- relates to
-
MDEV-14080 InnoDB shutdown sometimes hangs
- Closed
-
MDEV-22577 innodb_fast_shutdown=0 fails to report purge progress
- Closed
-
MDEV-26264 server wont start after clean shutdown
- Open
-
MDEV-27125 galera_new_cluster hangs with galera_recovery
- Open
-
MDEV-32033 all queries get stuck until a timeout occurs on all of them
- Open
-
MDEV-26327 Assertion `!"purge was not shut down"' in logs_empty_and_mark_files_at_shutdown during bootstrap
- Open