[GitHub] [airflow] coolacid commented on issue #16271: Celery Executor Dangling MySQL Connection

[GitBox <gi...@apache.org>]

coolacid commented on issue #16271:
URL: https://github.com/apache/airflow/issues/16271#issuecomment-854864127


   If I remove the `register_pre_exec_callback(default_action_log)` from `utils.cli_action_loggers` I no longer have the dangling open connection. 
   
   ```
   af_worker    | [2021-06-04 16:27:44,517: DEBUG/MainProcess] Disposing DB connection pool (PID 6)
   af_worker    | [2021-06-04 16:27:44,518: WARNING/MainProcess] Pool size: 5  Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0
   ```
   However, I still get `Got an error reading communication packets`.
   
   ```
   mysql_1      | 2021-06-04T16:35:55.204039Z 3213 [Note] Got an error reading communication packets
   mysql_1      | 2021-06-04T16:35:55.264724Z 3214 [Note] Got an error reading communication packets
   ```
   Enabling the query log again, and checking for those connection IDs show no actual queries. 
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org