Change Details

Are long/slow queries being killed correctly (and logged) on XTools servers?

Are long/slow queries being killed correctly (and logged) on XTools servers? Errors such as the following ("MySQL server has gone away") are being raised regularly, perhaps because the MySQL server is killing queries rather than them being killed by the [[ https://wikitech.wikimedia.org/wiki/Tool:XTools#Killing_slow_queries | script ]]. > [2017-07-20 22:27:35] request.CRITICAL: Exception thrown when handling an exception (Twig_Error_Runtime: An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT lag FROM `heartbeat_p`.`heartbeat` h RIGHT JOIN `meta_p`.`wiki` w ON concat(h.shard, ".labsdb")=w.slice WHERE dbname LIKE :project OR name LIKE :project OR url LIKE :project LIMIT 1' with params ["enwiki"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away"). at /var/www/app/Resources/views/base.html.twig line 146) {"exception":"[object] (Twig_Error_Runtime(code: 0): An exception has been thrown during the rendering of a template (\"An exception occurred while executing 'SELECT lag FROM `heartbeat_p`.`heartbeat` h\n RIGHT JOIN `meta_p`.`wiki` w ON concat(h.shard, \".labsdb\")=w.slice\n WHERE dbname LIKE :project OR name LIKE :project OR url LIKE :project LIMIT 1' with params [\"enwiki\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\"). at /var/www/app/Resources/views/base.html.twig:146, Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'SELECT lag FROM `heartbeat_p`.`heartbeat` h\n RIGHT JOIN `meta_p`.`wiki` w ON concat(h.shard, \".labsdb\")=w.slice\n WHERE dbname LIKE :project OR name LIKE :project OR url LIKE :project LIMIT 1' with params [\"enwiki\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\\DBAL\\Driver\\PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []

Are long/slow queries being killed correctly (and logged) on XTools servers? Errors such as the following ("MySQL server has gone away") are being raised regularly, perhaps because the MySQL server is killing queries rather than them being killed by the [[ https://wikitech.wikimedia.org/wiki/Tool:XTools#Killing_slow_queries | script ]]. > [2017-07-20 22:27:35] request.CRITICAL: Exception thrown when handling an exception (Twig_Error_Runtime: An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT lag FROM `heartbeat_p`.`heartbeat` h RIGHT JOIN `meta_p`.`wiki` w ON concat(h.shard, ".labsdb")=w.slice WHERE dbname LIKE :project OR name LIKE :project OR url LIKE :project LIMIT 1' with params ["enwiki"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away"). at /var/www/app/Resources/views/base.html.twig line 146) {"exception":"[object] (Twig_Error_Runtime(code: 0): An exception has been thrown during the rendering of a template (\"An exception occurred while executing 'SELECT lag FROM `heartbeat_p`.`heartbeat` h\n RIGHT JOIN `meta_p`.`wiki` w ON concat(h.shard, \".labsdb\")=w.slice\n WHERE dbname LIKE :project OR name LIKE :project OR url LIKE :project LIMIT 1' with params [\"enwiki\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\"). at /var/www/app/Resources/views/base.html.twig:146, Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'SELECT lag FROM `heartbeat_p`.`heartbeat` h\n RIGHT JOIN `meta_p`.`wiki` w ON concat(h.shard, \".labsdb\")=w.slice\n WHERE dbname LIKE :project OR name LIKE :project OR url LIKE :project LIMIT 1' with params [\"enwiki\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\\DBAL\\Driver\\PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []