Nothing is displayed in AMC - able to access records when using Studio
Root cause
There are too many records in AMC.
Solution or Workaround
Create Index on AMC tables:
create index moment_pid_rootpid_fatherpid_project_job on talend_amc.LOG_logcatcher (moment, pid, root_pid, father_pid, project, job);
create index moment_pid_fatherpid_rootpid_systempid_project_job on talend_amc.LOG_metercatcher (moment,pid,father_pid,root_pid,system_pid,project,job);
create index moment_pid_fatherpid_rootpid_systempid_project_job on talend_amc.LOG_statcatcher (moment,pid,father_pid,root_pid,system_pid,project,job);
Delete old history:
selected_date = 'date selected from statcatcher table', the message_type in the selected record must be ‘end’
selected_pid = the pid in the selected record
delete from statcatcher where moment <= 'selected_date'
delete from logcatcher where moment <= 'selected_date'
delete from flowmetercatcher where moment <= 'selected_date'
To avoid orphaned records, delete records with the selected_pid
delete from statcatcher where pid = 'selected_pid'
delete from logcatcher where pid = 'selected_pid'
delete from flowmetercatcher where pid = 'selected_pid'
