GitHub user ajinp-dot added a comment to the discussion: FAB Provider - 'Server has gone away'
This looks like the classic “MySQL server has gone away” issue with Airflow, usually caused by stale or idle connections in the SQLAlchemy pool. Since it happens after a few hours, it’s likely MySQL (RDS) is closing idle connections (wait_timeout) and Airflow is trying to reuse them. Fix is to enable connection recycling and health checks, like setting sql_alchemy_pool_recycle to a value lower than MySQL timeout and sql_alchemy_pool_pre_ping = True so dead connections are refreshed automatically. Also double check RDS settings like wait_timeout and max_allowed_packet. This is more of a connection lifecycle issue than load or max connections. That said, in rare cases if the MySQL database itself is corrupted or tables become inaccessible, similar errors can show up. If you start seeing InnoDB errors in logs or queries failing inconsistently, you can try third party recovery tools like Stellar Repair for MySQL, helps to Repair and extract data from damaged tables. GitHub link: https://github.com/apache/airflow/discussions/63718#discussioncomment-16186924 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
