I am attempting to migrate my retool db schema from staging to production.
The schema diff is showing everything correctly, (1 table modified with new field, 1 new table and 3 enums for use in that table) but when I hit migrate the diff disappears and there is no error or confirmation of any type.
There is no evidence in the history of the attempt to migrate at all.
Console shows a 403
I have tried logging out and back in again, and have also invalidated all sessions and logged back in again. No difference.
Any suggestions welcome, as I am loathe to have to recreate all the changes manually in prod.
+1, this is a pretty bad silent failure. No way to tell what's happening aside from the network tab of the browser. Seems like it's a retool issue more than a code issue
Hi all - thanks for reaching out and for reporting this.
We recently pushed out an update that restricted the ability to run migrations to users with Own level permissions on the RetoolDB resource, which has always been the intended functionality. That said, it looks like there is an issue where even some resource owners are being denied access. We've reproduced the issue and are investigating right now!
I definitely recommend double checking your user permissions, but understand that some of you may still be stuck. I'll provide an update here as soon as there is news to share.
I posted this elsewhere, but will include an update here as well.
We have a temporary fix planned that will explicitly allow org admins to run migrations. I'll let you know when it ships, but you can expect it before the end of the week. Let me know if you have any additional questions!
The fix I mentioned above is live on the Cloud as of version 3.197! Note that this only applies to org admins, so it isn't a perfect solution but should unblock the majority of users. Let us know if you notice any additional issues!
