[debian-mysql] Bug#458695: mysql-dfsg-5.0: FTBFS: failed test "view"
Lucas Nussbaum
lucas at lucas-nussbaum.net
Wed Jan 2 12:25:31 UTC 2008
Package: mysql-dfsg-5.0
version: 5.0.51-1
Severity: serious
User: debian-qa at lists.debian.org
Usertags: qa-ftbfs-20080101 qa-ftbfs
Justification: FTBFS on i386
Hi,
During a rebuild of all packages in sid, your package failed to build on i386.
Relevant part:
> make[4]: Entering directory `/build/user/mysql-dfsg-5.0-5.0.51/server-tools'
> make[4]: Nothing to be done for `all-am'.
> make[4]: Leaving directory `/build/user/mysql-dfsg-5.0-5.0.51/server-tools'
> make[3]: Leaving directory `/build/user/mysql-dfsg-5.0-5.0.51/server-tools'
> make[2]: Leaving directory `/build/user/mysql-dfsg-5.0-5.0.51'
> make[1]: Leaving directory `/build/user/mysql-dfsg-5.0-5.0.51'
> if [ ! -f testsuite-stamp ] ; then \
> cd mysql-test ; \
> /usr/bin/perl ./mysql-test-run.pl --mysqld=--user=root --force ; \
> /usr/bin/perl ./mysql-test-run.pl --mysqld=--user=root --force --ps-protocol ; \
> fi
> Logging: ./mysql-test-run.pl --mysqld=--user=root --force
> MySQL Version 5.0.51
> Using ndbcluster when necessary, mysqld supports it
> Setting mysqld to support SSL connections
> 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 = 9310
> Using IM_PORT = 9312
> Using IM_MYSQLD1_PORT = 9313
> Using IM_MYSQLD2_PORT = 9314
> Killing Possible Leftover Processes
> Removing Stale Files
> Creating Directories
> Installing Master Database
> Installing Master Database
> Installing Slave1 Database
> Installing Master Cluster
> Saving snapshot of installed databases
> =======================================================
> Starting Tests in the 'main' suite
>
> TEST RESULT TIME (ms)
> -------------------------------------------------------
>
[....]
>
> variables-big [ skipped ] Test need 'big-test' option
> variables [ pass ] 3205
> view [ fail ]
>
> --- /build/user/mysql-dfsg-5.0-5.0.51/mysql-test/r/view.result 2007-11-15 17:28:37.000000000 +0300
> +++ /build/user/mysql-dfsg-5.0-5.0.51/mysql-test/var/log/view.reject 2008-01-02 04:53:31.000000000 +0300
> @@ -2719,12 +2719,12 @@
> v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` from `t1` having (`Age` < 75)
> SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75;
> Age
> -43
> -39
> +44
> +40
> SELECT * FROM v1;
> Age
> -43
> -39
> +44
> +40
> DROP VIEW v1;
> DROP TABLE t1;
> CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a char(6) DEFAULT 'xxx');
>
> mysqltest: Result content mismatch
>
> Stopping All Servers
> Restoring snapshot of databases
> Resuming Tests
>
> view_grant [ pass ] 4118
> wait_timeout [ pass ] 2205
> warnings [ pass ] 1903
> windows [ skipped ] Test requires: 'true'
> windows_shm [ skipped ] Test requires: 'true'
> xa [ pass ] 182
> -------------------------------------------------------
> Stopping All Servers
> Failed 1/484 tests, 99.79% were successful.
>
> The log files in var/log may give you some hint
> of what went wrong.
> If you want to report this error, please read first the documentation at
> http://www.mysql.com/doc/en/MySQL_test_suite.html
> The servers were restarted 115 times
> Spent 2545.937 of 3308 seconds executing testcases
>
> mysql-test-run in default mode: *** Failing the test(s): view
> mysql-test-run: *** ERROR: there were failing test cases
> Logging: ./mysql-test-run.pl --mysqld=--user=root --force --ps-protocol
> MySQL Version 5.0.51
> Using ndbcluster when necessary, mysqld supports it
> Setting mysqld to support SSL connections
> 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 = 9310
> Using IM_PORT = 9312
> Using IM_MYSQLD1_PORT = 9313
> Using IM_MYSQLD2_PORT = 9314
> Killing Possible Leftover Processes
> Removing Stale Files
> Creating Directories
> Installing Master Database
> Installing Master Database
> Installing Slave1 Database
> Installing Master Cluster
> Saving snapshot of installed databases
> =======================================================
> Starting Tests in the 'main' suite
>
> TEST RESULT TIME (ms)
> -------------------------------------------------------
>
> alias [ pass ] 162
> alter_table-big [ skipped ] Test need 'big-test' option
> alter_table [ pass ] 8020
> analyse [ pass ] 921
> analyze [ pass ] 403
[...]
> type_time [ pass ] 394
> type_timestamp [ pass ] 1903
> type_uint [ pass ] 126
> type_varchar [ pass ] 2705
> type_year [ pass ] 259
> udf [ pass ] 680
> union [ pass ] 8624
> update [ pass ] 3173
> user_limits [ disabled ] Bug#23921 random failure of user_limits.test
> user_var-binlog [ pass ] 312
> user_var [ pass ] 955
> varbinary [ pass ] 436
> variables-big [ skipped ] Test need 'big-test' option
> variables [ pass ] 3424
> view [ fail ]
>
> --- /build/user/mysql-dfsg-5.0-5.0.51/mysql-test/r/view.result 2007-11-15 17:28:37.000000000 +0300
> +++ /build/user/mysql-dfsg-5.0-5.0.51/mysql-test/var/log/view.reject 2008-01-02 05:49:49.000000000 +0300
> @@ -2719,12 +2719,12 @@
> v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` from `t1` having (`Age` < 75)
> SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75;
> Age
> -43
> -39
> +44
> +40
> SELECT * FROM v1;
> Age
> -43
> -39
> +44
> +40
> DROP VIEW v1;
> DROP TABLE t1;
> CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a char(6) DEFAULT 'xxx');
>
> mysqltest: Result content mismatch
>
> Stopping All Servers
> Restoring snapshot of databases
> Resuming Tests
>
> view_grant [ pass ] 4137
> wait_timeout [ pass ] 2210
> warnings [ pass ] 1234
> windows [ skipped ] Test requires: 'true'
> windows_shm [ skipped ] Test requires: 'true'
> xa [ pass ] 221
> -------------------------------------------------------
> Stopping All Servers
> Failed 1/484 tests, 99.79% were successful.
>
> The log files in var/log may give you some hint
> of what went wrong.
> If you want to report this error, please read first the documentation at
> http://www.mysql.com/doc/en/MySQL_test_suite.html
> The servers were restarted 115 times
> Spent 2584.908 of 3379 seconds executing testcases
>
> mysql-test-run in ps-protocol mode: *** Failing the test(s): view
> mysql-test-run: *** ERROR: there were failing test cases
> make: *** [build-stamp] Error 1
> dpkg-buildpackage: failure: debian/rules build gave error exit status 2
The full build log is available from:
http://people.debian.org/~lucas/logs/2008/01/01
A list of current common problems and possible solutions is available at
http://wiki.debian.org/qa.debian.org/FTBFS . You're welcome to contribute!
About the archive rebuild: The rebuild was done on about 50 AMD64 nodes
of the Grid'5000 platform, using a clean chroot containing a sid i386
environment. Internet was not accessible from the build systems.
--
| Lucas Nussbaum
| lucas at lucas-nussbaum.net http://www.lucas-nussbaum.net/ |
| jabber: lucas at nussbaum.fr GPG: 1024D/023B3F4F |
More information about the pkg-mysql-maint
mailing list