Farcry 6.2 Request Time Out Issue

Xiaofeng Liu

unread,

Oct 21, 2015, 2:31:08 AM10/21/15

to farcr...@googlegroups.com

Hi folks,

I got a strange request time out issue for my farcry 6.2 site, when it switched to connect to the production database server.
It was exactly the same code running on the same server but connecting to an internal SIT database server without any issue.

After the data source changed, now any page request will time out even if it only contains one line of cfoutput code.
It looked like a database issue to me initially so I created another test site (Non-farcry) with only one page request to the database I'm having problem with, and I can get the response back without issue.

From the debugger information I can see C:/wwwroot/mysite/farcry/core/tags/farcry/_farcryApplicationInit.cfm took long time to execute:

Total Time Avg Time Count Template

192387ms 192387ms 1 C:/wwwroot/mysite/farcry/core/tags/farcry/_farcryApplicationInit.cfm 141380ms 1285ms 110 C:/wwwroot/mysite/farcry/core/packages/fourq/_fourq/getData.cfm 42486ms 42486ms 1 CFC[C:/wwwroot/mysite/farcry/core/packages/security/security.cfc | init() ]

Also any query to the farPermission table took more than 5 seconds to execute.

The site is running farcry 6.2 on ColdFusion 11 update 6, Windows 2012 R2 standard server 64 bit. IIS 8.5.

Could anyone share some thoughts on this? I got no clue at the moment

Thanks,
Xiaofeng

--

Best regards,

Xiaofeng,^_^

Sean Coyne

unread,

Oct 21, 2015, 10:27:55 AM10/21/15

to farcry-dev

You're not going to get much response here, take your question to http://discourse.farcrycore.org

that is the new discussion forum

That said, does your database have the required indexes, etc? Also, are you connecting to a separate server? Is there a network bottleneck between the web and DB servers?

Don't respond here, start a new post in Discourse and we can discuss there and others can chime in as well.

Sean

Xiaofeng Liu

unread,

Oct 21, 2015, 7:38:12 PM10/21/15

to farcr...@googlegroups.com

Hi Sean,

I also created a thread in Discourse for this.

http://discourse.farcrycore.org/t/farcry-6-2-request-timeout-issue/482

Cheers,

Xiaofeng

--
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: farcr...@googlegroups.com
To unsubscribe, email: farcry-dev+...@googlegroups.com
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
---
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to farcry-dev+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.