db.log filling server [SEC=UNCLASSIFIED]
v0.16.1.7533 upgraded from 0.15.6.6430
./discovery.php -u
Observium Community Edition 0.16.1.7533
-- Database is up to date.
it's full of entries like
[2016/02/08 11:30:35 +1100] poller.php(622): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('424','fdb_count','') [2016/02/08 11:30:35 +1100] poller.php(626): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('427','fdb_count','') [2016/02/08 11:30:35 +1100] poller.php(622): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('424','firewall_sessions_ipv4','') [2016/02/08 11:30:35 +1100] poller.php(610): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('476','firewall_sessions_ipv4','') [2016/02/08 11:30:35 +1100] poller.php(626): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('427','firewall_sessions_ipv4','') [2016/02/08 11:30:35 +1100] poller.php(603): Failed dbQuery (#1364 - Field 'ifInUcastPkts_delta' doesn't have a default value), Query: INSERT INTO `ports-state` (`pol l_time`,`poll_period`,`ifInOctets`,`ifOutOctets`,`ifInErrors`,`ifOutErrors`,`ifInUcastPkts`,`ifOutUcastPkts`,`ifInOctets_perc`,`ifOutOctets_perc`,`ifOctets_rate`,`ifU
castPkts_rate`,`ifErrors_rate`,`port_id`) VALUES ('1454891434','1454891434','','','','','','','0','0','0','0','0','1668') [2016/02/08 11:30:35 +1100] poller.php(3592): Failed dbQuery (#1364 - Field 'mempool_polled' doesn't have a default value), Query: INSERT INTO `mempools-state` (`memp ool_id`) VALUES ('1973') [2016/02/08 11:30:35 +1100] poller.php(3592): Failed dbQuery (#1364 - Field 'mempool_polled' doesn't have a default value), Query: INSERT INTO `mempools-state` (`memp ool_id`) VALUES ('1974') [2016/02/08 11:30:35 +1100] poller.php(603): Failed dbQuery (#1364 - Field 'ifInUcastPkts_delta' doesn't have a default value), Query: INSERT INTO `ports-state` (`pol l_time`,`poll_period`,`ifInOctets`,`ifOutOctets`,`ifInErrors`,`ifOutErrors`,`ifInUcastPkts`,`ifOutUcastPkts`,`ifInOctets_perc`,`ifOutOctets_perc`,`ifOctets_rate`,`ifU
castPkts_rate`,`ifErrors_rate`,`port_id`) VALUES ('1454891434','1454891434','','','','','','','0','0','0','0','0','1669')
so the question is, how do i remediate it.
thanks
Peter Hine Senior Technical Support Engineer (Servers) FCoA ITS peter.hine@familycourt.gov.au
********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************
turned of the STRICT setting like a previous post, now getting
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
device_id appears to be a unique index but it appears multiple times in the table. (Embedded image moved to file: pic25943.gif) (Embedded image moved to file: pic03133.gif)
thanks
Peter Hine Senior Technical Support Engineer (Servers) FCoA ITS peter.hine@familycourt.gov.au
********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************
You can probably ignore this, since we need to fix & rewrite the ipsec stuff at some point.
adam. On 08/02/2016 01:46:20, peter.hine@familycourt.gov.au peter.hine@familycourt.gov.au wrote:
turned of the STRICT setting like a previous post, now getting
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
device_id appears to be a unique index but it appears multiple times in the table. (Embedded image moved to file: pic25943.gif) (Embedded image moved to file: pic03133.gif)
thanks
Peter Hine Senior Technical Support Engineer (Servers) FCoA ITS peter.hine@familycourt.gov.au
********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (2)
-
Adam Armstrong -
Peter.Hine＠familycourt.gov.au