Load issue when high traffic

[dawb]

Hi,

We are experiencing that when put into production with high traffic loads that some pages are returning an error with empty objects for the Azure_blobcache.

Have you encountered this previously and know a work around? We're trying to work out if this is a codebase issue or a response time from Azure issue.

[Emergency] Uncaught SilverStripe\ORM\Connect\DatabaseException: Couldn't run query: UPDATE "Azure_BlobCache" SET "Contents" = ?, "LastEdited" = ? WHERE ("ID" = ?) Lock wait timeout exceeded; try restarting transaction
GET /new-website-page/
Line 64 in /var/www/vendor/silverstripe/framework/src/ORM/Connect/DBConnector.php

Source
55 if
(!empty($sql)) {
56 $formatter = new SQLFormatter();
57 $formattedSQL =
$formatter->formatPlain($sql);
58 $msg = "Couldn't run
query:\n\n{$formattedSQL}\n\n{$msg}";
59 }
60
61 if ($errorLevel === E_USER_ERROR) {
62 // Treating errors as exceptions better
allows for responding to errors
63 // in code, such as credential checking
during installation
64 throw new
DatabaseException($msg, 0, null, $sql, $parameters);
65 } else {
66 user_error($msg ?? '', $errorLevel ?? 0);
67 }
68 }
69
70 /**