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:
Category:Tests: Engine Severity:S3 (Non-critical)
Version:5.0.91 OS:Linux
Assigned to: CPU Architecture:Any

[22 May 2010 2:05] Robin Johnson
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 TABLE IF EXISTS federated.archive_table;
CREATE TABLE federated.archive_table (
`id` int(4) NOT NULL,
`name` varchar(54) default NULL
DROP TABLE IF EXISTS federated.t1;
CREATE TABLE federated.t1 (
`id` int(4) NOT NULL,
`name` varchar(54) default NULL,
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

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

How to repeat:
Run MTR with archive engine enabled.
[22 May 2010 2:06] Robin Johnson
archive_gis diff reject vs. expected result

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

[22 May 2010 2:07] Robin Johnson
federated_archive diff actual test result vs expected

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

[22 May 2010 2:07] Robin Johnson
Sorry about the attachment screwup on bug #53909, the files weren't copying properly to my desktop for uploading.
[22 May 2010 8:12] Valeriy Kravchuk
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
[22 May 2010 17:36] Robin Johnson
Gentoo here, with our patchset mostly turned off.

I'll poke more for reproducibility.
[25 May 2010 8:57] Sveta Smirnova
Thank you for the feedback.

Please also provide configure options for MySQL if you compile it yourself.
[25 Jun 2010 23:00] Bugs System
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".