This mail is only relevant to you if you are using Beaker server and
have upgraded to version 0.6.8 prior to 12 April (that is, using
versions 0.6.8-1 through 0.6.8-4).
Yesterday we discovered a problem with the server upgrade notes for
version 0.6.8, resulting in gaps in the data in the new
system_status_duration table. We have released version 0.6.8-5 with the
upgrade notes amended. However, if you have already upgraded to version
0.6.8 (using 0.6.8-4 or earlier), you will need to repeat the section of
the notes entitled "Populate the system_status_duration table". Execute
"TRUNCATE TABLE system_status_duration;" first. An outage is required.
To verify that there are no problems with the data in the
system_status_duration table, you can execute the following two queries.
They should both produce no results.
SELECT * FROM system
WHERE NOT EXISTS
(SELECT 1 FROM system_status_duration
WHERE system_status_duration.system_id = system.id
AND system_status_duration.start_time = system.date_added);
SELECT * FROM system_status_duration
WHERE finish_time IS NOT NULL
AND NOT EXISTS
(SELECT 1 FROM system_status_duration i
WHERE i.system_id = system_status_duration.system_id
AND i.start_time = system_status_duration.finish_time);
If you have any questions, please reply to the list or find us on IRC.
Dan Callaghan <dcallagh(a)redhat.com>
Show replies by date