Moodle

Moodle locks the mysql database after some student/guest insertion on courses which belong to a meta-course

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: 1.9.2
  • Fix Version/s: None
  • Component/s: Database SQL/XMLDB, Performance
  • Labels:
    None
  • Environment:
    2 server Linux ubuntu (kernel image 2.6.20-16-server) : application with 4 Xeon E5345 processors, RAM 5.8GB; database with 4 Xeon E5345 processors, RAM 4.0 GB.
  • Database:
    MySQL
  • Affected Branches:
    MOODLE_19_STABLE

Description

The moodle locks after a few insertions of students / visitors in a course which is linked to a meta-course. One of the database server processor is fully occupied and no other request for database is treated. It is as if there was a LOCK command in the database without answer.

From mytop application, it's possible to see the following query:
SELECT COUNT(DISTINCT prs.userid) FROM (SELECT ra.userid, ra.roleid AS primary_roleid, ....

It's attached the screen from htop.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Dan Poltawski added a comment -

Hi Nivaldo, could you give any more details about the query in question?

Entry in slow query log or full details for the query?

I can't find the query you reffer to when searching the moodle codebase.

Show
Dan Poltawski added a comment - Hi Nivaldo, could you give any more details about the query in question? Entry in slow query log or full details for the query? I can't find the query you reffer to when searching the moodle codebase.
Hide
Permalink
D P added a comment -

Maybe I can second that:

MDL-16955

Show
D P added a comment - Maybe I can second that: MDL-16955
Hide
Permalink
Nivaldo A. P. de Vasconcelos added a comment -

Hi Dan,

I have no idea about that query. After turn off the statistics module the did not happens more.
That query seems built on processing. I will check where I found the code closest on moodle codebase and post here.

Best regards,
Nivaldo

Show
Nivaldo A. P. de Vasconcelos added a comment - Hi Dan, I have no idea about that query. After turn off the statistics module the did not happens more. That query seems built on processing. I will check where I found the code closest on moodle codebase and post here. Best regards, Nivaldo
Hide
Permalink
Michael de Raadt added a comment -

Thanks for reporting this issue.

We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported.

If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.

Michael d;

lqjjLKA0p6

Show
Michael de Raadt added a comment - Thanks for reporting this issue. We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported. If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed. Michael d; lqjjLKA0p6
Hide
Permalink
Michael de Raadt added a comment -

I'm closing this issue as it appears to have become inactive and is probably not relevant to a current supported version. If you are encountering this problem or one similar, please launch a new issue.

Show
Michael de Raadt added a comment - I'm closing this issue as it appears to have become inactive and is probably not relevant to a current supported version. If you are encountering this problem or one similar, please launch a new issue.

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.