Bug #53909 MTR failures for archive: archive, archive_gis, federated_archive, mysqldump-max
Submitted: 22 May 2010 1:58 Modified: 22 May 2010 2:10
Reporter: Robin Johnson Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Engine Severity:S3 (Non-critical)
Version:5.0.91 OS:Linux
Assigned to: CPU Architecture:Any

[22 May 2010 1:58] Robin Johnson
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:
Compile with archive engine and run MTR for 5.0.91
[22 May 2010 2:01] Robin Johnson
archive_gis diff reject vs. expected result

Attachment: zone-72.2.0.0 (application/octet-stream, text), 8.08 KiB.

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

Attachment: 20100521_mysql5.0.91-test-federated_archive.diff (application/octet-stream, text), 0 bytes.

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

Attachment: 20100521_mysql5.0.91-test-federated_archive.diff (application/octet-stream, text), 0 bytes.

[22 May 2010 2:05] Robin Johnson
I screw up the attachments badly. Just making a new bug instead.
[22 May 2010 2:10] Robin Johnson
One more:

mysqldump-max                  [ fail ]

--- /dev/shm/portage/dev-db/mysql-5.0.91/work/mysql/mysql-test/r/mysqldump-max.result   2010-05-05 17:31:05.000000000 +0300 
+++ /dev/shm/portage/dev-db/mysql-5.0.91/work/mysql/mysql-test/r/mysqldump-max.reject   2010-05-22 01:45:04.390735783 +0300 
@@ -65,11 +65,6 @@
 5  first value 
 select * from t5;
 id name
-1  first value 
-2  first value 
-3  first value 
-4  first value 
-5  first value 
 select * from t6;
 id name
 1  first value 
@@ -150,7 +145,6 @@
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 /*!40000 ALTER TABLE `t5` DISABLE KEYS */;
-INSERT  DELAYED IGNORE INTO `t5` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
 /*!40000 ALTER TABLE `t5` ENABLE KEYS */;
 DROP TABLE IF EXISTS `t6`; 
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
@@ -247,7 +241,6 @@ 
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 /*!40000 ALTER TABLE `t5` DISABLE KEYS */;
-INSERT  DELAYED INTO `t5` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
 /*!40000 ALTER TABLE `t5` ENABLE KEYS */;
 DROP TABLE IF EXISTS `t6`; 
 /*!40101 SET @saved_cs_client     = @@character_set_client */;

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases
Resuming Tests