| Issue Number | 4502 |
|---|---|
| Summary | Refresh DEV database from PROD |
| Created | 2018-07-31 14:39:16 |
| Issue Type | Task |
| Submitted By | Kline, Bob (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2018-08-09 17:40:02 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.230254 |
Please refresh the CDR and cdr_archived_versions databases from PROD. After the databases have been refreshed, please ask CBIIT to give you the numbers for disk space usage for the two databases (data and logs).
~bkline, the script
PullDevData.py is failing. I'm guessing this is because the
table import_disposition has already been deleted and the
script is trying to save its content.
Could you have a quick look at the list of tables to see if there are
others that will be deleted and won't need to be restored? I don't think
so but it's better to check first.
"action",
"active_status",
"doc_type",
"filter_set",
"filter_set_member",
"format",
"grp",
"grp_action",
"grp_usr",
"import_disposition",
"link_prop_type",
"link_properties",
"link_target",
"link_type",
"link_xml",
"query",
"query_term_def",
"query_term_rule",
"usr"
As discussed on the phone, please drop
import_disposition from the list of tables. That's the only
one that's going away right now. Thanks.
Yep, the script finished without problems after removing that table from the list.
We made changes to the file PullDevData.py. Should I create a new branch for this change or make the change to master in git?
Has to be in a separate branch in order to create a pull request for
merge into master.
The changes have been saved in git:
https://github.com/NCIOCPL/cdr-tools/commit/e2dc3c0
Closing ticket.
Elapsed: 0:00:00.001694