Moodle 2.3.2 + Postgres 9.0.3 + Quizzes(?) = stale db connections

Moodle 2.3.2 + Postgres 9.0.3 + Quizzes(?) = stale db connections

by Mike Kelly -
Number of replies: 2

Hi all,

We're running into a weird problem with our 2.3.2 install (actually, it's been an issue since we migrated to 2.0). I posted the details over on the General forum the other day, but then noticed Hardware/Performance, which is probably more applicable.

Rather than repost the whole thing, I'll just put the link to it here:

https://moodle.org/mod/forum/discuss.php?d=215289

Quick summary: Some activity/event (I suspect quizzes) are causing stale database connections to accumlate between our Moodle web & db servers. The problem eventually builds to a point where the web server becomes non-responsive & requires an httpd restart.

Persistent db connections in PHP have been disabled, so we're not sure where the problem is coming from. Any help would be appreciated - more details are at the link above.

Thanks!

Average of ratings: -
In reply to Mike Kelly

Re: Moodle 2.3.2 + Postgres 9.0.3 + Quizzes(?) = stale db connections

by Mike Kelly -

Does anyone have some ideas about the problem I linked to above? We could really use some assistance.

Average of ratings: -
In reply to Mike Kelly

Re: Moodle 2.3.2 + Postgres 9.0.3 + Quizzes(?) = stale db connections

by Michael Haskell -

Mike, I use mysql, but I'm curious if you found resolution to this topic? I'm interested in fixing quiz performance problems for our 2.3 instance.

 I got down a path where I was looking at cron jobs and potential inefficiency related to row-locks, wondering if there's any correlation with your cron period and stale transactions.  (probably a red herring, but thought it may be worth a look)

Average of ratings: -