Problem/Motivation
If certain conditions coincide, such as high load and the absence of certain keys in the cache, the site may break. The CSP module checks the cache on every request and tries to add a key if one is missing. If the cache_default table is in use, the query waits until the lock is released before it can be executed again. Under high load, the cache does not have time to be created and a new request to add an entry to the database is added to the waiting queue.
NOTICE: PHP message: Uncaught PHP Exception Drupal\Core\Database\DatabaseExceptionWrapper: "SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: INSERT INTO "cache_default" ("cid", "expire", "created", "tags", "checksum", "data", "serialized") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6) ON DUPLICATE KEY UPDATE "cid" = VALUES("cid"), "expire" = VALUES("expire"), "created" = VALUES("created"), "tags" = VALUES("tags"), "checksum" = VALUES("checksum"), "data" = VALUES("data"), "serialized" = VALUES("serialized"); Array
(
[:db_insert_placeholder_0] => csp:libraries:core
[:db_insert_placeholder_1] => -1
[:db_insert_placeholder_2] => 1706876727.955
[:db_insert_placeholder_3] => library_info
[:db_insert_placeholder_4] => 1022
[:db_insert_placeholder_5] => a:61:{s:8:"backbone";a:0:{}s:17:"internal.backbone";a:0:{}s:8:"ckeditor";a:0:{}s:9:"ckeditor5";a:0:{}s:23:"ckeditor5.editorClassic";a:0:{}s:25:"ckeditor5.editorDecoupled";a:0:{}s:20:"ckeditor5.essentials";a:0:{}s:17:"ckeditor5.heading";a:0:{}s:15:"ckeditor5.basic";a:0:{}s:27:"ckeditor5.specialCharacters";a:0:{}s:20:"ckeditor5.blockquote";a:0:{}s:15:"ckeditor5.image";a:0:{}s:14:"ckeditor5.link";a:0:{}s:14:"ckeditor5.list";a:0:{}s:24:"ckeditor5.horizontalLine";a:0:{}s:21:"ckeditor5.htmlSupport";a:0:{}s:19:"ckeditor5.alignment";a:0:{}s:22:"ckeditor5.removeFormat";a:0:{}s:25:"ckeditor5.pasteFromOffice";a:0:{}s:16:"ckeditor5.indent";a:0:{}s:23:"ckeditor5.sourceEditing";a:0:{}s:15:"ckeditor5.table";a:0:{}s:18:"ckeditor5.language";a:0:{}s:19:"ckeditor5.codeBlock";a:0:{}s:15:"ckeditor5.style";a:0:{}s:22:"ckeditor5.translations";a:0:{}s:10:"css.escape";a:0:{}s:6:"drupal";a:0:{}s:14:"drupalSettings";a:0:{}s:18:"drupal.active-link";a:0:{}s:11:"drupal.ajax";a:0:{}s:15:"drupal.announce";a:0:{}s:6:"loadjs";a:0:{}s:19:"drupal.autocomplete";a:0:{}s:17:"drupal.array.find";a:0:{}s:21:"drupal.array.includes";a:0:{}s:12:"drupal.batch";a:0:{}s:15:"drupal.checkbox";a:0:{}s:15:"drupal.collapse";a:0:{}s:18:"drupal.customevent";a:0:{}s:11:"drupal.date";a:0:{}s:15:"drupal.debounce";a:0:{}s:13:"drupal.dialog";a:0:{}s:18:"drupal.dialog.ajax";a:0:{}s:15:"drupal.displace";a:0:{}s:17:"drupal.dropbutton";a:0:{}s:22:"drupal.element.closest";a:0:{}s:22:"drupal.element.matches";a:0:{}s:18:"drupal.entity-form";a:0:{}s:11:"drupal.form";a:0:{}s:19:"drupal.machine-name";a:0:{}s:14:"drupal.message";a:0:{}s:23:"drupal.nodelist.foreach";a:0:{}s:20:"drupal.object.assign";a:0:{}s:15:"drupal.progress";a:0:{}s:13:"drupal.states";a:0:{}s:22:"drupal.string.includes";a:0:{}s:21:"drupal.tabbingmanager";a:0:{}s:16:"drupal.tabledrag";a:0:{}s:18:"drupal.tableheader";a:0:{}s:22:"drupal.tableresponsive";a:0:{}}
[:db_insert_placeholder_6] => 1
)
" at /var/www/html/web/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php line 53
Steps to reproduce
- Enable and configure CSP module
- Generate generate load on the site (10 rpc is enough)
- Regenerate cache (drush cr)
Proposed resolution
Implement hook_rebuild() to warm empty cache values for library info.
Remaining tasks
User interface changes
API changes
Data model changes