Story Tools: PRINT | Text Size: S M L XL | REPORT TYPO | SEND YOUR FEEDBACK

Twitter's own 'Y2K' problem

By John Bowman, CBCNews.ca

Back on Blog Watch a few months ago, I wrote about how Unix computer systems tell time by counting the number of seconds since midnight on Jan. 1, 1970, and how in 2038, that number will no longer fit into a 32-bit integer.

Well, Twitter is going to be hitting that limit a lot sooner than that.

Each post on Twitter is given a unique identifying number and Twitter is running out. Once Twitterers create more than 2,147,483,647 posts, Twitter will start giving them negative ID numbers: -1, -2, -3. And third-party apps will likely crash as a result.

According to Twitpocalypse.com, Twitter is quickly approaching 1.85 billion tweets. Martin Dufort and Fred Brunel of WhereCloud, the Montreal developers behind the site, told the Montreal Gazette that Twitter could hit the 32-bit limit sometime in June.

WhereCloud set up Twitpocalypse.com as a marketing campaign for its iPhone app, Reportage, which is still awaiting approval by Apple.

« Previous Post | Main | Next Post »

This discussion is now Open. Submit your Comment.

Comments

Marc B

Saskatoon

Why is this such a big deal? If Twitter was originally built with a signed-32bit integer as their tweet primary key, then we can say at least one or more of the following:

a) Twitter never expected to get this big
b) The developers lacked the knowledge/foresight/intelligence to at least used an UNSIGNED integer as their primary key
c) The developers were too cheap to spend the extra 4 bytes of disk space per tweet to make the primary key 64bit

Posted May 19, 2009 06:08 PM

François Caron

Are you certain of that? It could be a 32 bit unsigned integer. Or if Twitter is running on a 64 bit operating system, the theoretical limit will be reached some 2 BILLION years from now, assuming the same rate of growth.

Posted May 19, 2009 06:53 PM

gukid

So you make one unique identifier for the user, and another for the post of that user, thus exponentially increasing the limit, it's easy. There are actually hundreds of different ways of dealing with this problem.

This, is just a publicity stunt. People will join, and post, to try and "crash" twitter, but it will never happen, and their user base will increase.

Posted May 25, 2009 02:58 PM

Chris Thomson

Twitter's not going to be setting status_ids to negative numbers. As Matt Sanford, a Twitter API developer, has said:

"There is no change to the format of responses and the number will continue to grow upward."

Some clients that cannot properly interpret 32-bit signed ints so large will have an issue with negative numbers.

Posted June 12, 2009 05:32 PM

« Previous Post | Main | Next Post »

Post a Comment

Disclaimer:

Note: By submitting your comments you acknowledge that CBC has the right to reproduce, broadcast and publicize those comments or any part thereof in any manner whatsoever. Please note that due to the volume of e-mails we receive, not all comments will be published, and those that are published will not be edited. But all will be carefully read, considered and appreciated.

Note: Due to volume there will be a delay before your comment is processed. Your comment will go through even if you leave this page immediately afterwards.

Privacy Policy | Submissions Policy

[an error occurred while processing this directive]
Story Tools: PRINT | Text Size: S M L XL | REPORT TYPO | SEND YOUR FEEDBACK

World »

British PM condemns 'sick and depraved terrorist attack' that left 5 dead in London video audio
British Prime Minister Theresa May is condemning the "sick and depraved terrorist attack" in London that left at least five people dead and 40 injured.
Spying claim by U.S. intelligence committee chair renews fight over Russia probe
Republican Devin Nunes's comments that private communications of Donald Trump and his transition team may have been scooped up by American intelligence officials monitoring other targets has led the committee's ranking Democrat, Adam Schiff, to renew his party's calls for an independent probe of Trump campaign links to Russia.
Photos 'They destroyed us': Mosul residents on life under ISIS occupation
CBC News recently spent a week in the Iraqi city of Mosul, speaking to residents about what it was like living under the world's most feared terrorist group.
more »

Canada »

Liberals' 1st gender-sensitive budget identifies gaps, funds possible fixes
From offering 18-month parental leave to targeting $7 billion of its infrastructure funding for child-care spaces, today's federal budget offers solutions to issues women often identify. Finance Minister Bill Morneau says his fixes will help grow the economy.
Analysis Liberal budget offers lots of 'vision' but few new numbers: Aaron Wherry video
The Liberals are selling a vision of what they hope will eventually be. In lieu of a new tax cut or benefit, in the place of any big new investment, that will have to suffice.
Senate ethics committee reviews Don Meredith's case, ponders possible sanctions video
Members of the Senate's ethics committee met to review the case of embattled Senator Don Meredith on Wednesday, beginning the process of formally sanctioning the Toronto-area senator for his relationship with a teenage girl.
more »

Politics »

Analysis Liberal budget offers lots of 'vision' but few new numbers: Aaron Wherry video
The Liberals are selling a vision of what they hope will eventually be. In lieu of a new tax cut or benefit, in the place of any big new investment, that will have to suffice.
Liberals' 1st gender-sensitive budget identifies gaps, funds possible fixes
From offering 18-month parental leave to targeting $7 billion of its infrastructure funding for child-care spaces, today's federal budget offers solutions to issues women often identify. Finance Minister Bill Morneau says his fixes will help grow the economy.
Budget 2017: Liberals spend on training and innovation while holding line on most taxes video audio
The Liberal government has delivered a budget designed to brace Canadians for a fast-changing global economy and empower women in the workforce, while taking a wait-and-see approach to sweeping changes south of the border.
more »

Health »

Sorry - we can't find that page
 
CBC.ca

Sorry, we can't find the page you requested.

  1. Please check the URL in the address bar, or ...
  2. Use the navigation links at left to explore our site, or ...
  3. Enter a term in the Quick Search box at top, or ...
  4. Visit our site map page

In a few moments, you will be taken to our site map page, which will help you find what you looking for.

more »

Arts & Entertainment»

Looking back on Chuck Barris's career: 'He turned the cameras back on real people'
Chuck Barris's trio of hit game shows — The Dating Game, The Newlywed Game and The Gong Show — have had a lasting legacy, paving the way for countless dating shows and reality competitions.
The Magnetic North Theatre Festival cancels 2017 season
One of Canada's premier theatre festivals has cancelled its 2017 season due to financial constraints.
Ukraine bans Russia's entry to Eurovision Song Contest
The Eurovision Song Contest, nominally an apolitical festival of pop music confections and cheerfully tacky costumes, erupted into a political dispute Wednesday after Ukraine banned Russia's contestant from entering the country.
more »

Technology & Science »

New categories of dinosaur family tree proposed by scientists
Some of the best-known dinosaurs, like Tyrannosaurus rex and Brontosaurus, may be headed for a divorce due to irreconcilable differences.
Arctic sea ice may vanish even if world achieves climate goal, study says
Arctic sea ice may vanish in summers this century even if governments achieve a core target for limiting global warming set by almost 200 nations in 2015, scientists said on Monday.
Ground-breaking bat cave discovery gives Alberta researchers baseline in fight against deadly disease audio
The recent discovery of a large cave or hibernacula in northern Alberta where hundreds of bats have found hibernating is giving researchers a baseline measurement in the fight against the deadly white-nose syndrome.
more »

Money »

Budget 2017: Hello Uber tax, goodbye transit credit
Consumer tax changes in today's federal budget will add to the cost of Uber rides while ending a public-transit tax credit. Those are just two of several Liberal government moves that will hit pocketbooks directly, though modestly.
Budget 2017: Liberals spend on training and innovation while holding line on most taxes video audio
The Liberal government has delivered a budget designed to brace Canadians for a fast-changing global economy and empower women in the workforce, while taking a wait-and-see approach to sweeping changes south of the border.
Bell and Rogers to ask bars to pay more for sports packages
Bell and Rogers will soon ask sports bars to pay more for the right to broadcast the big game, on top of what they pay for their existing television service.
more »

Consumer Life »

Sorry - we can't find that page
 
CBC.ca

Sorry, we can't find the page you requested.

  1. Please check the URL in the address bar, or ...
  2. Use the navigation links at left to explore our site, or ...
  3. Enter a term in the Quick Search box at top, or ...
  4. Visit our site map page

In a few moments, you will be taken to our site map page, which will help you find what you looking for.

more »

Sports »

[an error occurred while processing this directive]
Analysis 5 reasons why the NHL's Olympic spirit may live on, despite Bettman's posturing
Gary Bettman continues to talk out of both sides of his mouth on the topic of whether NHL players will participate in the 2018 Olympics in Pyeongchang, South Korea.
Video Hip Check: William Nylander scores his 20th of the year, nabs more bonus cash video
Toronto Maple Leafs' rookie William Nylander extended his point streak to nine games, scoring the winning goal against the Columbus Blue Jackets.
Rachel Homan is perfect through 10 at curling worlds
Canada's Rachel Homan ran her win streak to double digits at the 2017 world women's curling championship on Thursday, defeating Italy's Diana Gaspari 8-5.
more »

Diversions »

[an error occurred while processing this directive]
more »