Roundup Tracker - Issues

Issue 678896

classification
add roundup-admin command to lock databases for backup
Type: rfe Severity: normal
Components: Interface Versions:
process
Status: closed wont fix
:
: richard : richard, rouilj, schlatterbeck, syrk
Priority: normal :

Created on 2003-02-02 03:42 by anonymous, last changed 2012-01-05 20:15 by schlatterbeck.

Messages
msg3153 Author: [hidden] (anonymous) Date: 2003-02-02 03:42
What do people think about providing 

   roundup-admin 
lock/unlock

functions that would lock access to a tracker's 
files. So to
do a backup, its a simple matter of:

   % 
roundup-admin lock
   % cp -pr $TRACKER_HOME 
/tmp/tracker
   % roundup-admin unlock

rather then 
having to edit the aliases file to take the mail
gateways off line 
and stopping apache or the 
roundup-gateway to disable the 
web interface.

Richard said:

I like it. Please enter as 
a feature request on sf.net

Done.

-- rouilj
msg3154 Author: [hidden] (rouilj) Date: 2003-03-08 20:34
Logged In: YES 
user_id=707416

Could this be as simple as creating a file in the database area
called 
DB_LOCKED and having the db access routines return
errors if the 
file exists?
msg3155 Author: [hidden] (rouilj) Date: 2003-04-01 19:03
Logged In: YES 
user_id=707416

When the database is locked, the roundup-mailgw should
return an 
exit code of 75, (EX_TEMPFAIL IIRC) for sendmail,
or 111 for qmail 
MUA to indicate to sendmail or other MUA
that a bounce email 
should not be sen, and the email should
be queued and tried again 
later.

-- rouilj
msg3156 Author: [hidden] (rouilj) Date: 2003-04-04 19:52
Logged In: YES 
user_id=707416

When the database is locked, the roundup-mailgw should
return an 
exit code of 75, (EX_TEMPFAIL IIRC) for sendmail,
or 111 for qmail 
MUA to indicate to sendmail or other MUA
that a bounce email 
should not be sen, and the email should
be queued and tried again 
later.

-- rouilj
msg3157 Author: [hidden] (syrk) Date: 2003-12-08 16:22
Logged In: YES 
user_id=38283

i second this.
msg4475 Author: [hidden] (schlatterbeck) Date: 2012-01-05 20:15
Since we support database backends with transaction support for some
time now, running your database backup routine in a transaction is the
way to go. One example (but one I wouldn't necessarily recommend for
everyday backup) is the roundup-admin export command.
History
Date User Action Args
2012-01-05 20:15:01schlatterbecksetstatus: open -> closed
resolution: wont fix
messages: + msg4475
nosy: + schlatterbeck
2003-02-02 03:42:53anonymouscreate