search

aodn / content

Tracks AODN Portal content and configuration issues
0 stars 0 forks source link

australian phytoplankton static harvester #439

Closed lbesnard closed 4 years ago

lbesnard commented 4 years ago

The static version (instead of the ongoing one) of the Australian phytoplankton db harvester ran today by mistake on aws10: aus_phyto_db

A backup of the schema 'aus_phyto_db' (and NOT 'aus_phyto_db_ongoing') should be uploaded to overwrite the changes done.

ggalibert commented 4 years ago

Can you please create a backlog item?

atkinsn commented 4 years ago

@ggalibert this is related to a DOI and a Data paper, so this is an issue that needs to be rectified ASAP, so its a bug.

atkinsn commented 4 years ago

@lwgordonimos is restoring this now. Estimate is a couple of hours, so for now, I won't worry about deactivating the DOI etc.

ghost commented 4 years ago

Well, that didn't take as long as I feared...

@lbesnard could you do a quick spot check on the RC database to confirm that the aus_phyto_db schema is as expected? If so, I will restore to prod.

ghost commented 4 years ago

@atkinsn @lbesnard this schema has now been restored on production

ghost commented 4 years ago

For posterity, the actions taken were:

harvest=# select drop_objects_in_schema('aus_phyto_db');
$ pg_restore -v --dbname=harvest < aus_phyto_db.dump