Werk #17213: oracle_sql: Fix ValueError: could not convert string to float: ''

Component Checks & agents
Title oracle_sql: Fix ValueError: could not convert string to float: ''
Date Nov 12, 2024
Level Trivial Change
Class Bug Fix
Compatibility Compatible - no manual interaction needed
Checkmk versions & editions
2.4.0b1 Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)
2.3.0p21 Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)
2.2.0p37 Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)

The agent plugin mk_oracle reports 'elapsed:' for the elapsed time, if the perl or bc call fail. In the past, the plugin oracle_sql crashes with

  elif key == "elapsed":
    instance.elapsed = float(line[1])
ValueError: could not convert string to float: ''

With this Werk, the crash is fixed. The missing metric elapsed_time will be omitted.

To the list of all Werks