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é.
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
Hello Tom
seems to be that its working better now !
thanks a lot for your support on this.
Jose
On Mon, Feb 29, 2016 at 12:10 PM, Tom Laermans tom.laermans@powersource.cx wrote:
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 listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (2)
-
Jose Colin -
Tom Laermans