The recent MHA authentication encountered Dbd::mysql::d r::imp_data_size unexpectedly this error. The DBD package is already installed. The following is a description of the problem and a solution.
1. Fault description
# MASTERHA_CHECK_REPL--CONF=/ETC/APP1.CNF
Mon Feb-19:56:29-[WARNING] Global configuration file/etc/masterha_default.cnf not found. Skipping.
Mon Feb 19:56:29-[INFO] Reading application default configuration from/etc/app1.cnf.
Mon Feb 19:56:29-[INFO] Reading server configuration from/etc/app1.cnf.
Mon Feb 19:56:29-[INFO] mha::mastermonitor version 0.56.
had to create Dbd::mysql::d r::imp_data_size unexpectedlyAT/USR/LIB64/PERL5/VENDOR_PERL/5.8.8/X86_64-LINUX-THREAD-MULTI/DBI.PM line 1190.
had to create Dbd::mysql::d b::imp_data_size unexpectedlyAT/USR/LIB64/PERL5/VENDOR_PERL/5.8.8/X86_64-LINUX-THREAD-MULTI/DBI.PM line 1190.
Mon Feb 19:56:29-[error][/usr/lib/perl5/site_perl/5.8.8/mha/mastermonitor.pm, ln326] Undefined subroutine &dbd::mysql::d B::_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::d r::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::d b::imp_data_size unexpectedly at/usr/lib64/perl5/vendor_perl/5.8.8/x86_64- LINUX-THREAD-MULTI/DBI.PM line 1190.
Mon Feb 19:56:29-[error][/usr/lib/perl5/site_perl/5.8.8/mha/mastermonitor.pm, ln326] Undefined subroutine &dbd::mysql::d B::_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::d r::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::d b::imp_data_size unexpectedly at/usr/lib64/perl5/vendor_perl/5.8.8/x86_64- LINUX-THREAD-MULTI/DBI.PM line 1190.
Mon Feb 19:56:29-[error][/usr/lib/perl5/site_perl/5.8.8/mha/mastermonitor.pm, ln326] Undefined subroutine &dbd::mysql::d B::_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
Mon Feb 19:56:29-[error][/usr/lib/perl5/site_perl/5.8.8/mha/mastermonitor.pm, ln326] Got fatal error, stopping O Perations
Mon Feb 19:56:29-[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 19:56:29-[error][/usr/lib/perl5/site_perl/5.8.8/mha/mastermonitor.pm, ln691] error happened on Monitori ng servers.
Mon Feb 19:56:29-[INFO] Got exit code 1 (not master dead).
MySQL Replication Health is not ok!
2, fault resolution
# # #查看当前系统的dbi与dbd包, as shown below 2 packages are installed
# 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 updated
--Finished Dependency Resolution
Dependencies resolved
===================================================================================================
Package Arch Version Repository Size
===================================================================================================
Installing:
PERL-DBI x86_64 1.52-2.el5 Base 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 | 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 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 updated
--Finished Dependency Resolution
--Author:leshami
--Blog:Http://blog.csdn.net/leshami
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!
# # #安装后正常.
???? Encounter Dbd::mysql::d r::imp_data_size unexpectedly