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

  • 3 weeks 4 days ago
    TypeError: Cannot assign null to property Drupal \ views \ Plugin \ views \ argument \ ArgumentPluginBase::$operator of type string

    Das geht auch:

          $this->operator = $break->operator ?? '' ;
  • 1 month 1 week ago
    Bootstrap 5 subtheme is not properly configured. This may be caused by a problem with file or directory permissions.
  • 3 weeks 4 days ago
    TypeError: Cannot assign null to property Drupal \ views \ Plugin \ views \ argument \ ArgumentPluginBase::$operator of type string

    It works too:

    • web/core/modules/views/src/Plugin/views/argument/NumericArgument.php 

    Line 63, 96 :

  • 1 month 2 weeks ago
    Site URI : http://default (Drupal, how2 update config?)

    Add this line to drupalroot/vendor/drush/drush/drush.yml

  • 2 months 3 weeks ago
    Webserver CPU Performance Test mit PHP

    Time: 0,19 

    CPU: AMD Ryzen 7 PRO 3700 8-Core Processor

  • 4 months 1 week ago
    TypeError: Cannot assign null to property Drupal \ views \ Plugin \ views \ argument \ ArgumentPluginBase::$operator of type string

    Line 63, 99 :

  • 5 months 1 week ago
    Drupal + Basic_Auth Problem : You do not have permission to access this page (Sie haben keine Zugriffsberechtigung für diese Seite. )

    My problem was:

  • 5 months 1 week ago
    Drupal Upgrade (Drupal 9 » Drupal 10)

    I had this exact issue and your site was the only place I found the fix.

    It'd be nice if the module developer applied your fix though.

    Good work! Much appreciated!

  • 6 months 1 week ago
    The datasource with ID 'elstut--entity:node' could not be retrieved for index (Drupal, Solr)

    Hier ist die Lösung. (/admin/config/search/search-api/server/solr_server/edit)

    Multisite-Kompatibilität
     + Nur Ergebnisse von dieser Seite beziehen
     

  • 6 months 1 week ago
    PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock

     

    Ich bekomme diese Fehlermeldung: