...so does this mean, it would be 'healthier' for the replica database, that we wouldn't use the forum? ;-)

---

...so does this mean, it would be 'healthier' for the replica database, that we wouldn't use the forum? ;-)

It probably means whatever was done to the Forum last year succeeded in not only screwing up the 'Resend Lost Tasks' feature but also hit the Replica database as well. The Solution? Turn off Resend Lost Tasks And the Replica. Well, it's Not the solution I would have chose, but, it appears that's the one we are stuck with. It would be nice to discover Why the Resend feature Suddenly caused problems with the Forum when it worked Fine for years, and also why the Forum now seems to hate the Replica as well.
Any suggestions?
;-)

i suggest fixing it

---

I came down with a bad case of i don't give a crap

i suggest fixing it

And just what do you think they do when a problem arises, sit on their collective hands and watch everyone gripe about it here? :|

---

CAPT Siran d'Vel'nahr - L L & P _\\//
Winders 11 OS? "What a piece of junk!" - L. Skywalker
"Logic is the cement of our civilization with which we ascend from chaos using reason as our guide." - T'Plana-hath

It probably means whatever was done to the Forum last year succeeded in not only screwing up the 'Resend Lost Tasks' feature but also hit the Replica database as well. The Solution? Turn off Resend Lost Tasks And the Replica. Well, it's Not the solution I would have chose, but, it appears that's the one we are stuck with. It would be nice to discover Why the Resend feature Suddenly caused problems with the Forum when it worked Fine for years, and also why the Forum now seems to hate the Replica as well.
Any suggestions?
;-)

Well, there's a partial explanation in the description for the attempted fix last night:

web: don't accidentally write to read-only DB replica
BOINC lets you maintain a read-only DB replica,
and certain read-only web pages (like top_users.php)
use the replica in preferences to the master.
But it turns out that these pages aren't actually read-only
because of the too-clever forum_preferences logic.
So sometimes it would add forum_preferences records to the replica,
leading to errors [when] it later copies the same item from the master.

Solution: skip the forum preferences logic if we're using the replica.

98bfcdb2d32719f1dbfa06bc55b58e5d28a7ae61

If your php coding skills are up to writing less-clever forum_preferences logic, I'm sure they would appreciate your (or anybody else's) assistance.

It probably means whatever was done to the Forum last year succeeded in not only screwing up the 'Resend Lost Tasks' feature but also hit the Replica database as well. The Solution? Turn off Resend Lost Tasks And the Replica. Well, it's Not the solution I would have chose, but, it appears that's the one we are stuck with. It would be nice to discover Why the Resend feature Suddenly caused problems with the Forum when it worked Fine for years, and also why the Forum now seems to hate the Replica as well.
Any suggestions?
;-)

Well, there's a partial explanation in the description for the attempted fix last night:

web: don't accidentally write to read-only DB replica
BOINC lets you maintain a read-only DB replica,
and certain read-only web pages (like top_users.php)
use the replica in preferences to the master.
But it turns out that these pages aren't actually read-only
because of the too-clever forum_preferences logic.
So sometimes it would add forum_preferences records to the replica,
leading to errors [when] it later copies the same item from the master.

Solution: skip the forum preferences logic if we're using the replica.

98bfcdb2d32719f1dbfa06bc55b58e5d28a7ae61

If your php coding skills are up to writing less-clever forum_preferences logic, I'm sure they would appreciate your (or anybody else's) assistance.

I don't think the forum_preferences are very clever. I still have the problem where BOINC tells me my Host location is different from the one on the Website. I just restarted a host a little while ago and it says it's location is none when it is actually listed as School on the Website. It's been set School for a while but keeps reverting to none on reboot. I can set it to something else, then back to School and it will be fine...for a while. If it can't even read the location right, how clever can it be?

Tue 20 Oct 2015 10:11:08 AM EDT | | Starting BOINC client version 7.2.33 for x86_64-pc-linux-gnu
Tue 20 Oct 2015 10:11:08 AM EDT | | Data directory: /home/tbar/BOINC
Tue 20 Oct 2015 10:11:08 AM EDT | | Host name: TBarsIntel
Tue 20 Oct 2015 10:11:08 AM EDT | | OS: Linux: 3.13.0-65-generic
Tue 20 Oct 2015 10:11:08 AM EDT | | Local time is UTC -4 hours
Tue 20 Oct 2015 10:11:08 AM EDT | SETI@home | URL http://setiathome.berkeley.edu/; Computer ID 7258715; resource share 100
Tue 20 Oct 2015 10:11:08 AM EDT | | Host location: none
Tue 20 Oct 2015 10:11:08 AM EDT | | General prefs: using your defaults
Tue 20 Oct 2015 10:11:08 AM EDT | | Reading preferences override file

I don't think the forum_preferences are very clever. I still have the problem where BOINC tells me my Host location is different from the one on the Website.

You don't tell what the location of your computer is on the forum preferences, but on the web preferences and project preferences.

https://setiathome.berkeley.edu/edit_forum_preferences_form.php is the forum preferences.

---

That's strange, because I can change it the way I ALWAYS have and it will respond the same way it always has. Here, http://setiathome.berkeley.edu/prefs.php?subset=project and Here, http://setiathome.berkeley.edu/show_host_detail.php?hostid=7258715

Tue 20 Oct 2015 11:15:46 AM EDT | SETI@home | New computer location: home
Tue 20 Oct 2015 11:16:57 AM EDT | SETI@home | New computer location: school

Now it's set to School again. See how long that lasts.
All my Hosts have different Locations, the Mac uses None, the other uses School. But it keeps reverting to None for some reason.

You do not set the location of the computer in the forum preferences. Those preferences are for these message boards and for the way that you want to be notified on subscribed threads.

You do set the location in the project preferences and separately on the details of your computer, but both those pages have N O T H I N G to do with the forum preferences. Click the link I gave in my previous post. See where you end up at.

---

You do not set the location of the computer in the forum preferences. Those preferences are for these message boards and for the way that you want to be notified on subscribed threads.

You do set the location in the project preferences and separately on the details of your computer, but both those pages have N O T H I N G to do with the forum preferences. Click the link I gave in my previous post. See where you end up at.

I see, different preferences. So....the Project Preferences are also messed up?
;-)

We are back from today's outrage and do not have the replica database working, this is not a cause for PANIC BUT instead it is a cause for concern.

---

If all is well, the 'modified' message is gone now.

David Anderson wrote:

Fixed; this bug was introduced in an older commit that wasn't on S@h yet.

---

If all is well, the 'modified' message is gone now.

David Anderson wrote:

Fixed; this bug was introduced in an older commit that wasn't on S@h yet.

Or perhaps:

web: initialize post.modified to zero, not current time

Looking better, anyway.

I should point out after the bug was fixed, the replica was still several days behind, and thus contained some broken commits that it hadn't gotten to yet, hence the continuing crashes even after the fix was implemented.

To solve that problem, and speed things along, I'm recreating the replica from scratch with the backup done during the outage today. Should be on line later this afternoon. THEN we'll see if everything is working well....

- 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.

---

With each crime and every kindness we birth our future.

I should point out after the bug was fixed, the replica was still several days behind, and thus contained some broken commits that it hadn't gotten to yet, hence the continuing crashes even after the fix was implemented.

To solve that problem, and speed things along, I'm recreating the replica from scratch with the backup done during the outage today. Should be on line later this afternoon. THEN we'll see if everything is working well....

- Matt

I wondered about that, but surely the replica was up-to-date before it went offline the first time.

Then, assuming that it was offline, was the bug so bad that the replica could still be updated in error, despite (a) being read-only, and (b) being offline? Without that, and with the bug being reported as caused by changes to the replica only, I couldn't see how new errors could creep into the system.

Sniff, something on my system just threw away close to two years of Seti statistics. I have an old backup of the statistics* file, but that dates back to 22 October 2014. A year's worth of data lost. :-(

<save_stats_days> was set to 1461 days, so it should've kept the data. My earliest 'time stamp' is now Fri, 16 Oct 2015 00:00:00 GMT.

The stats file for Pirates@home is still intact and showing all those entries.

Edit: I see Einstein's data got thrown out as well. Everything that contacted homebase on the 16th got reset.

---

Sniff, something on my system just threw away close to two years of Seti statistics. I have an old backup of the statistics* file, but that dates back to 22 October 2014. A year's worth of data lost. :-(

<save_stats_days> was set to 1461 days, so it should've kept the data. My earliest 'time stamp' is now Fri, 16 Oct 2015 00:00:00 GMT.

The stats file for Pirates@home is still intact and showing all those entries.

Edit: I see Einstein's data got thrown out as well. Everything that contacted homebase on the 16th got reset.

Had similar issue before on 2 hosts already. At some moment data log disappeared for SETI project while remained for others. number of days long enough to cover next 5 years...

Replica DB is back on line and only 3,540 seconds behind. That has to be some sort of record. Boincstats.com shows enough credit issued since the last daily update to create a number 2 in my "Best Ten Days".

Does any of the latest forum tinkering explain why the bit.ly shortcuts in my signature suddenly don't work? I changed one of them to its actual URL, but I don't have any characters left to change the others. The bit.ly URLs do still work on their own.

---

David
Sitting on my butt while others boldly go,
Waiting for a message from a small furry creature from Alpha Centauri.