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

  • 1 week 6 days ago
    How to Renew Let’s Encrypt SSL Certificate on Plesk via Ubuntu Shell

    Let’s Encrypt will only accept a wildcard via DNS challenge. 

    If your Plesk instance can’t create the _acme-challenge.example.com TXT (external DNS), the extension can’t complete validation and will show no success. 

  • 2 weeks 6 days ago
    Warning: Undefined array key "url" in Drupal\Core\Asset\CssCollectionOptimizerLazy->optimizeGroup()
    Warning: Undefined array key "url" in Drupal\Core\Asset\JsCollectionOptimizerLazy->optimizeGroup() 
  • 3 weeks 1 day ago
    Server install & config : Debian 12 + Plesk + Apache + nginx + MariaDB + Solr
    sudo timedatectl set-timezone Europe/Berlin
  • 4 weeks 1 day ago
    Warning: PHP Startup: Unable to load dynamic library 'apcu.so' ... cannot open shared object file: No such file or directory

    Try this:

  • 1 month 1 week ago
    List Cronjobs for all users (via for + crontab)

    Alternative (without warnings like "no crontab for dovecot") to see all tasks:

  • 1 month 1 week ago
    Install APCu (PHP 8.1, Plesk)

    php 8.3 apcu failed

    über Plesk hat es geklappt.

     

  • 1 month 1 week ago
    Install APCu (PHP 8.1, Plesk)

     

    install:

    # sudo apt install php-dev
    
  • 1 month 1 week ago
    pecl install apcu : phpize: not found / ERROR: `phpize' failed

    phpize

    # sudo apt install php-dev
    

     

    details

  • 1 month 1 week ago
    Install APCu (PHP 8.1, Plesk)

    Problem:

  • 2 months 4 weeks ago
    Install APCu (PHP 8.1, Plesk)

    Problem: