Posts by EricD

1) Message boards : Projects : News on Project Outages (Message 102717) Posted 26 Jan 2021 by EricD Post: NumberFields@Home is down with what appears to be a hard drive crash. We hope to have this resolved in the next few days. We finally got someone in to take a look at the server. After a hard reboot and a check of the file system, things appear to be back to normal. We are continuing to monitor the system, just in case. The drive crashed again (keeps dropping into read-only mode). Reboots are not helping this time. We should have the new SSD installed sometime next week. NumberFields@home should be back momentarily. The project has been reinstalled on the new hard drive and we are about to restore the database.
2) Message boards : Projects : News on Project Outages (Message 102569) Posted 14 Jan 2021 by EricD Post: NumberFields@Home is down with what appears to be a hard drive crash. We hope to have this resolved in the next few days. We finally got someone in to take a look at the server. After a hard reboot and a check of the file system, things appear to be back to normal. We are continuing to monitor the system, just in case. The drive crashed again (keeps dropping into read-only mode). Reboots are not helping this time. We should have the new SSD installed sometime next week.
3) Message boards : Projects : News on Project Outages (Message 101594) Posted 16 Nov 2020 by EricD Post: NumberFields@Home is down with what appears to be a hard drive crash. We hope to have this resolved in the next few days. We finally got someone in to take a look at the server. After a hard reboot and a check of the file system, things appear to be back to normal. We are continuing to monitor the system, just in case.
4) Message boards : Projects : News on Project Outages (Message 101584) Posted 15 Nov 2020 by EricD Post: NumberFields@Home is down with what appears to be a hard drive crash. We hope to have this resolved in the next few days.
5) Message boards : Server programs : Problem upgrading to boinc trunk (Message 40904) Posted 30 Oct 2011 by EricD Post: Nevermind. I found my problem. I needed to make some manual database upgrades using the db_update.php script. It helps when you actually read the wiki pages.
6) Message boards : Server programs : Problem upgrading to boinc trunk (Message 40901) Posted 30 Oct 2011 by EricD Post: Hi. I'm an admin for the NumberFields@home project. I am trying to upgrade from the core release 6_12 version to the latest trunk version. After upgrading, the server status showed the transitioner was not running. I found the following at the end of the transitioner logs: [2011/10/30 12:10:01] Executing command: transitioner -d 3 2011-10-30 12:10:01.6485 Starting 2011-10-30 12:10:01.6513 [debug] doing a pass Database error: Unknown column 'wu.app_version_id' in 'field list' query=SELECT wu.id, wu.name, wu.appid, wu.min_quorum, wu.need_validate, wu.canonical_resultid, wu.transition_time, wu.delay_bound, wu.error_mask, wu.max_error_results, wu.max_total_results, wu.file_delete_state, wu.assimilate_state, wu.target_nresults, wu.result_template_file, wu.priority, wu.hr_class, wu.batch, wu.app_version_id, res.id, res.name, res.report_deadline, res.server_state, res.outcome, res.validate_state, res.file_delete_state, res.sent_time, res.hostid, res.received_time, res.app_version_id FROM workunit AS wu LEFT JOIN result AS res ON wu.id = res.workunitid WHERE wu.transition_time < 1320001801 LIMIT 1000 2011-10-30 12:10:01.6516 [CRITICAL] WU enum error: Error 1054; exiting So there appears to be a database problem. I think this is related to an error message I received when running tools/upgrade: performing update update_7_26_2011 Doing query: alter table batch add fraction_done double not null, add nerror_jobs integer not null, add state integer not null, add completion_time double not null, add credit_estimate double not null, add credit_canonical double not null, add credit_total double not null, add name varchar(255) not null, add app_id integer not null Failed: Table 'decics.batch' doesn't exist performing update update_9_6_2011 Doing query: alter table user_submit add create_apps tinyint not null, add create_app_versions tinyint not null Failed: Table 'decics.user_submit' doesn't exist And there were a few other such failures. So it appears that there are some missing tables in the database. Do I just need to create these on my own, or did I miss a step in the upgrade process? Database administration is not one of my strong suits. Any suggestions on how I should proceed would be greatly appreciated. Thanks! --Eric

Copyright © 2024 University of California.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.