STATUS
------
Not approved. Test fails on Ubuntu.
REQUESTS
--------
1. Fix test failure. Note: The machine this was run on has the DBD::mysql module
and is fully operational WRT perl, mysql, php, and other DBI/DBD modules.
DETAILS
-------
> BUG#43909
> New perl script is added which will skip the backup_external_non_win
> test if perl DBI modules are not installed in the system
> added:
> mysql-test/suite/backup/include/have_dbi.inc
> modified:
> mysql-test/suite/backup/t/backup_external_non_win.test
>
> === added file 'mysql-test/suite/backup/include/have_dbi.inc'
> --- a/mysql-test/suite/backup/include/have_dbi.inc 1970-01-01 00:00:00 +0000
> +++ b/mysql-test/suite/backup/include/have_dbi.inc 2009-03-31 18:32:25 +0000
> @@ -0,0 +1,23 @@
> +# This script is written in order to skip the test if perl DBI modules are not
> +# installed in the system
> +
> +let TMP_FILE= $MYSQLTEST_VARDIR/tmp/dbi_exists;
> +
> +perl;
> +my $success= 1;
> +my $file= $ENV{'TMP_FILE'};
> +eval "require DBI";
> +if ($@)
> +{
> + $success= 0;
> +}
> +open FH, "> $file";
> +print FH "let \$dbi_exists= $success;";
> +close FH;
> +EOF
> +
> +source $MYSQLTEST_VARDIR/tmp/dbi_exists;
> +remove_file $MYSQLTEST_VARDIR/tmp/dbi_exists;
> +if(!$dbi_exists) {
> + skip DBI not installed.;
> +}
>
> === modified file 'mysql-test/suite/backup/t/backup_external_non_win.test'
> --- a/mysql-test/suite/backup/t/backup_external_non_win.test 2009-03-25 22:17:35
> +0000
> +++ b/mysql-test/suite/backup/t/backup_external_non_win.test 2009-03-31 18:32:25
> +0000
> @@ -9,6 +9,7 @@
> --source include/have_innodb.inc
> --source include/not_windows.inc
> --source suite/backup/include/backup_ext.inc
> +--source suite/backup/include/have_dbi.inc
>
> let $MYSQLD_BACKUPDIR = `select @@backupdir`;
> let $MYSQLD_DATADIR= `select @@datadir`;
>
1. Test fails as follows:
backup.backup_external_non_win [ fail ]
Test ended at 2009-03-31 20:43:17
CURRENT_TEST: backup.backup_external_non_win
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains:
/etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /
usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .
) at (eval 13) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge.
at /home/cbell/source/bzr/mysql-6.0-review/scripts/mysql_convert_table_format l
ine 51
mysqltest: At line 76: command "$MYSQL_CONVERT_TABLE_FORMAT --user=root -S $MAST
ER_MYSOCK --port=$MASTER_MYPORT --type=innodb db1" failed
Output from before failure:
exec of '/home/cbell/source/bzr/mysql-6.0-review/scripts/mysql_convert_table_for
mat --user=root -S /home/cbell/source/bzr/mysql-6.0-review/mysql-test/var/tmp/my
sqld.1.sock --port=12500 --type=innodb db1' failed, error: 512, status: 2, errn
o: 2
Chuck
