Description:
I can modify a certified fule's default frequency and alert thresholds at Advisor->Manage rules.
When I modified frequency and save it, meaningless thresholds save. Thus meaningless alert reported after changing its frequency.
How to repeat:
(1) Schedule All replication rules(20-item) to servers of replication
(2) Select Advisor->Manage rules.
(3) Click 'edit' of 'Slave I/O Thread Not Running'.
(4) Change frequency from default(01:00) to 0:20
(5) Save it.
(6) Login to mem database of repository and check them.
2-meaningless altert were added (INFO, WARNING) for 'Slave I/O Thread Not Running'.
[Before Modification]
service_manager@localhost [mem]> select * from rules,rule_thresholds where rules.name like 'slave_%_running.name' and rules.rule_id = rule_thresholds.rule_id\G
*************************** 1. row ***************************
rule_id: 88
advice: slave_io_thread_not_running.advice
certified:
command: slave_io_thread_not_running.command
default_frequency: 60000
description: slave_io_thread_not_running.description
dirty:
expression: (%Slave_IO_Running% != THRESHOLD)
info: slave_io_thread_not_running.info
name: slave_io_thread_not_running.name
uuid: fdff2f3a-9114-4b79-a266-200d489f03ab
version: 1.5
threshold_id: 148
level: CRITICAL
value: "Yes"
variable: THRESHOLD
rule_id: 88
*************************** 2. row ***************************
rule_id: 92
advice: slave_sql_thread_not_running.advice
certified:
command: slave_sql_thread_not_running.command
default_frequency: 60000
description: slave_sql_thread_not_running.description
dirty:
expression: (%Slave_SQL_Running% != THRESHOLD)
info: slave_sql_thread_not_running.info
name: slave_sql_thread_not_running.name
uuid: 7a02ebe8-8b36-4ddc-86e1-c296a04b60fc
version: 1.4
threshold_id: 154
level: CRITICAL
value: "Yes"
variable: THRESHOLD
rule_id: 92
2 rows in set (0.00 sec)
[After Modification]
1st and 3rd rules are meaningless alert.
service_manager@localhost [mem]> select * from rules,rule_thresholds where rules.name like 'slave_%_running.name' and rules.rule_id = rule_thresholds.rule_id\G
*************************** 1. row ***************************
rule_id: 88
advice: slave_io_thread_not_running.advice
certified:
command: slave_io_thread_not_running.command
default_frequency: 120000
description: slave_io_thread_not_running.description
dirty:
expression: (%Slave_IO_Running% != THRESHOLD)
info: slave_io_thread_not_running.info
name: slave_io_thread_not_running.name
uuid: fdff2f3a-9114-4b79-a266-200d489f03ab
version: 1.5
threshold_id: 210
level: INFO
value:
variable: THRESHOLD
rule_id: 88
*************************** 2. row ***************************
rule_id: 88
advice: slave_io_thread_not_running.advice
certified:
command: slave_io_thread_not_running.command
default_frequency: 120000
description: slave_io_thread_not_running.description
dirty:
expression: (%Slave_IO_Running% != THRESHOLD)
info: slave_io_thread_not_running.info
name: slave_io_thread_not_running.name
uuid: fdff2f3a-9114-4b79-a266-200d489f03ab
version: 1.5
threshold_id: 211
level: CRITICAL
value: "Yes"
variable: THRESHOLD
rule_id: 88
*************************** 3. row ***************************
rule_id: 88
advice: slave_io_thread_not_running.advice
certified:
command: slave_io_thread_not_running.command
default_frequency: 120000
description: slave_io_thread_not_running.description
dirty:
expression: (%Slave_IO_Running% != THRESHOLD)
info: slave_io_thread_not_running.info
name: slave_io_thread_not_running.name
uuid: fdff2f3a-9114-4b79-a266-200d489f03ab
version: 1.5
threshold_id: 212
level: WARNING
value:
variable: THRESHOLD
rule_id: 88
*************************** 4. row ***************************
rule_id: 92
advice: slave_sql_thread_not_running.advice
certified:
command: slave_sql_thread_not_running.command
default_frequency: 60000
description: slave_sql_thread_not_running.description
dirty:
expression: (%Slave_SQL_Running% != THRESHOLD)
info: slave_sql_thread_not_running.info
name: slave_sql_thread_not_running.name
uuid: 7a02ebe8-8b36-4ddc-86e1-c296a04b60fc
version: 1.4
threshold_id: 154
level: CRITICAL
value: "Yes"
variable: THRESHOLD
rule_id: 92
4 rows in set (0.00 sec)
Suggested fix:
[Workaround]
N/A
[Suggested fix]
Don't make meaningless altert when saving.
Description: I can modify a certified fule's default frequency and alert thresholds at Advisor->Manage rules. When I modified frequency and save it, meaningless thresholds save. Thus meaningless alert reported after changing its frequency. How to repeat: (1) Schedule All replication rules(20-item) to servers of replication (2) Select Advisor->Manage rules. (3) Click 'edit' of 'Slave I/O Thread Not Running'. (4) Change frequency from default(01:00) to 0:20 (5) Save it. (6) Login to mem database of repository and check them. 2-meaningless altert were added (INFO, WARNING) for 'Slave I/O Thread Not Running'. [Before Modification] service_manager@localhost [mem]> select * from rules,rule_thresholds where rules.name like 'slave_%_running.name' and rules.rule_id = rule_thresholds.rule_id\G *************************** 1. row *************************** rule_id: 88 advice: slave_io_thread_not_running.advice certified: command: slave_io_thread_not_running.command default_frequency: 60000 description: slave_io_thread_not_running.description dirty: expression: (%Slave_IO_Running% != THRESHOLD) info: slave_io_thread_not_running.info name: slave_io_thread_not_running.name uuid: fdff2f3a-9114-4b79-a266-200d489f03ab version: 1.5 threshold_id: 148 level: CRITICAL value: "Yes" variable: THRESHOLD rule_id: 88 *************************** 2. row *************************** rule_id: 92 advice: slave_sql_thread_not_running.advice certified: command: slave_sql_thread_not_running.command default_frequency: 60000 description: slave_sql_thread_not_running.description dirty: expression: (%Slave_SQL_Running% != THRESHOLD) info: slave_sql_thread_not_running.info name: slave_sql_thread_not_running.name uuid: 7a02ebe8-8b36-4ddc-86e1-c296a04b60fc version: 1.4 threshold_id: 154 level: CRITICAL value: "Yes" variable: THRESHOLD rule_id: 92 2 rows in set (0.00 sec) [After Modification] 1st and 3rd rules are meaningless alert. service_manager@localhost [mem]> select * from rules,rule_thresholds where rules.name like 'slave_%_running.name' and rules.rule_id = rule_thresholds.rule_id\G *************************** 1. row *************************** rule_id: 88 advice: slave_io_thread_not_running.advice certified: command: slave_io_thread_not_running.command default_frequency: 120000 description: slave_io_thread_not_running.description dirty: expression: (%Slave_IO_Running% != THRESHOLD) info: slave_io_thread_not_running.info name: slave_io_thread_not_running.name uuid: fdff2f3a-9114-4b79-a266-200d489f03ab version: 1.5 threshold_id: 210 level: INFO value: variable: THRESHOLD rule_id: 88 *************************** 2. row *************************** rule_id: 88 advice: slave_io_thread_not_running.advice certified: command: slave_io_thread_not_running.command default_frequency: 120000 description: slave_io_thread_not_running.description dirty: expression: (%Slave_IO_Running% != THRESHOLD) info: slave_io_thread_not_running.info name: slave_io_thread_not_running.name uuid: fdff2f3a-9114-4b79-a266-200d489f03ab version: 1.5 threshold_id: 211 level: CRITICAL value: "Yes" variable: THRESHOLD rule_id: 88 *************************** 3. row *************************** rule_id: 88 advice: slave_io_thread_not_running.advice certified: command: slave_io_thread_not_running.command default_frequency: 120000 description: slave_io_thread_not_running.description dirty: expression: (%Slave_IO_Running% != THRESHOLD) info: slave_io_thread_not_running.info name: slave_io_thread_not_running.name uuid: fdff2f3a-9114-4b79-a266-200d489f03ab version: 1.5 threshold_id: 212 level: WARNING value: variable: THRESHOLD rule_id: 88 *************************** 4. row *************************** rule_id: 92 advice: slave_sql_thread_not_running.advice certified: command: slave_sql_thread_not_running.command default_frequency: 60000 description: slave_sql_thread_not_running.description dirty: expression: (%Slave_SQL_Running% != THRESHOLD) info: slave_sql_thread_not_running.info name: slave_sql_thread_not_running.name uuid: 7a02ebe8-8b36-4ddc-86e1-c296a04b60fc version: 1.4 threshold_id: 154 level: CRITICAL value: "Yes" variable: THRESHOLD rule_id: 92 4 rows in set (0.00 sec) Suggested fix: [Workaround] N/A [Suggested fix] Don't make meaningless altert when saving.