Failed - Appliance gateway database upgrade from 10.0 to 10.1 running long and communications link failure

Products

• CA Mobile API Gateway

Issue/Introduction

When upgrading the gateway version from 10.0 to 10.1 

We successfully uploaded and installed the 10.1 Platform and Application patches, but during Gateway embedded DB upgrade from 10.0 to 10.1 via SSG menu encountered an issue with as it took more than an hour and half to complete the task and resulted a communication error.

Environment

Release : 7.1

Resolution

Command

SELECT table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` from information_schema.TABLES  WHERE table_schema = "ssg" ORDER BY (data_length + index_length) DESC limit 10;

Showed counters to be a high data table largest usage. Counters is used by apply throughput quota assertion.

You can selectively delete by reviewing below.

this query should do a select,

NOTE:  <value> in below needs to be populated. SEE BELOW!

SELECT COUNT(*) FROM ssg.counters WHERE last_update <= ((unix_timestamp(curtime()) * 1000)-<value?>);

Delete

DELETE FROM ssg.counters WHERE last_update <= ((unix_timestamp(curtime()) * 1000)-<value>);

Where <value> is the milliseconds you want to delete.

I.e. if you use 7776000000 

This is basically anything older then 3 months.

like,

DELETE FROM ssg.counters WHERE last_update <= ((unix_timestamp(curtime()) * 1000)-7776000000);

But you may want to make this much more aggressive