[
https://issues.jboss.org/browse/AS7-3707?page=com.atlassian.jira.plugin.s...
]
vijay sharma updated AS7-3707:
------------------------------
Description:
Hi- This is quite blocking for us because we are moving first time with jboss on Redhat
linux.
I have sqlserver 2008 R2 running on windows 2008 R2 and application is installed on RHEL.
Deployment works fine on RHEL.Also Im running one use case which works fine with my
windows 2008 server r2 but it gets failed on RHEL. Im using 64bits jdk 1.6.22:
--------------
Current thread has not commited in more than [60] seconds and may incur unwanted blocking
locks. Please refactor code to commit more frequently.
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) while
executing select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID=?
and ? between TSL_START_DATE and TSL_END_DATE Parameters (1140,2012-02-06 00:00:00.0)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) [SQL] select
TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID='1140' and
CAST('02/06/2012 00:00:00' AS DATETIME) between TSL_START_DATE and TSL_END_DATE
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5)
com.workbrain.server.jsp.locale.LocalizedException: Current thread has not commited in
more than [60] seconds and may incur unwanted blocking locks. Please refactor code to
commit more frequently.
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) while
executing select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID=?
and ? between TSL_START_DATE and TSL_END_DATE Parameters (1140,2012-02-06 00:00:00.0)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) [SQL] select
TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID='1140' and
CAST('02/06/2012 00:00:00' AS DATETIME) between TSL_START_DATE and TSL_END_DATE
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.tool.jdbc.proxy.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:126)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetHelper.isTimesheetLocked(TimesheetHelper.java:1141)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetHelper.isTimesheetLocked(TimesheetHelper.java:1149)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayLockColumn(TimesheetDayModel.java:1043)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayBeforeWorkSummary(TimesheetDayModel.java:651)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayDay(TimesheetDayModel.java:197)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jsp.dailytimesheet.dailyTimesheet_jsp._jspService(dailyTimesheet_jsp.java:1415)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:326)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:253)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:734)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:541)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:479)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:407)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677)
was:
Hi- This is quite blocking for us because we are moving first time with jboss on Redhat
linux.
I have sqlserver 2008 R2 running on windows 2008 R2 and application is installed on RHEL.
Deployment and everything works fine on windows box but when when i run same scenerio on
linux box then i get following error message:
--------------
Current thread has not commited in more than [60] seconds and may incur unwanted blocking
locks. Please refactor code to commit more frequently.
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) while
executing select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID=?
and ? between TSL_START_DATE and TSL_END_DATE Parameters (1140,2012-02-06 00:00:00.0)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) [SQL] select
TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID='1140' and
CAST('02/06/2012 00:00:00' AS DATETIME) between TSL_START_DATE and TSL_END_DATE
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5)
com.workbrain.server.jsp.locale.LocalizedException: Current thread has not commited in
more than [60] seconds and may incur unwanted blocking locks. Please refactor code to
commit more frequently.
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) while
executing select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID=?
and ? between TSL_START_DATE and TSL_END_DATE Parameters (1140,2012-02-06 00:00:00.0)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) [SQL] select
TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID='1140' and
CAST('02/06/2012 00:00:00' AS DATETIME) between TSL_START_DATE and TSL_END_DATE
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.tool.jdbc.proxy.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:126)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetHelper.isTimesheetLocked(TimesheetHelper.java:1141)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetHelper.isTimesheetLocked(TimesheetHelper.java:1149)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayLockColumn(TimesheetDayModel.java:1043)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayBeforeWorkSummary(TimesheetDayModel.java:651)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayDay(TimesheetDayModel.java:197)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jsp.dailytimesheet.dailyTimesheet_jsp._jspService(dailyTimesheet_jsp.java:1415)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:326)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:253)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:734)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:541)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:479)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:407)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677)
AS 7.0.2 Final with 64bits redhat linux
---------------------------------------
Key: AS7-3707
URL:
https://issues.jboss.org/browse/AS7-3707
Project: Application Server 7
Issue Type: Feature Request
Components: Server
Affects Versions: 7.0.2.Final
Environment: RHEL 5.4
Reporter: vijay sharma
Assignee: Jason Greene
Hi- This is quite blocking for us because we are moving first time with jboss on Redhat
linux.
I have sqlserver 2008 R2 running on windows 2008 R2 and application is installed on RHEL.
Deployment works fine on RHEL.Also Im running one use case which works fine with my
windows 2008 server r2 but it gets failed on RHEL. Im using 64bits jdk 1.6.22:
--------------
Current thread has not commited in more than [60] seconds and may incur unwanted blocking
locks. Please refactor code to commit more frequently.
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) while
executing select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID=?
and ? between TSL_START_DATE and TSL_END_DATE Parameters (1140,2012-02-06 00:00:00.0)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) [SQL]
select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND
EMP_ID='1140' and CAST('02/06/2012 00:00:00' AS DATETIME) between
TSL_START_DATE and TSL_END_DATE
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5)
com.workbrain.server.jsp.locale.LocalizedException: Current thread has not commited in
more than [60] seconds and may incur unwanted blocking locks. Please refactor code to
commit more frequently.
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) while
executing select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID=?
and ? between TSL_START_DATE and TSL_END_DATE Parameters (1140,2012-02-06 00:00:00.0)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) [SQL]
select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND
EMP_ID='1140' and CAST('02/06/2012 00:00:00' AS DATETIME) between
TSL_START_DATE and TSL_END_DATE
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.tool.jdbc.proxy.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:126)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetHelper.isTimesheetLocked(TimesheetHelper.java:1141)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetHelper.isTimesheetLocked(TimesheetHelper.java:1149)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayLockColumn(TimesheetDayModel.java:1043)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayBeforeWorkSummary(TimesheetDayModel.java:651)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayDay(TimesheetDayModel.java:197)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jsp.dailytimesheet.dailyTimesheet_jsp._jspService(dailyTimesheet_jsp.java:1415)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:326)
23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:253)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:734)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:541)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:479)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:407)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706)
23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira