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