I think it helps if you setup housekeeping first in this case, it will clean up your install, and will fix your issue.
Maarten
Sent from my iPhone
On 27 Oct 2016, at 15:19, Svensson Fredrik A fredrik.a.svensson@rjl.se wrote:
Hi there! When we are deleting a device we struggle with the time it takes, I have done a debug and this seems to be the problem:
SQL[DELETE FROM `devices_perftimes` WHERE `device_id` = '593'] ROWS[-1] SQL RUNTIME[97.04324698s] ERROR[Error in query: (The total number of locks exceeds the lock table size) 1206]
Can you help me with what I can do to fix this problem?
This also take some time: SQL[DELETE FROM `alert_log` WHERE `device_id` = '593'] ROWS[11480] SQL RUNTIME[15.23252392s]
Regards Fredrik
-----Ursprungligt meddelande----- Från: observium [mailto:observium-bounces@observium.org] För greg lambert Skickat: den 25 oktober 2016 09:41 Till: Observium Network Observation System observium@observium.org Ämne: [Observium] Acme Packet SBC 3820
Good Day,
I just loaded my SBC into observium - it doesn not graph the voice utilization. I was hoping to use it to graph voice channel useage etc.
Is there any suggested way to get this graphed?
Regards,
Greg
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