SAP-MaxDB checkmk plugin services crash if DB is offline

seebus commented 3 months ago

If the state of the DB is offline, the services in the checkmk gui fail:

DB state from maxdb.py: <<>> [[DB]] OK State OFFLINE

Shouldn't there be a catch for the services if the db is offline instead of a crash report?

Ma7h1 commented 3 months ago

Hello,

can you send me the agent output or the crash report or attach it here?

Greetings Mathias

seebus commented 3 months ago

Of course, here are the 4 crash reports:

Exception
ZeroDivisionError (float division by zero) Traceback
File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 716, in get_aggregated_result check_result = check_function(item_kw, params_kw, section_kws) File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 496, in __check_function return _aggregate_results(consume_check_results(check_function(*args, *kw))) File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 554, in consume_check_results for subr in subresults: File "/omd/sites/indicokunden/lib/python3/cmk/base/api/agent_based/register/check_plugins.py", line 91, in filtered_generator for element in generator(args, kwargs): File "/omd/sites/indicokunden/local/lib/python3/cmk/base/plugins/agent_based/maxdb_data.py", line 99, in check_maxdb_log 100.0 * used_log_pages_size / log_pages_size,

Exception
AttributeError ('NoneType' object has no attribute 'lower') Traceback
File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 716, in get_aggregated_result check_result = check_function(item_kw, params_kw, section_kws) File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 496, in __check_function return _aggregate_results(consume_check_results(check_function(*args, *kw))) File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 554, in consume_check_results for subr in subresults: File "/omd/sites/indicokunden/lib/python3/cmk/base/api/agent_based/register/check_plugins.py", line 91, in filtered_generator for element in generator(args, kwargs): File "/omd/sites/indicokunden/local/lib/python3/cmk/base/plugins/agent_based/maxdb_state.py", line 82, in check_maxdb_state yield Result(state=State(0 if data.get('AUTOSAVESTANDBY').lower() ==

Exception
TypeError (unsupported operand type(s) for *: 'float' and 'NoneType') Traceback
File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 716, in get_aggregated_result check_result = check_function(item_kw, params_kw, section_kws) File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 496, in __check_function return _aggregate_results(consume_check_results(check_function(*args, *kw))) File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 554, in consume_check_results for subr in subresults: File "/omd/sites/indicokunden/lib/python3/cmk/base/api/agent_based/register/check_plugins.py", line 91, in filtered_generator for element in generator(args, kwargs): File "/omd/sites/indicokunden/local/lib/python3/cmk/base/plugins/agent_based/maxdb_data.py", line 158, in check_maxdb_data 100.0 * used_size / usable_size,

Exception
TypeError (float() argument must be a string or a real number, not 'NoneType') Traceback
File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 716, in get_aggregated_result check_result = check_function(item_kw, params_kw, section_kws) File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 496, in __check_function return _aggregate_results(consume_check_results(check_function(*args, *kw))) File "/omd/sites/indicokunden/lib/python3/cmk/base/checkers.py", line 554, in consume_check_results for subr in subresults: File "/omd/sites/indicokunden/lib/python3/cmk/base/api/agent_based/register/check_plugins.py", line 91, in filtered_generator for element in generator(args, kwargs): File "/omd/sites/indicokunden/local/lib/python3/cmk/base/plugins/agent_based/maxdb_data.py", line 210, in check_maxdb_hitrate float(section.get(item, {}).get('DATACACHE_HITRATE')),

Ma7h1 commented 3 weeks ago

Hi, can you send me the lines from the Agent output. check_mk Service -> download Agentouput and then only the Content of "<<<maxdb...." Cheers Mathias

iteratio-com / Exchange

SAP-MaxDB checkmk plugin services crash if DB is offline #19