Hi,
You're running MySQL in strict mode. Please disable it.
Thanks, Tom
On 2016-02-29 09:41, Jose Colin wrote:
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.
please can you guide to fix this issue?.
thanks in advice.
José.
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium