Bug #43909 The test backup_external_non_win fails with perl error in team trees
Submitted: 27 Mar 2009 13:00 Modified: 23 Apr 2009 14:26
Reporter: Chuck Bell Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:6.0.11 OS:Other (debian)
Assigned to: Hema Sridharan CPU Architecture:Any
Tags: test
Triage: Triaged: D3 (Medium)

[27 Mar 2009 13:00] Chuck Bell
Description:
The test backup_external_non_win is failing on the debx86-b machine in pushbuild. The error is shown below.

backup.backup_external_non_win           [ fail ]
        Test ended at 2009-03-27 01:20:59

CURRENT_TEST: backup.backup_external_non_win
Can't locate DBI.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 /data0/pushbuild/pb2/pb/bzr_mysql-6.0-backup-merge/75/mysql-6.0.11-alpha-pb75/scripts/mysql_convert_table_format line 19.
BEGIN failed--compilation aborted at /data0/pushbuild/pb2/pb/bzr_mysql-6.0-backup-merge/75/mysql-6.0.11-alpha-pb75/scripts/mysql_convert_table_format line 19.
mysqltest: At line 75: command "$MYSQL_CONVERT_TABLE_FORMAT --user=root -S $MASTER_MYSOCK --port=$MASTER_MYPORT  --type=innodb db1" failed

Output from before failure:
exec of '/data0/pushbuild/pb2/pb/bzr_mysql-6.0-backup-merge/75/mysql-6.0.11-alpha-pb75/scripts/mysql_convert_table_format --user=root -S /dev/shm/pbtmp-n_mix-110/mysqld.1.sock --port=11100  --type=innodb db1' failed, error: 512, status: 2, errno: 2

How to repeat:
NA

Suggested fix:
Unknown
[27 Mar 2009 18:42] Hema Sridharan
There is possibility that perl DBI modules(with latest version) are not installed in the system. This may lead to error mentioned above.

I pulled new clone today, executed the test and test passes in backup team tree.
[30 Mar 2009 20:18] Daniel Fischer
DBD::mysql is not a core module. The test should be skipped if it is not available.
[31 Mar 2009 18:33] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/70950

2807 Hema Sridharan	2009-03-31
      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
[2 Apr 2009 19:51] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/71253

2807 Hema Sridharan	2009-04-02
      BUG#43909. Perl script added that will skip the backup_external_non_win test
      when DBI and DBD 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
[7 Apr 2009 14:21] Chuck Bell
It works now. Patch approved.
[7 Apr 2009 19:19] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/71580

2793 Hema Sridharan	2009-04-07
      BUG#43909. backup_external_non_win test failed becasue of absence of dbi and dbd modules.
      The new include file have_dbi.inc is created which will skip the test if DBI and DBD 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
[23 Apr 2009 7:19] Bugs System
Pushed into 6.0.11-alpha (revid:alik@sun.com-20090423070920-e5lq3vrrqi016z2c) (version source revid:alik@sun.com-20090423070920-e5lq3vrrqi016z2c) (merge vers: 6.0.11-alpha) (pib:6)
[23 Apr 2009 14:26] Paul Dubois
Test case changes. No changelog entry needed.