Production data sync failing! Urgent! Impacting customers!!
jonmhong
PROOP

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.

Solved

11 Replies

brody
EMPLOYEE

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

jonmhong
PROOP

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


jonmhong
PROOP

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?


brody
EMPLOYEE

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


jonmhong
PROOP

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


brody
EMPLOYEE

a year ago

What error do you get?


Status changed to Awaiting User Response Railway 12 months ago


jonmhong
PROOP

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


brody
EMPLOYEE

a year ago

Have you redeployed the database since I asked you to?


Status changed to Awaiting User Response Railway 12 months ago


jonmhong
PROOP

a year ago

Ah I forgot to do that, thank you


Status changed to Awaiting Railway Response Railway 12 months ago


brody
EMPLOYEE

a year ago

Working now?


Status changed to Awaiting User Response Railway 12 months ago


jonmhong
PROOP

a year ago

Yes it works thanks! And we found a workaround with the production problem.


Status changed to Awaiting Railway Response Railway 12 months ago


Status changed to Solved unicodeveloper 12 months ago


Loading...