Re: Re: Farcry 6.2 Request Time Out Issue

--089e01184da01bf1a20522a5df72
Content-Type: text/plain; charset=UTF-8

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

On Thu, Oct 22, 2015 at 1:27 AM, Sean Coyne <[email protected]> wrote:

> 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
>
>
> On Wednesday, October 21, 2015 at 2:31:08 AM UTC-4, Xiaofeng Liu wrote:
>>
>> 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 [image:
>> :frowning:]
>>
>> Thanks,
>> Xiaofeng
>>
>> --
>> Best regards,
>>
>> Xiaofeng,^_^
>>
> --
> You received this message cos you are subscribed to "farcry-dev" Google
> group.
> To post, email: farcry-dev-/[email protected]
> To unsubscribe, email: farcry-dev+unsubscribe-/[email protected]
> 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+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Best regards,

Xiaofeng,^_^

-- 
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: farcry-dev-/[email protected]
To unsubscribe, email: farcry-dev+unsubscribe-/[email protected]
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+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
For more options, visit https://groups.google.com/d/optout.

--089e01184da01bf1a20522a5df72
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Sean,<div><br></div><div>I also created a thread in Dis=
course for this.</div><div><br></div><div><a href=3D"http://discourse.farcr=
ycore.org/t/farcry-6-2-request-timeout-issue/482">http://discourse.farcryco=
re.org/t/farcry-6-2-request-timeout-issue/482</a><br></div><div><br></div><=
div>Cheers,</div><div>Xiaofeng</div></div><div class=3D"gmail_extra"><br><d=
iv class=3D"gmail_quote">On Thu, Oct 22, 2015 at 1:27 AM, Sean Coyne <span =
dir=3D"ltr">&lt;<a href=3D"mailto:[email protected]" target=3D"_blank">c=
[email protected]</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quo=
te" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"=
><div dir=3D"ltr">You&#39;re not going to get much response here, take your=
 question to <a href=3D"http://discourse.farcrycore.org" target=3D"_blank">=
http://discourse.farcrycore.org</a><div><br></div><div>that is the new disc=
ussion forum</div><div><br></div><div>That said, does your database have th=
e required indexes, etc?=C2=A0 Also, are you connecting to a separate serve=
r? Is there a network bottleneck between the web and DB servers?</div><div>=
<br></div><div>Don&#39;t respond here, start a new post in Discourse and we=
 can discuss there and others can chime in as well.</div><div><br></div><di=
v>Sean</div><div><div class=3D"h5"><div><br><br>On Wednesday, October 21, 2=
015 at 2:31:08 AM UTC-4, Xiaofeng Liu wrote:<blockquote class=3D"gmail_quot=
e" style=3D"margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-l=
eft:1ex"><div dir=3D"ltr"><p style=3D"margin-top:0px;font-family:Helvetica,=
Arial,sans-serif;font-size:14px;line-height:19px">Hi folks,</p><p style=3D"=
font-family:Helvetica,Arial,sans-serif;font-size:14px;line-height:19px">I g=
ot=C2=A0a strange request time out issue for my farcry 6.2 site, when it sw=
itched to connect to the production database server.<br>It was exactly the =
same code running on the same server but connecting to an internal SIT data=
base server without any issue.</p><p style=3D"font-family:Helvetica,Arial,s=
ans-serif;font-size:14px;line-height:19px">After the data source changed, n=
ow any page request will time out even if it only contains one line of cfou=
tput code.<br>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=
&#39;m having problem with, and I can get the response back without issue.<=
/p><p style=3D"font-family:Helvetica,Arial,sans-serif;font-size:14px;line-h=
eight:19px">From the debugger information I can see C:/wwwroot/mysite/farcr=
y/core/tags/farcry/_farcryApplicationInit.cfm took long time to execute:<br=
><br></p><p style=3D"font-family:Helvetica,Arial,sans-serif;font-size:14px;=
line-height:19px">Total Time Avg Time Count Template</p><p style=3D"font-fa=
mily:Helvetica,Arial,sans-serif;font-size:14px;line-height:19px"><span styl=
e=3D"font-size:small"><font color=3D"#ff0000"><b>192387ms 192387ms 1 C:/www=
root/mysite/farcry/core/tags/farcry/_farcryApplicationInit.cfm 141380ms 128=
5ms 110 C:/wwwroot/mysite/farcry/core/packages/fourq/_fourq/getData.cfm 424=
86ms 42486ms 1 CFC[C:/wwwroot/mysite/farcry/core/packages/security/security=
.cfc | init() ]</b></font></span></p><p style=3D"margin-top:0px;font-family=
:Helvetica,Arial,sans-serif;font-size:14px;line-height:19px">Also any query=
 to the <b>farPermission</b> table took more than 5 seconds to execute.</p>=
<p style=3D"font-family:Helvetica,Arial,sans-serif;font-size:14px;line-heig=
ht:19px">The site is running farcry 6.2 on ColdFusion 11 update 6, Windows =
2012 R2 standard server 64 bit. IIS 8.5.</p><p style=3D"font-family:Helveti=
ca,Arial,sans-serif;font-size:14px;line-height:19px">Could anyone share som=
e thoughts on this? I got no clue at the moment=C2=A0<img src=3D"http://dis=
course.farcrycore.org/images/emoji/emoji_one/frowning.png?v=3D0" title=3D":=
frowning:" alt=3D":frowning:" style=3D"border:0px;vertical-align:middle;wid=
th:20px;min-height:20px;max-width:690px;max-height:500px"></p><p style=3D"f=
ont-family:Helvetica,Arial,sans-serif;font-size:14px;line-height:19px">Than=
ks,<br>Xiaofeng</p><div><br></div>-- <br><div>Best regards,<br><br>Xiaofeng=
,^_^</div>
</div>
</blockquote></div></div></div></div><span class=3D"HOEnZb"><font color=3D"=
#888888">

<p></p>

-- <br>
You received this message cos you are subscribed to &quot;farcry-dev&quot; =
Google group.<br>
To post, email: <a href=3D"mailto:farcry-dev-/[email protected]" target=3D"_b=
lank">farcry-dev-/[email protected]</a><br>
To unsubscribe, email: <a href=3D"mailto:farcry-dev%2Bunsubscribe@googlegro=
ups.com" target=3D"_blank">farcry-dev+unsubscribe-/[email protected]</a><br>
For more options: <a href=3D"http://groups.google.com/group/farcry-dev" tar=
get=3D"_blank">http://groups.google.com/group/farcry-dev</a><br>
--------------------------------<br>
Follow us on Twitter: <a href=3D"http://twitter.com/farcry" target=3D"_blan=
k">http://twitter.com/farcry</a><br>
--- <br>
You received this message because you are subscribed to the Google Groups &=
quot;farcry-dev&quot; group.<br>
To unsubscribe from this group and stop receiving emails from it, send an e=
mail to <a href=3D"mailto:farcry-dev+unsubscribe-/[email protected]" target=
=3D"_blank">farcry-dev+unsubscribe-/[email protected]</a>.<br>
For more options, visit <a href=3D"https://groups.google.com/d/optout" targ=
et=3D"_blank">https://groups.google.com/d/optout</a>.<br>
</font></span></blockquote></div><br><br clear=3D"all"><div><br></div>-- <b=
r><div class=3D"gmail_signature">Best regards,<br><br>Xiaofeng,^_^</div>
</div>

<p></p>

-- <br />
You received this message cos you are subscribed to &quot;farcry-dev&quot; =
Google group.<br />
To post, email: farcry-dev-/[email protected]<br />
To unsubscribe, email: farcry-dev+unsubscribe-/[email protected]<br />
For more options: <a href=3D"http://groups.google.com/group/farcry-dev">htt=
p://groups.google.com/group/farcry-dev</a><br />
--------------------------------<br />
Follow us on Twitter: <a href=3D"http://twitter.com/farcry">http://twitter.=
com/farcry</a><br />
--- <br />
You received this message because you are subscribed to the Google Groups &=
quot;farcry-dev&quot; group.<br />
To unsubscribe from this group and stop receiving emails from it, send an e=
mail to <a href=3D"mailto:farcry-dev+unsubscribe-/[email protected]">farcry-d=
ev+unsubscribe-/[email protected]</a>.<br />
For more options, visit <a href=3D"https://groups.google.com/d/optout">http=
s://groups.google.com/d/optout</a>.<br />

--089e01184da01bf1a20522a5df72--