MySQL Bugs: #38302: sigar network stats error on solaris

Bug #38302	sigar network stats error on solaris
Submitted:	23 Jul 2008 0:33	Modified:	9 Jan 2015 10:03
Reporter:	Adam Dixon	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Agent	Severity:	S3 (Non-critical)
Version:	1.2.0.7879, 2.0.0.7014	OS:	Solaris (10)
Assigned to:	Jan Kneschke	CPU Architecture:	Any
Tags:	sigar, zones

Description:
# /opt/mysql/enterprise/agent/bin/mysql-service-agent --version
MySQL Service Agent - 1.2.0.7879, (glib lib=2.8.5, headers=2.8.5)

SunOS mysqlprd01 5.10 Generic_127127-11 sun4v sparc SUNW,T5240

2008-07-21 10:07:24: (critical) sigar_net_interface_config_primary_get() failed: 6
2008-07-21 10:08:00: (critical) sigar_net_interface_config_primary_get() failed: 6

# /opt/mysql/enterprise/agent/bin/sigar-test-all >/tmp/test.txt
sigar_net_interface_stat_get(e1000g0:2) failed#

test.txt output
...(trimmed)
[0] 
  net.ifname = lo0:1, 
  net.config.name = lo0:1, 
  net.config.type = Local Loopback, 
  net.config.desc = lo0:1, 
  net.config.address = 127.0.0.1, 
  net.config.destination = 127.0.0.1, 
  net.config.hwaddr = 00:00:00:00:00:00, 
  net.config.broadcast = 0.0.0.0, 
  net.config.netmask = 255.0.0.0, 
  net.config.flags = 2121
  net.config.mtu = 8232
  net.config.metric = 1
  net.stat.rx_packets = 4124779216896000
  net.stat.rx_bytes = (undef) 0
  net.stat.rx_errors = (undef) 0
  net.stat.rx_dropped = (undef) 0
  net.stat.rx_overruns = (undef) 0
  net.stat.rx_frame = (undef) 0
  net.stat.tx_packets = 4124779216896000
  net.stat.tx_bytes = (undef) 0
  net.stat.tx_errors = (undef) 0
  net.stat.tx_dropped = (undef) 0
  net.stat.tx_overruns = (undef) 0
  net.stat.tx_collisions = (undef) 0
  net.stat.tx_carrier = (undef) 0
  net.stat.speed = (undef) 0
agent/src/sigar-test-all.c.582 (): 
[1] 
  net.ifname = e1000g0:2, 
  net.config.name = e1000g0:2, 
  net.config.type = Ethernet, 
  net.config.desc = e1000g0:2, 
  net.config.address = x, 
  net.config.destination = (undef), 
  net.config.hwaddr = x, 
  net.config.broadcast = x, 
  net.config.netmask = x, 
  net.config.flags = 2115
  net.config.mtu = 1500
  net.config.metric = 1
  net.stat.rx_packets = 0
  net.stat.rx_bytes = 0
  net.stat.rx_errors = 0
  net.stat.rx_dropped = 0
  net.stat.rx_overruns = 0
  net.stat.rx_frame = 0
  net.stat.tx_packets = 0
  net.stat.tx_bytes = 0
  net.stat.tx_errors = 0
  net.stat.tx_dropped = 0
  net.stat.tx_overruns = 0
  net.stat.tx_collisions = 0
  net.stat.tx_carrier = 0
  net.stat.speed = 0
agent/src/sigar-test-all.c.636 (0): 
agent/src/sigar-test-all.c.738 (): 
  SIGAR_64BIT: 1
  __LP64__: 0
  __powerpc64__: 0
  __osf__: 0
  sizeof(size_t) = 8
  sizeof(off_t) = 8
  sizeof(int) = 4
  sizeof(long) = 8
  sizeof(long long) = 8

How to repeat:
Currently unknown, seems to work on other solaris installs.

Two different hosts not working in the same way (sigar err) both using Solaris zones, other Solaris hosts seem fine. Sort of confirming that sigar is having problems with zones and gathering network stats.

Similar experience on CentOS 5 (Final), running on a VPS.

2008-07-31 17:30:37: (critical) sigar_net_interface_config_primary_get() failed: 6

[root@server agent]# /usr/local/mysql/enterprise/agent/bin/mysql-service-agent --version
MySQL Service Agent - 1.3.2.9118, (glib lib=2.8.5, headers=2.8.5)

[root@server agent]# /usr/local/mysql/enterprise/agent/bin/sigar-test-all >/tmp/centos_test.txt
sigar_net_interface_stat_get(venet0:0) failedsigar_net_interface_stat_get(venet0:1) failedsigar_net_interface_stat_get(venet0:2) failed
[root@server agent]#

[root@server agent]# uname -a
Linux server.poweredbyslingshot.com 2.6.9-023stab046.2-entnosplit #1 SMP Mon Dec 10 15:37:37 MSK 2007 i686 i686 i386 GNU/Linux

Contents of /tmp/centos_test.txt to be attached.

sigar net interface test results on CentOS on VPS

Attachment: centos_test.txt (text/plain), 9.85 KiB.

added support for extacting the host-id from the public ssh-host-key
      
        * new option --agent-host-id-commandline 
        * prefix mac-addresses with mac:{...} and ssh-host keys with ssh:{...}
        * use ssh-host-key as default and mac-addresses as default (fixes #38679)
        * take host-id from commandline which defaults to ssh-keygen -l -t ... (fixes #38302)
        * test a set of files for the host-key to find them on most unixes

Now I'm QA on this one.

Verified fixed on 2.0.0.7111

An entry was added to the 2.0 changelog:

A sigar network stats error was generated on the Solaris platform:

# /opt/mysql/enterprise/agent/bin/mysql-service-agent --version
MySQL Service Agent - 1.2.0.7879, (glib lib=2.8.5, headers=2.8.5)

SunOS mysqlprd01 5.10 Generic_127127-11 sun4v sparc SUNW,T5240

2008-07-21 10:07:24: (critical) sigar_net_interface_config_primary_get() failed: 6
2008-07-21 10:08:00: (critical) sigar_net_interface_config_primary_get() failed: 6

# /opt/mysql/enterprise/agent/bin/sigar-test-all >/tmp/test.txt
sigar_net_interface_stat_get(e1000g0:2) failed#