Most of my links in the last 24 are unexpandable

[zimmeee]

mysql> SELECT unexpandable, count(_) FROM URLer JOIN URL USING(urlid) WHERE twitter_id = 5351152 AND tweettime >= now() - INTERVAL 1 DAY GROUP BY 1 ORDER BY count(); +--------------+----------+ | unexpandable | count(*) | +--------------+----------+ | 0 | 13 | | 1 | 507 | +--------------+----------+

[zimmeee]

(experimenting with markdown)

SELECT unexpandable, count(*) 
FROM URLer JOIN URL USING(urlid) 
WHERE twitter_id = 5351152 AND tweet_time >= now() - INTERVAL 1 DAY 
GROUP BY 1 ORDER BY count(*);

unexpandable	count(*)
0	13
1	507

[wasauce]

I have added some logging that will hopefully figure out what the issue is.

I made a change last week that allows the URL Expanding to fail — which would otherwise cause us to go over our usage limits. I need see it happening — and it appears like (as you noted) we are not getting any new TWEETS! --  Bill Ferrell 650.646.2065 From: Noah Zimmerman notifications@github.com Reply: zimmeee/fortunatepun reply@reply.github.com Date: February 6, 2014 at 11:41:05 PM To: zimmeee/fortunatepun fortunatepun@noreply.github.com Cc: wasauce wferrell@gmail.com Subject:  Re: [fortunatepun] Most of my links in the last 24 are unexpandable (#14)
(experimenting with markdown)

SELECT unexpandable, count(_)
FROM URLer JOIN URL USING(urlid)
WHERE twitter_id = 5351152 AND tweettime >= now() - INTERVAL 1 DAY
GROUP BY 1 ORDER BY count(); unexpandable count(*) 0 13 1 507 — Reply to this email directly or view it on GitHub.

[zimmeee]

seems to be resolved