SDP-30

ttyler (ttyler)
ttyler created this job , modified by super-tom_tyler
Closed
Enhanced offline_db 'stale data' check in weekly backup script.

Add a check to verify that the offline_db is current (based on
the journal counter) before doing the database swap in the
weekly backup script.

This addresses a scenario where a calamity of errors could cause
the offline_db to be stale before the weekly backup script is run.

A safety feature already in the SDP ensures that the offline_db is
not incomplete, e.g. in the process of being written, as could occur
if there were a sudden power off during checkpoint recovery.  The
improved check in this job will also verify that the data is current.
18610Fixed a bug with check_journalnum where it was being called to check the offline journal
number, but the function was hard coded to JOURNALNUM.

Implemented a function to compare the journal numbers of P4ROOT and OFFLINE_DB before
switching the db files as an extra layer of protection to avoid data loss.
18617#review-18610
Fixed a bug with check_journalnum where it was being called to check the offline journal
number, but the function was hard coded to JOURNALNUM.

Implemented a function to compare the journal numbers of P4ROOT and OFFLINE_DB before
switching the db files as an extra layer of protection to avoid data loss.
Status
Closed
Project
perforce-software-sdp
Severity
B
Reported By
ttyler
Reported Date
Modified By
super-tom_tyler
Modified Date
Owned By
ttyler
Dev Notes
This job, SDP-30, was originally named job000427.
Type
Feature