Feed Aggregator

So what’s the fix to apply ? Thanks !

Thanks, got it:

hostnameX FromDual.MySQL.master.Binlog_ignore_filter 1400661892

Here are the output of this command: hostnameX FromDual.MySQL.master.Binlog_position 1400661892 232071 hostnameX FromDual.MySQL.master.Slave_count 1400661892 0 hostnameX FromDual.MySQL.master.Binlog_event_count 1400661892 0 hostnameX FromDual.MySQL.master.Binlog_total_size 1400661892 407016903 hostnameX FromDual.MySQL.master.Binlog_ignore_filter 1400661892 hostnameX FromDual.MySQL.master.Binlog_count 1400661892 8 hostnameX FromDual.MySQL.master.Binlog_do_filter 1400661892 tableX hostnameX FromDual.MySQL.master.Binlog_number 1400661892 682 hostnameX FromDual.MySQL.master.Binlog_avg_event_size 1400661892 0 hostnameX FromDual.MySQL.master.Binlog_file 1400661892 mysql-bin.000682

I think I see what went wrong. Can you please send me the first 10 lines of the file /tmp/FromDualAgentCache.hostnameX.cache:

shell> head -n 10 /tmp/FromDualAgentCache.hostnameX.cache

Hello,

Here is the log when I’m adding the module master. My latest data are at 10:40 on Zabbix UI.

This line could be interesting :

4971:2014-05-20 10:50:18.155 - DBG : /usr/local/zabbix/bin/zabbix_sender –zabbix-server ipAddrX –port 10051 –input-file /tmp/FromDualAgentCache.hostnameX.cache –with-timestamps -vv zabbix_sender [4998]: Warning: [line 5] ‘Key value’ required Sending failed.

– FULL LOG –

4971:2014-05-20 10:50:16.677 - INFO: FromDual Performance Monitor for MySQL (0.9.2) run started. 4971:2014-05-20 10:50:16.677 - INFO: FromDualMySQLagent::setAgentLock 4971:2014-05-20 10:50:16.677 - INFO: Read configuration from /usr/local/mysql_performance_monitor/etc/FromDualMySQLagent.conf 4971:2014-05-20 10:50:16.677 - INFO: Sections found: default, hostnameX 4971:2014-05-20 10:50:16.677 - INFO: Reading default section 4971:2014-05-20 10:50:16.677 - DBG : ZabbixServer - ipAddrX 4971:2014-05-20 10:50:16.677 - DBG : Modules - process mysql …

Thanks to a UserParameter I guess:

UserParameter=FromDual.MySQL.check,/usr/local/mysql_performance_monitor/FromDualMySQL agent.pl /usr/local/mysql_performance_monitor/etc/FromDualMySQLagent.conf

I see… The only part in the code where exit code 1 can be reached is the signal TERM trap. Either somebody killed the process or mpm killed a long running former mpm process automatically. How do you start mpm agent?

Hello, This debug is when the MPM stops after some hours of work. I’ll send the debug for the module master after.

It looks like you did not enable the master module: INFO: Modules for section hostnameX: mpm server process mysql innodb slave

5698:2014-05-15 13:55:33.212 - INFO: FromDual Performance Monitor for MySQL (0.9.2) run started. 5698:2014-05-15 13:55:33.226 - INFO: FromDualMySQLagent::setAgentLock 5698:2014-05-15 13:55:33.227 - INFO: Read configuration from /usr/local/mysql_performance_monitor/etc/FromDualMySQLagent.conf 5698:2014-05-15 13:55:33.227 - INFO: Sections found: default, hostnameX 5698:2014-05-15 13:55:33.227 - INFO: Reading default section 5698:2014-05-15 13:55:33.227 - DBG : ZabbixServer - ipAddrX 5698:2014-05-15 13:55:33.227 - DBG : Modules - process mysql myisam innodb 5698:2014-05-15 13:55:33.227 - DBG : LogFile - /var/log/zabbix/FromDualMySQLagent.log 5698:2014-05-15 13:55:33.227 - DBG : Type - mysqld 5698:2014-05-15 13:55:33.227 - DBG : Password - ************ 5698:2014-05-15 13:55:33.227 - DBG : Disabled - false 5698:2014-05-15 13:55:33.227 - DBG : Username - db_user 5698:2014-05-15 13:55:33.227 - DBG : Debug - 4 5698:2014-05-15 13:55:33.227 - DBG : TimeShift - 0 5698:2014-05-15 13:55:33.227 - DBG : …

Hello Obyis

Hmm... In the master module nothing has changed since v0.9.1 if I searched correctly...
It looks like the problem is located in sending the cache file.
Can you please enabled Debug = 4 and send us the output when the error happens?

Thanks,
Oli

Hello, I don’t know if you received my previous post => Module Master stucks the MPM.

The MPM is sometimes unstable. It works for a full day and then no new data. I have to launch it manually : “sudo ./FromDualMySQLagent.pl etc/FromDualMySQLagent.conf”

Hello, Thanks, it works well with thoses fixes.

Unfortunately, I discovered that the error : “ERR : Load of cache file failed. rc=1301” is coming with the module “Master”. When I remove it, there are no more errors. So the MPM is stucked because of the module Master. For the moment, it’s running without that module.

We found a pretty uncomfortable bug. It can be fixed easily by yourself or wait for the release of version 0.9.3 coming out soon. For more information see: here.

This seems to be a bug in v0.9.2 which happens when you have deadlock error messages in SHOW ENGINE INNODB STATUS output. (bug #139).

Will be fixed in v0.9.3

Workaround: fix lines 51 and 64 in lib/InnoDbStatus.pm as follows:

-    $sha1 = Digest::SHA1->new;
+    $sha1 = Digest::SHA->new;

or as described in Abdel-Mawlas comment above.

Obyis,

Try to load “Digest::SHA1” instead of “Digest::SHA” at the beginning of “InnoDbStatus.pm” file by replacing “use Digest::SHA” with “use Digest::SHA1”. It should work after that.

Hello,

I still have the same error in the log even after installed libdigest-sha-perl “15116:2014-05-07 10:20:38.922 - ERR : Can’t locate object method “new” via package “Digest::SHA1” (perhaps you forgot to load “Digest::SHA1”?) at /usr/local/mysql_performance_monitor/lib/InnoDbStatus.pm line 54.”

I was looking to the Latest Data on Zabbix and noticed that the lastest data was at 01:30 AM. At this time, I’m in my bed so I didn’t touch it. It seems to work according to the log file. I only found that error : 10243:2014-05-07 11:42:48.960 - ERR : Load of cache file failed. rc=1301

So I deleted the cache file in /tmp/, works for a few minutes and it’s dead again.

Hello

oh, I see. The installation advice for Ubuntu/Debian has a bug. libdigest-sha1-perl does not exits (any more?). I fixed the installation docu.

But apt-get install libdigest-sha-perl should definitely work.

Oli

Hi, Here is an error I got : 28991:2014-05-06 15:24:38.940 - ERR : Can’t locate object method “new” via package “Digest::SHA1” (perhaps you forgot to load “Digest::SHA1”?) at /usr/local/mysql_performance_monitor/lib/InnoDbStatus.pm line 54.

And when I try to install : sudo apt-get install libdigest-sha-perl libdigest-sha1-perl"

None are available.

With Cpan I have this error : openssl-version.c:2:30: fatal error: openssl/opensslv.h: No such file or directory compilation terminated. Failed to build and link a simple executable using OpenSSL No ‘Makefile’ created NANIS/Crypt-SSLeay-0.72.tar.gz /usr/bin/perl Makefile.PL INSTALLDIRS=site – NOT OK Running make test Make had some problems, won’t test Running make install Make had some problems, won’t install Could not read metadata file. Falling back to other methods to determine prerequisites

So my MPM is alive but nothing is retrieved ?

Thanks Oli.

FromDual has the pleasure to announce the release of the new version 0.9.2 of its popular Database Performance Monitor for MySQL, MariaDB and Percona Server mpm.

This release makes mpm compatible with Zabbix v2.2 and contains various minor bug fixes and improvements.

You can download mpm from here.

In the inconceivable case that you find a bug in mpm please report it to our Bugtracker.

Any feedback, statements and testimonials are welcome as well! Please send them to feedback@fromdual.com.

New installation of mpm v0.9.2

Please follow our mpm installation guide.

Upgrade from 0.x to 0.9.2

# cd /download
# tar xf mysql_performance_monitor-0.9.2.tar.gz
# cd /opt
# tar xf /download/mysql_performance_monitor_agent-0.9.2.tar.gz
# rm -f mpm
# ln -s mysql_performance_monitor_agent-0.9.2 mpm

No other upgrade requirements are known.

Changes in mpm v0.9.2

mpm agent

• Fix of mpm_mr_version newline at EOL which affects zabbix_sender.
• zabbix_sender return code change from Zabbix v2.2 and v2.1.7 fixed (bug
  #124).
• Log rotate …