| Summary: | dev-db/mariadb-10.1.37 fails "main.mysqldump 'xtradb'" and "main.mysqldump 'innodb_plugin'" tests | ||
|---|---|---|---|
| Product: | Gentoo Linux | Reporter: | Paolo Pedroni <paolo.pedroni> |
| Component: | Current packages | Assignee: | Gentoo Linux MySQL bugs team <mysql-bugs> |
| Status: | UNCONFIRMED --- | ||
| Severity: | normal | Keywords: | TESTFAILURE |
| Priority: | Normal | ||
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Package list: | Runtime testing required: | --- | |
| Attachments: |
mariadb-10.1.37:20190312-123944.log.gz
emerge --info check-mysqld_1.log check-mysqld_1.log |
||
Created attachment 568762 [details]
emerge --info
Created attachment 568764 [details]
check-mysqld_1.log
Created attachment 568766 [details]
check-mysqld_1.log
|
Created attachment 568760 [details] mariadb-10.1.37:20190312-123944.log.gz main.mysqldump 'innodb_plugin' w4 [ fail ] Test ended at 2019-03-12 14:08:47 CURRENT_TEST: main.mysqldump mysqldump: Couldn't find table: "non_existing" 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: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`! mysqldump: Got error: 1146: "Table 'test.???????????????????????' doesn't exist" when using LOCK TABLES /var/tmp/portage/dev-db/mariadb-10.1.37/work/mariadb-10.1.37_build/client/mysqlimport: Error: 1146, Table 'test.words' doesn't exist, when using table: words 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`! mysqldump: Got error: 2005: "Unknown MySQL server host 'unknownhost' (-2)" when trying to connect mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006) --- /var/tmp/portage/dev-db/mariadb-10.1.37/work/mysql/mysql-test/r/mysqldump.result 2018-10-31 22:54:02.000000000 +0100 +++ /var/tmp/portage/dev-db/mariadb-10.1.37/work/mysql/mysql-test/r/mysqldump.reject 2019-03-12 14:08:47.598373612 +0100 @@ -4318,11 +4318,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; @@ -4330,7 +4331,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 length mismatch - saving '/var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/4/log/main.mysqldump-innodb_plugin/' to '/var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/log/main.mysqldump-innodb_plugin/' [...SKIP...] main.mysqldump 'xtradb' w6 [ fail ] Test ended at 2019-03-12 14:11:45 CURRENT_TEST: main.mysqldump mysqldump: Couldn't find table: "non_existing" 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: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`! mysqldump: Got error: 1146: "Table 'test.???????????????????????' doesn't exist" when using LOCK TABLES /var/tmp/portage/dev-db/mariadb-10.1.37/work/mariadb-10.1.37_build/client/mysqlimport: Error: 1146, Table 'test.words' doesn't exist, when using table: words 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`! mysqldump: Got error: 2005: "Unknown MySQL server host 'unknownhost' (-2)" when trying to connect mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006) --- /var/tmp/portage/dev-db/mariadb-10.1.37/work/mysql/mysql-test/r/mysqldump.result 2018-10-31 22:54:02.000000000 +0100 +++ /var/tmp/portage/dev-db/mariadb-10.1.37/work/mysql/mysql-test/r/mysqldump.reject 2019-03-12 14:11:45.288492583 +0100 @@ -4318,11 +4318,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; @@ -4330,7 +4331,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 length mismatch - saving '/var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/6/log/main.mysqldump-xtradb/' to '/var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/log/main.mysqldump-xtradb/'