Open leandroschatts opened 4 years ago
lpinsivy
commented
4 years ago Hi @leandroschatts all your process look like sub process of MySQL.
For me it's normal because it depend of how many users are connected to web interface, if users are connected to "custom views" menu, how many widgets they displayed and all internal Centreon processes.
Regards,
tetsumaki
commented
4 years ago Hi, same problem here with fresh install :
Centreon version : 19.10.1 (commit e77f8037b)
I found the problem :
// Build Query
$query = 'SELECT SQL_CALC_FOUND_ROWS h.host_id,
h.name as hostname,
h.alias as hostalias,
s.latency,
s.execution_time,
h.state as h_state,
s.service_id,
s.description,
s.state as s_state,
h.state_type as state_type,
s.last_hard_state,
s.output,
s.scheduled_downtime_depth as s_scheduled_downtime_depth,
s.acknowledged as s_acknowledged,
s.notify as s_notify,
s.perfdata,
s.active_checks as s_active_checks,
s.passive_checks as s_passive_checks,
h.scheduled_downtime_depth as h_scheduled_downtime_depth,
h.acknowledged as h_acknowledged,
h.notify as h_notify,
h.active_checks as h_active_checks,
h.passive_checks as h_passive_checks,
s.last_check,
s.last_state_change,
s.last_hard_state_change,
s.check_attempt,
s.max_check_attempts,
h.action_url as h_action_url,
h.notes_url as h_notes_url,
s.action_url as s_action_url,
s.notes_url as s_notes_url,
cv2.value AS criticality_id,
cv.value AS criticality_level,
h.icon_image
FROM hosts h JOIN instances i ON h.instance_id=i.instance_id, services s
LEFT JOIN customvariables cv ON (
s.service_id = cv.service_id
AND s.host_id = cv.host_id
AND cv.name = \'CRITICALITY_LEVEL\'
)
LEFT JOIN customvariables cv2 ON (
s.service_id = cv2.service_id
AND s.host_id = cv2.host_id
AND cv2.name = \'CRITICALITY_ID\'
) ';The query never ends and stacks with others.
I uninstalled the widget and killed the queries to correct the problem.
Before remove the widget :
tetsumaki
commented
4 years ago Screenshot before uninstall : https://framapic.org/RyVytTrX1k4U/uUS95BHCs1IE.png
BUG REPORT INFORMATION
Prerequisites
Versions
For the RPM based systems