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
[SOLVED] Lost connection to MySQL server during query
Moderator: crythias
-
- Znuny newbie
- Posts: 4
- Joined: 31 Jan 2011, 16:06
- Znuny Version: 2.4
-
- Znuny ninja
- Posts: 1029
- Joined: 13 Apr 2009, 12:26
- Znuny Version: 6.0.13
- Real Name: Wolfgang Fürtbauer
- Company: PBS Logitek GmbH
- Location: Pinsdorf
Re: Lost connection to MySQL server during query
I had a similar problem with 2 reasons
- EXTREM CPU load
- damaged mysql table
- EXTREM CPU load
- damaged mysql table
Produktiv:
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
-
- Znuny expert
- Posts: 164
- Joined: 12 Feb 2016, 08:05
- Znuny Version: 5.0.0
- Real Name: ann
- Company: rghdinc
Re: Lost connection to MySQL server during query
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?
Re: Lost connection to MySQL server during query
Hi,
anything in the OTRS Support Assessment? Maybe it is a wrong package size.
Florian
anything in the OTRS Support Assessment? Maybe it is a wrong package size.
Florian
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Lost connection to MySQL server during query
How much RAM you linux box has? Sounds like the oom killer was there..
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny expert
- Posts: 164
- Joined: 12 Feb 2016, 08:05
- Znuny Version: 5.0.0
- Real Name: ann
- Company: rghdinc
Re: Lost connection to MySQL server during query
Hi Florian,wurzel wrote:Hi,
anything in the OTRS Support Assessment? Maybe it is a wrong package size.
Florian
Thanks for your reply, how will I know if it is in a wrong package size?
Hello root!root wrote:How much RAM you linux box has? Sounds like the oom killer was there..
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!
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Lost connection to MySQL server during query
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 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.
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny expert
- Posts: 164
- Joined: 12 Feb 2016, 08:05
- Znuny Version: 5.0.0
- Real Name: ann
- Company: rghdinc
[SOLVED] Re: Lost connection to MySQL server during query
Hi root!root wrote: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 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.
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!!