Mysql 异常。 寻求帮助
我先描述下环境。我们这里有个rss download server。 使用activemq + timertask schual。 每格一个小时运行一次。数据库里大概有6000多个Feed。 rss download server并发30个线程去download feed 然后更新数据库。 可是这几天发现。download server工作不正常。时常是个好几个小时工作一次。或者更本就不工作。常看日志发现。 mysql执行一条update语句都需要十多分钟？ 日志请看下面：

sql 代码?

1. 2007-04-28?10:54:29,415?INFO??[STDOUT]?Hibernate:?update?CHANNELS?set?IS_DOWNLOADING=?,?LAST_UPDATED=now()?where?CHANNEL_ID=???
2. 2007-04-28?11:09:26,057?WARN??[org.hibernate.util.JDBCExceptionReporter]?SQL?Error:?0,?SQLState:?08S01??
3. 2007-04-28?11:09:26,550?ERROR?[org.hibernate.util.JDBCExceptionReporter]?Communications?link?failure?due?to?underlying?exception:???
4. ??
5. **?BEGIN?NESTED?EXCEPTION?**???
6. ??
7. java.io.EOFException??
8. ??
9. STACKTRACE:??
10. ??
11. java.io.EOFException??
12. ????at?com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1903)??
13. ????at?com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2402)??
14. ????at?com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2860)??
15. ????at?com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)??
16. ????at?com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1289)??
17. ????at?com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2270)??
18. ????at?com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:423)??
19. ????at?com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1960)??
20. ????at?com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1385)??
21. ????at?com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1728)??
22. ????at?com.mysql.jdbc.Connection.execSQL(Connection.java:2978)??
23. ????at?com.mysql.jdbc.Connection.execSQL(Connection.java:2902)??
24. ????at?com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:933)??
25. ????at?com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1027)??
26. ????at?org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)??
27. ????at?org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)??
28. ????at?org.hibernate.loader.Loader.getResultSet(Loader.java:1669)??
29. ????at?org.hibernate.loader.Loader.doQuery(Loader.java:662)??
30. ????at?org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)??
31. ????at?org.hibernate.loader.Loader.loadCollection(Loader.java:1919)??
32. ????at?org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)??
33. ????at?org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520)??
34. ????at?org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)??
35. ????at?org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1676)??
36. ????at?org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)??
37. ????at?org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)??
38. ????at?org.hibernate.collection.PersistentBag.iterator(PersistentBag.java:246)??
39. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.isNewItem(DownloadServiceDaoHibernateImpl.java:163)??
40. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.checkAndSaveNewItems(DownloadServiceDaoHibernateImpl.java:221)??
41. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.access$100(DownloadServiceDaoHibernateImpl.java:44)??
42. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl$2.doInHibernate(DownloadServiceDaoHibernateImpl.java:137)??
43. ????at?org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)??
44. ????at?org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)??
45. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.save(DownloadServiceDaoHibernateImpl.java:118)??
46. ????at?com.monitor110.rss.download.service.DownloadServiceImpl.persist(DownloadServiceImpl.java:41)??
47. ????at?sun.reflect.GeneratedMethodAccessor168.invoke(Unknown?Source)??
48. ????at?sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)??
49. ????at?java.lang.reflect.Method.invoke(Method.java:585)??
50. ????at?org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:299)??
51. ????at?org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)??
52. ????at?org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)??
53. ????at?org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)??
54. ????at?org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)??
55. ????at?org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)??
56. ????at?$Proxy84.persist(Unknown?Source)??
57. ????at?com.monitor110.rss.download.service.DownloadResultConsumer.onMessage(DownloadResultConsumer.java:28)??
58. ????at?org.jencks.LocalTransactionEndpoint.onMessage(LocalTransactionEndpoint.java:68)??
59. ????at?org.apache.activemq.ra.MessageEndpointProxy$MessageEndpointAlive.onMessage(MessageEndpointProxy.java:121)??
60. ????at?org.apache.activemq.ra.MessageEndpointProxy.onMessage(MessageEndpointProxy.java:61)??
61. ????at?org.apache.activemq.ActiveMQSession.run(ActiveMQSession.java:695)??
62. ????at?org.apache.activemq.ra.ServerSessionImpl.run(ServerSessionImpl.java:165)??
63. ????at?org.apache.geronimo.connector.work.WorkerContext.run(WorkerContext.java:291)??
64. ????at?EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown?Source)??
65. ????at?java.lang.Thread.run(Thread.java:595)??
66. ??
67. ??
68. **?END?NESTED?EXCEPTION?**??
69. ??
70. ??
71. ??
72. Last?packet?sent?to?the?server?was?914670?ms?ago.??
73. 2007-04-28?11:09:27,882?ERROR?[com.monitor110.rss.download.service.DownloadResultConsumer]?Can't?save?download?result??
74. org.springframework.dao.DataAccessResourceFailureException:?could?not?initialize?a?collection:?[com.monitor110.rss.domain.Channel.items#12686];?nested?exception?is?org.hibernate.exception.JDBCConnectionException:?could?not?initialize?a?collection:?[com.monitor110.rss.domain.Channel.items#12686]??
75. Caused?by:???
76. org.hibernate.exception.JDBCConnectionException:?could?not?initialize?a?collection:?[com.monitor110.rss.domain.Channel.items#12686]??
77. ????at?org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)??
78. ????at?org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)??
79. ????at?org.hibernate.loader.Loader.loadCollection(Loader.java:1926)??
80. ????at?org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)??
81. ????at?org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520)??
82. ????at?org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)??
83. ????at?org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1676)??
84. ????at?org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)??
85. ????at?org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)??
86. ????at?org.hibernate.collection.PersistentBag.iterator(PersistentBag.java:246)??
87. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.isNewItem(DownloadServiceDaoHibernateImpl.java:163)??
88. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.checkAndSaveNewItems(DownloadServiceDaoHibernateImpl.java:221)??
89. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.access$100(DownloadServiceDaoHibernateImpl.java:44)??
90. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl$2.doInHibernate(DownloadServiceDaoHibernateImpl.java:137)??
91. ????at?org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)??
92. ????at?org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)??
93. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.save(DownloadServiceDaoHibernateImpl.java:118)??
94. ????at?com.monitor110.rss.download.service.DownloadServiceImpl.persist(DownloadServiceImpl.java:41)??
95. ????at?sun.reflect.GeneratedMethodAccessor168.invoke(Unknown?Source)??
96. ????at?sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)??
97. ????at?java.lang.reflect.Method.invoke(Method.java:585)??
98. ????at?org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:299)??
99. ????at?org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)??
100. ????at?org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)??
101. ????at?org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)??
102. ????at?org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)??
103. ????at?org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)??
104. ????at?$Proxy84.persist(Unknown?Source)??
105. ????at?com.monitor110.rss.download.service.DownloadResultConsumer.onMessage(DownloadResultConsumer.java:28)??
106. ????at?org.jencks.LocalTransactionEndpoint.onMessage(LocalTransactionEndpoint.java:68)??
107. ????at?org.apache.activemq.ra.MessageEndpointProxy$MessageEndpointAlive.onMessage(MessageEndpointProxy.java:121)??
108. ????at?org.apache.activemq.ra.MessageEndpointProxy.onMessage(MessageEndpointProxy.java:61)??
109. ????at?org.apache.activemq.ActiveMQSession.run(ActiveMQSession.java:695)??
110. ????at?org.apache.activemq.ra.ServerSessionImpl.run(ServerSessionImpl.java:165)??
111. ????at?org.apache.geronimo.connector.work.WorkerContext.run(WorkerContext.java:291)??
112. ????at?EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown?Source)??
113. ????at?java.lang.Thread.run(Thread.java:595)??
114. Caused?by:?com.mysql.jdbc.CommunicationsException:?Communications?link?failure?due?to?underlying?exception:???
115. ??
116. **?BEGIN?NESTED?EXCEPTION?**???
117. ??
118. java.io.EOFException??
119. ??
120. STACKTRACE:??
121. ??
122. java.io.EOFException??
123. ????at?com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1903)??
124. ????at?com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2402)??
125. ????at?com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2860)??
126. ????at?com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)??
127. ????at?com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1289)??
128. ????at?com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2270)??
129. ????at?com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:423)??
130. ????at?com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1960)??
131. ????at?com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1385)??
132. ????at?com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1728)??
133. ????at?com.mysql.jdbc.Connection.execSQL(Connection.java:2978)??
134. ????at?com.mysql.jdbc.Connection.execSQL(Connection.java:2902)??
135. ????at?com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:933)??
136. ????at?com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1027)??
137. ????at?org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)??
138. ????at?org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)??
139. ????at?org.hibernate.loader.Loader.getResultSet(Loader.java:1669)??
140. ????at?org.hibernate.loader.Loader.doQuery(Loader.java:662)??
141. ????at?org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)??
142. ????at?org.hibernate.loader.Loader.loadCollection(Loader.java:1919)??
143. ????at?org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)??
144. ????at?org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520)??
145. ????at?org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)??
146. ????at?org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1676)??
147. ????at?org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)??
148. ????at?org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)??
149. ????at?org.hibernate.collection.PersistentBag.iterator(PersistentBag.java:246)??
150. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.isNewItem(DownloadServiceDaoHibernateImpl.java:163)??
151. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.checkAndSaveNewItems(DownloadServiceDaoHibernateImpl.java:221)??
152. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.access$100(DownloadServiceDaoHibernateImpl.java:44)??
153. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl$2.doInHibernate(DownloadServiceDaoHibernateImpl.java:137)??
154. ????at?org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)??
155. ????at?org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)??
156. ????at?com.monitor110.rss.download.service.DownloadServiceDaoHibernateImpl.save(DownloadServiceDaoHibernateImpl.java:118)??
157. ????at?com.monitor110.rss.download.service.DownloadServiceImpl.persist(DownloadServiceImpl.java:41)??
158. ????at?sun.reflect.GeneratedMethodAccessor168.invoke(Unknown?Source)??
159. ????at?sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)??
160. ????at?java.lang.reflect.Method.invoke(Method.java:585)??
161. ????at?org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:299)??
162. ????at?org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)??
163. ????at?org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)??
164. ????at?org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)??
165. ????at?org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)??
166. ????at?org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)??
167. ????at?$Proxy84.persist(Unknown?Source)??
168. ????at?com.monitor110.rss.download.service.DownloadResultConsumer.onMessage(DownloadResultConsumer.java:28)??
169. ????at?org.jencks.LocalTransactionEndpoint.onMessage(LocalTransactionEndpoint.java:68)??
170. ????at?org.apache.activemq.ra.MessageEndpointProxy$MessageEndpointAlive.onMessage(MessageEndpointProxy.java:121)??
171. ????at?org.apache.activemq.ra.MessageEndpointProxy.onMessage(MessageEndpointProxy.java:61)??
172. ????at?org.apache.activemq.ActiveMQSession.run(ActiveMQSession.java:695)??
173. ????at?org.apache.activemq.ra.ServerSessionImpl.run(ServerSessionImpl.java:165)??
174. ????at?org.apache.geronimo.connector.work.WorkerContext.run(WorkerContext.java:291)??
175. ????at?EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown?Source)??
176. ????at?java.lang.Thread.run(Thread.java:595)??
177. ??
178. ??
179. **?END?NESTED?EXCEPTION?**??
180. ??
181. ??
182. ??
183. Last?packet?sent?to?the?server?was?914670?ms?ago.??
184. ????at?com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2561)??
185. ????at?com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2860)??
186. ????at?com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)??
187. ????at?com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1289)??
188. ????at?com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2270)??
189. ????at?com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:423)??
190. ????at?com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1960)??
191. ????at?com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1385)??
192. ????at?com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1728)??
193. ????at?com.mysql.jdbc.Connection.execSQL(Connection.java:2978)??
194. ????at?com.mysql.jdbc.Connection.execSQL(Connection.java:2902)??
195. ????at?com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:933)??
196. ????at?com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1027)??
197. ????at?org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)??
198. ????at?org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)??
199. ????at?org.hibernate.loader.Loader.getResultSet(Loader.java:1669)??
200. ????at?org.hibernate.loader.Loader.doQuery(Loader.java:662)??
201. ????at?org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)??
202. ????at?org.hibernate.loader.Loader.loadCollection(Loader.java:1919)??
203. ????...?34?more??
204. 2007-04-28?11:09:28,956?INFO??[STDOUT]?Hibernate:?insert?into?DOWNLOAD_EVENTS?(EVENT_TIME,?EVENT_TYPE,?CHANNEL_URL,?ERROR_MESSAGE,?FEED_TITLE,?EVENT_CATEGORY,?CHANNEL_ID)?values?(?,??,??,??,??,??,??)??
205. 2007-04-28?11:09:46,123?WARN??[org.apache.commons.httpclient.HttpMethodBase]?Cookie?rejected:?"$Version=0;?cookieb2evosession=325238_kTKG95W2UgwnpNYoFDmTgALummwkBqbY;?$Path=/;?$Domain=.www.seeisee.com".?Illegal?domain?attribute?".www.seeisee.com".?Domain?of?origin:?"www.seeisee.com"??
206. 2007-04-28?11:09:49,692?ERROR?[org.hibernate.transaction.JDBCTransaction]?JDBC?commit?failed??
207. java.sql.SQLException:?Can't?call?commit?when?autocommit=true??
208. ????at?com.mysql.jdbc.Connection.commit(Connection.java:2145)??
209. ????at?org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:436)??
210. ????at?org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:331)??
211. ????at?org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)??
212. ????at?org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)??
213. ????at?org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:570)??
214. ????at?org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:651)??
215. ????at?org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:621)??
216. ????at?org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:311)??
217. ????at?org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)??
218. ????at?org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)??
219. ????at?org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)??
220. ????at?$Proxy84.persist(Unknown?Source)??
221. ????at?com.monitor110.rss.download.service.DownloadResultConsumer.onMessage(DownloadResultConsumer.java:39)??
222. ????at?org.jencks.LocalTransactionEndpoint.onMessage(LocalTransactionEndpoint.java:68)??
223. ????at?org.apache.activemq.ra.MessageEndpointProxy$MessageEndpointAlive.onMessage(MessageEndpointProxy.java:121)??
224. ????at?org.apache.activemq.ra.MessageEndpointProxy.onMessage(MessageEndpointProxy.java:61)??
225. ????at?org.apache.activemq.ActiveMQSession.run(ActiveMQSession.java:695)??
226. ????at?org.apache.activemq.ra.ServerSessionImpl.run(ServerSessionImpl.java:165)??
227. ????at?org.apache.geronimo.connector.work.WorkerContext.run(WorkerContext.java:291)??
228. ????at?EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown?Source)??
229. ????at?java.lang.Thread.run(Thread.java:595)??
230. 2007-04-28?11:09:50,219?INFO??[STDOUT]?Hibernate:?update?CHANNELS?set?IS_DOWNLOADING=?,?LAST_UPDATED=now()?where?CHANNEL_ID=???

1. 2007-04-28?10:54:29,415?INFO??[STDOUT]?Hibernate:?update?CHANNELS?set?IS_DOWNLOADING=?,?LAST_UPDATED=now()?where?CHANNEL_ID=???
2. 2007-04-28?11:09:26,057?WARN??[org.hibernate.util.JDBCExceptionReporter]?SQL?Error:?0,?SQLState:?08S01?
   

从开始这段看出这条update语句竟然执行了15多分钟。 从后面的msyql的异常也可以知道

Last?packet?sent?to?the?server?was?914670?ms?ago.

我想问问， 发生这种情况是不是msyql承受不了这样的压力呢？ 1 楼 duprf 2007-08-10 我现在出现了跟你一样的错误,不知道楼上的仁兄怎么解决 2 楼 dengyin2000 2007-08-10 duprf 写道我现在出现了跟你一样的错误,不知道楼上的仁兄怎么解决

并发太大了。。 我可以减少线程 解决这个问题。 现在换成了oracle。 没有减少现在也没有问题了。。。 3 楼 duprf 2007-08-13 dengyin2000 写道duprf 写道我现在出现了跟你一样的错误,不知道楼上的仁兄怎么解决

并发太大了。。 我可以减少线程 解决这个问题。 现在换成了oracle。 没有减少现在也没有问题了。。。谢谢你,我试试看