Update required to the Live Feed system
Blog post · 27 Jun, 2014

Update at 2.40am NZST: Live feeds are now back up and running. We’ll be posting up a full breakdown of the incident soon. Thanks for your patience during the live feed downtime!

Update at 2.45pm NZST: We’ve performed the necessary updates and PocketSmith is back online. Live Feeds won’t be active yet as we’re now verifying Live Feed transactions before they’re synced with your accounts. We’ll provide an update when this is complete.

Today, we discovered that the transaction IDs we’ve been receiving from our Live Feed provider, Yodlee, have now exceeded the signed integer limit of 2,147,483,647.

As a result, transactions with IDs subsequent to this were not imported into the PocketSmith database from the Live Feed system, causing transactions to temporarily stop being updated in our users’ accounts.

Thankfully, the effect of this is nowhere near as dramatic as the ‘Twitpocalypse’ of 2009, when Twitter’s tweet IDs headed for the magic figure of 2,147,483,647: All hell may break loose on twitter in 2 hours.

All it means is that we need to make a number of adjustments here to accommodate the new, bigger numbers. In the meantime however, your transactions are safe, and will be updated as per usual when our changes are complete.

We’re now in the process of implementing and testing the updates internally, and we will require 60 minutes of downtime in order to roll the change through. We’re sorry about the inconvenience, and look forward to getting us back up to speed very soon!

Thanks for holding on!

p/s Did you know that because of this, 2,147,483,647 is also the maximum score, and most amount of money you can earn in many video games?

Want to see more news?