Unable to Purge appmap_states tables

Document ID : KB000044847
Last Modified Date : 16/08/2018
Show Technical Document Details
Introduction:

 

 

Problem: 

The Enterprise Manager is supposed to purge the appmap_states_ddmmyyyy tables automatically and the frequency of this purging is controlled by the property introscope.apm.data.preserving.time. However due to a problem in 10.0 and 10.1 this does not occur and you may see the message in the console output from the Enterprise Manager

INFO | jvm 1 | 2016/04/19 12:14:14 | org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [DROP TABLE appmap_states_20160217]; SQL state [25006]; error code [0]; ERROR: cannot execute DROP TABLE in a read-only transaction; nested exception is org.postgresql.util.PSQLException: ERROR: cannot execute DROP TABLE in a read-only transaction

This problem could result in excessive space being using in the APM database.

Environment:  

APM 10.0 and 10.1 (Postgres or Oracle)

Workaround:

Manually drop the tables e.g.

DROP TABLE appmap_states_20160217

Additional Information:

This problem is addressed in 10.2.0.23 and later releases

Instructions:
Please Update This Required Field