cacti-0.8.8g web page responds too slow at times

[adeel7454]

Hi,
i am using cacti-0.8.8g, its a container on Proxmox and was working fine but from last couple of weeks its web access suddenly gets too slow that it take minutes to open the page after a detailed investigation i suspect the the issue occurs when when below mentioned type of process gets start, please advise me to resolve this issue.

7770 apache 20 0 286728 18312 8880 R 2.7 0.3 0:00.08 php

Moreover i am also attaching the stats taken from the server when it run normal and when it gets slow.

[netniV]

So it looks like you have a PHP process that was running for over 3 minutes. The chances are that its either locks or resources that are slowing down the process. I would check your logs (both cacti and PHP) to see what is being called at the time the process is started to see if there is a common denominator. you sould probably also look at your MySQL Slow Query log (make sure to set the minimum time to be 1 second or you'll get way too many queries).

[adeel7454]

please find the attached both required logs and advise me moreover i will also enable the mysql slow query and will let you know.

[adeel7454]

Few More Logs as well.




04/18/2019 10:41:08 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output_rt (local_data_id, rrd_name, time, poller_id, output) values (10101, 'traffic_in', '2019-04-18 10:41:08', '9232', '442164364887787')'
04/18/2019 10:41:08 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output_rt (local_data_id, rrd_name, time, poller_id, output) values (10101, 'traffic_out', '2019-04-18 10:41:08', '9232', '31613322592178')'
04/18/2019 10:41:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output_rt (local_data_id, rrd_name, time, poller_id, output) values (10101, 'traffic_in', '2019-04-18 10:41:20', '47348', '442165415356306')'
04/18/2019 10:41:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output_rt (local_data_id, rrd_name, time, poller_id, output) values (10101, 'traffic_out', '2019-04-18 10:41:20', '47348', '31613448754919')'
04/18/2019 10:43:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output_rt (local_data_id, rrd_name, time, poller_id, output) values (10101, 'traffic_in', '2019-04-18 10:43:02', '21056', '442174677564916')'
04/18/2019 10:43:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output_rt (local_data_id, rrd_name, time, poller_id, output) values (10101, 'traffic_out', '2019-04-18 10:43:02', '21056', '31614603698127')'

[netniV]

You may need to check whether the values exceed the columns at all or if there have been too many rows that the autoincrement id column has reached its max.

[adeel7454]

i am sorry i didint get it, could you please explain a bit form me? moreover Slow Query stats has also been attached with.

[netniV]

Try manually inserting the row that is generating the error, it's a valid SQL statement. The fact taht it's failing suggests either there is data too large for one of the columns or there are so many rows that your IDs have reached the upper limit.