topic Re: Schedule nsight database backup fail in ExtremeWireless (WiNG)

Schedule nsight database backup fail

Romain_Mercier — Fri, 18 Jan 2019 15:40:49 GMT

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

Re: Schedule nsight database backup fail

Daren_E — Sat, 19 Jan 2019 00:53:50 GMT

Hi Romain

Can you send me the output from the following command?
"show database backup-status detail"

Re: Schedule nsight database backup fail

Romain_Mercier — Tue, 22 Jan 2019 23:47:24 GMT

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

Re: Schedule nsight database backup fail

Daren_E — Wed, 23 Jan 2019 00:05:18 GMT

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?

Re: Schedule nsight database backup fail

Romain_Mercier — Wed, 23 Jan 2019 17:15:18 GMT

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.

Re: Schedule nsight database backup fail

Daren_E — Wed, 23 Jan 2019 22:57:42 GMT

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.

Re: Schedule nsight database backup fail

Romain_Mercier — Tue, 29 Jan 2019 22:45:12 GMT

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.

Re: Schedule nsight database backup fail

Romain_Mercier — Tue, 19 Feb 2019 18:51:58 GMT

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.

Re: Schedule nsight database backup fail

Romain_Mercier — Tue, 19 Feb 2019 22:30:35 GMT

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.

Re: Schedule nsight database backup fail

Romain_Mercier — Wed, 20 Feb 2019 14:47:13 GMT

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.

Re: Schedule nsight database backup fail

Romain_Mercier — Wed, 20 Feb 2019 15:01:53 GMT

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#

Re: Schedule nsight database backup fail

Romain_Mercier — Thu, 21 Feb 2019 17:14:49 GMT

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.