MySQL Bugs: #53910: MTR test failures in archive engine: archive, archive_gis, federated

Bug #53910	MTR test failures in archive engine: archive, archive_gis, federated_archive
Submitted:	22 May 2010 2:05	Modified:	25 Jun 2010 8:57
Reporter:	Robin Johnson	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Tests: Engine	Severity:	S3 (Non-critical)
Version:	5.0.91	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
The tests for the archive engine fail in 5.0.91.

archive                        [ fail ]  timeout

Stopping All Servers
Warning;  Aborted waiting on pid file:
'/dev/shm/portage/dev-db/mysql-5.0.91/work/mysql/mysql-test/var-ps/run/master.pid' after
70 seconds
mysql-test-run: WARNING: Forcing kill of process 1084
Restoring snapshot of databases
Resuming Tests

archive_gis                    [ fail ]

--- /dev/shm/portage/dev-db/mysql-5.0.91/work/mysql/mysql-test/r/archive_gis.result
2010-05-05 17:31:03.000000000 +0300
+++ /dev/shm/portage/dev-db/mysql-5.0.91/work/mysql/mysql-test/r/archive_gis.reject
2010-05-22 01:39:10.178310414 +0300
@@ -83,171 +83,37 @@
 INSERT into gis_geometry SELECT * FROM gis_geometrycollection;
 SELECT fid, AsText(g) FROM gis_point ORDER by fid;
 fid    AsText(g)
-101    POINT(10 10)
-102    POINT(20 10)
-103    POINT(20 20)
-104    POINT(10 20)
 SELECT fid, AsText(g) FROM gis_line ORDER by fid;
(see attachment)

federated                      [ pass ]            298
federated_archive              [ fail ]

mysqltest: At line 36: query 'DELETE FROM federated.t1 WHERE id = 1' succeeded - should
have failed with errno 1296...

The result from queries just before the failure was:
< snip >
DROP DATABASE IF EXISTS federated;
CREATE DATABASE federated;
DROP TABLE IF EXISTS federated.archive_table;
CREATE TABLE federated.archive_table (
`id` int(4) NOT NULL,
`name` varchar(54) default NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS federated.t1;
CREATE TABLE federated.t1 (
`id` int(4) NOT NULL,
`name` varchar(54) default NULL,
PRIMARY KEY (`id`)
)
ENGINE="FEDERATED" DEFAULT CHARSET=latin1
CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/archive_table';
INSERT INTO federated.t1 (id, name) VALUES (1, 'foo');
INSERT INTO federated.t1 (id, name) VALUES (2, 'bar');
SELECT * FROM federated.t1;
id  name
DELETE FROM federated.t1 WHERE id = 1;

More results from queries before failure can be found in
/dev/shm/portage/dev-db/mysql-5.0.91/work/mysql/mysql-test/var-ps/log/federated_archive.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

How to repeat:
Run MTR with archive engine enabled.

archive_gis diff reject vs. expected result

Attachment: 20100521_mysql5.0.91-test-archive_gis.diff (text/x-patch), 13.95 KiB.

federated_archive diff actual test result vs expected

Attachment: 20100521_mysql5.0.91-test-federated_archive.diff (text/x-patch), 958 bytes.

Sorry about the attachment screwup on bug #53909, the files weren't copying properly to my desktop for uploading.

What OS are you testing on? I see no problems with recent 5.0.92 from bzr on Mac OS X:

valeriy-kravchuks-macbook-pro:mysql-test openxs$ ./mtr --force archive archive_gis federated federated_archive
Logging: ./mtr --force archive archive_gis federated federated_archive
MySQL Version 5.0.92
Using ndbcluster when necessary, mysqld supports it
Setting mysqld to support SSL connections
Binaries are debug compiled
mysql-test-run: WARNING: Could not find all required ndb binaries, all ndb tests will fail, use --skip-ndbcluster to skip testing it.
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Using NDBCLUSTER_PORT       = 9311
Using IM_PORT               = 9313
Using IM_MYSQLD1_PORT       = 9314
Using IM_MYSQLD2_PORT       = 9315
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
Installing Slave1 Database
Saving snapshot of installed databases
=======================================================
Starting Tests in the 'main' suite

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

archive                        [ pass ]            717
archive_gis                    [ pass ]            182
federated                      [ pass ]           1651
skipped 9 bytes from file: socket (3)
federated_archive              [ pass ]             52
-------------------------------------------------------
Stopping All Servers
skipped 9 bytes from file: socket (3)
skipped 9 bytes from file: socket (3)
All 4 tests were successful.
The servers were restarted 1 times
Spent 2.602 of 7 seconds executing testcases

Gentoo here, with our patchset mostly turned off.

I'll poke more for reproducibility.

Thank you for the feedback.

Please also provide configure options for MySQL if you compile it yourself.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".