查看: 9988|回复: 3

关于启动时数据库报错的问题

升级   0.33%

1

主题

2

回帖

33

积分

注册会员

Rank: 2

积分
33
发表于 2022-12-8 14:13:35 | 显示全部楼层 |阅读模式
启动时报错,服务器日志:
****************************************
* data server start completed.
* port: 20050.
* web console port: 20051.
****************************************
****************************************
* storage server start completed.
* port: 20040.
****************************************
com.x.base.core.project.x_program_center loading datas, entity size:27.
2022-12-08 14:03:38.304 [main] ERROR com.alibaba.druid.pool.DruidDataSource - init datasource error, url: jdbc:h2:tcp://127.0.0.1:20050/X;LOCK_MODE=0;DEFAULT_LOCK_TIMEOUT=120000;JMX=FALSE;CACHE_SIZE=524288
org.h2.jdbc.JdbcSQLNonTransientConnectionException: File corrupted while reading record: null. Possible solution: use the recovery tool [90030-200]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:622) ~[h2-1.4.200.jar:1.4.200]
        at org.h2.engine.SessionRemote.done(SessionRemote.java:611) ~[h2-1.4.200.jar:1.4.200]
        at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:147) ~[h2-1.4.200.jar:1.4.200]
        at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:435) ~[h2-1.4.200.jar:1.4.200]
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:321) ~[h2-1.4.200.jar:1.4.200]
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:173) ~[h2-1.4.200.jar:1.4.200]
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:152) ~[h2-1.4.200.jar:1.4.200]
        at org.h2.Driver.connect(Driver.java:69) ~[h2-1.4.200.jar:1.4.200]
        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657) ~[druid-1.2.8.jar:1.2.8]
        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) ~[druid-1.2.8.jar:1.2.8]
        at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:927) ~[druid-1.2.8.jar:1.2.8]
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1401) ~[druid-1.2.8.jar:1.2.8]
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1397) ~[druid-1.2.8.jar:1.2.8]
        at com.alibaba.druid.pool.DruidDataSourceC3P0Adapter.getConnection(DruidDataSourceC3P0Adapter.java:91) ~[druid-1.2.8.jar:1.2.8]
        at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:125) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:94) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:249) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory(JDBCConfigurationImpl.java:807) ~[openjpa-3.2.0.jar:3.2.0]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at org.apache.openjpa.lib.conf.ConfigurationImpl.instantiateAll(ConfigurationImpl.java:331) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.conf.OpenJPAConfigurationImpl.instantiateAll(OpenJPAConfigurationImpl.java:1963) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:665) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:207) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:166) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.doCreateEM(EntityManagerFactoryImpl.java:282) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:201) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:188) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:178) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:64) ~[openjpa-3.2.0.jar:3.2.0]
        at com.x.base.core.container.factory.EntityManagerContainerFactory.createEntityManager(EntityManagerContainerFactory.java:109) ~[x_base_core_project.jar:?]
        at com.x.base.core.container.EntityManagerContainerBasic.get(EntityManagerContainerBasic.java:36) ~[x_base_core_project.jar:?]
        at com.x.program.center.Context.checkDefaultRole(Context.java:228) ~[classes/:?]
        at com.x.program.center.Context.concrete(Context.java:153) ~[classes/:?]
        at com.x.program.center.ApplicationServletContextListener.contextInitialized(ApplicationServletContextListener.java:13) ~[classes/:?]
        at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:1068) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:572) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ContextHandler.contextInitialized(ContextHandler.java:997) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.quickstart.QuickStartWebApp.contextInitialized(QuickStartWebApp.java:132) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:754) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:379) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1457) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.quickstart.QuickStartWebApp.startWebapp(QuickStartWebApp.java:153) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1422) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:911) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:288) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:524) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.quickstart.QuickStartWebApp.doStart(QuickStartWebApp.java:222) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:117) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:426) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.Server.start(Server.java:423) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.Server.doStart(Server.java:387) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at com.x.server.console.server.center.CenterServerTools.start(CenterServerTools.java:121) ~[console.jar:?]
        at com.x.server.console.server.Servers.startCenterServer(Servers.java:133) ~[console.jar:?]
        at com.x.server.console.Main.startCenterServer(Main.java:360) ~[console.jar:?]
        at com.x.server.console.Main.startAll(Main.java:417) ~[console.jar:?]
        at com.x.server.console.Main.main(Main.java:142) ~[console.jar:?]

请问什么原因啊?怎么处理?


回复

使用道具 举报

升级   100%

139

主题

1万

回帖

4万

积分

超级版主

Rank: 8Rank: 8

积分
41458
发表于 2022-12-8 16:43:26 | 显示全部楼层
您是什么情况下启动会这样?是不是有异常关停之类的,看起来您这个h2数据库有损坏,如果不重要,您可以把local目录删掉重启一下,数据会全清掉,如果比较重要,您需要联系h2看如何处理了。
另外,我们h2只作为测试使用,您正式使用的话建议您使用更稳定的外部数据库
回复

使用道具 举报

升级   0.33%

1

主题

2

回帖

33

积分

注册会员

Rank: 2

积分
33
发表于 2022-12-8 17:29:19 | 显示全部楼层
论坛管理员 发表于 2022-12-8 16:43
您是什么情况下启动会这样?是不是有异常关停之类的,看起来您这个h2数据库有损坏,如果不重要,您可以把lo ...

好的,我感觉也是数据库文件损坏,我研究一下h2数据库的修复吧
回复

使用道具 举报

升级   100%

139

主题

1万

回帖

4万

积分

超级版主

Rank: 8Rank: 8

积分
41458
发表于 2022-12-9 09:36:16 | 显示全部楼层
回复

使用道具 举报

发表回复

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

联系客服 关注微信 下载APP 返回顶部 返回列表
viewthread