Hi,
I received the message: "Failed INSERT into DB, see details in 'db.log' inside log dir." when trying to insert ports in a billing... and there's nothing about the query in the log.
Hi,
very well, that send me output for last 10 log entries:
$ tail -n 10 /opt/observium/logs/db.log
On 29.06.15 18:46, Eduardo Schoedler wrote:
Hi,
I received the message: "Failed INSERT into DB, see details in 'db.log' inside log dir." when trying to insert ports in a billing... and there's nothing about the query in the log.
Hi Mike,
Last 10 logs isn't about billing... http://pastebin.com/PAXuX6qF
Thanks.
2015-06-29 12:50 GMT-03:00 Mike Stupalov mike@observium.org:
Hi,
very well, that send me output for last 10 log entries:
$ tail -n 10 /opt/observium/logs/db.log
On 29.06.15 18:46, Eduardo Schoedler wrote:
Hi,
I received the message: "Failed INSERT into DB, see details in 'db.log' inside log dir." when trying to insert ports in a billing... and there's nothing about the query in the log.
-- Mike Stupalov http://observium.org
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
On 29.06.15 18:53, Eduardo Schoedler wrote:
Hi Mike,
Last 10 logs isn't about billing... http://pastebin.com/PAXuX6qF
It is also good for db fixes, but that try to find entries with bad INSERTs to billing. Something like:
$ grep 'bill' /opt/observium/logs/db.log | tail -n 10
Thanks.
2015-06-29 12:50 GMT-03:00 Mike Stupalov mike@observium.org:
Hi,
very well, that send me output for last 10 log entries:
$ tail -n 10 /opt/observium/logs/db.log
On 29.06.15 18:46, Eduardo Schoedler wrote:
Hi,
I received the message: "Failed INSERT into DB, see details in 'db.log' inside log dir." when trying to insert ports in a billing... and there's nothing about the query in the log.
-- Mike Stupalov http://observium.org
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
2015-06-29 13:03 GMT-03:00 Mike Stupalov mike@observium.org:
On 29.06.15 18:53, Eduardo Schoedler wrote:
Hi Mike,
Last 10 logs isn't about billing... http://pastebin.com/PAXuX6qF
It is also good for db fixes, but that try to find entries with bad INSERTs to billing. Something like:
$ grep 'bill' /opt/observium/logs/db.log | tail -n 10
Nothing.
-- Eduardo Schoedler
I'm not sure why it's trying to insert tx_bytes and rx_bytes into the device table. Those fields are only used on wifi radios!
What is that device? (57, 58 and 59)
adam.
Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] On 29/06/2015 17:05:52, Eduardo Schoedler listas@esds.com.br wrote: 2015-06-29 13:03 GMT-03:00 Mike Stupalov :
On 29.06.15 18:53, Eduardo Schoedler wrote:
Hi Mike,
Last 10 logs isn't about billing... http://pastebin.com/PAXuX6qF
It is also good for db fixes, but that try to find entries with bad INSERTs to billing. Something like:
$ grep 'bill' /opt/observium/logs/db.log | tail -n 10
Nothing.
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Hi Adam,
It's Ruckus access points.
Thanks,
2015-06-29 13:24 GMT-03:00 Adam Armstrong adama@memetic.org:
I'm not sure why it's trying to insert tx_bytes and rx_bytes into the device table. Those fields are only used on wifi radios!
What is that device? (57, 58 and 59)
adam.
Sent from Mailbird
On 29/06/2015 17:05:52, Eduardo Schoedler listas@esds.com.br wrote:
2015-06-29 13:03 GMT-03:00 Mike Stupalov :
On 29.06.15 18:53, Eduardo Schoedler wrote:
Hi Mike,
Last 10 logs isn't about billing... http://pastebin.com/PAXuX6qF
It is also good for db fixes, but that try to find entries with bad INSERTs to billing. Something like:
$ grep 'bill' /opt/observium/logs/db.log | tail -n 10
Nothing.
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Ahh. That issue should be fixed now :)
adam.
Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] On 29/06/2015 19:11:12, Eduardo Schoedler listas@esds.com.br wrote: Hi Adam,
It's Ruckus access points.
Thanks,
2015-06-29 13:24 GMT-03:00 Adam Armstrong :
I'm not sure why it's trying to insert tx_bytes and rx_bytes into the device table. Those fields are only used on wifi radios!
What is that device? (57, 58 and 59)
adam.
Sent from Mailbird
On 29/06/2015 17:05:52, Eduardo Schoedler wrote:
2015-06-29 13:03 GMT-03:00 Mike Stupalov :
On 29.06.15 18:53, Eduardo Schoedler wrote:
Hi Mike,
Last 10 logs isn't about billing... http://pastebin.com/PAXuX6qF
It is also good for db fixes, but that try to find entries with bad INSERTs to billing. Something like:
$ grep 'bill' /opt/observium/logs/db.log | tail -n 10
Nothing.
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Thank you!
Regards,
2015-06-29 15:12 GMT-03:00 Adam Armstrong adama@memetic.org:
Ahh. That issue should be fixed now :)
adam.
Sent from Mailbird
On 29/06/2015 19:11:12, Eduardo Schoedler listas@esds.com.br wrote:
Hi Adam,
It's Ruckus access points.
Thanks,
2015-06-29 13:24 GMT-03:00 Adam Armstrong :
I'm not sure why it's trying to insert tx_bytes and rx_bytes into the device table. Those fields are only used on wifi radios!
What is that device? (57, 58 and 59)
adam.
Sent from Mailbird
On 29/06/2015 17:05:52, Eduardo Schoedler wrote:
2015-06-29 13:03 GMT-03:00 Mike Stupalov :
On 29.06.15 18:53, Eduardo Schoedler wrote:
Hi Mike,
Last 10 logs isn't about billing... http://pastebin.com/PAXuX6qF
It is also good for db fixes, but that try to find entries with bad INSERTs to billing. Something like:
$ grep 'bill' /opt/observium/logs/db.log | tail -n 10
Nothing.
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Adam,
I'm seeing a lot of ospf query problems.
[2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9413' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9412' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9411' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9410' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9409' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9408' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9407'
It's normal?
Thanks.
2015-06-29 15:13 GMT-03:00 Eduardo Schoedler listas@esds.com.br:
Thank you!
Regards,
2015-06-29 15:12 GMT-03:00 Adam Armstrong adama@memetic.org:
Ahh. That issue should be fixed now :)
adam.
Sent from Mailbird
On 29/06/2015 19:11:12, Eduardo Schoedler listas@esds.com.br wrote:
Hi Adam,
It's Ruckus access points.
Thanks,
2015-06-29 13:24 GMT-03:00 Adam Armstrong :
I'm not sure why it's trying to insert tx_bytes and rx_bytes into the device table. Those fields are only used on wifi radios!
What is that device? (57, 58 and 59)
adam.
Sent from Mailbird
On 29/06/2015 17:05:52, Eduardo Schoedler wrote:
2015-06-29 13:03 GMT-03:00 Mike Stupalov :
On 29.06.15 18:53, Eduardo Schoedler wrote:
Hi Mike,
Last 10 logs isn't about billing... http://pastebin.com/PAXuX6qF
It is also good for db fixes, but that try to find entries with bad INSERTs to billing. Something like:
$ grep 'bill' /opt/observium/logs/db.log | tail -n 10
Nothing.
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler
fixed :)
adam.
Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] On 29/06/2015 19:38:11, Eduardo Schoedler listas@esds.com.br wrote: Adam,
I'm seeing a lot of ospf query problems.
[2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9413' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9412' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9411' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9410' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9409' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9408' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9407'
It's normal?
Thanks.
2015-06-29 15:13 GMT-03:00 Eduardo Schoedler :
Thank you!
Regards,
2015-06-29 15:12 GMT-03:00 Adam Armstrong :
Ahh. That issue should be fixed now :)
adam.
Sent from Mailbird
On 29/06/2015 19:11:12, Eduardo Schoedler wrote:
Hi Adam,
It's Ruckus access points.
Thanks,
2015-06-29 13:24 GMT-03:00 Adam Armstrong :
I'm not sure why it's trying to insert tx_bytes and rx_bytes into the device table. Those fields are only used on wifi radios!
What is that device? (57, 58 and 59)
adam.
Sent from Mailbird
On 29/06/2015 17:05:52, Eduardo Schoedler wrote:
2015-06-29 13:03 GMT-03:00 Mike Stupalov :
On 29.06.15 18:53, Eduardo Schoedler wrote:
Hi Mike,
Last 10 logs isn't about billing... http://pastebin.com/PAXuX6qF
It is also good for db fixes, but that try to find entries with bad INSERTs to billing. Something like:
$ grep 'bill' /opt/observium/logs/db.log | tail -n 10
Nothing.
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Adam,
More problems:
[2015/07/02 19:36:46 -0300] poller.php(1411): Failed dbQuery (#1062 - Duplicate entry '9-1580-xxxxxx01b0x5' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('9','1580','','xxxxxx01b0x5','learned') [2015/07/02 19:36:47 -0300] poller.php(1411): Failed dbQuery (#1062 - Duplicate entry '9-1580-xxxxxx01b0x6' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('9','1580','','xxxxxx01b0x6','learned') [2015/07/02 19:36:47 -0300] poller.php(1411): Failed dbQuery (#1062 - Duplicate entry '9-1580-xxxxxx01b0xa' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('9','1580','','xxxxxx01b04a','learned') [2015/07/02 19:36:47 -0300] poller.php(1411): Failed dbQuery (#1062 - Duplicate entry '9-1580-xxxxxx7454x7' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('9','1580','','xxxxxx745407','learned')
Can you verify?
Thanks.
2015-06-29 15:50 GMT-03:00 Adam Armstrong adama@memetic.org:
fixed :)
adam.
Sent from Mailbird
On 29/06/2015 19:38:11, Eduardo Schoedler listas@esds.com.br wrote:
Adam,
I'm seeing a lot of ospf query problems.
[2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9413' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9412' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9411' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9410' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9409' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9408' [2015/06/29 13:02:47 -0300] delete_device.php(8237): Failed dbQuery (#1146 - Table 'observium.ospf_nb' doesn't exist), Query: DELETE FROM `ospf_nb` WHERE `port_id` = '9407'
It's normal?
Thanks.
2015-06-29 15:13 GMT-03:00 Eduardo Schoedler :
Thank you!
Regards,
2015-06-29 15:12 GMT-03:00 Adam Armstrong :
Ahh. That issue should be fixed now :)
adam.
Sent from Mailbird
On 29/06/2015 19:11:12, Eduardo Schoedler wrote:
Hi Adam,
It's Ruckus access points.
Thanks,
2015-06-29 13:24 GMT-03:00 Adam Armstrong :
I'm not sure why it's trying to insert tx_bytes and rx_bytes into the device table. Those fields are only used on wifi radios!
What is that device? (57, 58 and 59)
adam.
Sent from Mailbird
On 29/06/2015 17:05:52, Eduardo Schoedler wrote:
2015-06-29 13:03 GMT-03:00 Mike Stupalov :
On 29.06.15 18:53, Eduardo Schoedler wrote:
Hi Mike,
Last 10 logs isn't about billing... http://pastebin.com/PAXuX6qF
It is also good for db fixes, but that try to find entries with bad INSERTs to billing. Something like:
$ grep 'bill' /opt/observium/logs/db.log | tail -n 10
Nothing.
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
On 29.06.15 19:05, Eduardo Schoedler wrote:
2015-06-29 13:03 GMT-03:00 Mike Stupalov mike@observium.org:
On 29.06.15 18:53, Eduardo Schoedler wrote:
Hi Mike,
Last 10 logs isn't about billing... http://pastebin.com/PAXuX6qF
It is also good for db fixes, but that try to find entries with bad INSERTs to billing. Something like:
$ grep 'bill' /opt/observium/logs/db.log | tail -n 10
Try this:
grep 'INSERT' /opt/observium/logs/db.log | tail -n 10
Nothing.
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (3)
-
Adam Armstrong -
Eduardo Schoedler -
Mike Stupalov