a year ago
We have a python service that uses an SDK to pull data from a Quickbooks desktop app. We need to do an initial sync to pull all historical data, so the sync takes 30-45 minutes.
The sync pulls all historical data on my local machine. But it fails in production after some 10-15 minutes, which indicates this is a Railway issue.
Is there a connection limit that Railway imposes? We need it lifted, so the sync can continue to run without severing the connection between our server (and SDK) and the remote machine hosting the Quickbooks desktop app.
Also, the TCP connection from our local machine to the DB doesn't work, so we can't force the sync this way.
What configuration do we need to change? We need to get on a call immediately to fix this issue.
11 Replies
a year ago
Hello,
We do not impose any outbound connections limits whatsoever, nor do we have that ability, I would have to recommend getting in contact with the 3rd party provider for that issue.
As for the database, It was misconfigured with an HTTP domain instead of a TCP Proxy, I have added the TCP Proxy so please redeploy the database so that setting can take effect.
Best,
Brody
Status changed to Awaiting User Response Railway • 12 months ago
brody
Hello,We do not impose any outbound connections limits whatsoever, nor do we have that ability, I would have to recommend getting in contact with the 3rd party provider for that issue.As for the database, It was misconfigured with an HTTP domain instead of a TCP Proxy, I have added the TCP Proxy so please redeploy the database so that setting can take effect.Best,Brody
a year ago
For the DB, I added the TCP proxy previously but removed it. But I'll try it again
Status changed to Awaiting Railway Response Railway • 12 months ago
a year ago
Also we tested pulling data from his prod server to our staging environment, and that worked perfectly. It didn't work when pulling from his prod server to our prod environment. There are no constraints at all between how you set up staging and production environments here?
a year ago
There are no constraints at all between how you set up staging and production environments here?
None what so ever.
Status changed to Awaiting User Response Railway • 12 months ago
a year ago
Ok thanks. Also, are my prod and staging DBs configured differently? I'm able to connect to the staging DB but not the prod DB. We're following the same format psql postgresql://user:password@proxy_url:port/db_name
staging's url starts with junction.* and prod starts with autorack.*
Status changed to Awaiting Railway Response Railway • 12 months ago
Status changed to Awaiting User Response Railway • 12 months ago
a year ago
psql postgresql://postgres:postgres_pass@proxy_url:port/railway
psql: error: connection to server at "<postgres_url>" (IP_ADDRESS), port PORT failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Status changed to Awaiting Railway Response Railway • 12 months ago
Status changed to Awaiting User Response Railway • 12 months ago
a year ago
Ah I forgot to do that, thank you
Status changed to Awaiting Railway Response Railway • 12 months ago
Status changed to Awaiting User Response Railway • 12 months ago
Status changed to Awaiting Railway Response Railway • 12 months ago
Status changed to Solved unicodeveloper • 12 months ago
