Long running requests in ColdFusion

At work, we have FusionReactor and there are some services written in CF that have long running requests a couple of times a day. The requests terminate anywhere from 300,000ms to 800,000 ms and I am not sure why they're "hanging".

CPU is running at an average of 20-30% and ram is about 24% so the server isn't taxed very much.

Here is where the thread is hanging.

Any insight as to what java.net.socketoutputstream.socketwrite0 is or anything else about this would be most helpful.

Andrew MaurerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

What is the DB ur using and how u created the connection in cfadmin
i have not worked with FusionReactor in a while, but does it not tell you which template is causing the issue?

from what i could gather by extensive googling, SocketOutputStream is an extension of FileOutputStream.
it can hang/block when a client (receiving end) closes the connection before the server finished sending data. slow network connection, TCP socket problems and extensive low-level logging can also cause this.

do these services of yours write large data to files or serve then to client (i.e. download recordset as csv file) or something like this?
do you know what is the request timeout set on the receiving end? is it long enough to serve all the data?

i would also check application and exception logs on the cf server and search for jrpp-35 thread around same time FR shows the hanging thread - there may be more info in those logs...

i would also suggest you post this question on cf-talk list (http://www.houseoffusion.com/groups/cf-talk/) - there are a lot more developers there who are familiar with FR and low-level stacks. someone there might have encountered exactly this issue before...


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Andrew MaurerAuthor Commented:
@srikanthmadishetti - it has nothing to do with the DB

@azadisaryev - yes every hung thread like this has to do with a large amount of xml data being transmitted.

Not sure about the timeout on the client side.. I would guess its plenty of time though.

I'll check the logs and if it keeps happening, i'll hit-up houseOfusion. Thanks!
@zadoc - My point in asking the DB conncetion was  AFAIK  it also depends on the kind of connection we make like ODBC / JDBC driver etc .

Any way if you feel ur DB connection is not an ISSUE  then check what Azadi suggested.
Andrew MaurerAuthor Commented:
Thanks but some of these hung requests have zero JDBC time/activity. Others show the JDBC time executed within a reasonable amount of time.

Also I am pretty sure that socketWrite is a java output method.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.