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 Not yet released	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