关于数据备份时候报错，导致数据恢复错误，请问怎么解决
请管理员大大看一下~谢谢备份的错误日志发来看看 <openjpa-3.2.2-re5933d6 fatal general error> org.apache.openjpa.persistence.PersistenceException: General error: "java.lang.NullPointerException"
FailedObject: com.x.program.center.core.entity.validation.Meta-06b908c7-6074-4bd9-8d5c-32e033d62a73
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5326)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5286)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:330)
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:123)
at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:59)
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1118)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:1076)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:998)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1077)
at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:305)
at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2537)
at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:298)
at org.apache.openjpa.jdbc.kernel.InstanceResultObjectProvider.getResultObject(InstanceResultObjectProvider.java:60)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2193)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:38)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
at com.x.server.console.action.DumpData$RunnableImpl.list(DumpData.java:188)
at com.x.server.console.action.DumpData$RunnableImpl.dump(DumpData.java:205)
at com.x.server.console.action.DumpData$RunnableImpl.lambda$run$0(DumpData.java:120)
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290)
at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:746)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183)
Caused by: org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.NullPointerException"
at org.h2.message.DbException.getJdbcSQLException(DbException.java:505)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:194)
at org.h2.message.DbException.convert(DbException.java:347)
at org.h2.message.DbException.toSQLException(DbException.java:319)
at org.h2.message.TraceObject.logAndConvert(TraceObject.java:366)
at org.h2.jdbc.JdbcResultSet.getTimestamp(JdbcResultSet.java:426)
at com.alibaba.druid.filter.FilterChainImpl.resultSet_getTimestamp(FilterChainImpl.java:1045)
at com.alibaba.druid.filter.FilterAdapter.resultSet_getTimestamp(FilterAdapter.java:1814)
at com.alibaba.druid.filter.FilterChainImpl.resultSet_getTimestamp(FilterChainImpl.java:1041)
at com.alibaba.druid.proxy.jdbc.ResultSetProxyImpl.getTimestamp(ResultSetProxyImpl.java:717)
at com.alibaba.druid.pool.DruidPooledResultSet.getTimestamp(DruidPooledResultSet.java:207)
at org.apache.openjpa.lib.jdbc.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:189)
at org.apache.openjpa.jdbc.sql.DBDictionary.getTimestamp(DBDictionary.java:1081)
at org.apache.openjpa.jdbc.sql.DBDictionary.getDate(DBDictionary.java:933)
at org.apache.openjpa.jdbc.sql.ResultSetResult.getDateInternal(ResultSetResult.java:376)
at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:473)
at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:838)
at org.apache.openjpa.jdbc.meta.strats.HandlerStrategies.loadDataStore(HandlerStrategies.java:225)
at org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy.load(HandlerFieldStrategy.java:202)
at org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:961)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1157)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1103)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:430)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:325)
... 32 more
Caused by: java.lang.NullPointerException
at org.h2.value.Value.convertToTimestamp(Value.java:1146)
at org.h2.value.Value.convertTo(Value.java:822)
at org.h2.value.Value.convertTo(Value.java:737)
at org.h2.value.Value.getTimestamp(Value.java:591)
at org.h2.jdbc.JdbcResultSet.getTimestamp(JdbcResultSet.java:424)
... 50 more
2023-11-06 13:36:44.806 ERROR com.x.server.console.action.DumpData - id:81a9bdd2-75a0-40d4-aea5-8880bd18e017, name:com.x.server.console.action.DumpData, message:dump:com.x.program.center.core.entity.validation.Meta error., exception:java.lang.Exception.
java.lang.Exception: dump:com.x.program.center.core.entity.validation.Meta error.
at com.x.server.console.action.DumpData$RunnableImpl.lambda$run$0(DumpData.java:123) ~
at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[?:?]
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655) ~[?:?]
at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484) ~[?:?]
at java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[?:?]
at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:746) ~[?:?]
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) ~[?:?]
at java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) ~[?:?]
at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) ~[?:?]
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) ~[?:?]
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183) ~[?:?]
Caused by: org.apache.openjpa.persistence.PersistenceException: General error: "java.lang.NullPointerException"
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5326) ~
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5286) ~
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) ~
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:330) ~
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:123) ~
at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:59) ~
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1118) ~
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:1076) ~
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:998) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1077) ~
at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:305) ~
at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2537) ~
at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:298) ~
at org.apache.openjpa.jdbc.kernel.InstanceResultObjectProvider.getResultObject(InstanceResultObjectProvider.java:60) ~
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2193) ~
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:38) ~
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~
at com.x.server.console.action.DumpData$RunnableImpl.list(DumpData.java:188) ~
at com.x.server.console.action.DumpData$RunnableImpl.dump(DumpData.java:205) ~
at com.x.server.console.action.DumpData$RunnableImpl.lambda$run$0(DumpData.java:120) ~
... 10 more
Caused by: org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.NullPointerException"
at org.h2.message.DbException.getJdbcSQLException(DbException.java:505) ~
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~
at org.h2.message.DbException.get(DbException.java:194) ~
at org.h2.message.DbException.convert(DbException.java:347) ~
at org.h2.message.DbException.toSQLException(DbException.java:319) ~
at org.h2.message.TraceObject.logAndConvert(TraceObject.java:366) ~
at org.h2.jdbc.JdbcResultSet.getTimestamp(JdbcResultSet.java:426) ~
at com.alibaba.druid.filter.FilterChainImpl.resultSet_getTimestamp(FilterChainImpl.java:1045) ~
at com.alibaba.druid.filter.FilterAdapter.resultSet_getTimestamp(FilterAdapter.java:1814) ~
at com.alibaba.druid.filter.FilterChainImpl.resultSet_getTimestamp(FilterChainImpl.java:1041) ~
at com.alibaba.druid.proxy.jdbc.ResultSetProxyImpl.getTimestamp(ResultSetProxyImpl.java:717) ~
at com.alibaba.druid.pool.DruidPooledResultSet.getTimestamp(DruidPooledResultSet.java:207) ~
at org.apache.openjpa.lib.jdbc.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:189) ~
at org.apache.openjpa.jdbc.sql.DBDictionary.getTimestamp(DBDictionary.java:1081) ~
at org.apache.openjpa.jdbc.sql.DBDictionary.getDate(DBDictionary.java:933) ~
at org.apache.openjpa.jdbc.sql.ResultSetResult.getDateInternal(ResultSetResult.java:376) ~
at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:473) ~
at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:838) ~
at org.apache.openjpa.jdbc.meta.strats.HandlerStrategies.loadDataStore(HandlerStrategies.java:225) ~
at org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy.load(HandlerFieldStrategy.java:202) ~
at org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:961) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1157) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1103) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:430) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:325) ~
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:123) ~
at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:59) ~
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1118) ~
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:1076) ~
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:998) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1077) ~
at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:305) ~
at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2537) ~
at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:298) ~
at org.apache.openjpa.jdbc.kernel.InstanceResultObjectProvider.getResultObject(InstanceResultObjectProvider.java:60) ~
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2193) ~
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:38) ~
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~
at com.x.server.console.action.DumpData$RunnableImpl.list(DumpData.java:188) ~
at com.x.server.console.action.DumpData$RunnableImpl.dump(DumpData.java:205) ~
at com.x.server.console.action.DumpData$RunnableImpl.lambda$run$0(DumpData.java:120) ~
... 10 more
Caused by: java.lang.NullPointerException
at org.h2.value.Value.convertToTimestamp(Value.java:1146) ~
at org.h2.value.Value.convertTo(Value.java:822) ~
at org.h2.value.Value.convertTo(Value.java:737) ~
at org.h2.value.Value.getTimestamp(Value.java:591) ~
at org.h2.jdbc.JdbcResultSet.getTimestamp(JdbcResultSet.java:424) ~
at com.alibaba.druid.filter.FilterChainImpl.resultSet_getTimestamp(FilterChainImpl.java:1045) ~
at com.alibaba.druid.filter.FilterAdapter.resultSet_getTimestamp(FilterAdapter.java:1814) ~
at com.alibaba.druid.filter.FilterChainImpl.resultSet_getTimestamp(FilterChainImpl.java:1041) ~
at com.alibaba.druid.proxy.jdbc.ResultSetProxyImpl.getTimestamp(ResultSetProxyImpl.java:717) ~
at com.alibaba.druid.pool.DruidPooledResultSet.getTimestamp(DruidPooledResultSet.java:207) ~
at org.apache.openjpa.lib.jdbc.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:189) ~
at org.apache.openjpa.jdbc.sql.DBDictionary.getTimestamp(DBDictionary.java:1081) ~
at org.apache.openjpa.jdbc.sql.DBDictionary.getDate(DBDictionary.java:933) ~
at org.apache.openjpa.jdbc.sql.ResultSetResult.getDateInternal(ResultSetResult.java:376) ~
at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:473) ~
at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:838) ~
at org.apache.openjpa.jdbc.meta.strats.HandlerStrategies.loadDataStore(HandlerStrategies.java:225) ~
at org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy.load(HandlerFieldStrategy.java:202) ~
at org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:961) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1157) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1103) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:430) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:325) ~
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:123) ~
at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:59) ~
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1118) ~
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:1076) ~
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:998) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1077) ~
at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:305) ~
at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2537) ~
at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:298) ~
at org.apache.openjpa.jdbc.kernel.InstanceResultObjectProvider.getResultObject(InstanceResultObjectProvider.java:60) ~
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2193) ~
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:38) ~
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~
at com.x.server.console.action.DumpData$RunnableImpl.list(DumpData.java:188) ~
at com.x.server.console.action.DumpData$RunnableImpl.dump(DumpData.java:205) ~
at com.x.server.console.action.DumpData$RunnableImpl.lambda$run$0(DumpData.java:120) ~
... 10 more
H2数据库对时间字段不包含日期Date的兼容有问题,需要升级或者迁移到MySQL. H2数据库对时间字段不包含日期Date的兼容有问题,需要升级或者迁移到MySQL. Ray 发表于 2023-11-7 17:52
H2数据库对时间字段不包含日期Date的兼容有问题,需要升级或者迁移到MySQL.
我现在也想迁移的MySQL,就是备份资料出这种问题，迁移的资料有问题呀啊:'(
页:
[1]