[traceback] DatabaseError: (1213, 'Deadlock found when trying to get lock; try restarting transaction')

VERIFIED FIXED

Status

VERIFIED FIXED
4 years ago
4 years ago

People

(Reporter: tasos, Assigned: tasos)

Tracking

Details

(Whiteboard: [kb=1606567] [qa-])

(Assignee)

Description

4 years ago
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

4 years ago
OS: Linux → All
Hardware: x86_64 → All
Whiteboard: [kb=1606567]

Comment 1

4 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

4 years ago
Status: ASSIGNED → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → FIXED

Updated

4 years ago
Version: unspecified → next

Comment 2

4 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

4 years ago
Verified as qa-
Status: RESOLVED → VERIFIED
Whiteboard: [kb=1606567] → [kb=1606567] [qa-]
(Assignee)

Updated

4 years ago
Version: next → 447
You need to log in before you can comment on or make changes to this bug.