PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock 

PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in [error] httpdocs/core/lib/Drupal/Core/Database/Statement.php:59 Stack trace:

Wieso bekomme ich diesen Fehler, wenn ich mit Drush Cache leeren möchte? (drush cr)

 

 

Comments

Profile picture for user Guest

Di, 01/09/2024 - 16:53

 

Ich bekomme diese Fehlermeldung:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO "cache_config" ("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), ...

Woran liegt es, bzw. was ist die Lösung?

 

 

Profile picture for user Guest

So, 01/26/2025 - 13:24

Drupal 10.4:

Drupal\Core\Database\DatabaseExceptionWrapper: Exception in MyCustomView2025 [mycustomview2025 ]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO "cache_entity" ...

Neuen Kommentar schreiben

Hilfe zum Textformat
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.

Suche

Neueste Kommentare

  • Same with Drush 13 + PHP 8.3 and my Solution

    2 months ago
    [preflight] The following restricted PHP modes have non-empty values: {open_basedir}. This configuration is incompatible with drush.

    Same with Drush 13 + PHP 8.3

  • Error : Failed to install the required package 'RPM' by using AP

    2 months 1 week ago
    Acronis CyberProtect Agent For Linux (Strato Root Server)

    Initializing...

    Error : Failed to install the required package 'RPM' by using APT. Please install it manually. 

    Exit

    Solution:

  • Installieren & Aktivieren

    2 months 1 week ago
    Acronis CyberProtect Agent For Linux (Strato Root Server)

    So habe es installiert und dann mit Hilfe von Key/Code (über Website von Acronis Cyber Protect) aktiviert:

  • I have a view with a path…

    2 months 1 week ago
    No route found for the specified format html. Supported formats: csv, json. (Drupal Routing)

    I have a view with a path like

    /my-content-export
    to export entivies as JSON or CSV.

  • admin_toolbar 3.5.2 is the…

    2 months 1 week ago
    InvalidArgumentException: The controller for URI "/admin/flush" is not callable.

    admin_toolbar 3.5.2 is the reason. Patch coming ...

  • Drupal 10.4, in a custom View

    1 month ago
    PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock

    Drupal 10.4:

  • Tools & Settings >> Security…

    3 months 1 week ago
    Server install & config : Debian 12 + Plesk + Apache + nginx + MariaDB + Solr

    Tools & Settings >> Security Policy :

     Allow only secure FTPS connections 

  • List config vaiables

    4 months 3 weeks ago
    MariaDB Server Performance Optimieren

     

    /usr/sbin/mariadbd --help --verbose | grep "query.*size"

  • Restart MariaDB / MySQL

    4 months 3 weeks ago
    MariaDB Server Performance Optimieren

    Commandline:

    systemctl restart mariadb

  • MariaDB Restart (after changes in /etc/mysql/db-performance.cnf)

    4 months 3 weeks ago
    MariaDB Server Performance Optimieren

    After my changes in /etc/mysql/db-performance.cnf