Monitoring, Management & Location Tracking

 View Only
last person joined: one year ago 

Articles relating to existing and legacy HPE Aruba Networking products and solutions including AirWave, Meridian Apps, ALE, Central / HPE Aruba Networking Central, and UXI / HPE Aruba Networking User Experience Insight
Back to Library

Error while upgrading Master Console to 6.1 

Jun 09, 2014 12:44 PM

It's possible to get an error like the one below when you're upgrading MC to 6.1.0 or 6.1.1 (a fix exists in 6.1.2). If you see this error, you can finish the upgrade wtih these 2 commands:

# echo "delete from mc_ap_search_results" | db
# root; make

There is absolutely no risk in running these commands, even on a regular AMP. 

This is the error:

ERROR: invalid input syntax for integer: "-": update mc_ap_search_results set ap_sysuptime = cast(device_config_uptime as bigint) () at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 191
Mercury::DB::Q::execute('Mercury::DB::Q', 'update mc_ap_search_results set ap_sysuptime = cast(device_co...') called at /usr/local/airwave/lib/perl/Mercury/UpdateDB/1218756157.pmline 82
Mercury::UpdateDB::1218756157::action('Mercury::UpdateDB::1218756157') called at /usr/local/airwave/lib/perl/Mercury/UpdateDB/Base.pm line 32
Mercury::UpdateDB::Base::__ANON__() called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 651
Mercury::Utility::ChangeDB::__ANON__() called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 528
Mercury::Utility::ChangeDB::modify_database('CODE(0xa4f9314)', 'CODE(0xa4f9394)') called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 654
Mercury::Utility::ChangeDB::_schema_change('Change device_config_uptime to ap_sysuptime in ap_list_cache', 'CODE(0xa7237a4)') called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 607
Mercury::Utility::ChangeDB::__ANON__() called at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 318
eval {...} called at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 317
Mercury::DB::Q::_run_then_do('Mercury::DB::Q', 'CODE(0xa4f9224)', 'CODE(0xa4f92a4)') called at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 289
Mercury::DB::Q::run_in_transaction('Mercury::DB::Q', 'CODE(0xa4f9224)') called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 608
Mercury::Utility::ChangeDB::schema_change('Change device_config_uptime to ap_sysuptime in ap_list_cache', 'CODE(0xa7237a4)') called at bin/update_db.pl line 53
at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 325
Mercury::DB::Q::_run_then_do('Mercury::DB::Q', 'CODE(0xa4f9224)', 'CODE(0xa4f92a4)') called at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 289
Mercury::DB::Q::run_in_transaction('Mercury::DB::Q', 'CODE(0xa4f9224)') called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 608
Mercury::Utility::ChangeDB::schema_change('Change device_config_uptime to ap_sysuptime in ap_list_cache', 'CODE(0xa7237a4)') called at bin/update_db.pl line 53
make: *** [updatedb] Error 255
It's possible to get an error like the one below when you're upgrading MC to 6.1.0 or 6.1.1 (a fix exists in 6.1.2). If you see this error, you can finish the upgrade wtih these 2 commands:

# echo "delete from mc_ap_search_results" | db
# root; make

There is absolutely no risk in running these commands, even on a regular AMP. 

This is the error:

ERROR: invalid input syntax for integer: "-": update mc_ap_search_results set ap_sysuptime = cast(device_config_uptime as bigint) () at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 191
Mercury::DB::Q::execute('Mercury::DB::Q', 'update mc_ap_search_results set ap_sysuptime = cast(device_co...') called at /usr/local/airwave/lib/perl/Mercury/UpdateDB/1218756157.pmline 82
Mercury::UpdateDB::1218756157::action('Mercury::UpdateDB::1218756157') called at /usr/local/airwave/lib/perl/Mercury/UpdateDB/Base.pm line 32
Mercury::UpdateDB::Base::__ANON__() called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 651
Mercury::Utility::ChangeDB::__ANON__() called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 528
Mercury::Utility::ChangeDB::modify_database('CODE(0xa4f9314)', 'CODE(0xa4f9394)') called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 654
Mercury::Utility::ChangeDB::_schema_change('Change device_config_uptime to ap_sysuptime in ap_list_cache', 'CODE(0xa7237a4)') called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 607
Mercury::Utility::ChangeDB::__ANON__() called at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 318
eval {...} called at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 317
Mercury::DB::Q::_run_then_do('Mercury::DB::Q', 'CODE(0xa4f9224)', 'CODE(0xa4f92a4)') called at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 289
Mercury::DB::Q::run_in_transaction('Mercury::DB::Q', 'CODE(0xa4f9224)') called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 608
Mercury::Utility::ChangeDB::schema_change('Change device_config_uptime to ap_sysuptime in ap_list_cache', 'CODE(0xa7237a4)') called at bin/update_db.pl line 53
at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 325
Mercury::DB::Q::_run_then_do('Mercury::DB::Q', 'CODE(0xa4f9224)', 'CODE(0xa4f92a4)') called at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 289
Mercury::DB::Q::run_in_transaction('Mercury::DB::Q', 'CODE(0xa4f9224)') called at /usr/local/airwave/lib/perl/Mercury/Utility/ChangeDB.pm line 608
Mercury::Utility::ChangeDB::schema_change('Change device_config_uptime to ap_sysuptime in ap_list_cache', 'CODE(0xa7237a4)') called at bin/update_db.pl line 53
make: *** [updatedb] Error 255


#AP-300
#AP325

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.