首页   注册   登录
V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
V2EX 是一个什么样的地方?
• 这里大量的成员热爱编程和图形设计
• 这里有关于虚拟世界话题的讨论
• 也有真实世界的
• 信息量的多少在这里是始终重要的
• 作为立场,我相信这个世界在持续变得更好
GeekHub
tan9le
V2EX  ›  V2EX

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

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

    在准备上一个新功能。
    tan9le
        2
    tan9le   2014-04-28 12:36:20 +08:00
    @Livid 好吧,原来是我中奖了,晚上去买张彩票去
    关于   ·   FAQ   ·   API   ·   我们的愿景   ·   广告投放   ·   感谢   ·   实用小工具   ·   1135 人在线   最高记录 5168   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 24ms · UTC 19:29 · PVG 03:29 · LAX 12:29 · JFK 15:29
    ♥ Do have faith in what you're doing.