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

[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')

[Livid]

因为刚才在 alter table。

在准备上一个新功能。

[tan9le]

@Livid 好吧，原来是我中奖了，晚上去买张彩票去