Problem upgrading to boinc trunk

Message boards : Server programs : Problem upgrading to boinc trunk
Message board moderation

To post messages, you must log in.

AuthorMessage
EricD

Send message
Joined: 30 Oct 11
Posts: 6
United States
Message 40901 - Posted: 30 Oct 2011, 19:41:41 UTC

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
ID: 40901 · Report as offensive
EricD

Send message
Joined: 30 Oct 11
Posts: 6
United States
Message 40904 - Posted: 30 Oct 2011, 23:10:13 UTC

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.
ID: 40904 · Report as offensive

Message boards : Server programs : Problem upgrading to boinc trunk

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.