[Bug]: Cache issue causes AppSmith to function and render UI incorrectly

[Yacubane]

Is there an existing issue for this?

• I have searched the existing issues

Description

Sometimes, AppSmith does not display UI correctly and does not invoke scripts:

• Button not displayed correctly (should be filled):

• Scripts aren't invoked:

After clearing web cache problem is fixed. I tried to investigate which part of cache is causing problems and I figured out that part of IndexedDB cache is causing that issue. More specifically it's IndexedDB > AppComputationCache > cachedResults. After clearing cachedResults and refreshing the web page everything is okay.

We managed to dump such cache before and after clearing it. The cache before clearing (with broken app) is much smaller (around 3x in our case) than after clearing cache and refreshing the website. This suggest that cache might be missing some elements. I haven't tried to compare cache keys one-by-one.

We also noticed that this bug can appear in any app.

As temporary solution we provided users with dedicated AppSmith app that can clear cachedResults.

Steps To Reproduce

Unfortunately we haven't figured out yet. Bug can appear in few hours or after many days.

Public Sample App

No response

Environment

Production

Severity

High (Blocker to building or releasing)

Issue video log

No response

Version

Self Hosted – v1.6.6

[pzhang-gopuff]

+1. We saw a similar issue in our app

[db-nfwf]

v1.71 Confirmed this is a problem for us on prem. Deleting the cachedResults does fix the issue temporarily. Is a blocker for users.

[yalhyane]

+1. we have a similar issue in our app