V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
tan9le
V2EX  ›  V2EX

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

  •  
  •   tan9le · 2014-04-28 12:31:23 +08:00 · 2921 次点击
    这是一个创建于 3862 天前的主题,其中的信息可能已经有所发展或是发生改变。
    @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')
    2 条回复
    Livid
        1
    Livid  
    MOD
       2014-04-28 12:33:52 +08:00
    因为刚才在 alter table。

    在准备上一个新功能。
    tan9le
        2
    tan9le  
    OP
       2014-04-28 12:36:20 +08:00
    @Livid 好吧,原来是我中奖了,晚上去买张彩票去
    关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   实用小工具   ·   2842 人在线   最高记录 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 23ms · UTC 14:20 · PVG 22:20 · LAX 06:20 · JFK 09:20
    Developed with CodeLauncher
    ♥ Do have faith in what you're doing.