mahara-contributors team mailing list archive

[Cecilia Vela Gurovic <1887321@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

>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

** Affects: mahara
     Importance: Undecided
         Status: New

-- 
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:
  New

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