Issue 256 in vision2pixels: Retry SQL commands if it fails

[vision...@googlecode.com]

Status: Accepted
Owner: goo...@obry.net
CC: olivier.ramonat
Labels: Type-Defect Priority-High Milestone-Release3.3
Component-Persistence Usability

New issue 256 by goo...@obry.net: Retry SQL commands if it fails
http://code.google.com/p/vision2pixels/issues/detail?id=256

Some commands seems to fail randomly. Would be nice to add a retry (2 or 3
times) and to log the failing command in a hope to detect a pattern and
better understand what is going on.

[vision...@googlecode.com]

Comment #1 on issue 256 by goo...@obry.net: Retry SQL commands if it fails
http://code.google.com/p/vision2pixels/issues/detail?id=256

Example:

Default_Callback HTML exception for URI="/" EXNAME="DB.DB_ERROR"
EXMESS="DB_Error on Execute INSERT INTO remember_user
('user_login', 'cookie_content') VALUES
('turbo', 'c8a47d49b6658e37342daae51f9aa918')"

[vision...@googlecode.com]

Comment #2 on issue 256 by pascal.obry: Retry SQL commands if it fails
http://code.google.com/p/vision2pixels/issues/detail?id=256

Default_Callback HTML exception for URI="/forum/entry" EXNAME="DB.DB_ERROR"
EXMESS="DB_Error on Execute INSERT OR REPLACE INTO last_user_visit
('user_login', 'post_id', 'last_comment_id') VALUES ('turbo', 1870, (SELECT
COALESCE ((SELECT last_comment_id FROM post WHERE id= 1870), 1))"

[vision...@googlecode.com]

Comment #3 on issue 256 by pascal.obry: Retry SQL commands if it fails
http://code.google.com/p/vision2pixels/issues/detail?id=256

This last SQL request is not there anymore since the change on the way the
last_user_visit is handled.

[vision...@googlecode.com]

Comment #4 on issue 256 by pascal.obry: Retry SQL commands if it fails
http://code.google.com/p/vision2pixels/issues/detail?id=256

Default_Callback HTML exception for URI="/forum/threads"

EXNAME="DB.DB_ERROR" EXMESS="DB_Error on Execute INSERT OR REPLACE INTO

last_forum_visit ('user_login', 'forum_id', 'last_post_id') VALUES
('turbo', 1, (SELECT post.id FROM post, category WHERE
post.category_id=category.id AND c"

[vision...@googlecode.com]

Updates:
Owner: pascal.obry

Comment #5 on issue 256 by TurboClic: Retry SQL commands if it fails

[vision...@googlecode.com]

Comment #6 on issue 256 by TurboClic: Retry SQL commands if it fails

[vision...@googlecode.com]

Comment #7 on issue 256 by TurboClic: Retry SQL commands if it fails
http://code.google.com/p/vision2pixels/issues/detail?id=256

UPDATE post SET visit_counter=visit_counter+1 WHERE id=1869

[vision...@googlecode.com]

Updates:
Labels: Assignment-Olivier

Comment #8 on issue 256 by olivier.ramonat: Retry SQL commands if it fails
http://code.google.com/p/vision2pixels/issues/detail?id=256

(No comment was entered for this change.)

[vision...@googlecode.com]

Comment #9 on issue 256 by olivier.ramonat: Retry SQL commands if it fails
http://code.google.com/p/vision2pixels/issues/detail?id=256

I'm able to reproduce the problem easily in gnadelite. Will fix it.

[vision...@googlecode.com]

Comment #10 on issue 256 by TurboClic: Retry SQL commands if it fails
http://code.google.com/p/vision2pixels/issues/detail?id=256

Really good! If the fix is safe we should consider it for 3.3.

[vision...@googlecode.com]

Updates:
Status: Fixed

Comment #11 on issue 256 by olivier.ramonat: Retry SQL commands if it fails
http://code.google.com/p/vision2pixels/issues/detail?id=256

New gnadelite release (v2.1) fixes the problem. I think this should go in
the 3.3 release.