Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 346990 - Lagged database slave causes posts to be posted dozens of times
Summary: Lagged database slave causes posts to be posted dozens of times
Status: RESOLVED FIXED
Alias: None
Product: Community
Classification: Eclipse Foundation
Component: Forums and Newsgroups (show other bugs)
Version: unspecified   Edit
Hardware: PC Linux
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Forums and Newsgroups inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-24 10:24 EDT by Denis Roy CLA
Modified: 2012-03-06 19:44 EST (History)
2 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Denis Roy CLA 2011-05-24 10:24:26 EDT 
It doesn't happen all too frequently, but when the database slave gets lagged too far behind (>120s) new forum posts can be "posted" a dozen times or more.  Fortunately, they are not repeated to NNTP and are fairly easy to clean up.

In the immediate term, I need to fix the database monitor script that sends Bugzilla (and Forum) queries to the master should the slave be too far behind (or simply not running).

In the longer term, I need to fix this behaviour in the slave.  There must be some post-sumbit data the forum is fetching from the slave and when it doesn't see it there, it reposts.
Comment 1 Eric Rizzo CLA 2011-05-24 10:36:05 EDT 
Here's another case of it happening: http://www.eclipse.org/forums/index.php/sp/115585/
If you have an easier way of cleaning up those duplicates rather than dozens of manual clicks, please do so.
Comment 2 Denis Roy CLA 2012-03-06 19:44:37 EST 
This has been addressed also.