http://coldfusion.com logo
Join Slack
Powered by
I'm fairly new to fusion reactor and I think I fin...
# adobe
d
I'm fairly new to fusion reactor and I think I finally have an issue I can try to debug using FR. Whats some of the things you'd check why this request is still running?
many other requests with stored procedure calls to the same database are executed just fine. and typically this slow running request is fast too.
the jdbc request is 99.9% of the entire request and it eventually finishes with a 500 error.
I can run the stored procedure fine in sql studio.
Ok its now working. for 90 mins everytime I ran that request the ODBC request would take minutes to finish. and now its working.
c
Is FR the best tool if its a DB issue? dont think its going to be giving much more info if its a DB issue other than finding other things running at the same time or letting you see patters in a page that might be the issue over time?
d
Ask your db folks to look for evidence of deadlocks. That's a common cause of a normally quick query sometimes taking way longer.
j
Lol. Took this screenshot about 5 hours ago. We’re in the same boat today…
d
yeah man. and I am the db guy too, lately I've had to learn more about databases and sql.
b
@Daniel Mejia If the DB call is still running, you'll need to dip into your DB server's tools to see what it's doing
✅ 1
Start by looking at the locks it's waiting to grant
✅ 1
If this is SQL Server, you can run 
sp_lock
and Google for 
sp_lock2
which has much more information
✅ 1
👏🏾 1
you'll need the SPID of the process which you can prolly find by looking in 
sys.sysprocesses
✅ 1
4 Views
Open in Slack
PreviousNext
Powered by