Public bug reported:
The patch in Bug 1492919 resolved the deadlock issues for some users,
but others are still reporting that they are getting deadlocks. This
seems to be an issue unique to MySQL, and it can happen with as few as 2
or 3 concurrent users.
It has been reported across all stable versions. Strangely, it seems to
be a relatively recent issue (i.e. we never heard this with Mahara 1.8
or 1.7, etc), so this suggests it was triggered by something that
changed fairly recently. One possible candidate is our switch to the
mysqli driver (before that Mahara wasn't doing transactions at all, in
mysql).
** Affects: mahara
Importance: High
Assignee: Aaron Wells (u-aaronw)
Status: In Progress
** Description changed:
The patch in Bug 1492919 resolved the deadlock issues for some users,
but others are still reporting that they are getting deadlocks. This
seems to be an issue unique to MySQL, and it can happen with as few as 2
or 3 concurrent users.
+
+ It has been reported across all stable versions. Strangely, it seems to
+ be a relatively recent issue (i.e. we never heard this with Mahara 1.8
+ or 1.7, etc), so this suggests it was triggered by something that
+ changed fairly recently. One possible candidate is our switch to the
+ mysqli driver (before that Mahara wasn't doing transactions at all, in
+ mysql).
** Changed in: mahara
Status: New => In Progress
** Changed in: mahara
Importance: Undecided => High
** Changed in: mahara
Assignee: (unassigned) => Aaron Wells (u-aaronw)
--
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/1514608
Title:
MySQL deadlock issues with simultaneous users
Status in Mahara:
In Progress
Bug description:
The patch in Bug 1492919 resolved the deadlock issues for some users,
but others are still reporting that they are getting deadlocks. This
seems to be an issue unique to MySQL, and it can happen with as few as
2 or 3 concurrent users.
It has been reported across all stable versions. Strangely, it seems
to be a relatively recent issue (i.e. we never heard this with Mahara
1.8 or 1.7, etc), so this suggests it was triggered by something that
changed fairly recently. One possible candidate is our switch to the
mysqli driver (before that Mahara wasn't doing transactions at all, in
mysql).
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1514608/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
