Search before asking
Motivation
When running on TiDB, the primary key of t_ds_alert using default AUTO_INCREMENT is not globally monotonically increasing.
Our incremental consumer loads alerts by filtering id > last_max_id. Some later inserted alert rows get smaller IDs and will never be consumed, which leads to lost task failure alerts.
Design Detail
To mitigate this risk, we propose adding a fallback check: scan records created in the last 10 minutes with alert_status = 0 as supplementary data retrieval.
Compatibility, Deprecation, and Migration Plan
No response
Test Plan
No response
Code of Conduct
Search before asking
Motivation
When running on TiDB, the primary key of t_ds_alert using default AUTO_INCREMENT is not globally monotonically increasing.
Our incremental consumer loads alerts by filtering id > last_max_id. Some later inserted alert rows get smaller IDs and will never be consumed, which leads to lost task failure alerts.
Design Detail
To mitigate this risk, we propose adding a fallback check: scan records created in the last 10 minutes with alert_status = 0 as supplementary data retrieval.
Compatibility, Deprecation, and Migration Plan
No response
Test Plan
No response
Code of Conduct