DB table getting out of sync

💬 Queries and Resources
1

i have an app using the retool database and for some reason it appears the Postgres Sequence for my main data table gets out of sync with recent commits. This then silently prevents the bulk insert operations I have after the sequence gets out of sync. Somehow i belong to more than 1 organization when i login it asks me... only thing I can think of is somehow there are 2 dbs? I have never come accross this using a DB before

2

Hey @jmjava,

Thanks for joining our builder talks! :slightly_smiling_face:

I am splitting this out as a separate topic because this particular question might require a bit more information. We have office hours in ~8 minutes on Discord Office Hours if you want to discuss it live with our team and community

If you can't join office hours, are you able to share screenshots of your database process/queries?

3

oh wow that sounds great. I am on my work machine but if absolutely needed i could switch over to my lab PC

4

Hey @jmjava,

Thanks for joining the past two office hours! :slightly_smiling_face:

It sounds like this is in a good state - though we're not necessarily sure why the behavior changed :thinking: Please reach out again if you notice anything unexpected

For anyone following along here's some of the topics we discussed in office hours:

  • First, it is very easy to find yourself in multiple Retool accounts (multiple organizations per a single email address). For Cloud accounts, if you own the Retool organization and no longer need it, you can manually sign in and archive it. If you want to leave someone else's Cloud org, you can archive your own account.
  • We talked about running queries the in app editor vs the end user mode. Both should present the same behavior. It's possible you'll see slightly degraded performance in the editor compared to end user mode, but the functionality should be equivalent
  • If you think your app has a race condition, it could make sense to test converting any JS transformers to JS queries so that you can control when the JS is evaluated.
1 Like
5

Thanks again Tess!!! Good summary! Appreciate the help and advice!

1 Like