mahara-contributors team mailing list archive

[Kristina Hoeppner <1887321@xxxxxxxxxxxxxxxxxx>]

More investigation is needed for this. Pushing it out to 21.04 to do as
we are getting too close to the release of 20.10 to make major changes
in this area.

** Changed in: mahara
       Status: New => Triaged

** Changed in: mahara
    Milestone: 20.10.0 => 21.04.0

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
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