Funny story. About 3 years ago I realized that the BOINC database has result ids stored a integers, which are 4 bytes long and signed by default. The sign takes up one bit, thus leaving 31 bits remaining for the value. That means the maximum value is 2^31 (2 to the power of 31, or 2147483648). I mentioned this at this time, noting we were well on our way towards this maximum value, and put it on the "things we'll need to fix eventually" list.

Nobody has been really watching this (I've been pretty much out for over two months until this week), and sure enough we hit that limit yesterday, and the whole BOINC backend pretty much barfed. We tried to implement a "quick fix" by changing the result id signed integer to an unsigned integer (both in mysql and the C code), thus giving us an extra bit for the value. Now that means the maximum value is 2^32 (2 to the power of 32, or 4294967296). That should have bought us a couple more years.

However, this quick fix didn't really work. There's all kinds of code in BOINC that needs to be changed to get unsigned integers to work. Dave made some of these changes and Jeff tested them this morning, but still to no avail. More necessary fixes were found. We seem to be once again creating and sending out work at the moment. However the hood is wide open on BOINC now, so we're watching things carefully over the next day or so.

We're certainly not done - there are tons of cosmetic fixes that need to be made (our logs are full of entries containing negative result ids). In the long term we'll have to do the same for workunit ids, and at that point we'll probably go ahead and make them long longs (which are always 8 bytes, as opposed to longs, which are 4 bytes on 32-bit systems and 8 bytes on 64-bit systems) in the C code and bigints in mysql. At that point our id space will max out at 2305843009213693952, which should probably be enough. That's a million results a day for 6.3 billion years. If we're still running SETI@home 6.3 billion years from now there's probably nobody out there. Agreed?

We've been bitten by this long ago in informix, and have since been storing larger numbers there as int8's (8 byte integers) or doubles.

Warning: since we didn't come across this problem in advance and solve is gracefully, there may be some ugliness in the form of blocked results in weird states - these will most likely time out on their own and get resent. Sorry if this causes any confusion in the coming weeks.

By the way, it should be mentioned there were some random download server issues over this past weekend. No big deal - usual stuff regarding linux kernel hangs. We kicked the servers on monday morning and they went back to work.

- Matt

---

-- BOINC/SETI@home network/web/science/development person
-- "Any idiot can have a good idea. What is hard is to do it." - Jeanne-Claude

Thanks for the update Matt,

Claggy

Warning: since we didn't come across this problem in advance and solve is gracefully, there may be some ugliness in the form of blocked results in weird states - these will most likely time out on their own and get resent. Sorry if this causes any confusion in the coming weeks.

Matt, sorry you came back off tour and had to wade into this so soon - but in a way it was good that it bit while there was an extra pair of hands to help bail, and at least the bug had the good grace to bite at a reasonably civilised hour and day of the week.

Re the ugly blocked results: we get periodic reports on the boards of workunits in unusual states. Typically, it's two results returned, but both still waiting for validation. Or three results, two of them valid and the third still waiting. Sometimes these clear of their own accord when the original deadline day comes round, sometimes they hang around much longer than that.

Once the string has been tied off, and the sealing wax has set, would it be a good idea - would it be possible - to run the transitioner over the whole database and try to pick off the uglies?

How soon before the scheduler comes back up? - I can't report with the scheduler down - I've got about 18 results waiting on the scheduler... (would'a been more, but I was way down on SETI WU's before this... (except on two computers [out of 4])

---

.

Hello, from Albany, CA!...

Thanks for the update. Let us know when the hood goes back down and gets latched.

---

Will clients (on our crunchers) need to be updated, also?

Well I liked the update, but I won't be posting here soon I think, at least with a RAC that keeps on falling, elsewhere like at Einstein My RAC is going up, and Einstein is set to 0% and S@H to 100%, It seems Seti at Home does not like 3-GTX295 cards in one case, and 6 like cards would be worse more likely, so I may be going elsewhere, like It or not and I don't. And I've done everything I could short of using a PCXT to crunch with, Yes I know what one of those is capable of, I've been around that long.

---

The T1 Trust, PRR T1 Class 4-4-4-4 #5550, 1 of America's First HST's

...short of using a PCXT to crunch with, Yes I know what one of those is capable of, I've been around that long.

You should upgrade that slow Intel chip with a NEC V20!

Sorry, couldn't resist. I've been around a while too. In fact, most of my early work was on the even more ancient Z80A. I rolled my own 32bit multiply and divide routines from scratch on that puppy. Those were the days ...
;)

---

...short of using a PCXT to crunch with, Yes I know what one of those is capable of, I've been around that long.

You should upgrade that slow Intel chip with a NEC V20!

Sorry, couldn't resist. I've been around a while too. In fact, most of my early work was on the even more ancient Z80A. I rolled my own 32bit multiply and divide routines from scratch on that puppy. Those were the days ...
;)

Well I have an even slower computer, an Atari 1200XL, Only 100,000 were ever made and @ 1.78MHz their the slowest short of an Apple II that could display 256 colors on screen, My 1st computer was an Atari 400 w/48K back in 1980.

Seriously though the DCF here is making Me sink fast and It's like I'm being pulled down by a tractor beam while the Warp Drive is on full reverse.

---

The T1 Trust, PRR T1 Class 4-4-4-4 #5550, 1 of America's First HST's

Sorry. I know this is not the correct place to put this comment, but after read the posts of DrFoo and VW Bobier I couldn't resist to comment that I have an old ATARI 800, big as a typewritter, and one ATARI Mega ST, both still working fine. With these machines and a cartidge of Atari Basic began my sohn his informatics carrier. Today he is Master programmer, CCNT, and several titles more I don't remember...
In fact today I still playing with my three 7 to 13 y.o. Grandchildrens those old games like Karateka, Barbarian Fighter, Xenon and others, hand to hand, one joystich each...
And, want you now? Despite his own Core 4 or I3 or I7 machines both 3 are glad to play those old games, also with his Oldfather!

---

Just remember when you sort out those negative numbers, two's complement.

---

Sorry. I know this is not the correct place to put this comment, but after read the posts of DrFoo and VW Bobier I couldn't resist to comment that I have an old ATARI 800, big as a typewritter, and one ATARI Mega ST, both still working fine. With these machines and a cartidge of Atari Basic began my sohn his informatics carrier. Today he is Master programmer, CCNT, and several titles more I don't remember...
In fact today I still playing with my three 7 to 13 y.o. Grandchildrens those old games like Karateka, Barbarian Fighter, Xenon and others, hand to hand, one joystich each...
And, want you now? Despite his own Core 4 or I3 or I7 machines both 3 are glad to play those old games, also with his Oldfather!

Do you use it for crunching?

---

BOINC WIKI

quote]
Do you use it for crunching?[/quote]

No,no... I use them only to play with my Grandchildren.

I think if that were possible, crunching a single WU would take several weeks, not to say with Astropulse...

...short of using a PCXT to crunch with, Yes I know what one of those is capable of, I've been around that long.

You should upgrade that slow Intel chip with a NEC V20!

LOL! My office was once stocked with IBM PCs. I swapped out the 8088s with V20s. The staff was amazed how I made their machines so fast.

Damn, I'm getting old.

---

Join the PACK!

How can 1970,1980 technology still remain at the front end of modern technogy? 7474's 7476's went by the wayside as the 8-bit bus was developed.

---

I had a mitts 680B but never had a monitor or keyboard on it to play games with it as only had 512 BYTES of memory in it. 24 switches and leds for output. It did work for about 20 years though as a house alarm.

---

Getting back to SETI technical matters, I'm having trouble requesting new tasks, both on production and Beta, getting: "11/16/2011 7:46:34 AM SETI@home Beta Test Scheduler request failed: Failure when receiving data from the peer" almost every time I try: occasionally a Beta request will get through...

---

.

Hello, from Albany, CA!...

Getting back to SETI technical matters, I'm having trouble requesting new tasks, both on production and Beta, getting: "11/16/2011 7:46:34 AM SETI@home Beta Test Scheduler request failed: Failure when receiving data from the peer" almost every time I try: occasionally a Beta request will get through...

Check the Cricket graphs, my friend.
Nobody is connecting very well right now.
And once the problem is fixed the bandwidth will rapidly become saturated and connecting will still be difficult.

But right now something is fundamentally broken, and you are in the same boat with the rest of us, it's not on your end.

---

"Freedom is just Chaos, with better lighting." Alan Dean Foster

Yes, but I thought the staff should be made aware...

---

.

Hello, from Albany, CA!...

Yes, but I thought the staff should be made aware...

If there is any connectivity, e-mails to mobile phones are sent.

---