Bug #39583 agent reports 4 critical regex after fix for InnoDB bug#36941
Submitted: 22 Sep 2008 9:36 Modified: 4 Nov 2008 17:45
Reporter: Carsten Segieth Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S3 (Non-critical)
Version:2.0.0.7049++ OS:Any
Assigned to: Jan Kneschke CPU Architecture:Any

[22 Sep 2008 9:36] Carsten Segieth 
Description:
Agent needs to react on the fix of bug#36941 Performance problem in ha_print_info (SHOW INNODB STATUS)

Bug #39462 No deprecation when removing Hash table size, used cells from INNODB STATUS outp

2008-09-20 16:15:49: (critical) job_collect_mysql.c.460: executing the regex for innodb pattern "Total number of lock structs in row lock hash table (\d+)" (57) failed: -1 
2008-09-20 16:15:49: (critical) job_collect_mysql.c.460: executing the regex for innodb pattern "Hash table size (\d+), used cells \d+, node heap has \d+ buffer.s." (66) failed: -1
2008-09-20 16:15:49: (critical) job_collect_mysql.c.460: executing the regex for innodb pattern "Hash table size \d+, used cells (\d+), node heap has \d+ buffer.s." (66) failed: -1
2008-09-20 16:15:49: (critical) job_collect_mysql.c.460: executing the regex for innodb pattern "Hash table size \d+, used cells \d+, node heap has (\d+) buffer.s." (66) failed: -1

How to repeat:
- install 5.1.28
- run agent against

Suggested fix:
- no longer look for depreceated values
[16 Oct 2008 16:15] Jan Kneschke 
revno: 1074
committer: Jan Kneschke <jan@jan-kneschkes-macbook-pro.local>
branch nick: mysql-lb
timestamp: Thu 2008-10-16 18:12:40 +0200
message:
  reduce the log-level for failed regex to not spam the logs if someone changes the innodb output (fixes #39583)
  
   * 5.1.28 removed some fields from the output
[4 Nov 2008 17:45] Carsten Segieth 
checked OK with agent 2.0.0.7088 and server 5.1.29