Technical News

烦人

February 24, 2005 - 23:30 UTC
Update on yesterday's outage: We are still dealing with some database fallout. Most of the classic SETI@home systems are up - enough that we can serve workunits to users. However, BOINC is dead in the water until we get at least one database server up and running.
With the master database corrupted beyond repair, we turned all our attention to the replica. Its disks finished sync'ing last night, and after some file system checks the machine booted and mysql started just fine. A battery of tests revealed no corruption.. until we got to the result table. Of course, that's by far the biggest and most important table in the database. We are attempting to repair it now.

Assuming we can repair it with little or no data loss, we will then dump all the data from the replica back onto the master. If we're lucky, this will be done by tomorrow morning and we can start revving all the engines back up.

Please note that since it was a slower machine than the master, the data on the replica database server was about 30 minutes behind real time. We did try to limp both systems along to sync the replica data up even further but no dice. So, when we do get back on line it will be as if there was a half-hour hole in time during which all uploaded results were lost (and any user profile updates, message board postings, etc.). We sincerely apologize to all our users for this loss.

Court brought in a UPS from his personal server collection. So the master database will be protected while we scramble to purchase another. The database server was unprotected yesterday because it was in our lab, not in the data closet where all of our UPS's are. We were/are just weeks away from a data closet reorganization designed to make room for the DB server.
-------------
这是BOINC网站上的新闻.

Snake_SH

太大意了，至少应该拿个UPS过去。

song

数据服务器没有ups是不可想象的，可是主页没有停过就有点说不通了

tomytomy

肯定还有内情，借口。

烦人

简单翻译:

    关于昨天停机故障的最新消息:我们还在对一些数据库的不同步进行处理.大多数Classic SETI@home的系统已经恢复---已经足够让我们为用户提供WU.但是,在我们修复并开启至少一台数据库服务器前,BOINC项目还将停滞.
    由于主数据库已无法修复,我们把所有的注意力都集中到了备份机上.昨天晚上完成磁盘同步并做完一些文件系统的测试后,这台机子启动了,(它上面的)MySQL数据库也恢复运行了.
    在(检查)结果数据表之前的一系列测试都没有问题.当然,目前它是数据库中最大和最重要的表.我们现在正尝试修复它.
    如果能不丢失数据或者只丢失一点点数据修好它的话,我们就会把备份中的所有数据导入主数据库中.幸运的话,我们会在明天上午完成(修复工作)并恢复所有的设备.
    请注意,由于备份机的性能不及主机,所以备份服务器上的数据大约比真实时间慢了30分钟.We did try to limp both systems along to sync the replica data up even further but no dice. (这句不会翻...)所以,当恢复服务后,将会就像存在半小时的时间漏洞,正好在这段时间内上传的所有结果都丢失了(包括用户资料的更新,留言板上的帖子等).我们真诚地向这些受损失的用户道歉.

......

烦人

机房里是有UPS的,但出故障那天,数据库服务器放在实验室里而不是机房.

DF3-CQB

借口吧.....他们自己的图片介绍里面是有UPS的,还说有150LB重是个BIG BEAR....

Rojer

哎呀！这三十分钟是什么时候？希望没有中国用户上传

烦人

应该是BOINC的数据库.不是Classic SETI@home的.

JockWen

那还好

烦人

JockWen  在 2005-2-26 11:50 发表:

那还好

等一下出门的时候小心点,见到BOINC用户你就跑...

挡我者玩

看来老外，也会吹牛B啊！
就是吹的水平不高，又吹破了，看来得来中国听听开会了！