[Plugin: Twitter Tools] Occasional Double Posts (21 posts)

I have Twitter Tools configured to publish daily digests of my tweets for the day. It usually works just fine, but it will double-post about 2-3 times per month. Is this a bud in the plugin, or is there something I may be doing wrong?

This is something we've spent several days trying to debug, without success. We have never been able to reproduce the issue reliably. I have a couple of ideas I'd like to try to see what kind of impact they have.

It's on a long list of things to investigate, so if someone wanted to sponsor the development it would move up the list.

Last week I start a trial and removed all twitter tools entry’s in the options table of WP MySQL Database (aktt_). And start over with new settings of twitter tools.
And it seems, that this fix the double post behaviour.

I think the problem could be a race condition that occurs when multiple "people" access your site simultaneously (for example search crawlers that hit your blog with multiple connections).

I've set up a cron job to hit my blog just after the scheduled post time, and the one post it was supposed to do has worked correctly so far. Of course that doesn't say much (I only have one weekly post set up), I'll have to monitor it for a few more weeks before I can say for sure that this is the problem.

Week two of my test, another single post, just the way it should be. So I really think the 'race condition' theory holds true. Somehow, when called multiple times simultaneously, Twitter Tools doesn't lock quickly enough or somehow misses the locks of the other threads, causing it to double-post.

Anybody got an idea on how to prevent that? (I'm no good at thinking up such solutions. Apart from somehow abusing memcached, I came up blank, and that would add quite a big dependency to it.)

i've finally turned this plugin off after 3 months of this issue. and i have no intention of diving into my sql tables searching for "aktt_" options. b-o-r-i-n-g. as if i didn't have my hands full with 300 other sql db's...... although i am curious if that fix actually works. or actually Alex King should be interested in whether or not that fix works. (props though, i'm sure critics are quick and the thankers are slow, especially when it comes to a free plugin that probably took many hours to develop).

can anyone recommend another plugin that will post a daily tweet digest?

I just had a quintuple post without any quotes, though I did have some parentheses in a couple of them. Some of the posts had the appropriate tag but two of them did not. Perhaps it is a character escaping issue?