V2EX 的 mysql 貌似有死锁的问题?

2014-04-28 12:31:23 +08:00
 tan9le
@Livid 我在打开这个帖子: http://v2ex.com/t/110284#reply76 时碰到了如下的异常,好像是死锁:

Traceback (most recent call last):
File "/Library/Python/2.7/site-packages/tornado/web.py", line 1141, in _when_complete
callback()
File "/Library/Python/2.7/site-packages/tornado/web.py", line 1162, in _execute_method
self._when_complete(method(*self.path_args, **self.path_kwargs),
File "/www/v2ex/galaxy/handlers/web/topic.py", line 293, in get
self.store.flush()
File "/Library/Python/2.7/site-packages/storm/store.py", line 501, in flush
self._flush_one(obj_info)
File "/Library/Python/2.7/site-packages/storm/store.py", line 558, in _flush_one
self._connection.execute(expr, noresult=True)
File "/Library/Python/2.7/site-packages/storm/databases/mysql.py", line 106, in execute
return Connection.execute(self, statement, params, noresult)
File "/Library/Python/2.7/site-packages/storm/database.py", line 241, in execute
raw_cursor = self.raw_execute(statement, params)
File "/Library/Python/2.7/site-packages/storm/database.py", line 374, in raw_execute
self._run_execution(raw_cursor, args, params, statement)
File "/Library/Python/2.7/site-packages/storm/database.py", line 388, in _run_execution
self._check_disconnect(raw_cursor.execute, *args)
File "/Library/Python/2.7/site-packages/storm/database.py", line 454, in _check_disconnect
return function(*args, **kwargs)
File "/Library/Python/2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/Library/Python/2.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')
2927 次点击
所在节点    V2EX
2 条回复
Livid
2014-04-28 12:33:52 +08:00
因为刚才在 alter table。

在准备上一个新功能。
tan9le
2014-04-28 12:36:20 +08:00
@Livid 好吧,原来是我中奖了,晚上去买张彩票去

这是一个专为移动设备优化的页面(即为了让你能够在 Google 搜索结果里秒开这个页面),如果你希望参与 V2EX 社区的讨论,你可以继续到 V2EX 上打开本讨论主题的完整版本。

https://www.v2ex.com/t/110326

V2EX 是创意工作者们的社区,是一个分享自己正在做的有趣事物、交流想法,可以遇见新朋友甚至新机会的地方。

V2EX is a community of developers, designers and creative people.

© 2021 V2EX