Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 680124 - dev-db/mariadb-10.1.37 fails "main.mysqldump 'xtradb'" and "main.mysqldump 'innodb_plugin'" tests
Summary: dev-db/mariadb-10.1.37 fails "main.mysqldump 'xtradb'" and "main.mysqldump 'i...
Status: UNCONFIRMED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords: TESTFAILURE
Depends on:
Blocks:
 
Reported: 2019-03-12 13:53 UTC by Paolo Pedroni
Modified: 2019-03-12 14:20 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments
mariadb-10.1.37:20190312-123944.log.gz (mariadb-10.1.37:20190312-123944.log.gz,331.56 KB, application/gzip)
2019-03-12 13:53 UTC, Paolo Pedroni
Details
emerge --info (file_680124.txt,8.52 KB, text/plain)
2019-03-12 13:53 UTC, Paolo Pedroni
Details
check-mysqld_1.log (check-mysqld_1.log,57.44 KB, text/x-log)
2019-03-12 14:09 UTC, Paolo Pedroni
Details
check-mysqld_1.log (check-mysqld_1.log,56.64 KB, text/x-log)
2019-03-12 14:10 UTC, Paolo Pedroni
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Paolo Pedroni 2019-03-12 13:53:31 UTC
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/'
Comment 1 Paolo Pedroni 2019-03-12 13:53:58 UTC
Created attachment 568762 [details]
emerge --info
Comment 2 Paolo Pedroni 2019-03-12 14:09:14 UTC
Created attachment 568764 [details]
check-mysqld_1.log
Comment 3 Paolo Pedroni 2019-03-12 14:10:07 UTC
Created attachment 568766 [details]
check-mysqld_1.log