mysql dead_mysql Deadlock

最新推荐文章于 2022-04-15 07:52:56 发布

卢庆春

最新推荐文章于 2022-04-15 07:52:56 发布

阅读量53

点赞数

文章标签： mysql dead

本文链接：https://blog.csdn.net/weixin_35472986/article/details/113906783

版权

[2013-06-17 22:19:05,826] {ERROR api_views.api_like - 934} Traceback (most recent call last):

File "/data1/dist/app/main/duitang/api/api_views.py", line 932, in api_like

liked = form.save()

File "/data1/dist/app/main/duitang/like/forms.py", line 83, in save

liked = like_it(like_object, category)

File "/data1/dist/app/main/duitang/like/forms.py", line 62, in like_it

liked, created = Like.objects.get_or_create(user=self.user, category=category, object_id=like_object.id)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/django/db/models/manager.py", line 135, in get_or_create

return self.get_query_set().get_or_create(**kwargs)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/django/db/models/query.py", line 385, in get_or_create

obj.save(force_insert=True, using=self.db)

File "/data1/dist/app/main/duitang/like/models.py", line 54, in save

super(Like, self).save(*args, **kwargs)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/django/db/models/base.py", line 460, in save

self.save_base(using=using, force_insert=force_insert, force_update=force_update)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/django/db/models/base.py", line 553, in save_base

result = manager._insert(values, return_id=update_pk, using=using)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/django/db/models/manager.py", line 195, in _insert

return insert_query(self.model, values, **kwargs)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/django/db/models/query.py", line 1436, in insert_query

return query.get_compiler(using=using).execute_sql(return_id)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 791, in execute_sql

cursor = super(SQLInsertCompiler, self).execute_sql(None)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 735, in execute_sql

cursor.execute(sql, params)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 86, in execute

return self.cursor.execute(query, args)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/MySQLdb/cursors.py", line 174, in execute

self.errorhandler(self, exc, value)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler

raise errorclass, errorvalue

OperationalError: (1213, 'Deadlock found when trying to get lock; try restarting transaction')

[2013-06-17 22:19:06,190] {ERROR async._worker - 100} async worker [duitang.callback.mblogsync.update_message] [(>,)] [{}] err: [Traceback (most recent call last):

File "/data1/dist/app/main/duitang/common/async.py", line 91, in _worker

profiling(func, "async")(*a, **kw)

File "/data1/dist/app/main/duitang/common/async.py", line 19, in _profiling

r = func(*a, **kw)

File "/data1/dist/app/main/duitang/callback/mblogsync.py", line 51, in update_message

mon_album = get_or_create_mongo_album(msg)

File "/data1/dist/app/main/duitang/callback/mblogsync.py", line 26, in get_or_create_mongo_album

alb_id, alb_name = get_album_info(msg)

File "/data1/dist/app/main/duitang/callback/mblogsync.py", line 19, in get_album_info

album = msg.album

File "/data1/dist/app/main/duitang/message/models.py", line 273, in __getattribute__

return super(Message, self).__getattribute__(name)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/django/db/models/fields/related.py", line 315, in __get__

rel_obj = QuerySet(self.field.rel.to).using(db).get(**params)

File "/duitang/dist/sys/python/lib/python2.7/site-packages/django/db/models/query.py", line 349, in get

% self.model._meta.object_name)

DoesNotExist: Album matching query does not exist.

]

[2013-06-17 22:19:06,861] {ERROR views.callback - 496} Cannot login via sina, code: cab614ffc313e0b0b29f4e78e988c09e

[2013-06-17 22:19:25,800] {ERROR api_views.api_like - 934} Traceback (most recent call last):