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

Status: VERIFIED FIXED

(Mozilla Reps Graveyard :: reps.mozilla.org, task)

Description

[Tasos Katsoulas [:tasos]]

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

Comment 1

[[github robot]]

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.

Comment 2

[[github robot]]

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.

Comment 3

[Tasos Katsoulas [:tasos]]

Verified as qa-