Hi guys,
It's been a while since I posted on here, but I made a fresh Observium
installation (for the moment, yes, it's CE, can't convince the CEO to shell
out that cash for Pro yet...) however I'm having a weird issue with the
table ports-state:
root@comet:/opt/observium# ./poller.php -h 1 -d | grep -C2 MEMORY\ DB
SQL[INSERT INTO `ports-state` (`port_id`) VALUES ('1')]
Certain MEMORY DB error for table 'ports-state'.
SQL[UPDATE `ports-state` set `poll_time` ='1407517231',`poll_period`
='1407517231',`ifInOctets` ='2974209',`ifOutOctets` ='2974209',`ifInErrors`
='0',`ifOutErrors` ='0',`ifInUcastPkts` ='10310',`ifOutUcastPkts`
='10310',`ifInOctets_perc` ='0',`ifOutOctets_perc` ='0',`ifOctets_rate`
='0',`ifUcastPkts_rate` ='0',`ifErrors_rate` ='0' WHERE `port_id` = '1']
--
SQL[INSERT INTO `ports-state` (`port_id`) VALUES ('2')]
Certain MEMORY DB error for table 'ports-state'.
SQL[UPDATE `ports-state` set `poll_time` ='1407517231',`poll_period`
='1407517231',`ifInOctets` ='997162274',`ifOutOctets`
='12070347',`ifInErrors` ='0',`ifOutErrors` ='0',`ifInUcastPkts`
='929556',`ifOutUcastPkts` ='92562',`ifInOctets_perc`
='0',`ifOutOctets_perc` ='0',`ifOctets_rate` ='0',`ifUcastPkts_rate`
='0',`ifErrors_rate` ='0' WHERE `port_id` = '2']
--
SQL[INSERT INTO `ports-state` (`port_id`) VALUES ('3')]
Certain MEMORY DB error for table 'ports-state'.
SQL[UPDATE `ports-state` set `poll_time` ='1407517231',`poll_period`
='1407517231',`ifInOctets` ='17012646',`ifOutOctets`
='369532358',`ifInErrors` ='0',`ifOutErrors` ='0',`ifInUcastPkts`
='74830',`ifOutUcastPkts` ='550361',`ifInOctets_perc`
='0',`ifOutOctets_perc` ='0',`ifOctets_rate` ='0',`ifUcastPkts_rate`
='0',`ifErrors_rate` ='0' WHERE `port_id` = '3']
root@comet:/opt/observium#
This in turn doesn't enable the "current" port speeds on the web and when I
look in the database itself, the table is empty. Has anyone come accross
this before? Is there a way to fix this?
Details:
OS: Debian 7.6
PHP: 5.4.4-14+deb7u12
MySQL: 5.6.15
Observium: v0.14.4.5229
Thanks in advance guys!
