EPrints Technical Mailing List Archive

Message: #03304

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Re: Adding fields to a live system - any data integrity concerns?

Also stop the indexer when you stop apache and restart the indexer when you restart apache. 

Seb.

On 18/07/14 16:49, Jan Ploski wrote:

If you want to do it as a hotfix, the proper procedure would be to
1. Add expected columns and indexes to database tables
2. Add the field definition (which depends on 1)
3. (optional) Run whatever initialization scripts you need to run for
the field
4. apachectl graceful

Unfortunately, EPrints tools assume that you add the field definition
first and that they then update the database for you. This leaves a
window of inconsistency during which your users will get errors.

Obviously, if you don't mind a short service interruption, it's not a
concern and you can do it "offline" during a maintenance window:
1. apachectl stop
2. Add field definition
3. Use epadmin to update database
4. (optional) Run whatever initialization scripts you need to run for
the field
5. apachectl start