[1.7.8] No activities after small load (~80000 messages in 20hours)

(Migrated from https://github.com/syndesisio/syndesis/issues/6052)

Author: *Matej Melko *
Assignees: Zoran Regvart,

This is a...

[pre][code]
[ ] Feature request
[ ] Regression (a behavior that used to work and stopped working in a new release)
[x] Bug report [!-- Please search GitHub for a similar issue or PR before submitting --]
[ ] Documentation issue or request
[/code][/pre]

Description

After putting some small load (~3 messages /s ) for couple of hours no activities are listed in integrations. I hit this also on i-dev cluster and openshift pro.
!screenshot_20190703_111436

GET https://syndesis-test.b6ff.rh-idev.openshiftapps.com/api/v1/activity/integrations/i-LilthRWl7ZNNJJhTBQNz

results in

504 Gateway timeout

. Looks like connection to DB is really slow.

There is

syndesis-test

project on i-dev cluster that can be used for investigation.