ERROR ReadTopologyInstance: ReplicationLagQuery: sql: no rows in result set

[HBO2]

@AMecea

I see some errors in the orchestrator log files. Everything seems to be working ok, but still it's an Error, right?

[martini] Completed 200 OK in 902.204µs
[martini] Started GET /api/audit-recovery/prodain.default for 10.1.1.151:37904
[martini] Completed 200 OK in 2.15601ms
[martini] Started GET /api/cluster/devain.default for 10.1.1.151:37904
[martini] Completed 200 OK in 4.074418ms
[martini] Started GET /api/maintenance for 10.1.1.151:37904
[martini] Completed 200 OK in 831.604µs
[martini] Started GET /api/audit-recovery/devain.default for 10.1.1.151:37904
[martini] Completed 200 OK in 2.14341ms
2018-12-01 11:56:05 ERROR ReadTopologyInstance(devain-mysql-0.devain-mysql-nodes.default:3306) ReplicationLagQuery: sql: no rows in result set
[martini] Started GET /api/cluster/prodain.default for 10.1.1.151:37904
[martini] Completed 200 OK in 3.742317ms
[martini] Started GET /api/maintenance for 10.1.1.151:37904
[martini] Completed 200 OK in 766.804µs
[martini] Started GET /api/audit-recovery/prodain.default for 10.1.1.151:37904
[martini] Completed 200 OK in 8.255337ms
[martini] Started GET /api/cluster/devain.default for 10.1.1.151:37904
[martini] Completed 200 OK in 2.967213ms
[martini] Started GET /api/maintenance for 10.1.1.151:37904
[martini] Completed 200 OK in 1.184805ms
[martini] Started GET /api/audit-recovery/devain.default for 10.1.1.151:37904
[martini] Completed 200 OK in 1.744307ms
[martini] Started GET /api/raft-follower-health-report/e30d7211/ain-mysql-operator-orchestrator-0.ain-mysql-operator-orchestrator-headless/ain-mysql-operator-orchestrator-0.ain-mysql-operator-orchestrator-headless for 10.1.1.144:34906
[martini] Completed 200 OK in 1.030305ms
[martini] Started GET /api/lb-check for 10.1.1.81:33952
[martini] Completed 200 OK in 1.174005ms
[martini] Started GET /api/raft-health for 10.1.1.81:33974
[martini] Completed 200 OK in 743.204µs

[AMecea]

This is because of how the lag query is composed, specified here.

A possible fix is to remove the WHERE clauses.