MySQL Bugs: #38001: agent AIX 5.3 does not report RAM + CPU

Bug #38001	agent AIX 5.3 does not report RAM + CPU
Submitted:	9 Jul 2008 20:52	Modified:	4 Aug 2009 16:37
Reporter:	Carsten Segieth	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Agent	Severity:	S2 (Serious)
Version:	2.0.0.7001	OS:	IBM AIX (5.3)
Assigned to:	Jan Kneschke	CPU Architecture:	Any
Tags:	mem_20_maint, platforms, sigar

Description:
Acc. to Darren the 32bit agent on AIX5.3 does not report RAM - and from this the server crashed (which is reported as bug#38000).

Agent was started on "aix53" which is, if I'm right, a 64bit box like the similar box "aix52", where this works without problems.

How to repeat:
- install new aix5.3-32bit agent
- start it and try to check it on the dashboard

Suggested fix:
- add missing data

agent debug log, zipped

Attachment: agent.AIX53.zip (application/octet-stream, text), 31.36 KiB.

the agent does not report ram_total

 <task>
   <taskId>37844</taskId>
   <command>collect_data</command>
   <utc>2008-07-09T20:45:49.677Z</utc>
   <data>
    <datum>
     <target>
      <namespace>os</namespace>
      <classname>mem</classname>
      <instance>001125c5b8650000.0</instance>
      <attribute>ram_total</attribute>
     </target>
     <utc>2008-07-09T20:45:46.888Z</utc>
    </datum>
   </data>
  </task>

notice the lack of <value> -- that will be a NULL ram_total entry

1062 jan@kneschke.de	2008-10-29
     updated sigar to 3957

       $ svn diff -r3709:HEAD src/ include/ > sigar-3709-3957.diff
       $ cd plugins/agent/sigar/
       $ patch -ls -p0 -i sigar-3709-3957.diff

This may bring back CPU counts and info.

... but it looks that it didn't (tested with 2.0.0.7097: there are still no CPU and RAM values)

$ mysql-service-agent --agent-run-os-tests --log-level=debug
...
2009-03-04 21:02:48: (info) failed to open './libsigar_aixperfstat.so': No such file or directory
2009-03-04 21:02:48: (info) [mem] using /dev/kmem
...

but we build "libsigar_perfstat.so" (see the missing 'aix').

revno: 1223
committer: jan@mysql.com
branch nick: trunk
timestamp: Wed 2009-03-04 21:16:02 +0100
message:
  aix_sigar.c requires libsigar_aixperfstat instead of libsigar_perfstat
  
    * (info) failed to open './libsigar_aixperfstat.so': No such file or directory
------------------------------------------------------------
revno: 1222
committer: jan@mysql.com
branch nick: trunk
timestamp: Wed 2009-03-04 21:08:43 +0100
message:
  include the return-code in the error-msg if one of the sigar-functions fails
  
    * fixed some warnings along the way

revno: 1231
committer: jan@mysql.com
branch nick: rel-2.0
timestamp: Wed 2009-03-04 21:20:22 +0100
message:
  aix_sigar.c requires libsigar_aixperfstat instead of libsigar_perfstat
  
    * (info) failed to open './libsigar_aixperfstat.so': No such file or directory
------------------------------------------------------------
revno: 1230
committer: jan@mysql.com
branch nick: rel-2.0
timestamp: Wed 2009-03-04 21:19:51 +0100
message:
  include the return-code in the error-msg if one of the sigar-functions fails
  
    * fixed some warnings along the way

Jan Kneschke writes: 
the sigar changes are added, let QA test if it worked.

Marcos Palacios writes: 
Available in Build 2.1.0.1079.

Marcos Palacios writes: 
Verified fixed in agent build 2.1.0.1079.

An entry was added to the 2.1.0 changelog:

The Agent running on AIX 5.3 did not report CPU data or RAM size, causing the Enterprise Dashboard to crash with a Null Pointer Exception.