I know there are plenty of other topics with the same error, but none that I found shared a cause…
Expected behavior
Expect (any) data to load.
Actual behavior
Consistently receiving this message on every table:
To eliminate the possibility of a UI error, I copied the offending request into Postman and it’s still failing. Ultimately, it looks like our server is timing out as Heroku is throwing a timeout at the router (see below).
This all began when adding a new table. When I saw the error, I reverted to the last functioning revision (from months earlier) and the issue persisted, so it seems this came out of nowhere with no obvious cause. The only difference is that there’s an extra table in the database that isn’t configured in Forest Admin.
Double checked DB connection string, etc, but the DB seems to be working perfectly fine. Can connect to it remotely and other applications on Heroku using the same database are functioning fine.
Since I was dealing with an issue, I since decided to upgrade, so everything should be on the latest. Confirmed that the server is running and accessible at the APPLICATION_URL
.
Failure Logs
Logs from Heroku (no other errors):
app[web.1]: GET /forest/accounts?fields%5B[FIELDS]&page%5Bnumber%5D=1&page%5Bsize%5D=50&searchExtended=0&sort=name&timezone=America%2FPhoenix - - - - ms
2021-03-29T17:45:09.281162+00:00
heroku[router]: at=error code=H12 desc="Request timeout" method=GET path="/forest/accounts?fields%5B[PAGE]&page%5Bsize%5D=50&searchExtended=0&sort=name&timezone=America%2FPhoenix" host=[HOST] request_id=3f1239f6-4624-436f-8007-d6d8efb829a4 fwd="[IP]" dyno=web.1 connect=1ms service=30000ms status=503 bytes=0 protocol=https
Context
Please provide any relevant information about your setup.
- Package Version:
- Express Version: ^4.17.1
- Sequelize Version: ^7.3.1
- Database Dialect: Postgres (SSL)
- Database Version: 12.6
- Project Name: Pharos