4563 app_admi 20 0 14.5g 2.5g 11m R 99.7 7.9 192:02.29 java 3696 app_admi 20 0 14.5g 2.5g 11m R 99.4 7.9 180:52.60 java 4203 app_admi 20 0 14.5g 2.5g 11m R 99.4 7.9 71:37.76 java

tenuousdrunkshipInternet and Web Development

Nov 12, 2013 (3 years and 8 months ago)

409 views



1.

查占用
cpu
较多线程

09:52 [app_admin@a02.comments.sh.jj.tudou.com]$ top
-
H

top
-

09:55:02 up 9 days, 18:12,


1 user,


load average: 2.97, 2.99, 2.96

Tasks: 1151 total,



5 running, 1146 sleeping,



0 stopped,



0 zombie

Cpu(s):


6.9%us,


7.1%sy,


0.0%ni,
85.9%id,


0.0%wa,


0.0%hi,


0.1%si,


0.0%st

Mem:


32796564k total, 32613532k used,



183032k free,



143628k buffers

Swap:


4191224k total,




18404k used,


4172820k free, 27227764k cached




PID USER






PR


NI


VIRT


RES


SHR
S %CPU %MEM




TIME+


COMMA
ND












































































































































































































4563 app_admi


20



0 14.5g 2.5g


11m R 99.7


7.9
192:02.29
java















































































































































































































3696 app_admi


20



0 14.5g 2.5g


1
1m R 99.4


7.9 180:52.60
java















































































































































































































4203 app_admi


20



0 14.5g 2.5g


11m R 99.4


7.9


71:37.76
java













































































































































































































31851
squid





20



0 1829m 1.4g 1604 S


3.6


4.4 492:13.87
squid














































































































































































































8486 app_admi


20



0 15836 2116


952 R


1.0


0.0



0:01.15
top
















































































































































































































3602 app_admi


20



0 14.5g 2.5g


11m S


0.7


7.9



0:21.55
java















































































































































































































3847 app_admi


20



0 14.5g 2.5g


11m S


0.7


7.9



0:21.64
java















































































































































































































3870 app_admi


20



0 14.5g 2.5g


11m S


0.7


7.9



0:21.88
java















































































































































































































4184 app_admi


20



0 14.5g 2.5g


11m S


0.7


7.9



0:22.93 java












线程
id

4563,3696,4203
占用
cpu
较多
.

转换成
16
进制后线程
id
是,
0x11d3 , 0xe70, 0x106b



2.

jstack
中查询这几个线程,发现都是执行
sql
查询时出现被锁住的现象。



"http
-
apr
-
8080
-
exec
-
135" daemon prio=10 tid=0x00007fa6b421e800
nid=0xe70

runnable
[0x00007fa778e20000]




java.lang.Thread.State: RUNNABLE









at java.net.PlainSocketImpl.socketAvailable(Native Method)









at java.net.PlainSocketImpl.available(Plai
nSocketImpl.java:472)









-

locked <0x000000078584f398> (a java.net.SocksSocketImpl)









at java.net.SocketInputStream.available(SocketInputStream.java:217)









at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:71)









at com.mysql.jdbc.util.ReadAheadInputStream.skip(ReadAheadInputStream.java:299)









at com.mysql.jdbc.MysqlIO.clearInputStream(MysqlIO.java:800)









at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1506)









at com.mysql.jdbc.MysqlIO.sqlQ
ueryDirect(MysqlIO.java:1666)









at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)









-

locked <0x000000078584f788> (a java.lang.Object)









at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)









at com.mysql.jdbc.Stateme
nt.executeQuery(Statement.java:824)









-

locked <0x000000078584f788> (a java.lang.Object)









-

locked <0x0000000785e36ce8> (a com.mysql.jdbc.Statement)









at com.mysql.jdbc.DatabaseMetaData$9.forEach(DatabaseMetaData.java:4453)









at co
m.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaData.java:79)









at com.mysql.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:4440)









at
com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnecti
onT
ester.java:104)









at
com.mchange.v2.c3p0.impl.DefaultConnectionTester.statusOnException(DefaultConnectionTester
.java:77)









at
com.mchange.v2.c3p0.impl.DefaultConnectionTester.statusOnException(DefaultConnectionTester
.java:56)









at
com.
mchange.v2.c3p0.impl.NewPooledConnection.handleThrowable(NewPooledConnection.java
:352)









-

locked <0x000000078584bae8> (a com.mchange.v2.c3p0.impl.NewPooledConnection)









at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPrep
aredStatement.
java:925)









at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)









at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralState
ment.java:205)









at

com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(Gen
eralStatement.java:173)









at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralSt
atement.java:123)









at
com.ibatis.sql
map.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.j
ava:615)









at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.j
ava:589)









at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.qu
eryForList(SqlMapSessionImpl.java:118)









at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTempla
te.java:298)









at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)









at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemp
late.java:249)









at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:
296)









at
org.springframework.orm.
ibatis.SqlMapClientTemplate$$FastClassByCGLIB$$98dc7020.invoke(<g
enerated>)









at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)









at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cg
lib2AopPr
oxy.java:696)









at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:149)









at
org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocat
ionProceedingJoinPoint.ja
va:88)









at com.tudou.utils.error.report.AspectJSqlErrorHandler.queryTimeout(Unknown Source)









at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)









at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm
pl.java:25)









at java.lang.reflect.Method.invoke(Method.java:597)









at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(Abs
tractAspectJAdvice.java:627)









at
org.springframework.aop.aspectj.AbstractAspe
ctJAdvice.invokeAdviceMethod(AbstractAspectJAd
vice.java:616)









at
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)









at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethod
Invo
cation.java:171)









at
org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvi
ce.java:54)









at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:171)









at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterc
eptor.java:89)









at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:171)









at
org.springfram
ework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib
2AopProxy.java:631)









at
org.springframework.orm.ibatis.SqlMapClientTemplate$$EnhancerByCGLIB$$4f37f036.queryForL
ist(<generated>)









at

com.tudou.commentnew.dao.ItemMotherCommentDAO.getItemCommentIdsByWeighing(Item
MotherCommentDAO.java:383)









at
com.tudou.commentnew.service.ItemMotherCommentService.getItemCommentIdsByWeighing(I
temMotherCommentService.java:643)









at
com.tudou.c
ommentnew.service.ItemMotherCommentService.getCommentsByWeighing(ItemM
otherCommentService.java:694)









at
com.tudou.commentnew.web.action.ItemMotherCommentAction.getCommentByWeighing(Item
MotherCommentAction.java:1513)









at
com.tudou.commentnew.w
eb.action.ItemMotherCommentAction.execute(ItemMotherComment
Action.java:94)









at com.tudou.commentnew.web.ServletDispacher.doGet(ServletDispacher.java:83)









at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)









at javax.servlet
.http.HttpServlet.service(HttpServlet.java:728)









at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)









at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210
)









at com.tudou.monitor.appfilter.AppFilter.doFilter(AppFilter.java:78)









at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)









at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:210)









at com.tudou.commentnew.web.CharactorFilter.doFilter(CharactorFilter.java:46)









at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)









at org.apache.catali
na.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)









at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)









at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.jav
a:123)









at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)









at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)









at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:99)









at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)









at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)









at
org.apache.coyote.http11.AbstractHttp11
Processor.process(AbstractHttp11Processor.java:1008)









at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:5
89)









at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)









-

locked <0x0000000785870740> (a org.apache.tomcat.util.net.SocketWrapper)









at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)









at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
java:908)









at java.lang.Thread.run(Thread.java:662)






"http
-
apr
-
8080
-
exec
-
942" daemon prio=10 tid=0x00007fa6b4f5e000

nid=0x11d3

runnable
[0x00007fa4c81f9000]




java.lang.Thread.State: RUNNABLE









at java.net.PlainSocketImpl.socketAvailable
(Native Method)









at java.net.PlainSocketImpl.available(PlainSocketImpl.java:472)









-

locked <0x00000007855d1ba8> (a java.net.SocksSocketImpl)









at java.net.SocketInputStream.available(SocketInputStream.java:217)









at com.mysql.jdbc
.util.ReadAheadInputStream.available(ReadAheadInputStream.java:231)









at com.mysql.jdbc.MysqlIO.clearInputStream(MysqlIO.java:801)









at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1506)









at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Mysql
IO.java:1666)









at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)









-

locked <0x00000007855d1f98> (a java.lang.Object)









at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)









at com.mysql.jdbc.Statement.executeQuery(
Statement.java:824)









-

locked <0x00000007855d1f98> (a java.lang.Object)









-

locked <0x0000000785e190d0> (a com.mysql.jdbc.Statement)









at com.mysql.jdbc.DatabaseMetaData$9.forEach(DatabaseMetaData.java:4453)









at com.mysql.jdbc.Dat
abaseMetaData$IterateBlock.doForAll(DatabaseMetaData.java:79)









at com.mysql.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:4440)









at
com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionT
ester.java:10
4)









at
com.mchange.v2.c3p0.impl.DefaultConnectionTester.statusOnException(DefaultConnectionTester
.java:77)









at
com.mchange.v2.c3p0.impl.DefaultConnectionTester.statusOnException(DefaultConnectionTester
.java:56)









at
com.mchange.v2.c3p0.
impl.NewPooledConnection.handleThrowable(NewPooledConnection.java
:352)









-

locked <0x00000007855e6ff8> (a com.mchange.v2.c3p0.impl.NewPooledConnection)









at

com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.
java:925)









at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)









at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatem
ent.sqlExecuteQuery(GeneralState
ment.java:205)









at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(Gen
eralStatement.java:173)









at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryFor
List(GeneralSt
atement.java:123)









at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.j
ava:615)









at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.j
ava:589)









at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)









at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTempla
te.java:298)









at
org.springframework.orm.ibatis.SqlMa
pClientTemplate.execute(SqlMapClientTemplate.java:209)









at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemp
late.java:249)









at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapCli
entTemplate.java:
296)









at
org.springframework.orm.ibatis.SqlMapClientTemplate$$FastClassByCGLIB$$98dc7020.invoke(<g
enerated>)









at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)









at
org.springframework.aop.framework.Cglib2A
opProxy$CglibMethodInvocation.invokeJoinpoint(Cg
lib2AopProxy.java:696)









at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:149)









at
org.springframework.aop.aspectj.MethodInvocationProceedin
gJoinPoint.proceed(MethodInvocat
ionProceedingJoinPoint.java:88)









at com.tudou.utils.error.report.AspectJSqlErrorHandler.queryTimeout(Unknown Source)









at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)









at
sun.reflect.Deleg
atingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)









at java.lang.reflect.Method.invoke(Method.java:597)









at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(Abs
tractAspectJAdvice.java:627
)









at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAd
vice.java:616)









at
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)









at
org.springframework.aop.fram
ework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:171)









at
org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvi
ce.java:54)









at
org.springframework.aop.framework.ReflectiveMethodInvo
cation.proceed(ReflectiveMethodInvo
cation.java:171)









at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterc
eptor.java:89)









at

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:171)









at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib
2AopProxy.java:631)









at
org.springframewo
rk.orm.ibatis.SqlMapClientTemplate$$EnhancerByCGLIB$$4f37f036.queryForL
ist(<generated>)









at
com.tudou.commentnew.dao.ItemMotherCommentDAO.getItemCommentIdsByWeighing(Item
MotherCommentDAO.java:383)









at
com.tudou.commentnew.service.ItemMotherCo
mmentService.getItemCommentIdsByWeighing(I
temMotherCommentService.java:643)









at
com.tudou.commentnew.service.ItemMotherCommentService.getCommentsByWeighing(ItemM
otherCommentService.java:694)









at
com.tudou.commentnew.web.action.ItemMotherComme
ntAction.getCommentByWeighing(Item
MotherCommentAction.java:1513)









at
com.tudou.commentnew.web.action.ItemMotherCommentAction.execute(ItemMotherComment
Action.java:94)









at com.tudou.commentnew.web.ServletDispacher.doGet(ServletDispacher.java:83
)









at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)









at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)









at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)









at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)









at com.tudou.monitor.appfilter.AppFilter.doFilter(AppFilter.java:78)









at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
licationFilterChain.java:243)









at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)









at com.tudou.commentnew.web.CharactorFilter.doFilter(CharactorFilter.java:46)









at
org.apache.catalina.core.App
licationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)









at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)









at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.
java:222)









at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)









at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)









at org.apache.catalina.core.StandardHostValve
.invoke(StandardHostValve.java:171)









at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)









at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)









at org.apache.catalina.connecto
r.CoyoteAdapter.service(CoyoteAdapter.java:408)









at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008)









at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:5
89
)









at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)









-

locked <0x00000007855f6a28> (a org.apache.tomcat.util.net.SocketWrapper)









at

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)









at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)









at java.lang.Thread.run(Thread.java:662)




"http
-
apr
-
8080
-
exec
-
642" dae
mon prio=10 tid=0x00007fa6b4a28000
nid=0x106b

runnable
[0x00007fa4cde38000]




java.lang.Thread.State: RUNNABLE









at java.net.PlainSocketImpl.socketAvailable(Native Method)









at java.net.PlainSocketImpl.available(PlainSocketImpl.java:472)









-

locked <0x0000000785cef068> (a java.net.SocksSocketImpl)









at java.net.SocketInputStream.available(SocketInputStream.java:217)









at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:71)









at com.mysql.jdbc.util.
ReadAheadInputStream.skip(ReadAheadInputStream.java:299)









at com.mysql.jdbc.MysqlIO.clearInputStream(MysqlIO.java:800)









at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1506)









at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:166
6)









at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)









-

locked <0x0000000785cd3fe0> (a java.lang.Object)









at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)









at com.mysql.jdbc.Statement.executeQuery(Statement.j
ava:824)








-

locked <0x0000000785cd3fe0> (a java.lang.Object)









-

locked <0x0000000785edfe60> (a com.mysql.jdbc.Statement)









at com.mysql.jdbc.DatabaseMetaData$9.forEach(DatabaseMetaData.java:4453)









at com.mysql.jdbc.DatabaseMetaDat
a$IterateBlock.doForAll(DatabaseMetaData.java:79)









at com.mysql.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:4440)









at
com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionT
ester.java:104)









a
t
com.mchange.v2.c3p0.impl.DefaultConnectionTester.statusOnException(DefaultConnectionTester
.java:77)









at
com.mchange.v2.c3p0.impl.DefaultConnectionTester.statusOnException(DefaultConnectionTester
.java:56)









at

com.mchange.v2.c3p0.impl.NewPooledConnection.handleThrowable(NewPooledConnection.java
:352)









-

locked <0x0000000785ceed10> (a com.mchange.v2.c3p0.impl.NewPooledConnection)









at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProx
yPreparedStatement.
java:925)









at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)









at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralState
ment.java:205)









at
com.ibati
s.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(Gen
eralStatement.java:173)









at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralSt
atement.java:123)









at
com.ibatis.sqlmap.engine
.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.j
ava:615)









at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.j
ava:589)









at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList
(SqlMapSessionImpl.java:118)









at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTempla
te.java:298)









at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)









at
o
rg.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemp
late.java:249)









at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:
296)









at
org.springframework.orm.ibatis.Sql
MapClientTemplate$$FastClassByCGLIB$$98dc7020.invoke(<g
enerated>)









at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)









at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cg
lib2AopProxy.java:6
96)









at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:149)









at
org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocat
ionProceedingJoinPoint.java:88)









at com.tudou.utils.error.report.AspectJSqlErrorHandler.queryTimeout(Unknown Source)









at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)









at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25
)









at java.lang.reflect.Method.invoke(Method.java:597)









at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(Abs
tractAspectJAdvice.java:627)









at
org.springframework.aop.aspectj.AbstractAspectJAdvice.
invokeAdviceMethod(AbstractAspectJAd
vice.java:616)









at
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)









at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation
.java:171)









at
org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvi
ce.java:54)









at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:171)









at

org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterc
eptor.java:89)









at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:171)









at
org.springframework
.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib
2AopProxy.java:631)









at
org.springframework.orm.ibatis.SqlMapClientTemplate$$EnhancerByCGLIB$$4f37f036.queryForL
ist(<generated>)









at
com.tudou.commentnew.dao.ItemMotherCom
mentDAO.getItemCommentIdsByWeighing(Item
MotherCommentDAO.java:383)









at
com.tudou.commentnew.service.ItemMotherCommentService.getItemCommentIdsByWeighing(I
temMotherCommentService.java:643)









at
com.tudou.commentnew.service.ItemMotherCommentServ
ice.getCommentsByWeighing(ItemM
otherCommentService.java:694)









at
com.tudou.commentnew.web.action.ItemMotherCommentAction.getCommentByWeighing(Item
MotherCommentAction.java:1513)









at
com.tudou.commentnew.web.action.ItemMotherCommentAction.execu
te(ItemMotherComment
Action.java:94)









at com.tudou.commentnew.web.ServletDispacher.doGet(ServletDispacher.java:83)









at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)









at javax.servlet.http.HttpServlet.service(HttpServlet.j
ava:728)









at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)









at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)









at com.tudou.monitor.appfilte
r.AppFilter.doFilter(AppFilter.java:78)









at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)









at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)









at com.tudou.commentnew.web.CharactorFilter.doFilter(CharactorFilter.java:46)









at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)









at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:210)









at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)









at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)









at org.apache.catalina.a
uthenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)









at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)









at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)









at or
g.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)









at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)









at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Process
or.java:1008)









at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:5
89)









at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)









-

locked <0x0000000785cfd568> (a
org.apache.tomcat.util.net.SocketWrapper)









at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)









at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)









at java.lang.Thread.
run(Thread.java:662)