Hello Guys
Recently i report that i had a lot of php processes
running on the server and this consume the whole
resources of the server so i checked the logs and notice
that i have a 3.5 GB db.log file and in there is the
next info:
t row 1), Query: INSERT INTO `sensors-state`
(`sensor_id`,`sensor_value`,`sensor_event`,`sensor_status`,`sensor_last_change`,`sensor_polled`)
VALUES ('278','70','ok','','','1456155044')
[2016/02/22 15:30:45 +0000] poller.php(9150): Failed
dbQuery (#1364 - Field 'ifInUcastPkts_delta' doesn't
have a default value), Query: INSERT INTO `ports-state`
(`poll_time`,`poll_period`,`ifInOctets`,`ifOutOctets`,`ifInErrors`,`ifOutErrors`,`ifInUcastPkts`,`ifOutUcastPkts`,`ifInOctets_perc`,`ifOutOctets_perc`,`ifOctets_rate`,`ifUcastPkts_rate`,`ifErrors_rate`,`port_id`)
VALUES
('1456155045','1456155045','15446864133','15446864133','0','0','66588490','66588490','0','0','0','0','0','524')
[2016/02/22 15:30:45 +0000] poller.php(9150): Failed
dbQuery (#1364 - Field 'ifInUcastPkts_delta' doesn't
have a default value), Query: INSERT INTO `ports-state`
(`poll_time`,`poll_period`,`ifInOctets`,`ifOutOctets`,`ifInErrors`,`ifOutErrors`,`ifInUcastPkts`,`ifOutUcastPkts`,`ifInOctets_perc`,`ifOutOctets_perc`,`ifOctets_rate`,`ifUcastPkts_rate`,`ifErrors_rate`,`port_id`)
VALUES
('1456155045','1456155045','64446811076','175584922424','0','0','339891989','309672599','0','0','0','0','0','525')
[2016/02/22 15:30:46 +0000] poller.php(6813): Failed
dbQuery (#1364 - Field 'mempool_polled' doesn't have a
default value), Query: INSERT INTO `mempools-state`
(`mempool_id`) VALUES ('91')
[2016/02/22 15:30:46 +0000] poller.php(6813): Failed
dbQuery (#1364 - Field 'mempool_polled' doesn't have a
default value), Query: INSERT INTO `mempools-state`
(`mempool_id`) VALUES ('92')
[2016/02/22 15:30:46 +0000] poller.php(6813): Failed
dbQuery (#1364 - Field 'mempool_polled' doesn't have a
default value), Query:
this is the reason why i have many poller pids on the
server.