SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

Problem


# drush cr

In ExceptionHandler.php line 56:
                                                                                                                                                                                                                                                                                                                             
  SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; 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) 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] => last_write_timestamp_cache_config                                                                                                                                                                                                                                                        
      [:db_insert_placeholder_1] => -1                                                                                                                                                                                                                                                                                       
      [:db_insert_placeholder_2] => 1719743783.289                                                                                                                                                                                                                                                                           
      [:db_insert_placeholder_3] =>                                                                                                                                                                                                                                                                                          
      [:db_insert_placeholder_4] => 0                                                                                                                                                                                                                                                                                        
      [:db_insert_placeholder_5] => d:1719743783.29;                                                                                                                                                                                                                                                                         
      [:db_insert_placeholder_6] => 1                                                                                                                                                                                                                                                                                        
  )                                                                                                                                                                                                                                                                                                                          
                                                                                                                                                                                                                                                                                                                             

In StatementWrapperIterator.php line 113:
                                                                                               
  SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction  
                                                                                               

 

Solution?

 

 

Neuen Kommentar schreiben

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

Suche

Neueste Kommentare

  • 5 days ago
    Wget - Eine Webseite rekursive downloaden

    wget -U 'Mozilla/MyUserAgent' -P MyTempDir123 --wait=0.2 --random-wait -nd -r -x -l 4 -e robots=off --reject

  • 5 days ago
    Wget - Eine Webseite rekursive downloaden

    wget -U 'Mozilla/MyUserAgent2024' -P MyOutPutDirectory --wait=1 --random-wait -nd -r -l 2 -e robots=off --reject

  • 1 month ago
    CPU benchmarking with sysbench (single-threaded/all cores)

     

    # sysbench --threads="$(nproc)" cpu run

  • 1 month ago
    CPU benchmarking with sysbench (single-threaded/all cores)

    # sysbench --threads="$(nproc)" cpu run

  • 1 month ago
    Linux Autovervollständigung - bash autocomplete
    source ~/.bashrc

    Diese Lösung wird empfohlen aber hat bei mir nicht funktioniert.

    Welche Alternative gibt es?

  • 1 month ago
    PHP-CLI auf PHP8.2 umstellen (für Composer, Drush etc)

    ln -snf /opt/plesk/php/8.3/bin/php /etc/alternatives/php

  • 1 month 1 week ago
    Drush Update failed (require php >=8.2)

    In composer.json, update: 

     

  • 1 month 1 week ago
    Drupal: Anmeldung fehlgeschlagen Es hat mehr als 5 fehlerhafte Anmeldeversuche für dieses Benutzerkonto gegeben. Es ist vorübergehend gesperrt.
    drush sqlq "DELETE FROM flood"
  • 1 month 1 week ago
    Drupal SMTP + Gmail funktioniert nicht mehr (Passwort ist richtig); was ist die Lösung?
  • 1 month 1 week ago
    Failed to authenticate on SMTP server with username gmail.com using the following authenticators: "LOGIN", "PLAIN", "XOAUTH2". Authenticator "LOGIN" returned "Expected response code "235" but got code "535",

    Type    symfony_mailer
    Date    Mo, 28. 08 2024 - 10:14
    User    admin