Question: What needs to be done when the Airwave upgrade to 8.0.1 fails
Environment Information: Airwave version: 8.0.1
Symptoms: We can see the below message under the upgrade logs,
insert() - DBD::Pg::st execute failed: ERROR: null value in column "organization" violates not-null constraint
DETAIL: Failing row contains (3, --- Begin AirWave License Key ---
Order: 5276061
Product: AMP
Pa..., null, AMP, AW-200, 200, 1410826182, 1406938182, W0000035274, null, null). [for Statement "INSERT INTO license
(
id,
aps,
product,
organization,
package,
mac,
generated,
raw_license,
serial,
expires,
ip_address
)
VALUES
(
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?
)" with ParamValues: 1='3', 2='200', 3='AMP', 4=undef, 5='AW-200', 6=undef, 7='1406938182', 8='--- Begin AirWave License Key ---
Order: 5276061
Product: AMP
Package: AW-200
APs: 200
RAPIDS: Yes
VisualRF: Yes
Expires: 1410826182
Expires_on: Tue Sep 16 00:09:42 2014
Serial: W0000035274
Generated: Sat Aug 2 00:09:42 2014 UTC
Certificate_ID: 5276061-35274-QQ235
--- Signature ---
iD8DBQFT3CxGvN8PdJTKS2ERAkIVAJ0YjcsBSIBl70ZiWrtu430cN2W+YACfS0jA
x3Ud+ZpBZjCFipMTbHJtWB8=
=6ucd
--- End AirWave License Key ---
', 9='W0000035274', 10='1410826182', 11=undef] at /usr/local/airwave/lib/perl/Mercury/DB/Q/st.pm line 20.
at /opt/airwave/local/lib/perl5/site_perl/5.10.0/Rose/DB/Object.pm line 1177
Rose::DB::Object::insert('Mercury::DB::License=HASH(0x1e81f8c8)') called at /opt/airwave/local/lib/perl5/site_perl/5.10.0/Rose/DB/Object.pm line 632
Rose::DB::Object::save('Mercury::DB::License=HASH(0x1e81f8c8)') called at /usr/local/airwave/lib/perl/Mercury/DB/RoseTableRow.pm line 568
Mercury::DB::RoseTableRow::create('Mercury::DB::License', 'raw_license', '--- Begin AirWave License Key ---\x{a}Order: 5276061\x{a}Product: AMP...', 'generated', 1406938182, 'organization', undef, 'product', 'AMP', ...) called at /usr/local/airwave/lib/perl/Mercury/Licensing/Single.pm line 310
Mercury::Licensing::Single::save('Mercury::Licensing::Single=HASH(0x1e957b00)') called at /usr/local/airwave/lib/perl/Mercury/Scripts/SafeMigration.pm line 463
Mercury::Scripts::SafeMigration::__ANON__() called at /usr/local/airwave/lib/perl/Mercury/Scripts/SafeMigration.pm line 490
Mercury::Scripts::SafeMigration::go('Mercury::Scripts::SafeMigration') called at -e line 1
make[1]: *** [mercury_safe_migration] Error 255
make[1]: Leaving directory `/root/svn/mercury'
make: *** [upgrade] Error 2
make: Leaving directory `/root/svn/mercury'
Stopping Pound: [60G[[0;32m OK [0;39m]
Stopping httpd: [60G[[0;32m OK [0;39m]
tsdb-server: unrecognized service
beam.erl: no process killed
Cause: This is happening as the provided license key does not have "organization" column specified.
Resolution: We can follow the below steps to resolve this issue,
Delete the license key from the path /var/airwave/license
# cd /var/airwave/license
# rm -f license.txt
Once the license key is removed we can cleared the failed migration job by executing the below command,
# dbc "delete from migration_job;"
Now we can recompile the script
# screen
# root
# make
Once the "make" completes successfully we can re add the license key from the web interface of Airwave.