Halo 2.6.0-rc.1 无法启动

Priscilla-ism

我先前在这里提出了这个问题。

在安装 2.6.0-rc.1 之后，网站依然显示“拒绝连接”。

我该如何解决此问题？

下面是 log 的一段：

2023-05-30T11:26:42.730+08:00  INFO 7 --- [main] run.halo.app.Application                 : Starting Application v2.6.0-rc.1 using Java 17.0.7 with PID 7 (/application/BOOT-INF/classes started by root in /application)
2023-05-30T11:26:42.762+08:00  INFO 7 --- [main] run.halo.app.Application                 : No active profile set, falling back to 1 default profile: "default"
2023-05-30T11:26:45.715+08:00  INFO 7 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode
2023-05-30T11:26:45.719+08:00  INFO 7 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data R2DBC repositories in DEFAULT mode.
2023-05-30T11:26:46.043+08:00  INFO 7 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 301 ms. Found 1 R2DBC repository interfaces.
2023-05-30T11:26:47.554+08:00  INFO 7 --- [main] c.g.j.r.m.MysqlConnectionFactoryProvider : set jasync.mysql.CLIENT_FOUND_ROWS=true
2023-05-30T11:26:47.685+08:00  INFO 7 --- [main] c.github.jasync.sql.db.util.NettyUtils   : jasync available transport - native (epoll)
2023-05-30T11:26:49.836+08:00  INFO 7 --- [main] org.pf4j.DefaultPluginStatusProvider     : Enabled plugins: []
2023-05-30T11:26:49.839+08:00  INFO 7 --- [main] org.pf4j.DefaultPluginStatusProvider     : Disabled plugins: []
2023-05-30T11:26:49.845+08:00  INFO 7 --- [main] org.pf4j.DefaultPluginManager            : PF4J version 3.9.0 in 'deployment' mode
2023-05-30T11:26:52.263+08:00  INFO 7 --- [main] o.s.b.a.e.web.EndpointLinksResolver      : Exposing 5 endpoint(s) beneath base path '/actuator'
2023-05-30T11:26:52.980+08:00 ERROR 7 --- [db-sql-netty-thread-2] c.g.jasync.sql.db.mysql.MySQLConnection  : <mysql-connection-1> Received an error message -> ErrorMessage(errorCode=1049, sqlState=#42000, errorMessage=Unknown database 'halo')
2023-05-30T11:26:53.018+08:00 ERROR 7 --- [db-sql-netty-thread-4] c.g.jasync.sql.db.mysql.MySQLConnection  : <mysql-connection-2> Received an error message -> ErrorMessage(errorCode=1049, sqlState=#42000, errorMessage=Unknown database 'halo')
2023-05-30T11:26:53.023+08:00  WARN 7 --- [main] onfigReactiveWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'r2dbcScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/R2dbcInitializationConfiguration.class]: Failed to execute database script
2023-05-30T11:26:53.026+08:00  INFO 7 --- [main] r.h.a.e.c.DefaultControllerManager       : Shutting down 0 controllers...
2023-05-30T11:26:53.027+08:00  INFO 7 --- [main] r.h.a.e.c.DefaultControllerManager       : Shutdown 0 controllers.
2023-05-30T11:26:53.028+08:00  INFO 7 --- [main] r.h.a.e.controller.DefaultController     : Disposing controller garbage-collector-controller
2023-05-30T11:26:53.029+08:00  INFO 7 --- [main] r.h.a.e.controller.DefaultController     : Controller garbage-collector-controller is disposed
2023-05-30T11:26:53.081+08:00  INFO 7 --- [main] .s.b.a.l.ConditionEvaluationReportLogger : 

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2023-05-30T11:26:53.085+08:00 ERROR 7 --- [db-sql-netty-thread-4] c.g.jasync.sql.db.mysql.MySQLConnection  : <mysql-connection-4> Received an error message -> ErrorMessage(errorCode=1049, sqlState=#42000, errorMessage=Unknown database 'halo')
2023-05-30T11:26:53.087+08:00 ERROR 7 --- [db-sql-netty-thread-4] c.g.jasync.sql.db.mysql.MySQLConnection  : <mysql-connection-6> Received an error message -> ErrorMessage(errorCode=1049, sqlState=#42000, errorMessage=Unknown database 'halo')
2023-05-30T11:26:53.090+08:00 ERROR 7 --- [db-sql-netty-thread-4] c.g.jasync.sql.db.mysql.MySQLConnection  : <mysql-connection-8> Received an error message -> ErrorMessage(errorCode=1049, sqlState=#42000, errorMessage=Unknown database 'halo')
2023-05-30T11:26:53.092+08:00 ERROR 7 --- [db-sql-netty-thread-2] c.g.jasync.sql.db.mysql.MySQLConnection  : <mysql-connection-3> Received an error message -> ErrorMessage(errorCode=1049, sqlState=#42000, errorMessage=Unknown database 'halo')
2023-05-30T11:26:53.093+08:00 ERROR 7 --- [db-sql-netty-thread-2] c.g.jasync.sql.db.mysql.MySQLConnection  : <mysql-connection-5> Received an error message -> ErrorMessage(errorCode=1049, sqlState=#42000, errorMessage=Unknown database 'halo')
2023-05-30T11:26:53.094+08:00 ERROR 7 --- [db-sql-netty-thread-4] c.g.jasync.sql.db.mysql.MySQLConnection  : <mysql-connection-10> Received an error message -> ErrorMessage(errorCode=1049, sqlState=#42000, errorMessage=Unknown database 'halo')
2023-05-30T11:26:53.095+08:00 ERROR 7 --- [db-sql-netty-thread-2] c.g.jasync.sql.db.mysql.MySQLConnection  : <mysql-connection-7> Received an error message -> ErrorMessage(errorCode=1049, sqlState=#42000, errorMessage=Unknown database 'halo')
2023-05-30T11:26:53.096+08:00 ERROR 7 --- [db-sql-netty-thread-2] c.g.jasync.sql.db.mysql.MySQLConnection  : <mysql-connection-9> Received an error message -> ErrorMessage(errorCode=1049, sqlState=#42000, errorMessage=Unknown database 'halo')
2023-05-30T11:26:53.098+08:00 ERROR 7 --- [db-sql-netty-thread-2] c.g.jasync.sql.db.mysql.MySQLConnection  : <mysql-connection-11> Received an error message -> ErrorMessage(errorCode=1049, sqlState=#42000, errorMessage=Unknown database 'halo')
2023-05-30T11:26:53.115+08:00 ERROR 7 --- [main] o.s.boot.SpringApplication               : Application run failed

johnniang

从日志中显示是你所连接的数据库中不存在名为 halo 的数据库。

建议升级到 Halo 2.6.0 后再试。

Priscilla-ism

johnniang
谢谢你，目前看起来已经解决了这个问题。
但是我目前依然无法运行 Halo。
新的报错如下（截取了前 200 多行）

2023-06-02T16:18:32.067+08:00  INFO 7 --- [main] run.halo.app.Application                 : Starting Application v2.6.0 using Java 17.0.7 with PID 7 (/application/BOOT-INF/classes started by root in /application)
2023-06-02T16:18:32.123+08:00  INFO 7 --- [main] run.halo.app.Application                 : No active profile set, falling back to 1 default profile: "default"
2023-06-02T16:18:35.003+08:00  INFO 7 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode
2023-06-02T16:18:35.006+08:00  INFO 7 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data R2DBC repositories in DEFAULT mode.
2023-06-02T16:18:35.386+08:00  INFO 7 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 359 ms. Found 1 R2DBC repository interfaces.
2023-06-02T16:18:39.095+08:00  INFO 7 --- [main] org.pf4j.DefaultPluginStatusProvider     : Enabled plugins: []
2023-06-02T16:18:39.097+08:00  INFO 7 --- [main] org.pf4j.DefaultPluginStatusProvider     : Disabled plugins: []
2023-06-02T16:18:39.102+08:00  INFO 7 --- [main] org.pf4j.DefaultPluginManager            : PF4J version 3.9.0 in 'deployment' mode
2023-06-02T16:18:41.947+08:00  INFO 7 --- [main] o.s.b.a.e.web.EndpointLinksResolver      : Exposing 5 endpoint(s) beneath base path '/actuator'
2023-06-02T16:18:43.384+08:00  WARN 7 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:43.633+08:00  WARN 7 --- [main] onfigReactiveWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'r2dbcScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/R2dbcInitializationConfiguration.class]: Failed to execute database script
2023-06-02T16:18:43.636+08:00  INFO 7 --- [main] r.h.a.e.c.DefaultControllerManager       : Shutting down 0 controllers...
2023-06-02T16:18:43.638+08:00  INFO 7 --- [main] r.h.a.e.c.DefaultControllerManager       : Shutdown 0 controllers.
2023-06-02T16:18:43.640+08:00  INFO 7 --- [main] r.h.a.e.controller.DefaultController     : Disposing controller garbage-collector-controller
2023-06-02T16:18:43.642+08:00  INFO 7 --- [main] r.h.a.e.controller.DefaultController     : Controller garbage-collector-controller is disposed
2023-06-02T16:18:43.678+08:00  WARN 7 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:43.680+08:00  WARN 7 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:43.683+08:00  WARN 7 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:43.684+08:00  WARN 7 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:43.686+08:00  WARN 7 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:43.688+08:00  WARN 7 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:43.689+08:00  WARN 7 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:43.690+08:00  WARN 7 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:43.703+08:00  WARN 7 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:43.705+08:00  WARN 7 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:43.729+08:00  INFO 7 --- [main] .s.b.a.l.ConditionEvaluationReportLogger : 

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2023-06-02T16:18:43.757+08:00 ERROR 7 --- [main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'r2dbcScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/R2dbcInitializationConfiguration.class]: Failed to execute database script
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1770) ~[spring-beans-6.0.9.jar:6.0.9]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598) ~[spring-beans-6.0.9.jar:6.0.9]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:520) ~[spring-beans-6.0.9.jar:6.0.9]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.9.jar:6.0.9]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.9.jar:6.0.9]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.9.jar:6.0.9]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.9.jar:6.0.9]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:973) ~[spring-beans-6.0.9.jar:6.0.9]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:941) ~[spring-context-6.0.9.jar:6.0.9]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:608) ~[spring-context-6.0.9.jar:6.0.9]
	at org.springframework.boot.web.reactive.context.ReactiveWebServerApplicationContext.refresh(ReactiveWebServerApplicationContext.java:66) ~[spring-boot-3.1.0.jar:3.1.0]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:733) ~[spring-boot-3.1.0.jar:3.1.0]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:435) ~[spring-boot-3.1.0.jar:3.1.0]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:311) ~[spring-boot-3.1.0.jar:3.1.0]
	at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:150) ~[spring-boot-3.1.0.jar:3.1.0]
	at run.halo.app.Application.main(Application.java:28) ~[classes/:2.6.0]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[application/:na]
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:95) ~[application/:na]
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[application/:na]
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65) ~[application/:na]
Caused by: org.springframework.r2dbc.connection.init.UncategorizedScriptException: Failed to execute database script
	at org.springframework.r2dbc.connection.init.DatabasePopulator.lambda$populate$4(DatabasePopulator.java:65) ~[spring-r2dbc-6.0.9.jar:6.0.9]
	at reactor.core.publisher.Mono.lambda$onErrorMap$27(Mono.java:3759) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.Mono.lambda$onErrorResume$29(Mono.java:3849) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:94) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoUsingWhen$ResourceSubscriber.onError(MonoUsingWhen.java:203) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:106) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.Operators.error(Operators.java:198) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoError.subscribe(MonoError.java:53) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.Mono.subscribe(Mono.java:4485) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:103) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:106) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxRetry$RetrySubscriber.onError(FluxRetry.java:95) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoFlatMap$FlatMapMain.onError(MonoFlatMap.java:180) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.pool.AbstractPool$Borrower.fail(AbstractPool.java:475) ~[reactor-pool-1.0.0.jar:1.0.0]
	at reactor.pool.SimpleDequePool.lambda$drainLoop$9(SimpleDequePool.java:429) ~[reactor-pool-1.0.0.jar:1.0.0]
	at reactor.core.publisher.FluxDoOnEach$DoOnEachSubscriber.onError(FluxDoOnEach.java:186) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoFlatMap$FlatMapMain.onError(MonoFlatMap.java:180) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoFlatMap$FlatMapMain.secondError(MonoFlatMap.java:241) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoFlatMap$FlatMapInner.onError(MonoFlatMap.java:315) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.onError(MonoIgnoreThen.java:278) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:106) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.onError(MonoIgnoreThen.java:278) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:231) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.onComplete(MonoIgnoreThen.java:203) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.Operators.complete(Operators.java:137) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.netty.FutureMono.doSubscribe(FutureMono.java:122) ~[reactor-netty-core-1.1.7.jar:1.1.7]
	at reactor.netty.FutureMono$DeferredFutureMono.subscribe(FutureMono.java:114) ~[reactor-netty-core-1.1.7.jar:1.1.7]
	at reactor.core.publisher.Mono.subscribe(Mono.java:4485) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:263) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoIgnoreThen.subscribe(MonoIgnoreThen.java:51) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.Mono.subscribe(Mono.java:4485) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:103) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.MonoFlatMapMany$FlatMapManyInner.onError(MonoFlatMapMany.java:255) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxPeekFuseable$PeekFuseableSubscriber.onError(FluxPeekFuseable.java:234) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxContextWrite$ContextWriteSubscriber.onError(FluxContextWrite.java:121) ~[reactor-core-3.5.6.jar:3.5.6]
	at io.asyncer.r2dbc.mysql.internal.util.DiscardOnCancelSubscriber.onError(DiscardOnCancelSubscriber.java:75) ~[r2dbc-mysql-1.0.2.jar:1.0.2]
	at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onError(FluxPeekFuseable.java:903) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxHandle$HandleConditionalSubscriber.onNext(FluxHandle.java:349) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.SinkManyEmitterProcessor.drain(SinkManyEmitterProcessor.java:471) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.SinkManyEmitterProcessor.tryEmitNext(SinkManyEmitterProcessor.java:269) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.SinkManySerialized.tryEmitNext(SinkManySerialized.java:100) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.InternalManySink.emitNext(InternalManySink.java:27) ~[reactor-core-3.5.6.jar:3.5.6]
	at io.asyncer.r2dbc.mysql.client.ReactorNettyClient$ResponseSink.next(ReactorNettyClient.java:356) ~[r2dbc-mysql-1.0.2.jar:1.0.2]
	at io.asyncer.r2dbc.mysql.client.ReactorNettyClient.lambda$new$0(ReactorNettyClient.java:115) ~[r2dbc-mysql-1.0.2.jar:1.0.2]
	at reactor.core.publisher.FluxPeek$PeekSubscriber.onNext(FluxPeek.java:185) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.netty.channel.FluxReceive.drainReceiver(FluxReceive.java:292) ~[reactor-netty-core-1.1.7.jar:1.1.7]
	at reactor.netty.channel.FluxReceive.onInboundNext(FluxReceive.java:401) ~[reactor-netty-core-1.1.7.jar:1.1.7]
	at reactor.netty.channel.ChannelOperations.onInboundNext(ChannelOperations.java:411) ~[reactor-netty-core-1.1.7.jar:1.1.7]
	at reactor.netty.channel.ChannelOperationsHandler.channelRead(ChannelOperationsHandler.java:113) ~[reactor-netty-core-1.1.7.jar:1.1.7]
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.asyncer.r2dbc.mysql.client.MessageDuplexCodec.handleDecoded(MessageDuplexCodec.java:178) ~[r2dbc-mysql-1.0.2.jar:1.0.2]
	at io.asyncer.r2dbc.mysql.client.MessageDuplexCodec.channelRead(MessageDuplexCodec.java:81) ~[r2dbc-mysql-1.0.2.jar:1.0.2]
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346) ~[netty-codec-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:318) ~[netty-codec-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.handler.ssl.SslHandler.unwrap(SslHandler.java:1383) ~[netty-handler-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.handler.ssl.SslHandler.decodeJdkCompatible(SslHandler.java:1246) ~[netty-handler-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.handler.ssl.SslHandler.decode(SslHandler.java:1295) ~[netty-handler-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.handler.codec.ByteToMessageDecoder.decodeRemovalReentryProtection(ByteToMessageDecoder.java:529) ~[netty-codec-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:468) ~[netty-codec-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:290) ~[netty-codec-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) ~[netty-transport-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe.epollInReady(AbstractEpollStreamChannel.java:800) ~[netty-transport-classes-epoll-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.java:499) ~[netty-transport-classes-epoll-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:397) ~[netty-transport-classes-epoll-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997) ~[netty-common-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.1.92.Final.jar:4.1.92.Final]
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.1.92.Final.jar:4.1.92.Final]
	at java.base/java.lang.Thread.run(Unknown Source) ~[na:na]
	Suppressed: java.lang.Exception: #block terminated with an error
		at reactor.core.publisher.BlockingSingleSubscriber.blockingGet(BlockingSingleSubscriber.java:99) ~[reactor-core-3.5.6.jar:3.5.6]
		at reactor.core.publisher.Mono.block(Mono.java:1710) ~[reactor-core-3.5.6.jar:3.5.6]
		at org.springframework.boot.r2dbc.init.R2dbcScriptDatabaseInitializer.runScripts(R2dbcScriptDatabaseInitializer.java:68) ~[spring-boot-3.1.0.jar:3.1.0]
		at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.runScripts(AbstractScriptDatabaseInitializer.java:146) ~[spring-boot-3.1.0.jar:3.1.0]
		at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applyScripts(AbstractScriptDatabaseInitializer.java:108) ~[spring-boot-3.1.0.jar:3.1.0]
		at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applySchemaScripts(AbstractScriptDatabaseInitializer.java:98) ~[spring-boot-3.1.0.jar:3.1.0]
		at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.initializeDatabase(AbstractScriptDatabaseInitializer.java:76) ~[spring-boot-3.1.0.jar:3.1.0]
		at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.afterPropertiesSet(AbstractScriptDatabaseInitializer.java:66) ~[spring-boot-3.1.0.jar:3.1.0]
		at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1816) ~[spring-beans-6.0.9.jar:6.0.9]
		at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1766) ~[spring-beans-6.0.9.jar:6.0.9]
		at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598) ~[spring-beans-6.0.9.jar:6.0.9]
		at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:520) ~[spring-beans-6.0.9.jar:6.0.9]
		at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.9.jar:6.0.9]
		at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.9.jar:6.0.9]
		at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.9.jar:6.0.9]
		at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.9.jar:6.0.9]
		at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:973) ~[spring-beans-6.0.9.jar:6.0.9]
		at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:941) ~[spring-context-6.0.9.jar:6.0.9]
		at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:608) ~[spring-context-6.0.9.jar:6.0.9]
		at org.springframework.boot.web.reactive.context.ReactiveWebServerApplicationContext.refresh(ReactiveWebServerApplicationContext.java:66) ~[spring-boot-3.1.0.jar:3.1.0]
		at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:733) ~[spring-boot-3.1.0.jar:3.1.0]
		at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:435) ~[spring-boot-3.1.0.jar:3.1.0]
		at org.springframework.boot.SpringApplication.run(SpringApplication.java:311) ~[spring-boot-3.1.0.jar:3.1.0]
		at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:150) ~[spring-boot-3.1.0.jar:3.1.0]
		at run.halo.app.Application.main(Application.java:28) ~[classes/:2.6.0]
		at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
		at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
		at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
		at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
		at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[application/:na]
		at org.springframework.boot.loader.Launcher.launch(Launcher.java:95) ~[application/:na]
		at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[application/:na]
		at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65) ~[application/:na]
Caused by: org.springframework.dao.DataAccessResourceFailureException: Failed to obtain R2DBC Connection
	at org.springframework.r2dbc.connection.ConnectionFactoryUtils.lambda$getConnection$0(ConnectionFactoryUtils.java:90) ~[spring-r2dbc-6.0.9.jar:6.0.9]
	at reactor.core.publisher.Mono.lambda$onErrorMap$28(Mono.java:3773) ~[reactor-core-3.5.6.jar:3.5.6]
	at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:94) ~[reactor-core-3.5.6.jar:3.5.6]
	... 73 common frames omitted
Caused by: io.r2dbc.spi.R2dbcBadGrammarException: Unknown database 'halo'
	at io.asyncer.r2dbc.mysql.message.server.ErrorMessage.toException(ErrorMessage.java:128) ~[r2dbc-mysql-1.0.2.jar:1.0.2]
	at io.asyncer.r2dbc.mysql.message.server.ErrorMessage.toException(ErrorMessage.java:73) ~[r2dbc-mysql-1.0.2.jar:1.0.2]
	at io.asyncer.r2dbc.mysql.LoginExchangeable.accept(QueryFlow.java:803) ~[r2dbc-mysql-1.0.2.jar:1.0.2]
	at io.asyncer.r2dbc.mysql.LoginExchangeable.accept(QueryFlow.java:748) ~[r2dbc-mysql-1.0.2.jar:1.0.2]
	at reactor.core.publisher.FluxHandle$HandleConditionalSubscriber.onNext(FluxHandle.java:326) ~[reactor-core-3.5.6.jar:3.5.6]
	... 45 common frames omitted

2023-06-02T16:18:46.291+08:00  INFO 8 --- [main] run.halo.app.Application                 : Starting Application v2.6.0 using Java 17.0.7 with PID 8 (/application/BOOT-INF/classes started by root in /application)
2023-06-02T16:18:46.301+08:00  INFO 8 --- [main] run.halo.app.Application                 : No active profile set, falling back to 1 default profile: "default"
2023-06-02T16:18:48.708+08:00  INFO 8 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode
2023-06-02T16:18:48.712+08:00  INFO 8 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data R2DBC repositories in DEFAULT mode.
2023-06-02T16:18:48.999+08:00  INFO 8 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 263 ms. Found 1 R2DBC repository interfaces.
2023-06-02T16:18:51.771+08:00  INFO 8 --- [main] org.pf4j.DefaultPluginStatusProvider     : Enabled plugins: []
2023-06-02T16:18:51.773+08:00  INFO 8 --- [main] org.pf4j.DefaultPluginStatusProvider     : Disabled plugins: []
2023-06-02T16:18:51.778+08:00  INFO 8 --- [main] org.pf4j.DefaultPluginManager            : PF4J version 3.9.0 in 'deployment' mode
2023-06-02T16:18:53.954+08:00  INFO 8 --- [main] o.s.b.a.e.web.EndpointLinksResolver      : Exposing 5 endpoint(s) beneath base path '/actuator'
2023-06-02T16:18:55.393+08:00  WARN 8 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:55.635+08:00  WARN 8 --- [main] onfigReactiveWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'r2dbcScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/R2dbcInitializationConfiguration.class]: Failed to execute database script
2023-06-02T16:18:55.642+08:00  INFO 8 --- [main] r.h.a.e.c.DefaultControllerManager       : Shutting down 0 controllers...
2023-06-02T16:18:55.646+08:00  INFO 8 --- [main] r.h.a.e.c.DefaultControllerManager       : Shutdown 0 controllers.
2023-06-02T16:18:55.647+08:00  INFO 8 --- [main] r.h.a.e.controller.DefaultController     : Disposing controller garbage-collector-controller
2023-06-02T16:18:55.648+08:00  INFO 8 --- [main] r.h.a.e.controller.DefaultController     : Controller garbage-collector-controller is disposed
2023-06-02T16:18:55.672+08:00  WARN 8 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:55.673+08:00  WARN 8 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:55.673+08:00  WARN 8 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:55.674+08:00  WARN 8 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:55.674+08:00  WARN 8 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:55.684+08:00  WARN 8 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:55.685+08:00  WARN 8 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:55.685+08:00  WARN 8 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:55.686+08:00  WARN 8 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:55.686+08:00  WARN 8 --- [reactor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec    : Connection has been closed by peer
2023-06-02T16:18:55.758+08:00  INFO 8 --- [main] .s.b.a.l.ConditionEvaluationReportLogger : 

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2023-06-02T16:18:55.802+08:00 ERROR 8 --- [main] o.s.boot.SpringApplication               : Application run failed

johnniang

同样的问题，你需要去 MySQL 侧创建名为 halo 的数据库。

create database halodb character set utf8mb4 collate utf8mb4_bin;

Priscilla-ism

johnniang
这是否意味着先前的数据库已经没有了？
如果这样，我是否有方法检视整个 MySQL 来尝试找到丢失的数据？