MySQL Bugs: #42637: Some Data Collection Items return 'nan' instead of proper values.

Bug #42637	Some Data Collection Items return 'nan' instead of proper values.
Submitted:	6 Feb 2009 2:32	Modified:	30 Jun 2009 12:21
Reporter:	Meiji KIMURA	Email Updates:
Status:	Incomplete	Impact on me:	None
Category:	MySQL Enterprise Monitor: Agent	Severity:	S3 (Non-critical)
Version:	2.0.3	OS:	Any
Assigned to:	Jan Kneschke	CPU Architecture:	Any

Description:
We can check the Data Collection Items Used to Create Rules.
http://dev.mysql.com/doc/mysql-monitor/2.0/en/mem-data-items.html

But not all items return a proper value. It depends on a platform.

We can check items to return values using an output of this command.

shell> bin/mysql-monitor-agent --agent-run-os-tests

If (undef) is displayed for an item, we cannot use that item in the platform.

Even if the items display proper value in the output, some of them cannot be evaluated by agents. At that time agent reports <value>nan</value> for an item in their debug-log.

How to repeat:
(1) Check proper items on the platform using this command.

shell> bin/mysql-monitor-agent --agent-run-os-tests

(2) Activate an agent with debug-log mode.

(3) Make a new rule using these value and set a schedule for it.

os:disk:disk_servicetime
os:disk:disk_queue

(4) Check a debug-log of an agents, and compare the result of (1) and debug log.

You can see values for them in (1) like these,

For os:disk:disk_servicetime
> diskusage.service_time = 1.50
> diskusage.service_time = -1.00
> diskusage.service_time = 0.00

For os:disk:disk_queue
> diskusage.queue = 4601241602640715283
> diskusage.queue = 13830554455654793216
> diskusage.queue = 0

But you can see <value>nan</value> for them in the debug log.

Suggested fix:
[Workaround]

 none.

[Suggested fix:]

 The items evaluated proper value in '--agent-run-os-tests' should be able to used as ' Data Collection Items '.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Carsten Segieth writes: 
sigar output in attached file

8. os:disk:disk_servicetime
10. os:disk:disk_queue

I re-test these values in latest version (2.3.5). When the agent is installed in CentOS 5.x (32-bit) and made the rule.

When adding these rule, MEM dashborad display this error.

[English]
    * U0146 Unable to schedule rule "Service Time" due to "os.disk.disk_servicetime" data not being collected from server "mkcentos53:3306". It may be an unsupported collection for that server.

U0146 Unable to schedule rule "Disk Queue" due to "os.disk.disk_queue" data not being collected from server "mkcentos53:3306". It may be an unsupported collection for that server.

[Japanese]
U0146 "os.disk.disk_servicetime" データがサーバ "mkcentos53:3306" から得られたものではないため、ルール "Service Time" をスケジュールすることができません。これは、そのサーバではサポートされていない収集方法である可能性があります

So these items are not supported in that platform(Linux CentOS 5.x) and agent version(2.3.5).