应用使用的是
达梦版本 1.9的
数据库的数据是通过mysql迁移至达梦的 ，然后项目在运行过程中有如下error日志
问题一：
2021-06-08 16:22:07.738 [QuartzScheduler_schedulerFactoryBean-LAPTOP-PI56A9CB1623140347616_MisfireHandler] ERROR o.s.scheduling.quartz.LocalDataSourceJobStore - MisfireHandler: Error handling misfires: Couldn't store trigger 'logAlertGroup.logAlertGroup' for 'logAlertGroup.logAlertGroup' job:The job (logAlertGroup.logAlertGroup) referenced by the trigger does not exist.
org.quartz.JobPersistenceException: Couldn't store trigger 'logAlertGroup.logAlertGroup' for 'logAlertGroup.logAlertGroup' job:The job (logAlertGroup.logAlertGroup) referenced by the trigger does not exist.
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1228)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1042)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:991)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3249)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3997)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:4018)
Caused by: org.quartz.JobPersistenceException: The job (logAlertGroup.logAlertGroup) referenced by the trigger does not exist.
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1213)
... 5 common frames omitted
问题二：
2021-06-08 16:22:09.125 [asyncServiceExecutor-1] INFO com.jeecms.system.service.impl.SysLogServiceImpl - refresh cache log to DB: 1
2021-06-08 16:22:09.130 [asyncServiceExecutor-1] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 6092, SQLState:
2021-06-08 16:22:09.130 [asyncServiceExecutor-1] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - 数据大小已超过可支持范围
2021-06-08 16:22:09.134 [asyncServiceExecutor-1] ERROR org.hibernate.internal.ExceptionMapperStandardImpl - HHH000346: Error during managed flush [org.hibernate.exception.GenericJDBCException: could not insert: [com.jeecms.system.domain.SysLog]]
2021-06-08 16:22:09.137 [asyncServiceExecutor-1] ERROR o.s.a.i.SimpleAsyncUncaughtExceptionHandler - Unexpected error occurred invoking async method: public void com.jeecms.system.service.impl.SysLogServiceImpl.asyncLog(java.lang.String,com.jeecms.system.domain.SysLog,com.jeecms.common.response.ResponseInfo,com.jeecms.auth.domain.CoreUser,com.jeecms.system.domain.CmsSite)
org.springframework.orm.jpa.JpaSystemException: could not insert: [com.jeecms.system.domain.SysLog]; nested exception is org.hibernate.exception.GenericJDBCException: could not insert: [com.jeecms.system.domain.SysLog]
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:312)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:223)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:540)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:532)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [com.jeecms.system.domain.SysLog]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3051)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3547)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:600)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:474)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1437)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:494)
at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3245)
at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2451)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:156)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536)
... 11 common frames omitted
Caused by: dm.jdbc.driver.DMException: 数据大小已超过可支持范围
at dm.jdbc.driver.DBError.throwException(Unknown Source)
at dm.jdbc.a.b.b(Unknown Source)
at dm.jdbc.a.b.a(Unknown Source)
at dm.jdbc.driver.DmdbPreparedStatement.do_setString(Unknown Source)
at dm.jdbc.driver.DmdbPreparedStatement.setString(Unknown Source)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.setString(HikariProxyPreparedStatement.java)
at org.hibernate.type.descriptor.sql.VarcharTypeDescriptor$1.doBind(VarcharTypeDescriptor.java:46)
at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:74)
at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:280)
at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:275)
at org.hibernate.type.AbstractSingleColumnStandardBasicType.nullSafeSet(AbstractSingleColumnStandardBasicType.java:39)
at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2729)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3023)
... 27 common frames omitted |
|
回复第7楼