遭遇DBD::mysql::dr::imp_data_size unexpectedly-白红宇

最近的MHA验证时，遭遇了DBD::mysql::dr::imp_data_size unexpectedly这个错误。而DBD这个包已经是安装过了的。下面是这个问题的描述和解决方案。

1、故障描述

# masterha_check_repl --conf=/etc/app1.cnf

Mon Feb 16 19:56:29 2015 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.

Mon Feb 16 19:56:29 2015 - [info] Reading application default configuration from /etc/app1.cnf..

Mon Feb 16 19:56:29 2015 - [info] Reading server configuration from /etc/app1.cnf..

Mon Feb 16 19:56:29 2015 - [info] MHA::MasterMonitor version 0.56.

Had to create DBD::mysql::dr::imp_data_size unexpectedly at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line 1190.

Had to create DBD::mysql::db::imp_data_size unexpectedly at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line 1190.

Mon Feb 16 19:56:29 2015 - [error][/usr/lib/perl5/site_perl/5.8.8/MHA/MasterMonitor.pm, ln326] Undefined subroutine &DBD::mysql::db::_login called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBD/mysql.pm line 140.

at /usr/lib/perl5/site_perl/5.8.8/MHA/Server.pm line 166

Had to create DBD::mysql::dr::imp_data_size unexpectedly at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line 1190.

Had to create DBD::mysql::db::imp_data_size unexpectedly at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line 1190.

at /usr/lib/perl5/site_perl/5.8.8/MHA/Server.pm line 166

Had to create DBD::mysql::dr::imp_data_size unexpectedly at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line 1190.

Had to create DBD::mysql::db::imp_data_size unexpectedly at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line 1190.

at /usr/lib/perl5/site_perl/5.8.8/MHA/Server.pm line 166

Mon Feb 16 19:56:29 2015 - [error][/usr/lib/perl5/site_perl/5.8.8/MHA/MasterMonitor.pm, ln326] Got fatal error, stopping operations

Mon Feb 16 19:56:29 2015 - [error][/usr/lib/perl5/site_perl/5.8.8/MHA/MasterMonitor.pm, ln520] Error happened on checking configurations. at /usr/lib/perl5/site_perl/5.8.8/MHA/MasterMonitor.pm line 326

Mon Feb 16 19:56:29 2015 - [error][/usr/lib/perl5/site_perl/5.8.8/MHA/MasterMonitor.pm, ln691] Error happened on monitoring servers.

Mon Feb 16 19:56:29 2015 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

2、故障解决

###查看当前系统的dbi与dbd包，如下表明2个包都已安装

# rpm -qa|grep -i dbi

perl-DBI-1.52-2.el5

# rpm -qa|grep -i dbd

perl-DBD-Pg-1.49-4.el5_8

perl-DBD-MySQL-3.0007-2.el5

###我们首先卸载这2个rpm包

# rpm -e --nodeps perl-DBI-1.52-2.el5

# rpm -e --nodeps perl-DBD-MySQL-3.0007-2.el5

###下面使用yum方式分别安装这2个包

# yum install perl-DBI

Loaded plugins: fastestmirror, security

Loading mirror speeds from cached hostfile

* base: mirrors.cug.edu.cn

* epel: mirrors.ustc.edu.cn

* extras: mirrors.hust.edu.cn

* updates: mirrors.hust.edu.cn

Setting up Install Process

Resolving Dependencies

--> Running transaction check

---> Package perl-DBI.x86_64 0:1.52-2.el5 set to be updated

--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================================

Package Arch Version Repository Size

===================================================================================================

Installing:

perl-DBI x86_64 1.52-2.el5 base 600 k

Transaction Summary

===================================================================================================

Install 1 Package(s)

Upgrade 0 Package(s)

Total download size: 600 k

Is this ok [y/N]: y

Downloading Packages:

perl-DBI-1.52-2.el5.x86_64.rpm | 600 kB 00:01

Running rpm_check_debug

Running Transaction Test

Finished Transaction Test

Transaction Test Succeeded

Running Transaction

Installing : perl-DBI 1/1

Installed:

perl-DBI.x86_64 0:1.52-2.el5

Complete!

# yum install perl-DBD-mysql

Loaded plugins: fastestmirror, security

Loading mirror speeds from cached hostfile

* base: mirrors.cug.edu.cn

* epel: mirrors.ustc.edu.cn

* extras: mirrors.hust.edu.cn

* updates: mirrors.hust.edu.cn

Setting up Install Process

Resolving Dependencies

--> Running transaction check

---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated

--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: perl-DBD-MySQL

--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: perl-DBD-MySQL

--> Running transaction check

---> Package mysql.x86_64 0:5.0.95-5.el5_9 set to be updated

--> Finished Dependency Resolution

-- Author: Leshami

-- Blog :

Dependencies Resolved

==========================================================================================

Package Arch Version Repository Size

==========================================================================================

Installing:

perl-DBD-MySQL x86_64 3.0007-2.el5 base 148 k

Installing for dependencies:

mysql x86_64 5.0.95-5.el5_9 base 4.9 M

Transaction Summary

==========================================================================================

Install 2 Package(s)

Upgrade 0 Package(s)

Total size: 5.0 M

Total download size: 148 k

Is this ok [y/N]: y

Downloading Packages:

perl-DBD-MySQL-3.0007-2.el5.x86_64.rpm | 148 kB 00:00

Running rpm_check_debug

Running Transaction Test

Finished Transaction Test

Transaction Test Succeeded

Running Transaction

Installing : mysql 1/2

Installing : perl-DBD-MySQL 2/2

Installed:

perl-DBD-MySQL.x86_64 0:3.0007-2.el5

Dependency Installed:

mysql.x86_64 0:5.0.95-5.el5_9

Complete!

###安装后正常。