Network Management

Reply
Moderator

AirWave 8.0.10 now available. Upgrade has a database bloat check.

AirWave 8.0.10 is now available for download from the support site. Link to support site

 

New in AirWave 8.0.10 is a check for bloated database tables. This check happens early in the upgrade process, and will not proceed if there are any bloated tables.

Please open a support case if you run into the following output during the upgrade:
-----
[root@localhost mercury]# start_amp_upgrade -v 8.0.20151208.1147
Directory not specified; using /root.
Upgrade script found in local cache.
Upgrade package found in local cache.
Upgrade package found in local cache.
******************************************************************

Database tables need vacuuming before you can proceed with upgrade

******************************************************************
Upgrade aborted.
Please contact Aruba Networks Support at
1-800-WiFi-LAN or support@arubanetworks.com
[root@localhost mercury]#
----- 

 

Attached are the release notes for AirWave 8.0.10.


Rob Gin
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company

Re: AirWave 8.0.10 now available. Upgrade has a database bloat check.

Thnaks Rob, finally have
"AirWave now calculates the uptime of a device based on the actual uptime of the device, not just the time
that the device is connected to the AMP."

Would still love to see a time-stamp report of when a device went down and came back up.
Feature request was added to the portal a while back ;)
Pasquale Monardo | Senior Network Solutions Consultant
ACDX #420 | ACMP
[If you found my post helpful, please give kudos!]
Occasional Contributor I

Re: AirWave 8.0.10 now available. Upgrade has a database bloat check.

I just performed an upgrade from 8.0.8.1 to 8.0.10.  According to the release notes it is bundled with CentOS 6.6, but I am still seeing OS version of 6.2.  I did perform the command that was specified at the end and rebooted.  Is the 6.6 only for new installations, or did I miss a step?

Re: AirWave 8.0.10 now available. Upgrade has a database bloat check.

New installations afaik
Pasquale Monardo | Senior Network Solutions Consultant
ACDX #420 | ACMP
[If you found my post helpful, please give kudos!]
New Contributor

Re: AirWave 8.0.10 now available. Upgrade has a database bloat check.

I tried the process in the following article and was able to vaccum database and upgrade successfully.

 

To vacuum/reindex please run the following commands on AMP CLI :

1. Disable AMP:
# amp_disable

2. Prior to running each db command below (reindex and vacuum) stop and restart the postgres database using the commands:
# service postgresql stop
# service postgresql start
This will remove any queued up nightly jobs and allow the reindex and vacuum jobs to proceed with without waiting in the queue.

2a. If you are a super user for postgres then :
#db
airwave=> reindex database airwave
airwave=> vacuum full analyze

2b. For normal root login users, run the following commands:
AMP Version < 7.3
# /opt/airwave/bin/reindexdb -d airwave -Upostgres
# /opt/airwave/bin/vacuumdb -v -f -z -Upostgres airwave
AMP Version >= 7.3
# /opt/airwave/pgsql/bin/reindexdb -d airwave -Upostgres
# /opt/airwave/pgsql/bin/vacuumdb -v -f -z -Upostgres airwave

2c. or you can also run these for normal root login users :

# psql -Upostgres airwave
psql (8.4.4)
Type "help" for help.

airwave=# reindex database airwave;
REINDEX
airwave=# vacuum full analyze;
VACUUM
airwave=#

3. Enable AMP bye :
# amp_enable

 

Ref: http://www.airheads.eu/t5/Monitoring-Management-Location/Vacuum-Reindex-in-AMP/ta-p/177274

 

MVP

Re: AirWave 8.0.10 now available. Upgrade has a database bloat check.

The linked article on vacuuming has some AMP version specific commands.

Is that "safe" for general use?

I'd feel nervous aobut following it unless AMP-Engineers had blessed it or extended it for the current version.

 

I've got the "needs vacuuming" message from AMP_upgrade, so I'm currently awaiting a callback from TAC with instructions. (I'm also backing up my AMP database before anything happens)

--Matthew

if I've helped, please give kudos
if I've provided a solution, please mark the solution so others can find it
Moderator

Re: AirWave 8.0.10 now available. Upgrade has a database bloat check.

The support team has a script that targets only the bloated tables.  Running vacuums on all tables is generally not needed.


Rob Gin
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company

Re: AirWave 8.0.10 now available. Upgrade has a database bloat check.

There is no way to revert so have to call in, in order for TAC to run the scripts correct?

When I say revert, I don't mean, re-install with the previous version and restore backup..
Pasquale Monardo | Senior Network Solutions Consultant
ACDX #420 | ACMP
[If you found my post helpful, please give kudos!]
Moderator

Re: AirWave 8.0.10 now available. Upgrade has a database bloat check.

The database bloat check is pre-upgrade.  So your version shouldn't have changed if the check failed.


Rob Gin
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company

Re: AirWave 8.0.10 now available. Upgrade has a database bloat check.

Awesome.
Pasquale Monardo | Senior Network Solutions Consultant
ACDX #420 | ACMP
[If you found my post helpful, please give kudos!]
Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: