主题 : PV保存报错
级别: 解元
UID: 119192
积分:399 加为好友
威望: 11 精华: 0
主题:36 回复:215
注册时间:2017-12-26
在线时长:0
1#   发表于:2020-06-28 17:16:16  IP:203.219.*.*
对象信息:
sessionId = "203cccc3-6c45-46c5-b279-d37543d3c113"
accessTime = {Date@12553} "Sun Jun 28 17:04:51 CST 2020"
accessDate = {Date@12554} "Sun Jun 28 17:04:51 CST 2020"
ip = "127.0.0.1"
area = "123"
accessSource = "直接访问"
externalLink = null
engine = null
entryPage = "http://localhost:8080/"
lastStopPage = "http://localhost:8080/"
visitSecond = {Integer@12212} -1
visitPageCount = {Integer@12555} 12
operatingSystem = "MAC"
browser = "chrome 83"
keyword = ""
site = {CmsSite@12455} "com.jeecms.core.entity.CmsSite@445c7c89"


六月 28, 2020 5:06:41 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [JeeCmsFront] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement] with root cause
java.sql.SQLException: [KingbaseES Server]ERROR: invalid input syntax for type timestamp: "'17:04:51'"
at com.kingbase.core.QueryExecutor.processResultSetExtended(Unknown Source)
at com.kingbase.core.QueryExecutor.processResultSet(Unknown Source)
at com.kingbase.core.QueryExecutor.executePV3(Unknown Source)
at com.kingbase.core.QueryExecutor.execute(Unknown Source)
at com.kingbase.core.QueryExecutor.execute(Unknown Source)
at com.kingbase.jdbc3.AbstractJdbc3Statement.executePV3X(Unknown Source)
at com.kingbase.jdbc3.AbstractJdbc3Statement.execute(Unknown Source)
at com.kingbase.jdbc2.AbstractJdbc2Statement.executeUpdate(Unknown Source)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2723)
at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1069)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2721)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:145)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:253)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3281)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3183)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3525)
at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:159)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:425)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:584)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
at com.jeecms.cms.manager.assist.impl.CmsSiteAccessMngImpl$$EnhancerBySpringCGLIB$$944e6272.saveOrUpdate(<generated>)
at com.jeecms.cms.service.CmsSiteFlowCacheImpl.freshAccessCacheToDB(CmsSiteFlowCacheImpl.java:390)
at com.jeecms.cms.service.CmsSiteFlowCacheImpl.refreshToDB(CmsSiteFlowCacheImpl.java:359)
at com.jeecms.cms.service.CmsSiteFlowCacheImpl.totalCache(CmsSiteFlowCacheImpl.java:259)
at com.jeecms.cms.service.CmsSiteFlowCacheImpl.flow(CmsSiteFlowCacheImpl.java:117)
at com.jeecms.cms.action.front.CmsSiteFlowAct.flowStatistic(CmsSiteFlowAct.java:23)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:180)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.jeecms.common.web.XssFilter.doFilter(XssFilter.java:40)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:164)
at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)

级别: 解元
UID: 119192
积分:399 加为好友
威望: 11 精华: 0
主题:36 回复:215
注册时间:2017-12-26
在线时长:0
2#   发表于:2020-06-28 17:18:53  IP:203.219.*.*
回复第1楼
jc_site_access保存入库时
六月 28, 2020 5:06:41 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [JeeCmsFront] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement] with root cause
java.sql.SQLException: [KingbaseES Server]ERROR: invalid input syntax for type timestamp: "'17:04:51'"
at com.jeecms.cms.service.CmsSiteFlowCacheImpl.freshAccessCacheToDB(CmsSiteFlowCacheImpl.java:394)
at com.jeecms.cms.service.CmsSiteFlowCacheImpl.refreshToDB(CmsSiteFlowCacheImpl.java:361)
at com.jeecms.cms.service.CmsSiteFlowCacheImpl.totalCache(CmsSiteFlowCacheImpl.java:261)
at com.jeecms.cms.service.CmsSiteFlowCacheImpl.flow(CmsSiteFlowCacheImpl.java:119)
at com.jeecms.cms.action.front.CmsSiteFlowAct.flowStatistic(CmsSiteFlowAct.java:23)
级别: 论坛管理员
UID: 122721
积分:57884 加为好友
威望: 2 精华: 1
主题:5 回复:50085
注册时间:2018-05-07
在线时长:0
3#   发表于:2020-06-28 17:22:34  IP:117.153.*.*
您这个是自己开发的接口?
每天告诉自己一次,“我真的很不错”。
级别: 解元
UID: 119192
积分:399 加为好友
威望: 11 精华: 0
主题:36 回复:215
注册时间:2017-12-26
在线时长:0
4#   发表于:2020-06-28 17:23:54  IP:203.219.*.*
回复第3楼
不是,没改动。jc_site_access的2个时间字段报错
级别: 解元
UID: 119192
积分:399 加为好友
威望: 11 精华: 0
主题:36 回复:215
注册时间:2017-12-26
在线时长:0
5#   发表于:2020-06-28 17:25:04  IP:203.219.*.*
回复第3楼
发错类型了,不属于二次开发
级别: 论坛管理员
UID: 122721
积分:57884 加为好友
威望: 2 精华: 1
主题:5 回复:50085
注册时间:2018-05-07
在线时长:0
6#   发表于:2020-06-28 17:31:02  IP:117.153.*.*
是导入的时候报错还是什么情况下报错?
每天告诉自己一次,“我真的很不错”。
级别: 解元
UID: 119192
积分:399 加为好友
威望: 11 精华: 0
主题:36 回复:215
注册时间:2017-12-26
在线时长:0
7#   发表于:2020-06-28 17:31:39  IP:203.219.*.*
回复第6楼
刷新页面,统计pv值,保存结果时报错
级别: 论坛管理员
UID: 122721
积分:57884 加为好友
威望: 2 精华: 1
主题:5 回复:50085
注册时间:2018-05-07
在线时长:0
8#   发表于:2020-06-28 17:45:37  IP:117.153.*.*
您是什么版本的?
每天告诉自己一次,“我真的很不错”。
级别: 解元
UID: 119192
积分:399 加为好友
威望: 11 精华: 0
主题:36 回复:215
注册时间:2017-12-26
在线时长:0
9#   发表于:2020-06-28 17:51:54  IP:203.219.*.*
回复第8楼
V8
级别: 论坛管理员
UID: 122721
积分:57884 加为好友
威望: 2 精华: 1
主题:5 回复:50085
注册时间:2018-05-07
在线时长:0
10#   发表于:2020-06-28 18:04:44  IP:117.153.*.*
这个版本已经不在维护了的
每天告诉自己一次,“我真的很不错”。
1 共1页