Welcome to MilkyWay@home

Improved Database Stability


Advanced search

Message boards : News : Improved Database Stability
Message board moderation

To post messages, you must log in.

AuthorMessage
Jake Weiss
Volunteer moderator
Project developer
Project tester
Project scientist

Send message
Joined: 25 Feb 13
Posts: 573
Credit: 56,634,187
RAC: 421,250
50 million credit badge6 year member badgeextraordinary contributions badge
Message 67339 - Posted: 16 Apr 2018, 19:21:10 UTC

Hey Everyone,

I made some more configuration updates to improve database stability. If you notice any database errors, please post about them here.

Jake
ID: 67339 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
ProfileContact
Avatar

Send message
Joined: 28 Aug 07
Posts: 12
Credit: 1,050,851
RAC: 742
1 million credit badge10 year member badge
Message 67400 - Posted: 25 Apr 2018, 2:20:04 UTC

When I'm logged into this site and visit my team page I get a database error that is not there if I'm logged out.



Also, I requested a change of foundership and after the 60 day grace period instead of being presented with the option to finalize the transfer, I could only choose to initiate the transfer again.
I'm not sure that the error is related to the change of foundership fail because I've had the fail occur on 3 or 4 other BOINC project sites that didn't display the error - but I'm sure I've seen that error before on other project's team pages.
ID: 67400 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
ProfileContact
Avatar

Send message
Joined: 28 Aug 07
Posts: 12
Credit: 1,050,851
RAC: 742
1 million credit badge10 year member badge
Message 67408 - Posted: 25 Apr 2018, 16:22:45 UTC - in response to Message 67400.  

I think there may be two seperate issues here.
I see the same database error when logged into the team page at Collatz but I was still able to finalize the founder transfer there.
I don't see the database error on the few BOINC projects that didn't show the option to finalize the transfer after the required wait period.
ID: 67408 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Jake Weiss
Volunteer moderator
Project developer
Project tester
Project scientist

Send message
Joined: 25 Feb 13
Posts: 573
Credit: 56,634,187
RAC: 421,250
50 million credit badge6 year member badgeextraordinary contributions badge
Message 67409 - Posted: 25 Apr 2018, 18:51:15 UTC
Last modified: 25 Apr 2018, 19:08:54 UTC

Hi Contact,

I found the query that is causing that database error. I am working on a fix for it now. It doesn't seem like an issue that would prevent team transfer though. We will see.

Jake

[Edit]
I fixed the issue with the database error. Changing founders does seem to work, I am not sure what method you were using though. Maybe you can give me a little more direction to where exactly you were seeing an issue.
[/Edit]
ID: 67409 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
ProfileContact
Avatar

Send message
Joined: 28 Aug 07
Posts: 12
Credit: 1,050,851
RAC: 742
1 million credit badge10 year member badge
Message 67410 - Posted: 25 Apr 2018, 19:21:23 UTC - in response to Message 67409.  
Last modified: 25 Apr 2018, 19:39:02 UTC

Thanks!
I no longer see the database error and I agree that the error did not cause the founder transfer fail because the database error was there for a least one other project (Collatz) where the transfer could be completed.

May I burden you further and ask if you can explain your fix simply enough for me to forward the info to other projects that may be experiencing the same database error?

Also, may I burden you even further to ask you to investigate why the founder transfer may have failed?

I can wait another 60 days to try if you need.

[Edit]Jake Weiss wrote:
I am not sure what method you were using though. Maybe you can give me a little more direction to where exactly you were seeing an issue.

When you are a member of a team you have an option on the projects team page to initiate a Team foundership change.
[/Edit]
ID: 67410 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Jake Weiss
Volunteer moderator
Project developer
Project tester
Project scientist

Send message
Joined: 25 Feb 13
Posts: 573
Credit: 56,634,187
RAC: 421,250
50 million credit badge6 year member badgeextraordinary contributions badge
Message 67413 - Posted: 26 Apr 2018, 14:52:57 UTC

Hi Contact,

There was a problem using a Group By statement in the database query for new users. As a quick fix, I just removed it. This means names can show up more than once as a new user, but I don't really think that's too big of a deal.


As for the founder issue, I actually tried it and simulated a 60 day wait time on our database. The functionality definitely works assuming the date is set correctly when a request is sent. I'll check on that today. Chances are, you will have to wait another 60 days once I get it working though. That seems to be the only fair way to make sure the system isn't getting cheated.

Jake
ID: 67413 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
ProfileContact
Avatar

Send message
Joined: 28 Aug 07
Posts: 12
Credit: 1,050,851
RAC: 742
1 million credit badge10 year member badge
Message 67414 - Posted: 26 Apr 2018, 16:04:00 UTC - in response to Message 67413.  

Thanks for your time and information Jake, and my apologies for hijacking this thread.
I agree that it's most fair and more interesting to wait again.

As a side note, I just had another founder transfer fail on another project and this time noticed this response after I re-initiated transfer:
SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting
The current founder has been notified of your request by email and private message.


Likely not the problem on this site, and maybe just an insignificant mail send fail, but could something like that block some other call to the code and so not actually initiate founder transfer?
ID: 67414 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote

Message boards : News : Improved Database Stability

©2019 Astroinformatics Group