# HY000/2006 MySQL server has gone away **URL:** \ **Category:** Percona Server for MySQL 8.0\ **Created:** [August 11, 2024, 11:52am UTC](https://forums.percona.com/t/hy000-2006-mysql-server-has-gone-away/32209 "2024-08-11T11:52:10Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\ **Post date:** [August 11, 2024, 11:52am UTC](https://forums.percona.com/t/hy000-2006-mysql-server-has-gone-away/32209/1 "2024-08-11T11:52:10Z")
Hello, Since the upgrade to 8.0.37-29 (from 8.0.36-28) that I’m getting sporadic errors of “MySQL server has gone away”. I’m using Docker (`percona:8.0`) on an AlmaLinux 8, and PHP (8.2) connects through a `.sock` file on the Host, using `mysqli`. This is a busy website, and there are loads of connections and queries every second. These errors are happening ~5 to ~10 times a day, which is very little, but they weren’t happening on the previous version. I don’t seem to find any pattern on the queries where this is happening. Can be SELECTs, REPLACEs, etc… Any idea what could be causing this? Or any tips how I can debug this further to find the cause? Nothing has changed on my host, other than upgrading the Docker image. Many thanks! ---
**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\ **Post date:** [August 11, 2024, 6:41pm UTC](https://forums.percona.com/t/hy000-2006-mysql-server-has-gone-away/32209/2 "2024-08-11T18:41:23Z")
Hi @nunop, a random thought, is it OoM’ing? Can you post error log? Thanks, K ---
**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\ **Post date:** [August 11, 2024, 9:15pm UTC](https://forums.percona.com/t/hy000-2006-mysql-server-has-gone-away/32209/3 "2024-08-11T21:15:42Z")
Thank you for your reply! Nope - I’m very careful about that, constantly monitoring it, and it’s not the case here. (if you mean in relation to MySQL taking too much of the host’s RAM) In fact, I restarted the container soon after my post here, and minutes later, I got 2 more of these errors. If you mean the query taking too much RAM, I doubt too, as these failing are very simple and quick queries. I don’t have slow queries. (sometimes some do get logged to the slow log, but they’re well optimized and 99.99% of the times they run very instantly) * * * Thank you for the tip about looking at the error log. From what I see, when these errors happen, it’s because those queries have been waiting for 300 seconds already !! > 2024-08-11T09:59:35.141286Z 41573386 [Note] [MY-013730] [Server] ‘wait\_timeout’ period of 300 seconds was exceeded for `myuser`@`%`. The idle time since last command was too long. > 2024-08-11T09:59:35.141452Z 41573386 [Note] [MY-010914] [Server] Aborted connection 41573386 to db: ‘mydb’ user: ‘myuser’ host: ‘localhost’ (The client was disconnected by the server because of inactivity.). > > 2024-08-11T14:54:34.535522Z 366486 [Note] [MY-013730] [Server] ‘wait\_timeout’ period of 300 seconds was exceeded for `myuser`@`%`. The idle time since last command was too long. > 2024-08-11T14:54:34.535637Z 366486 [Note] [MY-010914] [Server] Aborted connection 366486 to db: ‘mydb’ user: ‘myuser’ host: ‘localhost’ (The client was disconnected by the server because of inactivity.). But I wonder why is this happening now. Has anything changed around this area, between the 2 versions? Or… anything changed regarding deadlocks/transactions ?? Many thanks! ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 12, 2024, 1:03pm UTC](https://forums.percona.com/t/hy000-2006-mysql-server-has-gone-away/32209/4 "2024-08-12T13:03:32Z")
Hey @nunop, You can ‘SET GLOBAL wait\_timeout=600’ to increase the timeout period. I would also `EXPLAIN` these queries and fix them to use proper indexing so they do not take as long to execute. ---
**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\ **Post date:** [August 12, 2024, 2:35pm UTC](https://forums.percona.com/t/hy000-2006-mysql-server-has-gone-away/32209/5 "2024-08-12T14:35:28Z")
Hi @matthewb Thank you very much for your reply. But that really shouldn’t be the solution, as these queries should run instantly (and they do, 99.99% of the time) !! The queries in question are well optimized - using proper indexes, and they’re simple queries. I have waaaay more complex & huge queries, and those run instantly, loads of times every second, and they’re not even the ones being affected by this issue I’m reporting. So, indexing/optimization is fine, and I’m well aware of those things 🙂 (I still do appreciate the tip!) There is something else causing this, and it was not happening before the update to the last version. Hence I was asking: > Has anything changed around this area, between the 2 versions? > Or… anything changed regarding deadlocks/transactions ? Many thanks again! ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 12, 2024, 4:16pm UTC](https://forums.percona.com/t/hy000-2006-mysql-server-has-gone-away/32209/6 "2024-08-12T16:16:06Z")
Looks like you have a simple idle connections issue. Have your code correctly disconnect/close the connection to MySQL before the 5m is over, otherwise MySQL will force close the connection to reclaim resources. You can view all the release notes here: [https://dev.mysql.com/doc/relnotes/mysql/8.0/en/](https://dev.mysql.com/doc/relnotes/mysql/8.0/en/) ---
**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\ **Post date:** [August 12, 2024, 7:29pm UTC](https://forums.percona.com/t/hy000-2006-mysql-server-has-gone-away/32209/7 "2024-08-12T19:29:38Z")
Thank you. Ok… I’ll assume then that the problem is not on MySQL. Maybe it’s the application/request (it’s PHP, btw) that may be taking too long somewhere, and then when it reaches that specific query, 5 minutes have passed. Could be a coincidence with the MySQL upgrade then. I’ll continue to investigate around those terms, so! At least it’s rare, but worrying! I appreciate your help 😊👍🏻 ---
**Author:** ![lalit.choudhary](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lalit.choudhary/32/51_2.png) [@lalit.choudhary](https://forums.percona.com/u/lalit.choudhary)\ **Post date:** [August 16, 2024, 5:02am UTC](https://forums.percona.com/t/hy000-2006-mysql-server-has-gone-away/32209/8 "2024-08-16T05:02:42Z")
@nunop Thank you for the update. You can also refer to the blog post below for possible setting configurations that might help avoid this issue in the future. > **[Diagnosing and Fixing "MySQL Server Has Gone Away" Messages](https://www.percona.com/blog/diagnosing-and-fixing-mysql-server-has-gone-away-messages/)** > > There are some cases when there could be a few possible reasons behind the error message "MySQL server has gone away". ---
**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\ **Post date:** [August 16, 2024, 9:12am UTC](https://forums.percona.com/t/hy000-2006-mysql-server-has-gone-away/32209/9 "2024-08-16T09:12:20Z")
Thank you very much. I have added some profiling, where for each query, it will take the `time()` before and after the query, and when this issue happens, it will dump all this info into the logs. This will tell me whether the problem is with some MySQL query taking a lot of time, or the PHP process taking a lot of time in between the queries. That’s the first step!! 🙂 Once I release this, and the “gone away” issue happens again, I’ll update here with the findings. Hopefully it will be something obvious, and I’ll fix right away. ---
**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\ **Post date:** [August 18, 2024, 7:44pm UTC](https://forums.percona.com/t/hy000-2006-mysql-server-has-gone-away/32209/10 "2024-08-18T19:44:13Z")
Alright… based on the profiling logs, it appears that the problem is in the PHP process hanging somewhere, and not the SQL queries taking that much time. Now I have to figure out what’s hanging in PHP !! This thread can be closed, then 🙂 Thank you, everyone, for your help!