Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB Lock bug #5

Open
DownGoat opened this issue May 9, 2014 · 1 comment
Open

DB Lock bug #5

DownGoat opened this issue May 9, 2014 · 1 comment
Labels

Comments

@DownGoat
Copy link
Owner

DownGoat commented May 9, 2014

/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py:331: Warning: Data truncated for column 'description' at row 1
  cursor.execute(statement, parameters)
Exception in thread Thread-11:
Traceback (most recent call last):
  File "/usr/lib/python2.7/threading.py", line 810, in __bootstrap_inner
    self.run()
  File "/home/dwg/ownCloud/PyCharm/FeedServer/feedserver/feedstorer.py", line 108, in run
    add_entry(entry, feed.id)
  File "/home/dwg/ownCloud/PyCharm/FeedServer/feedserver/feedstorer.py", line 54, in add_entry
    "feed_id": feed_id,
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2814, in update
    result = session.execute(update_stmt, params=self._params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 910, in execute
    clause, params or {})
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 201, in execute
    self.errorhandler(self, exc, value)
  File "/usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') 'UPDATE entry SET feed_id=%s, published=%s, updated=%s, title=%s, content=%s, description=%s, link=%s, remote_id=%s WHERE entry.id = %s' (1L, 1399675388.0, 1399675388.0, 'Told my Fianc\xc3\xa9e after she got her haircut that she looks like a 12 year old boy', '<table> <tr><td> <a href="http://www.reddit.com/r/AdviceAnimals/comments/255zu3/told_my_fianc\xc3\xa9e_after_she_got_her_haircut_that/"><img alt="Told my Fianc\xc3\xa9e after she got her haircut that she looks like a 12 year old boy" src="http://b.thumbs.redditmedia.com/iuFGyaRGQEVO60B7.jpg" title="Told my Fianc\xc3\xa9e after she got her haircut that she looks like a 12 year old boy" /></a> </td><td> submitted by <a href="http://www.reddit.com/user/killablake007"> killablake007 </a> to <a href="http://www.reddit.com/r/AdviceAnimals/"> AdviceAnimals</a> <br /> <a href="http://imgur.com/RdnBQw6">[link]</a> <a href="http://www.reddit.com/r/AdviceAnimals/comments/255zu3/told_my_fianc\xc3\xa9e_after_she_got_her_haircut_that/">[comment]</a> </td></tr></table>', '<table> <tr><td> <a href="http://www.reddit.com/r/AdviceAnimals/comments/255zu3/told_my_fianc\xc3\xa9e_after_she_got_her_haircut_that/"><img alt="Told my Fianc\xc3\xa9e after she got her haircut that she looks like a 12 year old boy" src="http://b.thumbs.redditmedia.com/iuFGyaRGQEVO60B7.jpg" title="Told my Fianc\xc3\xa9e after she got her haircut that she looks like a 12 year old boy" /></a> </td><td> submitted by <a href="http://www.reddit.com/user/killablake007"> killablake007 </a> to <a href="http://www.reddit.com/r/AdviceAnimals/"> AdviceAnimals</a> <br /> <a href="http://imgur.com/RdnBQw6">[link]</a> <a href="http://www.reddit.com/r/AdviceAnimals/comments/255zu3/told_my_fianc\xc3\xa9e_after_she_got_her_haircut_that/">[comment]</a> </td></tr></table>', 'http://

@DownGoat DownGoat added this to the Stable version milestone May 9, 2014
@DownGoat DownGoat added the bug label May 9, 2014
@DownGoat
Copy link
Owner Author

Exception in thread Thread-13:
Traceback (most recent call last):
  File "/usr/lib/python2.7/threading.py", line 810, in __bootstrap_inner
    self.run()
  File "/home/dwg/ownCloud/PyCharm/FeedServer/feedserver/feedstorer.py", line 108, in run
    add_entry(entry, feed.id)
  File "/home/dwg/ownCloud/PyCharm/FeedServer/feedserver/feedstorer.py", line 54, in add_entry
    "feed_id": feed_id,
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2814, in update
    result = session.execute(update_stmt, params=self._params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 910, in execute
    clause, params or {})
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 201, in execute
    self.errorhandler(self, exc, value)
  File "/usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') 'UPDATE entry SET feed_id=%s, published=%s, updated=%s, title=%s, content=%s, description=%s, link=%s, remote_id=%s WHERE entry.id = %s' (1L, 1399737112.0, 1399737112.0, 'Hvernig \xc3\xa1 a\xc3\xb0 bera fram nafn Hery Rajaonarimampianina, forseta Madagaskar?', '<table> <tr><td> <a href="http://www.reddit.com/r/lemurinn/comments/257orq/hvernig_\xc3\xa1_a\xc3\xb0_bera_fram_nafn_hery/"><img alt="Hvernig \xc3\xa1 a\xc3\xb0 bera fram nafn Hery Rajaonarimampianina, forseta Madagaskar?" src="http://e.thumbs.redditmedia.com/Ro5zg3N1coBOqiRj.jpg" title="Hvernig \xc3\xa1 a\xc3\xb0 bera fram nafn Hery Rajaonarimampianina, forseta Madagaskar?" /></a> </td><td> submitted by <a href="http://www.reddit.com/user/lemurinn"> lemurinn </a> to <a href="http://www.reddit.com/r/lemurinn/"> lemurinn</a> <br /> <a href="http://lemurinn.is/2014/05/05/hvernig-a-ad-bera-fram-nafn-hery-rajaonarimampianina-forseta-madagaskar/">[link]</a> <a href="http://www.reddit.com/r/lemurinn/comments/257orq/hvernig_\xc3\xa1_a\xc3\xb0_bera_fram_nafn_hery/">[comment]</a> </td></tr></table>', '<table> <tr><td> <a href="http://www.reddit.com/r/lemurinn/comments/257orq/hvernig_\xc3\xa1_a\xc3\xb0_bera_fram_nafn_hery/"><img alt="Hvernig \xc3\xa1 a\xc3\xb0 bera fram nafn Hery Rajaonarimampianina, forseta Madagaskar?" src="http://e.thumbs.redditmedia.com/Ro5zg3N1coBOqiRj.jpg" title="Hvernig \xc3\xa1 a\xc3\xb0 bera fram nafn Hery Rajaonarimampianina, forseta Madagaskar?" /></a> </td><td> submitted by <a href="http://www.reddit.com/user/lemurinn"> lemurinn </a> to <a href="http://www.reddit.com/r/lemurinn/"> lemurinn</a> <br /> <a href="http://lemurinn.is/2014/05/05/hvernig-a-ad-bera-fram-nafn-hery-rajaonarimampianina-forseta-madagaskar/">[link]</a> <a href="http://www.reddit.com/r/lemurinn/comments/257orq/hvernig_\xc3\xa1_a\xc3\xb0_bera_fram_nafn_hery/">[comment]</a> </td></tr></table>', 'http://www.reddit.com/r/lemurinn/comments/257orq/hvernig_\xc3\xa1_a\xc3\xb0_bera_fram_nafn_hery/', 'http://www.reddit.com/r/lemurinn/comments/257orq/hvernig_\xc3\xa1_a\xc3\xb0_bera_fram_nafn_hery/', 9926L)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant