Question

Schedule nsight database backup fail

  • 18 January 2019
  • 11 replies
  • 336 views

Userlevel 1
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

11 replies

Userlevel 3
Hi Romain,

Technically that is a true statement.
Engineering even on your current version of code will not support those 2 model APs.
Note:
5.9.2 no longer has software for those 2 APs, but thankfully you can go to 5.9.1.5 on WiNG and still adopt those model APs with the VX9000.
That still puts you in a better position with Nsight server though its not 5.9.2.x.
Userlevel 1
Thank you Daren,

I will plan to upgrade to 5.9.1.5. I will see if my issue still occurs or not. If it is, I will try to get the "show database backup-status detail " information.
Userlevel 1
Hi Daren,

I'm currently upgrading all the wireless infrastructure to version 5.9.1.5-001R.
I'll be back when the upgrade will be done.
Userlevel 1
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.
Userlevel 1
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.
Userlevel 1
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#
Userlevel 1
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.
Userlevel 3
Hi Romain

Can you send me the output from the following command?
"show database backup-status detail"
Userlevel 1
Hi Daren,

I can't call this command. Are you sure it exists ?
Here is the possible completion I have :
code:
nsight#show database ?
keyfile Keyfile
statistics Statistics
status Status
Userlevel 3
Hi Romain,

That command might not be available in older code.
Newer versions of Nsight provides a lot of improvement.
Note: I am running 5.9.3.x
Is it possible to upgrade Nsight and WiNG infrastructure to at lease 5.9.2.x?
Userlevel 1
Hi Daren,

I have several AP8222 and Ap650 still running on my network and all others are AP7532 or AP7562. It seems that AP650 and AP8222 are no longer supported in version 5.9.x, am I right ?

My partner told me that the VX9000 hosting the nsight (in standalone mode) must run in the same version as the VX9000 controling the APs. Is this true ?

Depending of those two question I should upgrade or not.

The replacement of the AP8222 and AP650 is planned for this year but it will take few months.

Reply