Closed
Bug 1110653
Opened 10 years ago
Closed 10 years ago
[traceback] DatabaseError: (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Categories
(Mozilla Reps Graveyard :: reps.mozilla.org, task)
Tracking
(Not tracked)
VERIFIED
FIXED
People
(Reporter: tasos, Assigned: tasos)
Details
(Whiteboard: [kb=1606567] [qa-])
Traceback (most recent call last): File "/data/www/reps.mozilla.org/remo/vendor/lib/python/django/core/handlers/base.py", line 113, in get_response response = callback(request, *callback_args, **callback_kwargs) File "/data/www/reps.mozilla.org/remo/remo/base/decorators.py", line 81, in wrapper return func(request, *args, **kwargs) File "/data/www/reps.mozilla.org/remo/remo/voting/views.py", line 214, in view_voting Vote.objects.create(user=user, poll=poll) File "/data/www/reps.mozilla.org/remo/vendor/lib/python/django/db/models/manager.py", line 149, in create return self.get_query_set().create(**kwargs) File "/data/www/reps.mozilla.org/remo/vendor/lib/python/django/db/models/query.py", line 416, in create obj.save(force_insert=True, using=self.db) File "/data/www/reps.mozilla.org/remo/remo/voting/models.py", line 147, in save name=name) File "/data/www/reps.mozilla.org/remo/remo/dashboard/models.py", line 83, in resolve action_items.update(completed=True, resolved=True) File "/data/www/reps.mozilla.org/remo/vendor/lib/python/django/db/models/query.py", line 581, in update rows = query.get_compiler(self.db).execute_sql(None) File "/data/www/reps.mozilla.org/remo/vendor/lib/python/django/db/models/sql/compiler.py", line 1020, in execute_sql cursor = super(SQLUpdateCompiler, self).execute_sql(result_type) File "/data/www/reps.mozilla.org/remo/vendor/lib/python/django/db/models/sql/compiler.py", line 846, in execute_sql cursor.execute(sql, params) File "/data/www/reps.mozilla.org/remo/vendor/lib/python/django/db/backends/mysql/base.py", line 128, in execute six.reraise(utils.DatabaseError, utils.DatabaseError(*tuple(e.args)), sys.exc_info()[2]) File "/data/www/reps.mozilla.org/remo/vendor/lib/python/django/db/backends/mysql/base.py", line 120, in execute return self.cursor.execute(query, args) File "/usr/lib64/python2.6/site-packages/newrelic-2.22.1.20/newrelic/hooks/database_dbapi2.py", line 22, in execute *args, **kwargs) File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue
Assignee | ||
Updated•10 years ago
|
OS: Linux → All
Hardware: x86_64 → All
Whiteboard: [kb=1606567]
Comment 1•10 years ago
|
||
Commit pushed to master at https://github.com/mozilla/remo https://github.com/mozilla/remo/commit/1342460acd243f9b75efd54aafb65043d7281319 [fix bug 1110653] Update save method in Vote table to avoid deadlocks.
Updated•10 years ago
|
Status: ASSIGNED → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
Updated•10 years ago
|
Version: unspecified → next
Comment 2•10 years ago
|
||
Commits pushed to master at https://github.com/mozilla/remo https://github.com/mozilla/remo/commit/41c06179c325c9053fbd23d623bdb7d92de3f67a [bug 1110653] Avoid db deadlocks when updating events. https://github.com/mozilla/remo/commit/3117414125b2549f1a6bda5db9bb99dd63e04aa1 Merge pull request #887 from akatsoulas/1110653-db-deadlocks [bug 1110653] Avoid db deadlocks when updating events.
Assignee | ||
Comment 3•10 years ago
|
||
Verified as qa-
Status: RESOLVED → VERIFIED
Whiteboard: [kb=1606567] → [kb=1606567] [qa-]
Assignee | ||
Updated•10 years ago
|
Version: next → 447
Updated•4 years ago
|
Product: Mozilla Reps → Mozilla Reps Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•