Наша задача сводки MySQL блокировала датчики, которые она должна была обрабатывать
DEV · 16.11.2026 · 01:25
В шестой части Devlog InfraGuard описываются проблемы с работой сводки, включая блокировку вставок датчиков и несоответствие между работой базы данных и временем жизни процессов.
Оригинал
Our MySQL rollup job blocked the sensors it was supposed to summarize
InfraGuard Engineering Devlog, part 6 of 6. On November 12, five commits went into InfraGuard's rollup worker. Retention cleanup was not completing, a drain path had replayed data, and the worker blocked sensor inserts. The common theme was a mismatch between database work and process lifetime. A minute-long process, a seven-minute workflow PM2 restarted the worker every minute. Database statements could outlive the client, while subsequent script steps never ran. One drain operat