Re: MySQL server has gone away

Mahmood N <[email protected]>
Newsgroups gmane.comp.db.mysql.general
Message-ID <[email protected]>
Thanks for the quick reply. So, how can I get further information? 

Thing is that, after 5 minutes, when I refresh the page every thing is normal.
 Regards,
Mahmood 

    On Monday, April 3, 2017 3:39 PM, Ken D'Ambrosio <[email protected]> wrote:
 

 Basically, it says that MySQL is not responding to queries. So it likely has died, or perhaps is mis-configured.

On April 3, 2017 7:07:25 AM EDT, Mahmood N <[email protected]> wrote:
Hi,I am using Moodle which itself uses SQL for the database. Problem is that, when I run the email plugin and execute the command, the refresh time of the page becomes high (in the order of 3-5 minutes) and at the end, I see this message
Debug info: MySQL server has gone away
SELECT id, sid, state, userid, lastip, timecreated, timemodified FROM mdl_sessions WHERE sid = ?
[array (
 0 => 'jqfbgd5b0q6e2l81bb5gb87mn3',
)]
Error code: dmlreadexceptionStack trace:    
   - line 479 of /lib/dml/moodle_database.php: dml_read_exception thrown
   - line 1175 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
   - line 1551 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
   - line 1523 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
   - line 1502 of /lib/dml/moodle_database.php: call to moodle_database->get_record_select()
   - line 286 of /lib/classes/session/manager.php: call to moodle_database->get_record()
   - line 82 of /lib/classes/session/manager.php: call to core\session\manager::initialise_user_session()
   - line 785 of /lib/setup.php: call to core\session\manager::start()
   - line 27 of /config.php: call to require_once()
   - line 30 of /index.php: call to require_once()


Although it looks like a bug in Moodle, but the guys said it is a MySQL issue. I am confused about that. If you have any idea please let me know. What does this error say exactly?

 Regards,
Mahmood

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.