Monitoring, Management & Location Tracking

Error while upgrading Master Console to 6.1

Aruba Employee

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

Version history
Revision #:
1 of 1
Last update:
‎06-09-2014 09:44 AM
Updated by:
 
Labels (1)
Contributors
Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: 
Is this a frequent problem?

Request an official Aruba knowledge base article to be written by our experts.