Project

General

Profile

Tâche #13302

Distribution EOLE - Scénario #13189: Etudier la restauration totale (SR-T03-002 2.5.1)

La table "bareos" ne doit pas être sauvegardé/restauré

Added by Emmanuel GARETTE over 5 years ago. Updated over 5 years ago.

Status:
Fermé
Priority:
Normal
Assigned To:
Start date:
09/29/2015
Due date:
% Done:

100%

Estimated time:
1.00 h
Spent time:
Remaining (hours):
0.0

Description

Quand on sauvegarde mysql, toutes les databases sont sauvegardés. Il ne faut pas ssauvegardé celle de bareos (elle est fait par ailleurs).

En effet, les informations sur le job en cours est supprimé en plein milieu de la restauration.

Erreur dans les logs :

29-Sep 16:41 scribe-fd JobId 6: ClientAfterJob: restauration de /home/backup/sql/bareos.sql
29-Sep 16:41 scribe-fd JobId 6: ClientAfterJob: restauration de /home/backup/sql/controlevnc.sql
29-Sep 16:41 scribe-fd JobId 6: ClientAfterJob: restauration de /home/backup/sql/sympa.sql
29-Sep 16:41 scribe-fd JobId 6: ClientAfterJob: restauration de /home/backup/sql/pydio.sql
29-Sep 16:41 scribe-fd JobId 6: ClientAfterJob: restauration de /home/backup/sql/roundcube.sql
29-Sep 16:41 scribe-fd JobId 6: ClientAfterJob: restauration de /home/backup/sql/mysql.sql
29-Sep 16:41 scribe-dir JobId 6: Warning: Error updating job record. sql_update.c:192 Update failed: affected_rows=0 for UPDATE Job SET JobStatus='T',EndTime='2015-09-29 16:41:55',ClientId=1,JobBytes=643128,ReadBytes=174923,JobFiles=9,JobErrors=0,VolSessionId=3,VolSessionTime=1443537630,PoolId=0,FileSetId=0,JobTDate=1443537715,RealEndTime='2015-09-29 16:41:55',PriorJobId=0,HasBase=0,PurgedFiles=0 WHERE JobId=6

Associated revisions

Revision 2fdd61bc (diff)
Added by Emmanuel GARETTE over 5 years ago

ne pas sauvegarde la base mysql (ref #13302 @1h)

History

#1 Updated by Emmanuel GARETTE over 5 years ago

  • Project changed from Distribution EOLE to eole-bareos
  • % Done changed from 0 to 100
  • Estimated time set to 1.00 h
  • Remaining (hours) set to 0.25

#2 Updated by Scrum Master over 5 years ago

  • Status changed from En cours to Résolu

#3 Updated by Joël Cuissinat over 5 years ago

  • Status changed from Résolu to Fermé
  • Remaining (hours) changed from 0.25 to 0.0
root@amonecole:~# bareosrestore.py --search *.sql
Recherche dans la sauvegarde
/home/backup/sql/pydio.sql
/home/backup/sql/ocsweb.sql
/home/backup/sql/sympa.sql
/home/backup/sql/mysql.sql
/home/backup/sql/phpmyadmin.sql
/home/backup/sql/roundcube.sql
/home/backup/sql/glpi.sql
/home/backup/sql/controlevnc.sql

root@amonecole:~#

Also available in: Atom PDF