Hi,
After enabling lmd, we have observed that checks in Thruk not getting executing further and got stuck at the same time.
We have observed that below entries in lmd.log file
Backends: ahedf
[2025-03-19 11:04:41.071][Warn][pid:82857][peer:1069] [sample][r:ddd0d3] slow query finished after 6.543479737s, response size: 26 B
GET timeperiods
ResponseHeader: fixed16
OutputFormat: json
Columns: in
KeepAlive: on
[2025-03-19 11:04:41.071][Warn][pid:82857][peer:1069] [sample][r:c27e76] slow query finished after 6.94456967s, response size: 26 B
GET timeperiods
ResponseHeader: fixed16
OutputFormat: json
Columns: in
KeepAlive: on
[2025-03-19 11:17:38.169][Warn][pid:82857][peer:1069] [sample][r:c484ea] slow query finished after 9.641389903s, response size: 228 B
GET status
ResponseHeader: fixed16
OutputFormat: json
Columns: program_start accept_passive_host_checks accept_passive_service_checks cached_log_messages check_external_commands check_host_freshness check_service_freshness connections connections_rate enable_event_handlers enable_flap_detection enable_notifications execute_host_checks execute_service_checks forks forks_rate host_checks host_checks_rate last_command_check last_log_rotation log_messages log_messages_rate nagios_pid neb_callbacks neb_callbacks_rate obsess_over_hosts obsess_over_services process_performance_data requests requests_rate service_checks service_checks_rate
KeepAlive: on
Please find below lmd.ini file
OMD[sample@xxxx]:/tmp$ cat thruk/lmd/lmd.ini
Listen = ['/omd/sites/sample/tmp/thruk/lmd/live.sock']
LogFile = '/omd/sites/sample/tmp/thruk/lmd/lmd.log'
LogLevel = 'Debug'
[[Connections]]
name = 'sample'
id = 'ahedf'
source = ['/omd/sites/sample/tmp/run/live']
OMD[sample@xxxx]:/tmp$
After restarting the OMD services, again the checks getting executed.
Kindly advice what are the possible reasons for the error slow query finished after 9.641389903s, response size: 228 B.
Hi,
After enabling lmd, we have observed that checks in Thruk not getting executing further and got stuck at the same time.
We have observed that below entries in lmd.log file
Backends: ahedf
[2025-03-19 11:04:41.071][Warn][pid:82857][peer:1069] [sample][r:ddd0d3] slow query finished after 6.543479737s, response size: 26 B
GET timeperiods
ResponseHeader: fixed16
OutputFormat: json
Columns: in
KeepAlive: on
[2025-03-19 11:04:41.071][Warn][pid:82857][peer:1069] [sample][r:c27e76] slow query finished after 6.94456967s, response size: 26 B
GET timeperiods
ResponseHeader: fixed16
OutputFormat: json
Columns: in
KeepAlive: on
[2025-03-19 11:17:38.169][Warn][pid:82857][peer:1069] [sample][r:c484ea] slow query finished after 9.641389903s, response size: 228 B
GET status
ResponseHeader: fixed16
OutputFormat: json
Columns: program_start accept_passive_host_checks accept_passive_service_checks cached_log_messages check_external_commands check_host_freshness check_service_freshness connections connections_rate enable_event_handlers enable_flap_detection enable_notifications execute_host_checks execute_service_checks forks forks_rate host_checks host_checks_rate last_command_check last_log_rotation log_messages log_messages_rate nagios_pid neb_callbacks neb_callbacks_rate obsess_over_hosts obsess_over_services process_performance_data requests requests_rate service_checks service_checks_rate
KeepAlive: on
Please find below lmd.ini file
OMD[sample@xxxx]:
/tmp$ cat thruk/lmd/lmd.ini/tmp$Listen = ['/omd/sites/sample/tmp/thruk/lmd/live.sock']
LogFile = '/omd/sites/sample/tmp/thruk/lmd/lmd.log'
LogLevel = 'Debug'
[[Connections]]
name = 'sample'
id = 'ahedf'
source = ['/omd/sites/sample/tmp/run/live']
OMD[sample@xxxx]:
After restarting the OMD services, again the checks getting executed.
Kindly advice what are the possible reasons for the error slow query finished after 9.641389903s, response size: 228 B.