First time here? Check out the FAQ!
0

carmls timeouts

For the last 4 days this query has been timing out after running for 5 minutes. We have never had this problem before running this query.

http://carmls.rets.paragonrels.com/re...

Error Message: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

login: constellationws

jflaig's avatar
jflaig
asked 2023-05-03 08:33:49 -0500
bwolven's avatar
bwolven
updated 2023-05-04 09:54:36 -0500
edit flag offensive 0 remove flag close merge delete

Comments

Hi jflaig,

Thanks for letting us know. When was the query you posted sent? We'll take a look at that time frame.

Also, we'd highly recommend you switch to HTTPS as HTTP will be discontinued soon.

Joe_Brueske's avatar Joe_Brueske (2023-05-03 08:37:22 -0500) edit

Hi Joe, this query runs and responds immediately: http://carmls.rets.paragonrels.com/re...

If you change the closing date filter from July 1 2022 to June 1 2022, it responds, but takes a good five minutes to do so. If you change it to May 1 2022, it times out.

JoeW's avatar JoeW (2023-05-03 08:40:56 -0500) edit

That query ran shortly before I posted this message. It never used to timeout until a few days ago.

jflaig's avatar jflaig (2023-05-03 08:46:21 -0500) edit

Thank you for the information. We'll start looking at "all the things".

When you say a few days ago, since it's Wednesday, did it start on during the weekend?

Joe_Brueske's avatar Joe_Brueske (2023-05-03 08:48:48 -0500) edit

on 4/30 in the morning

jflaig's avatar jflaig (2023-05-03 08:50:31 -0500) edit

Correct, it started on Sunday.

JoeW's avatar JoeW (2023-05-03 08:51:34 -0500) edit

We're still reviewing, but we have been able to reproduce. We'll keep you updated.

Joe_Brueske's avatar Joe_Brueske (2023-05-03 10:55:08 -0500) edit

thanks, it has always worked in the past.

jflaig's avatar jflaig (2023-05-03 10:57:17 -0500) edit

any updates?

jflaig's avatar jflaig (2023-05-04 06:57:38 -0500) edit

Hi Constellation,

Please attempt your query again. We aren't experiencing a timeout, but the 2022-06-01+ still took us about 4.5 minutes to complete. We opened a work order to troubleshoot this slowness, but don't have an ETA on full resolution. Development indicated this has happened before, but it rarely happens. This will make root cause analysis a little more challenging.

Joe_Brueske's avatar Joe_Brueske (2023-05-04 08:49:02 -0500) edit

our timeout is 11 minutes. the error is that the connection is closed by the remote host. this happens after exactly 5 minutes everytime. possibly the query runs faster on your end due to your location?

jflaig's avatar jflaig (2023-05-04 09:22:36 -0500) edit

Try it again now to see if it is working better.

bwolven's avatar bwolven (2023-05-04 09:36:03 -0500) edit
add a comment see more comments

1 Answer

0

it works suoer fast now

jflaig's avatar
jflaig
answered 2023-05-04 09:44:27 -0500
edit flag offensive 0 remove flag delete link

Comments

Glad to hear that. Hopefully it will continue to do so.

bwolven's avatar bwolven (2023-05-04 09:53:52 -0500) edit

You still need to change the domain on your URL to carmls-rets.paragonrels.com
And get it working with HTTPS if you haven't already done that?

bwolven's avatar bwolven (2023-05-04 09:55:50 -0500) edit

I changed it.

jflaig's avatar jflaig (2023-05-04 10:04:17 -0500) edit

Great!

bwolven's avatar bwolven (2023-05-04 10:05:22 -0500) edit

Are you having any further issues with this today?

bwolven's avatar bwolven (2023-05-08 13:59:50 -0500) edit

@jflaig We released the official fix for this to CARMLS now.
Can you verify that it is still working correctly and that the speed is still acceptable?

bwolven's avatar bwolven (2023-05-11 12:32:21 -0500) edit

no issues lately

jflaig's avatar jflaig (2023-05-11 12:33:36 -0500) edit

The permanent fix was released within the last hour or so keep an eye on it.

bwolven's avatar bwolven (2023-05-11 12:35:40 -0500) edit

@jflaig The fix has been deployed to the remaining Paragon RETS servers so you can see if they perform better with the fix too.

bwolven's avatar bwolven (2023-05-15 12:13:17 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer