首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Mysql >

Mysql 错误。 寻求帮助

2012-11-08 
Mysql 异常。 寻求帮助我先描述下环境。我们这里有个rss download server。 使用activemq + timertask schual

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。 没有减少现在也没有问题了。。。谢谢你,我试试看

读书人精选
热点排行