On 4/3/2017 8:15 AM, Mahmood N wrote:
When I click on the submit button in Moodle and it is waiting for refresh, I 
execute the mysql command but the output is not meaningful

mahmood@ce:/var/www/html/courses$ mysql -u moodle -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 30912
Server version: 5.5.54-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show full processlist
     ->
     ->



Meanwhile using Webmin, I execute the same command for that user and see
  Output from SQL command show full processlist ..
| Id | User | Host | db | Command | Time | State | Info |
| 30912 | moodle | localhost |
  | Sleep | 42 |



I am not expert with MySQL, however as the Moodle admin I am trying to fix the 
problems.
Regards,
Mahmood


You need to consider a few possibilities,

a) Moodle didn't want to wait long enough for the query to complete (a Moodle Timeout) so it said "the server is not responding..."

b) Moodle sent MySQL a command that was "too large". To protect itself from abuse, all MySQL instances have a configurable limit about how "large" a command can be. If the command is larger than this limit, the server rejects it and closes the connection. (this could explain why the query you just attempted from Moodle is not visible in the list of executing commands)

c) Something is unstable in your MySQL instance. The MySQL Error Log may contain details explaining why mysqld was unable to stay running. The angel process mysqld_safe would try to restart the server automatically which could explain why Moodle was only unresponsive for a short while.

Additional resources:
https://dev.mysql.com/doc/refman/5.6/en/problems.html (in particular, review B.5.2)

--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN

Become certified in MySQL! Visit https://www.mysql.com/certification/ for details.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to