Index  | Recent Threads  | Unanswered Threads  | Who's Active  | Guidelines  | Search
 

Quick Go »
No member browsing this thread
Thread Status: Active
Total posts in this thread: 2
[ Jump to Last Post ]
Post new Thread
Author
Previous Thread This topic has been viewed 2392 times and has 1 reply Next Thread
knreed
Former World Community Grid Tech
Joined: Nov 8, 2004
Post Count: 4504
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Periodic Out of Work Messages/BOINC Outage Wed Oct 17 starting at 17:00 UTC [Completed]

Volunteers contributing to the Help Conquer Cancer project are periodically getting messages that no jobs are available to send.

The cause of these periodic messages is a slow response in a database query that fills the buffer that stores the jobs that are examined when a client requests new work.

It turns out the database index used by that query is not optimal and it is resulting in the slow response. We will need to alter that index to make it include the required keys. However, it will take up to 3 hours for that index to be altered. During that time access to the table will need to be stopped.

We are going to make this change at 17:00 UTC on Wednesday October 17th. During this time, volunteers will not be able to report completed jobs or obtain new work.

We apologize for the inconvenience.
----------------------------------------
[Edit 1 times, last edit by knreed at Oct 17, 2012 5:43:41 PM]
[Oct 16, 2012 6:16:38 PM]   Link   Report threatening or abusive post: please login first  Go to top 
knreed
Former World Community Grid Tech
Joined: Nov 8, 2004
Post Count: 4504
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Re: Periodic Out of Work Messages/BOINC Outage Wed Oct 17 starting at 17:00 UTC [Completed]

We are happy to report that the index rebuild time was significantly faster than we expected and this change is completed.

The database query is now running in 1/10th the time it ran previously and users will not see the periodic out of work messages for this reason.
[Oct 17, 2012 5:45:04 PM]   Link   Report threatening or abusive post: please login first  Go to top 
[ Jump to Last Post ]
Post new Thread