[SOLVED] Lost connection to MySQL server during query

rbreidenstein · Post by **rbreidenstein** » 28 Feb 2011, 16:36

Lost connection to MySQL server during query, SQL: 'UPDATE sessions SET session_value = ? WHERE session_id = ?

The above error is being displayed on the server. I am not sure what maybe causing it at this point because the server obviously has connectivity to the SQL server as the ticketing system is functioning. Does anyone have any ideas on how I can resolve this error or obtain more detailed information on what is causing this error to be logged?

Thanks,

Rick

Wolfgangf · Post by **Wolfgangf** » 28 Feb 2011, 20:28

I had a similar problem with 2 reasons
- EXTREM CPU load
- damaged mysql table

gecelann · Post by **gecelann** » 11 Jan 2017, 07:42

Wolfgangf wrote:I had a similar problem with 2 reasons
- EXTREM CPU load
- damaged mysql table

Hi wolfgangf,

How did you fixed the issue regarding the lost connection in MySQL?

wurzel · Post by **wurzel** » 11 Jan 2017, 11:21

Hi,

anything in the OTRS Support Assessment? Maybe it is a wrong package size.

Florian

Post by **root** » 11 Jan 2017, 11:40

How much RAM you linux box has? Sounds like the oom killer was there..

gecelann · Post by **gecelann** » 12 Jan 2017, 03:43

wurzel wrote:Hi,

anything in the OTRS Support Assessment? Maybe it is a wrong package size.

Florian

Hi Florian,

Thanks for your reply, how will I know if it is in a wrong package size?

root wrote:How much RAM you linux box has? Sounds like the oom killer was there..

Hello root!

I use the script grep -i kill /var/log/messages* in ssh.
and this is the result that I've found, please see the screenshot.
Can you please teach me how to fix it.
Because our current OTRS 5 is performing too slow and I guess it is connected to this issue.
Thank you!

Selection_118.png

Selection_117.png

Post by **root** » 12 Jan 2017, 08:30

gecelann wrote: Can you please teach me how to fix it.
Because our current OTRS 5 is performing too slow and I guess it is connected to this issue.

Add more RAM and check your MySQL configuration. If you like to proof that database as a performance issues enable the slow query log.

gecelann · Post by **gecelann** » 12 Jan 2017, 10:07

root wrote:
gecelann wrote: Can you please teach me how to fix it.
Because our current OTRS 5 is performing too slow and I guess it is connected to this issue.
Add more RAM and check your MySQL configuration. If you like to proof that database as a performance issues enable the slow query log.

Hi root!

Thank you so much! One of my boss upgraded RAM in our server and it is working perfectly fine.
Tho we still need to monitor the system. Thank you!!

Znuny and ((OTRS)) Community Edition

[SOLVED] Lost connection to MySQL server during query

[SOLVED] Lost connection to MySQL server during query

Re: Lost connection to MySQL server during query

Re: Lost connection to MySQL server during query

Re: Lost connection to MySQL server during query

Re: Lost connection to MySQL server during query

Re: Lost connection to MySQL server during query

Re: Lost connection to MySQL server during query

[SOLVED] Re: Lost connection to MySQL server during query