There are too many old session maps/defect partitions and APM is not removing them. What should be done to resolve this?

Document ID : KB000020598
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

There are too many ts_us_sessions_map and defect table partitions. How can these be removed?

Solution:

The Collector is keeping old hourly ts_us_sessions_map table partitions and 'ts_defects' table partitions. This occurs when defect aggregation is behind or not running, then the defect and session map partitions are not dropped.

To resolve this, manually drop the unneeded partitions.

Determine the partitions to drop by running this query:

select tablename from pg_tables where tablename like 'ts_%' order by tablename ;

Then do the following sequence:

  1. Backup the APM Database using Introscope's database backup script located in <EM home>/install/database-scripts/<os>/dbbackup-postgres (for Postgres) or for Oracle, use Oracle's built in utility. (important!!!)

  2. Stop all EMs running APM CE Services

  3. Run the sql commands to drop the unneeded tables such as drop ts_defects_date or ts_us_sessions_map_date ;

  4. Restart all EMs running APM CE Services

  5. Generate Defects

  6. Validate in logs and APM GUI seeing defects and session maps

Note that in 9.5.1, there is a fix for too many old defect or stats partitions - (TT 85377). This fix drops session maps and defect partitions older than 60 days.