主题 : 请问jeebbs论坛部分帖子删除报错500是什么原因?
级别: 白丁
UID: 127281
积分:71 加为好友
威望: 2 精华: 0
主题:10 回复:72
注册时间:2018-12-12
在线时长:0
1#   发表于:2019-03-18 19:36:02  IP:121.146.*.*
type Exception report

message Request processing failed; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
com.jeecms.common.web.XssFilter.doFilter(XssFilter.java:45)
org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:38)
org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
root cause

org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:81)
org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:73)
org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:63)
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3400)
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3630)
org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:114)
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67)
org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1227)
org.hibernate.internal.SessionImpl.list(SessionImpl.java:1293)
org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
com.jeecms.common.hibernate4.HibernateSimpleDao.find(HibernateSimpleDao.java:167)
com.jeecms.bbs.dao.impl.BbsTopicPostOperateDaoImpl.getList(BbsTopicPostOperateDaoImpl.java:56)
com.jeecms.bbs.manager.impl.BbsTopicPostOperateMngImpl.getList(BbsTopicPostOperateMngImpl.java:41)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
com.sun.proxy.$Proxy48.getList(Unknown Source)
com.jeecms.bbs.manager.impl.BbsPostMngImpl.deleteById(BbsPostMngImpl.java:463)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
com.sun.proxy.$Proxy36.deleteById(Unknown Source)
com.jeecms.bbs.manager.impl.BbsTopicMngImpl.deleteById(BbsTopicMngImpl.java:465)
com.jeecms.bbs.manager.impl.BbsTopicMngImpl.deleteByIds(BbsTopicMngImpl.java:482)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
com.sun.proxy.$Proxy50.deleteByIds(Unknown Source)
com.jeecms.bbs.action.front.BbsTopicAct.delete(BbsTopicAct.java:735)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:180)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
com.jeecms.common.web.XssFilter.doFilter(XssFilter.java:45)
org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:38)
org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
级别: 论坛管理员
UID: 122721
积分:57884 加为好友
威望: 2 精华: 1
主题:5 回复:50085
注册时间:2018-05-07
在线时长:0
2#   发表于:2019-03-19 08:24:56  IP:117.141.*.*
您这个报错是数据库的id重复产生的
每天告诉自己一次,“我真的很不错”。
级别: 白丁
UID: 127281
积分:71 加为好友
威望: 2 精华: 0
主题:10 回复:72
注册时间:2018-12-12
在线时长:0
3#   发表于:2019-03-19 08:38:34  IP:121.146.*.*
那这个问题怎么解决呢?求详解
级别: 白丁
UID: 127281
积分:71 加为好友
威望: 2 精华: 0
主题:10 回复:72
注册时间:2018-12-12
在线时长:0
4#   发表于:2019-03-19 08:45:01  IP:121.146.*.*
请求有何解决办法?我定位到是List<BbsTopicPostOperate>list=topicPostOperateMng.getList(bean.getId(), BbsTopicPostOperate.DATA_TYPE_TOPIC,null, null,0,Integer.MAX_VALUE);  这个查询方法在查到数据库某一条记录的时候报的错
级别: 论坛管理员
UID: 122721
积分:57884 加为好友
威望: 2 精华: 1
主题:5 回复:50085
注册时间:2018-05-07
在线时长:0
5#   发表于:2019-03-19 08:47:24  IP:117.141.*.*
您好  您可以通过这个看下查的是哪个表   然后去表内看下是否有重复的数据   并吧重复的数据删除就好了
每天告诉自己一次,“我真的很不错”。
级别: 白丁
UID: 127281
积分:71 加为好友
威望: 2 精华: 0
主题:10 回复:72
注册时间:2018-12-12
在线时长:0
6#   发表于:2019-03-19 09:15:11  IP:121.146.*.*
回复第5楼 您好 我看数据库这个表bbs_topic_post_operate也没有重复重复数据的
级别: 论坛管理员
UID: 122721
积分:57884 加为好友
威望: 2 精华: 1
主题:5 回复:50085
注册时间:2018-05-07
在线时长:0
7#   发表于:2019-03-19 09:17:04  IP:117.141.*.*
每天告诉自己一次,“我真的很不错”。
级别: 白丁
UID: 127281
积分:71 加为好友
威望: 2 精华: 0
主题:10 回复:72
注册时间:2018-12-12
在线时长:0
8#   发表于:2019-03-19 09:36:59  IP:121.146.*.*
回复第7楼  这些资料我都查过了,大概意思我也知道,就是不知道有什么具体解决方案吗?[localimg]2[/localimg]
级别: 论坛管理员
UID: 122721
积分:57884 加为好友
威望: 2 精华: 1
主题:5 回复:50085
注册时间:2018-05-07
在线时长:0
9#   发表于:2019-03-19 09:42:10  IP:117.141.*.*
稍等   我帮您找下解决的方案
每天告诉自己一次,“我真的很不错”。
级别: 白丁
UID: 127281
积分:71 加为好友
威望: 2 精华: 0
主题:10 回复:72
注册时间:2018-12-12
在线时长:0
10#   发表于:2019-03-19 09:42:34  IP:121.146.*.*
回复第7楼
1 2 > >| 共2页