Store and Forward local cache record size is increasing, no data in DB or errors

We have setup up memory buffer size to 250,
store

  • max record 35000,
  • write size 25
  • write time 5000
    forward
  • write size 25
  • write time 1000
    But for about last one hour, database storage is showing idle as local cache kept going up and no data in DB.
    I do not see any errors in logs also.

What should I look for to see why it is not forwarding to database?

Looks like there was an active insert query that was stuck for 2 hours causing others to queue behind it. I canceled it and now all good.

My team mate resaved all DB configurations, being remote we were working in parallel. Now we don't know which action fixed the issue!