Why is the configuration database access and jvm gc alarms have no effect?

[liyongfa0311]

Please answer these questions before submitting your issue.

• Why do you submit this issue?
• [ X ] Question or discussion
• Bug
• Requirement
• Feature or performance improvement

---

Question

• What do you want to know?
  I want a database access and GC timeout alert, but no alarms come out after the threshold is reached.There are no problems with service related and endpoint related alarms.

---

Bug

• Which version of SkyWalking, OS and JRE?
  CentOS 7

• Which company or project?

• What happen?
  If possible, provide a way for reproducing the error. e.g. demo application, component version.
  The following is my configuration information
  

---

Requirement or improvement

• Please describe about your requirements or improvement suggestions.

[liyongfa0311]

[wu-sheng]

Where do you find the metrics names?

[liyongfa0311]

In this oal file https://github.com/apache/skywalking/blob/v6.1.0/oap-server/generated-analysis/src/main/resources/official_analysis.oal
Linked by the oal documentation introduction

[wu-sheng]

Database access alarm is a part of service alarm, I think.

[wu-sheng]

Your rule name needs being ended with _rule, I think. Please check the logs?

[liyongfa0311]

I am very sorry that I made such a simple error on the gc configuration, but my database access configuration does not have this error. Can't I get a database-only alarm?

[liyongfa0311]

I have checked that the data of database access in es has exceeded the configured threshold.

[wu-sheng]

For database, you could use service name filter. Do you know it?

[liyongfa0311]

Do I need to change metrics-name to service_resp_time ? Where is using the database_access_resp_time?

[wu-sheng]

Metrics name comes from OAL only. There is entity name of DB for filter.

[liyongfa0311]

I didn't understand what you mean. Can I get a database access timeout alert through configuration?

[wu-sheng]

Can I get a database access timeout alert through configuration?

What is the timeout in JDBC? Do you understand what are you asking?

[liyongfa0311]

I want to get slow sql alarm through skywalking，so can I get a alert that the timeout of database access through configuring alarm-settings.yml?

[wu-sheng]

I want to get slow sql alarm through skywalking，so can I get a alert that the timeout of database access through configuring alarm-settings.yml?

No, we don't have that. TopN is not a metrics type, it is TopN type.