Skip to main content

Backup stopped abnormally

  • June 19, 2016
  • 2 replies
  • 21 views

HadyZ
Forum|alt.badge.img
  • Participating Frequently

Running an incremental backup on vertica 7.1

nohup /opt/vertica/bin/vbr.py --task backup --config-file /home/dbadmin/BackupDev.ini | tee /home/dbadmin/backup_log/FullBackup_out.txt

 

after 4 hours , the process is no longer running and the backup not done . 

the snapsho folder is not empty but the backup process is no longer running . 

 

no info in the FullBackup_out.txt and when querying the databsae_snapshots table , it just hangs with no results . 

 

what could be the issue 

2 replies

Rahul_Choudhary
Forum|alt.badge.img
  • Participating Frequently
  • June 20, 2016

Hi 

 

Can you share the backup (vbr.py) log to look into as to what have caused this immature backup process termination?

 

 

Thanks

Rahul


HadyZ
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • June 20, 2016

thats the backupdev.ini file 

 

snapshotName = BackupDev
restorePointLimit = 1
passwordFile = Bkppass

[Database]
dbName = verticadst
dbUser = dbadmin

[Transmission]

[Mapping]
v_verticadst_node0001 = 172.16.17.28:/backup
v_verticadst_node0002 = 172.16.17.29:/backup
v_verticadst_node0003 = 172.16.17.30:/backup

 

i dont see any log file in /tmp/vbr 

only these files . 

-rw-r--r-- 1 dbadmin verticadba 352 Jun 19 00:56 BackupDev.info
-rw-r--r-- 1 dbadmin verticadba 289 May 28 12:46 BackupDev.ini
-rw-r----- 1 dbadmin verticadba 957 Jun 19 05:03 BackupDev.txt
-rw------- 1 dbadmin verticadba 34 May 28 06:54 Bkppass
-rwxr-xr-x 1 dbadmin verticadba 164579 Jun 19 00:56 vbr.py