平台备份报错

平台备份报错,看不太懂,有没有大佬帮忙指点下

java.lang.Exception: Fail to write entity Entity

        at com.fr.decision.backup.BackUpContext.write(BackUpContext.java:99)

        at com.fr.decision.backup.AbstractBackUpRecoveryContext.write(AbstractBackUpRecoveryContext.java:159)

        at com.fr.decision.backup.AbstractBackUpRecoveryContext.transfer(AbstractBackUpRecoveryContext.java:98)

        at com.fr.decision.backup.BackUpContext.backUp(BackUpContext.java:62)

        at com.fr.decision.webservice.v10.backup.module.BaseModuleBackup.backupDB(BaseModuleBackup.java:554)

        at com.fr.decision.webservice.v10.backup.module.ConfigBackup.extensionalBackup(ConfigBackup.java:29)

        at com.fr.decision.webservice.v10.backup.module.BaseModuleBackup.backup(BaseModuleBackup.java:201)

        at com.fr.decision.webservice.v10.backup.module.BaseModuleBackup.backup(BaseModuleBackup.java:135)

        at com.fr.decision.webservice.v10.backup.BackupModuleJob.doAutoBackup(BackupModuleJob.java:43)

        at com.fr.decision.webservice.v10.backup.BackupModuleJob.run(BackupModuleJob.java:34)

        at com.fr.scheduler.job.FineScheduleJob.execute(FineScheduleJob.java)

        at com.fr.third.v2.org.quartz.core.JobRunShell.run(JobRunShell.java:204)

        at com.fr.third.alibaba.ttl.TtlRunnable.run(TtlRunnable.java:58)

        at com.fr.third.v2.org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:606)

Caused by: com.fr.third.org.hibernate.exception.DataException: could not execute statement

        at com.fr.third.org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52)

        at com.fr.third.org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

        at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)

        at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)

        at com.fr.third.org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)

        at com.fr.third.org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)

        at com.fr.third.org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2997)

        at com.fr.third.org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3497)

        at com.fr.third.org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)

        at com.fr.third.org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:588)

        at com.fr.third.org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:462)

        at com.fr.third.org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)

        at com.fr.third.org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)

        at com.fr.third.org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1294)

        at com.fr.stable.db.session.SessionManager$DBSessionImpl.flush(SessionManager.java)

        at com.fr.decision.backup.BackUpContext.write(BackUpContext.java:90)

        ... 13 more

Caused by: java.sql.SQLDataException: data exception: string data, right truncation;  table: FINE_CONF_ENTITY column: VALUE

        at com.fr.third.org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:322)

        at com.fr.third.org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:247)

        at com.fr.third.org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStatement.java:4675)

        at com.fr.third.org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(JDBCPreparedStatement.java:312)

        at com.fr.third.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255)

        at com.fr.third.org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)

        ... 24 more

Caused by: com.fr.third.org.hsqldb.HsqlException: data exception: string data, right truncation;  table: FINE_CONF_ENTITY column: VALUE

        at com.fr.third.org.hsqldb.error.Error.error(Error.java:138)

        at com.fr.third.org.hsqldb.Table.enforceTypeLimits(Table.java:2393)

        at com.fr.third.org.hsqldb.Table.generateAndCheckData(Table.java:2691)

        at com.fr.third.org.hsqldb.Table.insertSingleRow(Table.java:2705)

        at com.fr.third.org.hsqldb.StatementDML.insertSingleRow(StatementDML.java:969)

        at com.fr.third.org.hsqldb.StatementInsert.getResult(StatementInsert.java:153)

        at com.fr.third.org.hsqldb.StatementDMQL.execute(StatementDMQL.java:184)

        at com.fr.third.org.hsqldb.Session.executeCompiledStatement(Session.java:1384)

        at com.fr.third.org.hsqldb.Session.execute(Session.java:1007)

        at com.fr.third.org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStatement.java:4667)

        ... 27 more

Caused by: com.fr.third.org.hsqldb.HsqlException: data exception: string data, right truncation

        at com.fr.third.org.hsqldb.error.Error.error(Error.java:138)

        at com.fr.third.org.hsqldb.error.Error.error(Error.java:107)

        at com.fr.third.org.hsqldb.types.CharacterType.convertToTypeLimits(CharacterType.java:443)

        at com.fr.third.org.hsqldb.Table.enforceTypeLimits(Table.java:2381)

        ... 35 more

FineReport 小白新手 发布于 2022-8-29 10:26
1min目标场景问卷 立即参与
回答问题
悬赏:3 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共1回答
最佳回答
0
zsh331Lv8专家互助
发布于2022-8-29 13:12

配置了MySQL外接数据库?将MySQL的引擎「MyISAM」切换为「InnoDB」后,重启服务再备份。

——————————

  • 小白新手 小白新手(提问者) 在那个里面可以调整这个?这个是有什么区别吗
    2022-08-29 13:37 
  • zsh331 zsh331 回复 小白新手(提问者) 区别就是一个报错,一个不报表。具体原因,你们单位的dba应该懂!
    2022-08-29 13:38 
  • 2关注人数
  • 346浏览人数
  • 最后回答于:2022-8-29 13:12
    请选择关闭问题的原因
    确定 取消
    返回顶部