Howdy Folks,

I have an app that cannot get information from mysql database for some reason.
Here is an query which application is trying to run but after some timeout
(something about 2-3 minutes):

11 Jul 2005 03:32:18,485 DEBUG [Thread-20] (PressReleaseDAO.java:328) -
sqlselect prd.press_release_id, pr.start_date,  prd.attention_title,
prd.headline, prd.sub_headline, prd.summary, prd.company_name, prd.body,
prd.city, prd.state, ind.industry_id, ind.industry_name from
press_release_detail prd, press_release pr, industry ind where pr.active_flag =
'Y' and pr.press_release_id = prd.press_release_id  and prd.industry =
ind.industry_id and start_date <= date_add(current_timestamp(), INTERVAL 3
HOUR) order by pr.start_date desc

Then errors follows:

11 Jul 2005 03:38:24,125 ERROR [Thread-18] (PressReleaseDAO.java:357) -
SQLException:java.sql.SQLException: Communication link failure:
java.net.SocketException
11 Jul 2005 03:38:24,126 ERROR [Thread-18] (BaseAction.java:75) -
com.flierwire.common.FlierwireSystemException: A system error has occurred,
please send an email to support at flierwire.com with details of what occurred.

I've tried to run this request in mysql and it has been ran fine.

After that I've increased max_connections limit in /etc/my.cnf and app runs
fine.



Is there a way to determin what connectiions to MySQL are being used by whom?

Thanks,

Todd


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to