Schedule nsight database backup fail

[Romain_Mercier]

Hi community,

I'm trying to schedule a backup of my nsight's database.
I added the following configuration to the nsight server configuration :

code:

database backup database nsight sftp://mylogin:mypass@myserver.domain/nsight-db/ start-date 12/21/2018 start-time 08:15 reoccurrence 168

But each time it is executed, it fails about 3 hours later with the message "scheduled backup for database nsight unsuccessful". I tried adding a filename at the end of the destination of backup but it fails with the same message.

If I execute a one-time backup with the command

code:

database-backup database nsight sftp://mylogin:mypass@myserver.domain/nsight-db/backup.tar.gz

I receive a file named backup.tar.gz of about 7.9GB so I conclued that there is no problem for the nsight server to connect to my server and store the backup.

For information, I'm using a VX9000 version 5.8.6.7-002R

Anyone has an idea on what's wrong ?

Regards,
Romain

[Romain_Mercier]

The backup ended at 20:04

Date :2019-02-20 20:04:12
Device :nsight
Description :backup for database nsight successful

About 12h17min to backup 14GB (size of the archive).

I don't know why the scheduled backup doesn't work.

[Romain_Mercier]

It seems that the full backup is processing :

code:

nsight#sh database backup-status detail
Last Database Backup Status : In_Progress(Starting database mart backup using sftp)
Last Database Backup Time   : 2019-02-20 07:47:56
-----------------------------------------------
Starting database mart backup using sftp

nsight#

[Romain_Mercier]

The scheduled backup failed and i received an email last night at 3:37 indicating the failure :

Date :https://about:blank:37:43
Device :nsight
Description :scheduled backup for database nsight unsuccessful

This morning I executed a one-time backup of placement info only and it ends succesfully in about 15 seconds. Here is the mail I received :

Date :https://about:blank:37:43
Device :nsight
Description :backup for database nsight-placement-info successful

During the process :

code:

nsight#sh database backup-status
Last Database Backup Status : In_Progress(Backing up: mart dev_placement)
Last Database Backup Time   : 2019-02-20 07:37:28
nsight#sh database backup-status
Last Database Backup Status : Successful
Last Database Backup Time   : Wed Feb 20 07:37:41 GMT+1 2019
nsight#

I will try a full one-time backup.

[Romain_Mercier]

All devices are now running version 5.9.1.5-001R.

I planned database backup in the configuration of the vx use as nsight (standalone) :
database backup database nsight sftp://configbackup:yaTSUC6CJeYmpubGKs4P@netgedor.uang/nsight-db/ start-date 02/19/2019 start-time 14:45 reoccurrence 168
I commited this configuration at 14:30 on today (02/19/2019, time of Paris, FR)
Now, it's 15:20 and here is the output of sh database backup-status detail :

code:

nsight#sh database backup-status detail
Last Database Backup Status : Failed(Starting backup of mart ...)
Last Database Backup Time   : 2019-02-19 14:07:08
-----------------------------------------------
Starting backup of mart ...

nsight#

The "last Database Backup Time" seems to be the reboot time after upgrade
On previous version, database backup took around 4 hours to achieve.
I'm waiting for the end of the operations.