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

**URL:** <https://forum.inductiveautomation.com/t/store-and-forward-local-cache-record-size-is-increasing-no-data-in-db-or-errors/67312>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [December 6, 2022, 11:13pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-local-cache-record-size-is-increasing-no-data-in-db-or-errors/67312 "2022-12-06T23:13:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![user5](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/user5/32/39393_2.png) [@user5](https://forum.inductiveautomation.com/u/user5)\
**Post date:** [December 6, 2022, 11:13pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-local-cache-record-size-is-increasing-no-data-in-db-or-errors/67312/1 "2022-12-06T23:13:40Z")

</div>

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?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/7/f7fbafc491bc3963be7a5f3366c6f93d9071e1fc.png)

---

<div class="post-metadata">

**Author:** ![user5](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/user5/32/39393_2.png) [@user5](https://forum.inductiveautomation.com/u/user5)\
**Post date:** [December 6, 2022, 11:22pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-local-cache-record-size-is-increasing-no-data-in-db-or-errors/67312/2 "2022-12-06T23:22:50Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![user5](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/user5/32/39393_2.png) [@user5](https://forum.inductiveautomation.com/u/user5)\
**Post date:** [December 6, 2022, 11:27pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-local-cache-record-size-is-increasing-no-data-in-db-or-errors/67312/3 "2022-12-06T23:27:54Z")

</div>

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