Moodle

performance issue on oracle system

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Critical Critical
  • Resolution: Won't Fix
  • Affects Version/s: 1.9.2
  • Fix Version/s: None
  • Component/s: Database SQL/XMLDB
  • Labels:
    None
  • Environment:
    oracle 10.2.0.1.0
    Solaris Coolstack
  • Database:
    Oracle
  • Affected Branches:
    MOODLE_19_STABLE

Description

we use OCI8 1.2.5 (pecl), because of the curso leak problems in 1.2.4

BUT we have performance problems, maybe the problem with the cursor leaks again in version 1.2.5.....?!
suddenly the 4/5 normal sessions (60 users in one minute in moodle) on the database server expand to 700...and we have to start it up again...after half an hour...the webserver processes also rise to this levels...
when we restart the database, everything wents back to normal...

is there anything we can do?
maybe set a timetolive somewhere?
downgrade to oci8 1.2.3?

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
D P added a comment -

have downgraded to oci8 1.2.3, but the problems stay...

another oddity:
cron.php always hangs at deleting the old logs...
in cron.php at:
if (delete_records_select("log", "time < '$loglifetime'")) {

maybe something with the logs...?! (we now have logs for ~15 days due to the fact, that we can't delete them (with cron))

Show
D P added a comment - have downgraded to oci8 1.2.3, but the problems stay... another oddity: cron.php always hangs at deleting the old logs... in cron.php at: if (delete_records_select("log", "time < '$loglifetime'")) { maybe something with the logs...?! (we now have logs for ~15 days due to the fact, that we can't delete them (with cron))
Hide
Permalink
D P added a comment -

? MDL-15947
someone did that on our server, too...

crossesfingers

Show
D P added a comment - ? MDL-15947 someone did that on our server, too... crossesfingers
Hide
Permalink
D P added a comment -

Looks ok, after changing config-table-clob to varchar2(4000) (http://moodle.org/mod/forum/discuss.php?d=87509#p389413)

What about the cache_text-table-clob? Should we do the same?
Do we have to change it back, when we want to update to a new moodle version?

Is there someone who reads this?! Where do I have to post this to get someone to read this?
(Or does no one use oracle and moodle?)

Show
D P added a comment - Looks ok, after changing config-table-clob to varchar2(4000) (http://moodle.org/mod/forum/discuss.php?d=87509#p389413) What about the cache_text-table-clob? Should we do the same? Do we have to change it back, when we want to update to a new moodle version? Is there someone who reads this?! Where do I have to post this to get someone to read this? (Or does no one use oracle and moodle?)
Hide
Permalink
Angelo Rigo added a comment -

Also have problems with Oracle into another system the solutiopn was rto create a ctxindex in the oracle field equivalent to a text type in mysql ,

Show
Angelo Rigo added a comment - Also have problems with Oracle into another system the solutiopn was rto create a ctxindex in the oracle field equivalent to a text type in mysql ,
Hide
Permalink
Dan Marsden added a comment -

fixing component.

Hi DP - I'm sure you're aware that you're not the only one to experience issues with Oracle performance - there ar a range of different causes for this - have a look at some of the other open tracker issues here - some contain Oracle specific fixes that may also help.

Oracle support is unfortunately rather limited - We try to convince most of our oracle clients to run under postgres instead (although this may not be possible in your case)

The developers who "know" about Oracle and it's issues are usually really busy on other tasks - Eloy here is solidly working on backup/restore for 2.0 so although this has been open for a while I wouldn't expect to be resolved any time soon (unless someone came up with some funding for a Moodle Partner to do some performance related work)
Microsoft have directly funded work to support MS SQL in Moodle - maybe you could try and convince Oracle to do the same?

Show
Dan Marsden added a comment - fixing component. Hi DP - I'm sure you're aware that you're not the only one to experience issues with Oracle performance - there ar a range of different causes for this - have a look at some of the other open tracker issues here - some contain Oracle specific fixes that may also help. Oracle support is unfortunately rather limited - We try to convince most of our oracle clients to run under postgres instead (although this may not be possible in your case) The developers who "know" about Oracle and it's issues are usually really busy on other tasks - Eloy here is solidly working on backup/restore for 2.0 so although this has been open for a while I wouldn't expect to be resolved any time soon (unless someone came up with some funding for a Moodle Partner to do some performance related work) Microsoft have directly funded work to support MS SQL in Moodle - maybe you could try and convince Oracle to do the same?
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.

People

Vote (0)
Watch (2)

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.