Retool Upgrade issue

💬 Self Hosted Retool
1
  1. My goal: Upgrade Retool Self-Hosted from version 3.114.28-stable to 3.148.32-stable.
  2. Issue: Error running database migrations add-secrets-rotation-run-state-colum-to-users-table.js: failed to find parent tuple for heap-only tuple (3, 7) in table "users".
  3. Retool version & hosting setup (Docker, K8s, cloud provider, etc.): I am using GKE and Kubernetes kustomization for deployments.
2

The main retool container fail to start because of a database migration issue.

3

FYI: @stefancvrkotic

4

Are you still having issues upgrading to 3.148, @Marcus_Santos? Previous users that have run into something similar were able to resolve it by going through the following:

  1. Take a backup of the current db
  2. Inspect your users table for duplicate rows w/ the same primary key
  3. If you find a duplicate, use the commands similar to this post to delete the offending row (in your case it's likely the tuple 3,7 )
  4. Run the VACUUM and REINDEX
5

Do you still need any assistance with this, @Marcus_Santos?