Author Topic: Lost connection to MySQL server during query  (Read 3829 times)

Offline tofinoguy

  • Jr. Member
  • **
  • Posts: 30
Lost connection to MySQL server during query
« on: September 15, 2009, 01:58:55 PM »
Hello,

I've mentioned on other threads that I've been experiencing severe performance issues and random errors displayed. In general, roundcube continues to function and does not log the user off, however it would be great to be able to get down to the bottom of the issues. Looking into my error logs, I see that most of the errors are a result of "Lost connection to MySQL server during query". This has happened on a very regular basis (every few minutes or so) since I upgraded to 0.3-stable. Below are some examples. Any idea what could be causing these errors?

[15-Sep-2009 10:43:04 -0700]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_30145b2b42ca72111d587056a1490e834297cbeea FROM 'SELECT vars FROM session\n     WHERE  sess_id=?']
[Native code: 2013]
[Native message: Lost connection to MySQL server during query]
 in /nfs/c01/h09/mnt/2175/domains/wickinn.com/html/webmail/program/include/rcube_mdb2.php on line 269 (GET /webmail/?_task=mail&_action=check-recent&_t=1253036452985&_remote=1&_=1253036452985&_unlock=1)
[15-Sep-2009 10:43:27] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_34438ac12dd6aee5a2f1dbcb8468ba9506c2ecef3 FROM 'SELECT vars FROM session\n     WHERE  sess_id=?']
[Native code: 2013]
[Native message: Lost connection to MySQL server during query]

[15-Sep-2009 10:43:27 -0700]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_34438ac12dd6aee5a2f1dbcb8468ba9506c2ecef3 FROM 'SELECT vars FROM session\n     WHERE  sess_id=?']
[Native code: 2013]
[Native message: Lost connection to MySQL server during query]
 in /nfs/c01/h09/mnt/2175/domains/wickinn.com/html/webmail/program/include/rcube_mdb2.php on line 269 (GET /webmail/?_task=mail&_action=check-recent&_t=1253036512985&_remote=1&_=1253036512985&_unlock=1)
[15-Sep-2009 10:49:51] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_36f68f29be10720cf7def85fcd743d62480205b86 FROM 'SELECT vars FROM session\n     WHERE  sess_id=?']
[Native code: 2013]
[Native message: Lost connection to MySQL server during query]

[15-Sep-2009 10:49:51 -0700]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_36f68f29be10720cf7def85fcd743d62480205b86 FROM 'SELECT vars FROM session\n     WHERE  sess_id=?']
[Native code: 2013]
[Native message: Lost connection to MySQL server during query]
 in /nfs/c01/h09/mnt/2175/domains/wickinn.com/html/webmail/program/include/rcube_mdb2.php on line 269 (GET /webmail/?_task=mail)