[#MDL-18055] security overview report not working - Moodle Tracker

Details

Type: Sub-task
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: 1.9.3
Fix Version/s: 1.9.5
Component/s: Administration
Labels:
None
Environment:
WAMP
Apache 2.0.11 PHP 5.2.8 MySQL 5.0.74

Database:

MySQL
Affected Branches:
MOODLE_19_STABLE
Fixed Branches:
MOODLE_19_STABLE

Description

I try to run the security overview report on my server and it takes a very long time to run, with MySQL at 100% CPU utilitzation, then it finishes and displays nothing but the text "Security overview" on a white screen.

I see no errors in my Apache log.

Issue Links

This issue has a non-specific relationship to:
MDL-18040	slow loading and lack of progress indication

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Petr Škoda (skodak) added a comment - 28/Jan/09 12:08 AM

hello,
I have added a timeout protection to the security overview report, it should not timeout anymore. The problem is that it may take a lot of time to complete though - please see the linked bug.

thanks for the report.

Show

Petr Škoda (skodak) added a comment - 28/Jan/09 12:08 AM hello, I have added a timeout protection to the security overview report, it should not timeout anymore. The problem is that it may take a lot of time to complete though - please see the linked bug. thanks for the report.

Hide

Permalink

Ryan Smith added a comment - 28/Jan/09 1:05 AM

I updated my CVS and got the new file. It still runs for a long time and displays nothing. My max_execution_time in PHP is set really high so I don't think its timing out on the script. In MySQL, it is running the query:

SELECT COUNT( DISTINCT u.id )
FROM mdl_role_capabilities rc
JOIN mdl_capabilities cap

for a very long time.

Show

Ryan Smith added a comment - 28/Jan/09 1:05 AM I updated my CVS and got the new file. It still runs for a long time and displays nothing. My max_execution_time in PHP is set really high so I don't think its timing out on the script. In MySQL, it is running the query: SELECT COUNT( DISTINCT u.id ) FROM mdl_role_capabilities rc JOIN mdl_capabilities cap for a very long time.

Hide

Permalink

Petr Škoda (skodak) added a comment - 28/Jan/09 1:21 AM

yes, it may take a veeery long time to execute on large sites

Could you please say how many course/users/course categories you have on your site?
Is it a shared hosting site?

Show

Petr Škoda (skodak) added a comment - 28/Jan/09 1:21 AM yes, it may take a veeery long time to execute on large sites Could you please say how many course/users/course categories you have on your site? Is it a shared hosting site?

Hide

Permalink

Ryan Smith added a comment - 28/Jan/09 1:27 AM

We have:

1,468 courses
22,482 users
19 course categories

No, it isn't a shared hosting site.

Show

Ryan Smith added a comment - 28/Jan/09 1:27 AM We have: 1,468 courses 22,482 users 19 course categories No, it isn't a shared hosting site.

Hide

Permalink

Petr Škoda (skodak) added a comment - 28/Jan/09 1:53 AM

reopening the query involved may take a really long time, unfortunately the timeout in SQL code is hard to prevent

I was thinking about a way to divide the query into several parts, but so far failed to do so

Show

Petr Škoda (skodak) added a comment - 28/Jan/09 1:53 AM reopening the query involved may take a really long time, unfortunately the timeout in SQL code is hard to prevent I was thinking about a way to divide the query into several parts, but so far failed to do so

Hide

Permalink

Petr Škoda (skodak) added a comment - 29/Jan/09 7:54 AM

please see the linked bug, I hope the latest changes will improve the situation

Show

Petr Škoda (skodak) added a comment - 29/Jan/09 7:54 AM please see the linked bug, I hope the latest changes will improve the situation

Hide

Permalink

Ryan Smith added a comment - 29/Jan/09 10:31 AM

I added my comments to the linked bug. I'm still not getting the report to run successfully.

Show

Ryan Smith added a comment - 29/Jan/09 10:31 AM I added my comments to the linked bug. I'm still not getting the report to run successfully.

Hide

Permalink

Petr Škoda (skodak) added a comment - 02/Feb/09 10:17 PM

should be solved now, see the linked bug
thanks a lot

Show

Petr Škoda (skodak) added a comment - 02/Feb/09 10:17 PM should be solved now, see the linked bug

thanks a lot

Hide

Permalink

Ryan Smith added a comment - 02/Feb/09 11:46 PM

works now, thanks!

Show

Ryan Smith added a comment - 02/Feb/09 11:46 PM works now, thanks!

People

Assignee:

Petr Škoda (skodak)

Reporter:

Ryan Smith

Participants:

Petr Škoda (skodak), Ryan Smith

Vote (0)

Watch (0)

Dates

Created:

27/Jan/09 11:26 PM

Updated:

17/Dec/10 12:52 PM

Resolved:

02/Feb/09 10:17 PM