Error scraping for rount _ map[value:Current session] : No metrics found while parsing" source="main.go:235"

[hanhan579]

Hello, I'm a Chinese beginner. Now I want to customize monitoring oracle

I'm using custom metric to collect my database information, but when i start my oracledb_exporter， I got the problem: nohup /oracle/app/oracledb/oracledb_exporter --custom.metrics /oracle/app/oracledb/default-metrics.toml &

time="2021-10-11T15:47:46+08:00" level=info msg="Starting oracledb_exporter 0.2.9" source="main.go:390" time="2021-10-11T15:47:46+08:00" level=info msg="Successfully loaded default metrics from: default-metrics.toml" source="main.go:397" time="2021-10-11T15:47:46+08:00" level=info msg="Successfully loaded custom metrics from: /oracle/app/oracledb/default-metrics.toml" source="main.go:406" time="2021-10-11T15:47:46+08:00" level=error msg="Unable to convert current value to float (metric=value,metricHelp=Current session,value=<>)" source="main.go:285" time="2021-10-11T15:47:46+08:00" level=error msg="Error scraping for rount _ map[value:Current session] : No metrics found while parsing" source="main.go:235" time="2021-10-11T15:47:46+08:00" level=error msg="Unable to convert current value to float (metric=value,metricHelp=Current session,value=<>)" source="main.go:285" time="2021-10-11T15:47:46+08:00" level=error msg="Error scraping for rount _ map[value:Current session] : No metrics found while parsing" source="main.go:235" time="2021-10-11T15:47:46+08:00" level=info msg="Listening on :9161" source="main.go:419" time="2021-10-11T15:47:47+08:00" level=error msg="Unable to convert current value to float (metric=value,metricHelp=Current session,value=<>)" source="main.go:285" time="2021-10-11T15:47:47+08:00" level=error msg="Error scraping for rount _ map[value:Current session] : No metrics found while parsing" source="main.go:235" time="2021-10-11T15:47:47+08:00" level=error msg="Unable to convert current value to float (metric=value,metricHelp=Current session,value=<>)" source="main.go:285" time="2021-10-11T15:47:47+08:00" level=error msg="Error scraping for rount _ map[value:Current session] : No metrics found while parsing" source="main.go:235"

This is my metrics :

[[metric]] context = "rount" metricsdesc = { value= "Current session" } request = "select 'DATA' || ' ' || limit || ' ' || total_session || ' ' || ROUND (total_session / limit * 100) from (select VALUE as limit FROM v$PARAMETER WHERE NAME='processes'), (select count(*) as total_session from v$session ) "

What did I do wrong? Thank you for answering for @Yannig @iamseth

[3DPIT]

It's not clear what query result you are.

I want to see the query result.

Then I can come up with a solution.

[hanhan579]

不清楚你是什么查询结果。

我想看看查询结果。

然后我可以想出一个解决方案。

I have solved this problem. Thank you

Can you help me see what's going on

time="2021-10-14T16:45:39+08:00" level=info msg="Starting oracledb_exporter 0.2.9" source="main.go:390" time="2021-10-14T16:45:39+08:00" level=info msg="Successfully loaded default metrics from: default-metrics.toml" source="main.go:397" time="2021-10-14T16:45:39+08:00" level=info msg="Successfully loaded custom metrics from: /usr/local/oracledb_exporter/default-metrics.toml" source="main.go:406" time="2021-10-14T16:45:45+08:00" level=error msg="Error scraping for tablespace _ map[bytes:Generic counter metric of tablespaces bytes in Oracle. free:Generic counter metric of tablespaces free bytes in Oracle. max_bytes:Generic counter metric of tablespaces max bytes in Oracle.] : Oracle query timed out" source="main.go:235" time="2021-10-14T16:45:50+08:00" level=error msg="Error scraping for tablespace _ map[bytes:Generic counter metric of tablespaces bytes in Oracle. free:Generic counter metric of tablespaces free bytes in Oracle. max_bytes:Generic counter metric of tablespaces max bytes in Oracle.] : Oracle query timed out" source="main.go:235" time="2021-10-14T16:45:50+08:00" level=info msg="Listening on :9161" source="main.go:419" time="2021-10-14T16:46:12+08:00" level=error msg="Error scraping for tablespace _ map[bytes:Generic counter metric of tablespaces bytes in Oracle. free:Generic counter metric of tablespaces free bytes in Oracle. max_bytes:Generic counter metric of tablespaces max bytes in Oracle.] : Oracle query timed out" source="main.go:235" time="2021-10-14T16:46:18+08:00" level=error msg="Error scraping for tablespace _ map[bytes:Generic counter metric of tablespaces bytes in Oracle. free:Generic counter metric of tablespaces free bytes in Oracle. max_bytes:Generic counter metric of tablespaces max bytes in Oracle.] : Oracle query timed out" source="main.go:235"

[hanhan579]

不清楚你是什么查询结果。

我想看看查询结果。

然后我可以想出一个解决方案。 Hello! My "oracledb_export" query always times out. I use binary files. There are only "default-metrics.toml" and "oracledb_exporter". How can I set the query time? How many seconds is the default query timeout?