Offline changes keep applying

We have a time tracking application that's used by most of our employees on a daily basis, and in the last week or so started noticing odd time entries for a few of our users. After initially assuming it was something on their mobile device, this week it has grown to many users across iOS ad Android devices. I spent some time testing today and I believe I have it narrowed down to Offline changes that sync successfully, but don't 'clear' after the sync, so on the next Retool app launch they sync again.

My steps to re-create the problem:

  1. Open the app within Retool Mobile, flip the phone to airplane mode so I can generate an Offline query, perform and action that runs a query. (Offline Manager will now show 1 Change pending)
  2. Kill the Retool mobile app
  3. Turn off Airplane mode, and bring the phone back online
  4. Launch Retool Mobile and Offline Manager will show 1 pending change
  5. Open the application, and the pending change will apply. Continue to use the application normally, and everything seems fine.
    All items/steps up to this point seem fine, and appear to be working as designed. However...
  6. Kill the Retool mobile app
  7. Re-launch Retool Mobile, and the notice for 1 Pending Change appears again.
  8. Open the app within Retool Mobile, and the Pending Change applies AGAIN.

From there, it appears you can loop through steps 6 - 8 above, and the Pending Change will keep reapplying each time the Retool Mobile app is launched. In our app the change includes a timestamp, so I know it's pushing the initially cached change, and not a new one.

If I manually go into the Offline Manager upon initial launch of the Retool Mobile app, I can select Remove on the pending change, and the process/loop stops. This makes me think the pending changes aren't getting cleared/completed properly, so they continue to re-appear in the Offline Manager.

Anyone seeing similar behavior?
Appreciate any help!

1 Like

Hi Matt,
I do confirm that i'm also struggling with the same issue, for about 2 or 3 weeks.
The offline queries keep re sync while retool app is reopened.
Apparently this trouble happens on version 3.168.
I've contacted the support team, which id currently dealing with it, so retool is aware of this issue.

Alex.

Thank you, @Alex_k! and thank you, @Matt_N for your detailed report. When we have an update we'll share it here too

1 Like

Hi @Tess,
We’re experiencing this issue as well, and it’s causing a significant problem on our end with duplicate entries in the database. The synced changes appear to reapply every time the app restarts, even after the initial sync has successfully gone through. This loop only stops if we manually clear the app storage, which is not a sustainable workaround.

Really hoping for a fix soon—thanks to the team for looking into it!

Hi there,

I just checked in, and it sounds like we have a fix ready :blush: It will go out in the next app update (3.185)

1 Like

Looking forward to it - thanks for the update @Tess!

Hi @Tess,

Do you have an ETA of when the issue will be fixed please ? It is currently still affecting our devices on iOS.

Thank you,

Hi @Tess,
I test the app today with the last version (3.191.1) and i have always the bug.

Hi folks,

Thanks for checking in. It looks like the bug fix for this is delayed due to another issue affecting mobile users. I will let you know when I have an updated ETA for this bug

The fix is out for Android & iOS (latest version 3.194). Please let me know if you see any issues once confirming you're on the latest version (find the version on Settings->About in the app)

2 Likes

Thanks @Tess and Retool Team! I updated to 3.194 (iOS), and after a couple quick tests it appears the offline changes are clearing properly now.

1 Like

Glad to hear! :raised_hands: