2006 MySQL server has gone away on Group module check

Created on 3 September 2021, about 3 years ago
Updated 20 February 2023, almost 2 years ago

Problem/Motivation

While running on the project, always on group module the scan fails with the following error:

In Connection.php line 701:
                                                                                                    
  SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 AS expression           
  FROM                                                                                              
  {key_value} key_value                                                                             
  WHERE (name = :db_condition_placeholder_0) AND (collection = :db_condition_placeholder_1); Array  
  (                                                                                                 
      [:db_condition_placeholder_0] => group                                                        
      [:db_condition_placeholder_1] => upgrade_status_scan_results                                  
  )                                                                                                 
                                                                                                    

In Statement.php line 59:
                                                                   
  SQLSTATE[HY000]: General error: 2006 MySQL server has gone away  

Steps to reproduce

Run scan from console while Group module is installed.

Proposed resolution

n/a

Remaining tasks

n/a

User interface changes

n/a

API changes

n/a

Data model changes

n/a

πŸ› Bug report
Status

Active

Version

3.10

Component

Code

Created by

πŸ‡§πŸ‡ͺBelgium golddragon007

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡«πŸ‡·France judapriest Grenoble

    Currently on the same issue with 4.0@alpha.

    In ExceptionHandler.php line 53:
                                                                                   
      SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 A  
      S "expression"                                                               
      FROM                                                                         
      "key_value" "key_value"                                                      
      WHERE ("name" = :db_condition_placeholder_0) AND ("collection" = :db_condit  
      ion_placeholder_1); Array                                                    
      (                                                                            
          [:db_condition_placeholder_0] => group                                   
          [:db_condition_placeholder_1] => upgrade_status_scan_results             
      )                                                                            
                                                                                   
    In StatementWrapper.php line 145:
                                                                       
      SQLSTATE[HY000]: General error: 2006 MySQL server has gone away  

    Here the SQL :

    SELECT * FROM `key_value` WHERE `collection` LIKE '%upgrade_status_scan_results%' ORDER BY `key_value`.`name` ASC

    But theres is no line for group. It seems, it did not create any entry in the key_value table for the module group.

  • πŸ‡«πŸ‡·France judapriest Grenoble
  • πŸ‡«πŸ‡·France judapriest Grenoble

    In the backoffice, the module is marked as compatible

    Before scan

    If trying to scan it from the backoffice
    We also have a timeout.
    But a problem have appear :
    after scan

    Probleme

    Do you have any idea ?

  • πŸ‡­πŸ‡ΊHungary GΓ‘bor Hojtsy Hungary

    While I understand the timeout on this scanning result is not good I think its an underlying problem in how phpstan interacts with something in group's code. On the other hand, given that both branches highlighted of the project are Drupal 10 compatible, I don't know what else would you do with any scanning result? I would take the info that it is compatible and sleep well for this upgrade? :)

Production build 0.71.5 2024