Gateway Time-Out when syncing database

Anvil Q&A
1

I need to synchronize my production database with my latest changes. I entered the “Data” section, and found the table to sync. It is just add one simple bool field that is defined in my app schema, and migrate it to the real database, so it is definitely not a big task.

However, every time I try to do it, after waiting for a while, I am getting this error message:

gateway-time-out
gateway-time-out700×208 7.55 KB

Now, I have a published application in production, but I am unable to add a simple bool field to one of my tables.

What could I do to solve this problem? It doesn’t seen something I can do personally, as it looks like a platform problem :frowning:

2

What is “it” that you are trying to do?

3

I try to synchronize the table, adding the boolean field from the app specs into the real database.

4

How do you do that?
Do you open the table in the UI and add a column?
Or do you use the migration tool?

5

Hi folks,

Two updates here:

  1. @renne’s table migration was adding a column to a large table, and the HTTP request was timing out before the process completed, even though the update was continuing in the background. This is a bumpy UX and we have ideas on how to improve it.

  2. This issue coincided with (and was possibly precipitated by) an AWS/hardware failure on the dedicated server @renne’s app was using. This was resolved and communicated by email long before I saw this thread.

3 Likes