Status 400 response
My app has been receiving frequent status 400 response when connecting to my Railway database. This just started happening on 1/31/24. Everything is US based.
Solution:Jump to solution
Update. This error appears to be a problem with Netlify function. They made a change that seems to have caused the error. They have (at least temporarily) rollled back the change and my app is working better.
28 Replies
Project ID:
d6eef051-2a81-4ab8-accb-09075bef3fc2d6eef051-2a81-4ab8-accb-09075bef3fc2
your legacy database was shut down, please migrate to a v2 database
I migrated to new v2 database weeks ago. Our app has been and does connect to new database. I have deleted teh legacy database and am still getting errors. Please note that my api gets data (generally after several tries) and have not changed.
can you send your deploy logs please https://bookmarklets.up.railway.app/log-downloader/
I have downloaded the logs. How do I send them to you?
send the resulting file here in this chat
sorry should have specified, id like the deploy logs for your app
App is on Netlify
do they provide logs for that?
Netlify does have different logs and I am happy to provide them. Is there something you are looking for so I can narrow down what to send.
Fyi. This app has been running on Netlify/Railway successfully for a long time (over year). When I migrated database I had to change to the new DATABASE_URL and password (for the V2 instance)
im looking for error logs to give me a better idea at whats going wrong
The app with Railway has worked well with the V2 database since 1/22/24
understood, but right now i'd need error logs to debug this further
This is the graphql function log for the past hour
Not sure it should matter but the function runs in US East (N. Virginia) - us-east-1
not seeing any database related errors there
It seems to me that my graphql service (Netlify) is timing out waiting for Railway database service to reply. This is periodic as the same calls work many times.
im not seeing anything via these logs that would suggest that, am i missing something?
probably not. The Netlify log will show an error if the graphql function gets an error. On the client I get an invalid JSON error which makes me thing the rw database is passing back something (timeout?) but not data. Since the request is getting JSON back it is not displayed as an error.
im not sure what else i can do to help without an explicit error message
ok. Can a customer change to the PRO plan (so I can move my db to us-east) and revert back to hobby plan if it does not help. Also, doe the switch of location move the db automatically or do I need to reload the data (and set new DATABASE_URL)
yes you can upgrade to pro, move your project over to the pro workspace and change the region of the database, railway handles the region change data migration.
if this doesnt help, you can always move the project back to the hobby workspace and terminate the pro plan
Thank you
Solution
Update. This error appears to be a problem with Netlify function. They made a change that seems to have caused the error. They have (at least temporarily) rollled back the change and my app is working better.
oh thats great