mahara-contributors team mailing list archive

[Kristina Hoeppner <1887321@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara
     Assignee: (unassigned) => Doris Tam (doristam)

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: mahara-contributors
https://bugs.launchpad.net/bugs/1887321

Title:
  too many DB connections

Status in Mahara:
  Triaged

Bug description:
  From forum post
  https://mahara.org/interaction/forum/topic.php?id=8654&offset=0&limit=10#post34439

  By what is reported in this forum post, it looks like the amount of
  connections by DB username is over 50 even when it's only one mahara
  account logged in on the site.

  We have to look into why this is happening, if we are opening
  connections but never closing them.

  By a quick search I could find that we are calling
  $db = ADONewConnection($CFG->dbtype);
  from init.php everytime, there are no checks for conditions so we always create a new connection
  but we are not calling the Disconnect function from ADOConnection to kill the connection.

  The forum post resports this for mysqli but we should check if we have
  the same problem with postgres as well

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1887321/+subscriptions