Public bug reported:

https://launchpadlibrarian.net/418306570/buildlog_ubuntu-cosmic-
amd64.mysql-5.7_5.7.23-2ubuntu1_BUILDING.txt.gz

using ppa:ubuntu-toolchain-r/ppa

CURRENT_TEST: main.mysqldump
mysqldump: Error: 'Expression #6 of SELECT list is not in GROUP BY clause and 
contains nonaggregated column 'information_schema.FILES.EXTRA' which is not 
functionally dependent on columns in GROUP BY clause; this is incompatible with 
sql_mode=only_full_group_by' when trying to dump tablespaces
mysqldump: Error: 'Expression #6 of SELECT list is not in GROUP BY clause and 
contains nonaggregated column 'information_schema.FILES.EXTRA' which is not 
functionally dependent on columns in GROUP BY clause; this is incompatible with 
sql_mode=only_full_group_by' when trying to dump tablespaces
mysqldump: Couldn't find table: "non_existing"
mysqldump: Error: 'Expression #6 of SELECT list is not in GROUP BY clause and 
contains nonaggregated column 'information_schema.FILES.EXTRA' which is not 
functionally dependent on columns in GROUP BY clause; this is incompatible with 
sql_mode=only_full_group_by' when trying to dump tablespaces
mysqldump: Error: 'Expression #6 of SELECT list is not in GROUP BY clause and 
contains nonaggregated column 'information_schema.FILES.EXTRA' which is not 
functionally dependent on columns in GROUP BY clause; this is incompatible with 
sql_mode=only_full_group_by' when trying to dump tablespaces
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or 
column(s) or function(s) or definer/invoker of view lack rights to use them 
when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references 
invalid table(s) or column(s) or function(s) or definer/invoker of view lack 
rights to use them (1356)
mysqldump: Got error: 1083: Field separator argument is not what is expected; 
check the manual when executing 'SELECT INTO OUTFILE'
mysqldump: Got error: 1083: Field separator argument is not what is expected; 
check the manual when executing 'SELECT INTO OUTFILE'
mysqldump: Got error: 1083: Field separator argument is not what is expected; 
check the manual when executing 'SELECT INTO OUTFILE'
mysqldump: [Warning] Using a password on the command line interface can be 
insecure.
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
mysqldump: [Warning] Using a password on the command line interface can be 
insecure.
mysqldump: Got error: 1146: Table 'test.???????????????????????' doesn't exist 
when using LOCK TABLES
mysqldump: Got error: 1083: Field separator argument is not what is expected; 
check the manual when executing 'SELECT INTO OUTFILE'
mysqldump: Got error: 1083: Field separator argument is not what is expected; 
check the manual when executing 'SELECT INTO OUTFILE'
mysqldump: user1 has insufficent privileges to SHOW CREATE FUNCTION `hello1`!
--- /<<PKGBUILDDIR>>/builddir/mysql-test/r/mysqldump.result     2019-04-08 
04:14:03.404712852 +0300
+++ /<<PKGBUILDDIR>>/builddir/mysql-test/var/1/log/mysqldump.reject     
2019-04-08 04:24:19.502521438 +0300
@@ -4193,11 +4193,12 @@
 Event  sql_mode        time_zone       Create Event    character_set_client    
collation_connection    Database Collation
 ee1            UTC     CREATE DEFINER=`root`@`localhost` EVENT `ee1` ON 
SCHEDULE AT '2035-12-31 20:01:23' ON COMPLETION NOT PRESERVE ENABLE DO set @a=5 
       latin1  latin1_swedish_ci       latin1_swedish_ci
 create event ee2 on schedule at '2018-12-31 21:01:23' do set @a=5;
+Warnings:
+Note   1588    Event execution time is in the past and ON COMPLETION NOT 
PRESERVE is set. The event was dropped immediately after creation.
 create event ee3 on schedule at '2030-12-31 22:01:23' do set @a=5;
 show events;
 Db     Name    Definer Time zone       Type    Execute at      Interval value  
Interval field  Starts  Ends    Status  Originator      character_set_client    
collation_connection    Database Collation
 second ee1     root@localhost  UTC     ONE TIME        2035-12-31 20:01:23     
NULL    NULL    NULL    NULL    ENABLED 1       latin1  latin1_swedish_ci       
latin1_swedish_ci
-second ee2     root@localhost  UTC     ONE TIME        2018-12-31 21:01:23     
NULL    NULL    NULL    NULL    ENABLED 1       latin1  latin1_swedish_ci       
latin1_swedish_ci
 second ee3     root@localhost  UTC     ONE TIME        2030-12-31 22:01:23     
NULL    NULL    NULL    NULL    ENABLED 1       latin1  latin1_swedish_ci       
latin1_swedish_ci
 drop database second;
 create database third;
@@ -4205,7 +4206,6 @@
 show events;
 Db     Name    Definer Time zone       Type    Execute at      Interval value  
Interval field  Starts  Ends    Status  Originator      character_set_client    
collation_connection    Database Collation
 third  ee1     root@localhost  UTC     ONE TIME        2035-12-31 20:01:23     
NULL    NULL    NULL    NULL    ENABLED 1       latin1  latin1_swedish_ci       
latin1_swedish_ci
-third  ee2     root@localhost  UTC     ONE TIME        2018-12-31 21:01:23     
NULL    NULL    NULL    NULL    ENABLED 1       latin1  latin1_swedish_ci       
latin1_swedish_ci
 third  ee3     root@localhost  UTC     ONE TIME        2030-12-31 22:01:23     
NULL    NULL    NULL    NULL    ENABLED 1       latin1  latin1_swedish_ci       
latin1_swedish_ci
 drop database third;
 set time_zone = 'SYSTEM';

mysqltest: Result content mismatch

safe_process[8522]: Child process: 8523, exit: 1

 - the logfile can be found in '/<<PKGBUILDDIR>>/builddir/mysql-
test/var/log/main.mysqldump/mysqldump.log'

Test main.mysqldump has failed 2 times, no more retries!

main.mysqltest                           w2 [ pass ]  48029
--------------------------------------------------------------------------
The servers were restarted 172 times
Spent 1661.244 of 643 seconds executing testcases

Completed: Failed 1/768 tests, 99.87% were successful.

Failing test(s): main.mysqldump

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://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

157 tests were skipped, 59 by the test itself.

mysql-test-run: *** ERROR: there were failing test cases
make[1]: *** [debian/rules:152: override_dh_auto_test] Error 1
make[1]: Leaving directory '/<<PKGBUILDDIR>>'
make: *** [debian/rules:227: build] Error 2
dpkg-buildpackage: error: debian/rules build subprocess returned exit status 2

** Affects: mysql-5.7 (Ubuntu)
     Importance: High
         Status: New


** Tags: cc-tc-updates ftbfs

** Changed in: mysql-5.7 (Ubuntu)
   Importance: Undecided => High

** Tags added: cc-tc-updates ftbfs

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1823665

Title:
  mysql-5.7 ftbfs with cosmic toolchain updates (amd64, i386 only)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1823665/+subscriptions

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to