@mattab opened this Issue on May 4th 2020 Member

In some cases, the DB can get stuck running SQL queries forever that won't complete or will take more than 1 day. This causes multiple issues downstream like blocking report processing delays, and also results in complicated to troubleshoot issues.

By using a Mysql-provided setting (MySQL 5.7+ provides max_execution_time variable), we can get all queries automatically killed if they take longer than X seconds. So if we set the value to say 8 hours, this would be a safe threshold as no query is expected to take longer than 1 hour or so...

@Findus23 commented on May 4th 2020 Member
@tsteur commented on May 4th 2020 Member

Closing as a duplicate

This Issue was closed on May 4th 2020
Powered by GitHub Issue Mirror