???? Encounter Dbd::mysql::d r::imp_data_size unexpectedly

Source: Internet
Author: User
Tags install perl

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.