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!