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

  • 2 months 2 weeks 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

  • 2 months 2 weeks 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:

  • 2 months 2 weeks 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:

  • 2 months 3 weeks 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.

  • 2 months 3 weeks ago
    InvalidArgumentException: The controller for URI "/admin/flush" is not callable.

    admin_toolbar 3.5.2 is the reason. Patch coming ...

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

    Drupal 10.4:

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

    Tools & Settings >> Security Policy :

     Allow only secure FTPS connections 

  • 5 months 1 week ago
    MariaDB Server Performance Optimieren

     

    /usr/sbin/mariadbd --help --verbose | grep "query.*size"
  • 5 months 1 week ago
    MariaDB Server Performance Optimieren

    Commandline:

    systemctl restart mariadb
  • 5 months 1 week ago
    MariaDB Server Performance Optimieren

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