DBD: mysql: dr: imp_data_size unexpectedly, dbdimp_data_size

DBD: mysql: dr: imp_data_size unexpectedly, dbdimp_data_size

The latest MHA verification encountered the error DBD: mysql: dr: imp_data_size unexpectedly. The DBD package has been installed. The following describes the problem and solutions.

 

1. fault description
# 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 unexpectedlyAt/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 unexpectedlyAt/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.
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.
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
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. troubleshooting
### View the dbi and dbd packages of the current system. The following shows that both 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

### First uninstall these two rpm packages
# Rpm-e -- nodeps perl-DBI-1.52-2.el5
# Rpm-e -- nodeps perl-DBD-MySQL-3.0007-2.el5

### Use yum to install these two packages
# 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. 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.95-5. el5_9 set to be updated
--> Finished Dependency Resolution
-- Author: Leshami
-- Blog: http://blog.csdn.net/leshami
Dependencies Resolved

========================================================== ========================================================== ============
Package Arch Version Repository Size
========================================================== ========================================================== ============
Installing:
Perl-DBD-mysqlx86_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. 0007-2.el5

Dependency Installed:
Mysql. x86_64. 0.95-5. el5_9

Complete!

### Normal after installation.