Bug #40907 ZFS file systems do not show up in the dashboard Meta Info
Submitted: 20 Nov 2008 21:46 Modified: 21 Sep 2009 13:49
Reporter: Marcos Palacios Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S3 (Non-critical)
Version:2.0.0.7102 OS:Solaris
Assigned to: Jan Kneschke CPU Architecture:Any

[20 Nov 2008 21:46] Marcos Palacios
Description:
The dashboard shows a blank for "Disk Space" in the Meta Info area on Open Solaris 2008.05 (running on xVM VirtualBox ver. 2.0.4). This is explicit to ZFS file systems.

The results of the 'mysql-monitor-agent --agent-run-os-tests' (for the file system data) are:

[0] 
  fs.dirname = /
  fs.devname = rpool/ROOT/opensolaris
  fs.typename = none
  fs.sys-type-name = zfs
  fs.type = 1
  fsusage.total = 5164677
  fsusage.free = 2702876
  fsusage.used = 2461801
  fsusage.avail = 2702876
  fsusage.files = 5505251
  fsusage.use_percent = 0.480000
[1] 
  fs.dirname = /devices
  fs.devname = /devices
  fs.typename = none
  fs.sys-type-name = devfs
  fs.type = 1
  fsusage.total = 0
  fsusage.free = 0
  fsusage.used = 0
  fsusage.avail = 0
  fsusage.files = 185
  fsusage.use_percent = 0.000000
[2] 
  fs.dirname = /dev
  fs.devname = /dev
  fs.typename = none
  fs.sys-type-name = dev
  fs.type = 1
  fsusage.total = 0
  fsusage.free = 0
  fsusage.used = 0
  fsusage.avail = 0
  fsusage.files = 5752
  fsusage.use_percent = 0.000000
[3] 
  fs.dirname = /system/contract
  fs.devname = ctfs
  fs.typename = none
  fs.sys-type-name = ctfs
  fs.type = 1
  fsusage.total = 0
  fsusage.free = 0
  fsusage.used = 0
  fsusage.avail = 0
  fsusage.files = 30
  fsusage.use_percent = 0.000000
[4] 
  fs.dirname = /proc
  fs.devname = proc
  fs.typename = none
  fs.sys-type-name = proc
  fs.type = 1
  fsusage.total = 0
  fsusage.free = 0
  fsusage.used = 0
  fsusage.avail = 0
  fsusage.files = 9964
  fsusage.use_percent = 0.000000
[5] 
  fs.dirname = /etc/mnttab
  fs.devname = mnttab
  fs.typename = none
  fs.sys-type-name = mntfs
  fs.type = 1
  fsusage.total = 0
  fsusage.free = 0
  fsusage.used = 0
  fsusage.avail = 0
  fsusage.files = 1
  fsusage.use_percent = 0.000000
[6] 
  fs.dirname = /etc/svc/volatile
  fs.devname = swap
  fs.typename = none
  fs.sys-type-name = tmpfs
  fs.type = 1
  fsusage.total = 191736
  fsusage.free = 190992
  fsusage.used = 744
  fsusage.avail = 190992
  fsusage.files = 150141
  fsusage.use_percent = 0.000000
[7] 
  fs.dirname = /system/object
  fs.devname = objfs
  fs.typename = none
  fs.sys-type-name = objfs
  fs.type = 1
  fsusage.total = 0
  fsusage.free = 0
  fsusage.used = 0
  fsusage.avail = 0
  fsusage.files = 147
  fsusage.use_percent = 0.000000
[8] 
  fs.dirname = /etc/dfs/sharetab
  fs.devname = sharefs
  fs.typename = none
  fs.sys-type-name = sharefs
  fs.type = 1
  fsusage.total = 0
  fsusage.free = 0
  fsusage.used = 0
  fsusage.avail = 0
  fsusage.files = 1
  fsusage.use_percent = 0.000000
[9] 
  fs.dirname = /lib/libc.so.1
  fs.devname = /usr/lib/libc/libc_hwcap3.so.1
  fs.typename = none
  fs.sys-type-name = lofs
  fs.type = 1
  fsusage.total = 5164677
  fsusage.free = 2702876
  fsusage.used = 2461801
  fsusage.avail = 2702876
  fsusage.files = 5505251
  fsusage.use_percent = 0.480000
[10] 
  fs.dirname = /dev/fd
  fs.devname = fd
  fs.typename = none
  fs.sys-type-name = fd
  fs.type = 1
  fsusage.total = 0
  fsusage.free = 0
  fsusage.used = 0
  fsusage.avail = 0
  fsusage.files = 258
  fsusage.use_percent = 0.000000
[11] 
  fs.dirname = /tmp
  fs.devname = swap
  fs.typename = none
  fs.sys-type-name = tmpfs
  fs.type = 1
  fsusage.total = 192696
  fsusage.free = 190992
  fsusage.used = 1704
  fsusage.avail = 190992
  fsusage.files = 150141
  fsusage.use_percent = 0.010000
[12] 
  fs.dirname = /var/run
  fs.devname = swap
  fs.typename = none
  fs.sys-type-name = tmpfs
  fs.type = 1
  fsusage.total = 191032
  fsusage.free = 190992
  fsusage.used = 40
  fsusage.avail = 190992
  fsusage.files = 150141
  fsusage.use_percent = 0.000000
[13] 
  fs.dirname = /opt
  fs.devname = rpool/ROOT/opensolaris/opt
  fs.typename = none
  fs.sys-type-name = zfs
  fs.type = 1
  fsusage.total = 2706568
  fsusage.free = 2702876
  fsusage.used = 3692
  fsusage.avail = 2702876
  fsusage.files = 5406889
  fsusage.use_percent = 0.010000
[14] 
  fs.dirname = /export
  fs.devname = rpool/export
  fs.typename = none
  fs.sys-type-name = zfs
  fs.type = 1
  fsusage.total = 2702895
  fsusage.free = 2702876
  fsusage.used = 19
  fsusage.avail = 2702876
  fsusage.files = 5405758
  fsusage.use_percent = 0.000000
[15] 
  fs.dirname = /export/home
  fs.devname = rpool/export/home
  fs.typename = none
  fs.sys-type-name = zfs
  fs.type = 1
  fsusage.total = 5473693
  fsusage.free = 2702876
  fsusage.used = 2770817
  fsusage.avail = 2702876
  fsusage.files = 5410603
  fsusage.use_percent = 0.510000
[16] 
  fs.dirname = /rpool
  fs.devname = rpool
  fs.typename = none
  fs.sys-type-name = zfs
  fs.type = 1
  fsusage.total = 2702931
  fsusage.free = 2702876
  fsusage.used = 55
  fsusage.avail = 2702876
  fsusage.files = 5405762
  fsusage.use_percent = 0.000000
[17] 
  fs.dirname = /rpool/ROOT
  fs.devname = rpool/ROOT
  fs.typename = none
  fs.sys-type-name = zfs
  fs.type = 1
  fsusage.total = 2702894
  fsusage.free = 2702876
  fsusage.used = 18
  fsusage.avail = 2702876
  fsusage.files = 5405757
  fsusage.use_percent = 0.000000

How to repeat:
- install the monitor on Open Solaris 2008.05
- install the solaris10-x86-32bit agent on the same box and point to the monitor
- on the Meta Info area, see the "Disk Space"
[20 Nov 2008 21:59] Marcos Palacios
Using solaris9-sparc-32bit, we also get:

sigar-test-all.c.427 (): (items = 13)
[0] 
  fs.dirname = /
  fs.devname = /dev/dsk/c0t2d0s0
  fs.typename = local
  fs.sys-type-name = ufs
  fs.type = 2
  fsusage.total = 5041230
  fsusage.free = 4887970
  fsusage.used = 153260
  fsusage.avail = 4837558
  fsusage.files = 620800
  fsusage.use_percent = 0.040000
sigar-test-all.c.485: 
sigar_disk_usage_get(/dev/dsk/c0t2d0s0) failed with: Not enough space (12) 
[1] 
  fs.dirname = /usr
  fs.devname = /dev/dsk/c0t2d0s3
  fs.typename = local
  fs.sys-type-name = ufs
  fs.type = 2
  fsusage.total = 6049806
  fsusage.free = 3706173
  fsusage.used = 2343633
  fsusage.avail = 3645675
  fsusage.files = 742400
  fsusage.use_percent = 0.400000
sigar-test-all.c.485: 
sigar_disk_usage_get(/dev/dsk/c0t2d0s3) failed with: Not enough space (12) 
[2] 
  fs.dirname = /proc
  fs.devname = /proc
  fs.typename = none
  fs.sys-type-name = proc
  fs.type = 1
  fsusage.total = 0
  fsusage.free = 0
  fsusage.used = 0
  fsusage.avail = 0
  fsusage.files = 15884
  fsusage.use_percent = 0.000000
[3] 
  fs.dirname = /etc/mnttab
  fs.devname = mnttab
  fs.typename = none
  fs.sys-type-name = mntfs
  fs.type = 1
  fsusage.total = 0
  fsusage.free = 0
  fsusage.used = 0
  fsusage.avail = 0
  fsusage.files = 1
  fsusage.use_percent = 0.000000
[4] 
  fs.dirname = /dev/fd
  fs.devname = fd
  fs.typename = none
  fs.sys-type-name = fd
  fs.type = 1
  fsusage.total = 0
  fsusage.free = 0
  fsusage.used = 0
  fsusage.avail = 0
  fsusage.files = 511
  fsusage.use_percent = 0.000000
[6] 
  fs.dirname = /var/run
  fs.devname = swap
  fs.typename = none
  fs.sys-type-name = tmpfs
  fs.type = 1
  fsusage.total = 855408
  fsusage.free = 855368
  fsusage.used = 40
  fsusage.avail = 855368
  fsusage.files = 98719
  fsusage.use_percent = 0.000000
[7] 
  fs.dirname = /tmp
  fs.devname = swap
  fs.typename = none
  fs.sys-type-name = tmpfs
  fs.type = 1
  fsusage.total = 1025656
  fsusage.free = 855368
  fsusage.used = 170288
  fsusage.avail = 855368
  fsusage.files = 98719
  fsusage.use_percent = 0.170000
[10] 
  fs.dirname = /nfstmp1
  fs.devname = nfssrva.mysql.com:/nfstmp1
  fs.typename = remote
  fs.sys-type-name = nfs
  fs.type = 3
  fsusage.total = 307583476
  fsusage.free = 134314616
  fsusage.used = 173268860
  fsusage.avail = 118690204
  fsusage.files = 39075840
  fsusage.use_percent = 0.600000
sigar-test-all.c.485: 
sigar_disk_usage_get(nfssrva.mysql.com:/nfstmp1) failed with: Permission denied (13) 
[11] 
  fs.dirname = /nfstmp2
  fs.devname = storage3.mysql.com:/nfstmp2
  fs.typename = remote
  fs.sys-type-name = nfs
  fs.type = 3
  fsusage.total = 378204780
  fsusage.free = 323389352
  fsusage.used = 54815428
  fsusage.avail = 304177624
  fsusage.files = 48037888
  fsusage.use_percent = 0.160000
sigar-test-all.c.485: 
sigar_disk_usage_get(storage3.mysql.com:/nfstmp2) failed with: Permission denied (13) 
sigar-test-all.c.447: 
sigar_file_system_usage_get(/users) failed with: Value too large for defined data type (79)
[26 Jun 2009 13:21] Jan Kneschke
sigar is reporting the zfs volumes as fs.typename = none compared to = local on the other filesystems. 

A upgrade of sigar may fix this, have to investigate.
[28 Jul 2009 20:26] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Patch pushed (before bzr rev. 1437) for next build.
[28 Jul 2009 20:30] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Available in Build 2.1.0.1079.
[29 Jul 2009 15:54] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Verified fixed in agent build 2.1.0.1079.

QA has tried to mark it 'Resolved' but there is a JIRA error shown in the type of issue ('Bug') due to it being a sub-task.
[4 Aug 2009 16:43] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Verified fixed in agent build 2.1.0.1079.
[7 Aug 2009 9:52] Tony Bedford
An entry was added to the 2.1.0 changelog:

The Enterprise Dashboard displayed a blank entry for Disk Space in the Meta Info area. This happened on Open Solaris 2008.05. This problem only occurred when using the ZFS file system.
[27 Aug 2009 20:44] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Re-opening for fixing in version 2.0.x, per Bug Council.
[27 Aug 2009 20:46] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
This is already in the 2.0.x build.
[27 Aug 2009 20:49] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Patch installed in versions => 2.0.6.7159.
[27 Aug 2009 20:53] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Verified fixed in service manager build 2.0.6.7159.
[21 Sep 2009 13:49] Tony Bedford
Updated changelog to reflect now also fixed in 2.0.6.