search

halo-dev / halo

强大易用的开源建站工具。
https://www.halo.run
GNU General Public License v3.0
33.53k stars 9.63k forks source link

使用Jar部署命令行执行正常，使用Systemd作为服务运行报错H2Connection Option{name='readOnly #6373

Closed timelyRain666 closed 2 months ago

timelyRain666 commented 2 months ago

系统信息

使用的哪种方式运行？

Fat Jar

发生了什么？

文件和系统版本： image application.yaml配置： image

直接使用java -jar halo.jar --spring.config.additional-location=optional:file:/root/halo --halo.external-url=https://blog.barbell.pro，能正常运行。 Snipaste_2024-07-25_09-40-15

但是根据文档使用systemctl运行不了，以下是/etc/systemd/system/halo.service文件内容： image

已反复systemctl daemon-reload，运行报 [main] io.r2dbc.h2.H2Connection : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only 主页和console界面都无法访问，下面有一部分日志，完整日志文件在附件

相关日志输出

2024-07-25T00:31:32.178+08:00  INFO 6314 --- [main] run.halo.app.Application                 : Starting Application v2.17.2 using Java 17.0.11 with PID 6314 (/root/halo/halo.jar started by root in /)
2024-07-25T00:31:32.286+08:00  INFO 6314 --- [main] run.halo.app.Application                 : No active profile set, falling back to 1 default profile: "default"
2024-07-25T00:31:37.335+08:00  WARN 6314 --- [main] o.s.c.a.AnnotationBeanNameGenerator      : Support for convention-based stereotype names is deprecated and will be removed in a future version of the framework. Please annotate the 'value' attribute in @run.halo.app.theme.finders.Finder with @AliasFor(annotation=Component.class) to declare an explicit alias for @Component's 'value' attribute.
2024-07-25T00:32:06.202+08:00  INFO 6314 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode
2024-07-25T00:32:06.243+08:00  INFO 6314 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data R2DBC repositories in DEFAULT mode.
2024-07-25T00:32:09.863+08:00  INFO 6314 --- [main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 3442 ms. Found 1 R2DBC repository interface.
2024-07-25T00:33:09.849+08:00  INFO 6314 --- [main] org.pf4j.DefaultPluginStatusProvider     : Enabled plugins: []
2024-07-25T00:33:09.871+08:00  INFO 6314 --- [main] org.pf4j.DefaultPluginStatusProvider     : Disabled plugins: []
2024-07-25T00:33:09.904+08:00  INFO 6314 --- [main] org.pf4j.DefaultPluginManager            : PF4J version 3.12.0 in 'deployment' mode
2024-07-25T00:33:48.936+08:00  INFO 6314 --- [main] r.h.a.search.lucene.LuceneSearchEngine   : Initialized lucene search engine
2024-07-25T00:34:00.755+08:00  INFO 6314 --- [main] o.s.b.a.e.web.EndpointLinksResolver      : Exposing 34 endpoints beneath base path '/actuator'
2024-07-25T00:34:18.635+08:00  INFO 6314 --- [main] o.s.b.web.embedded.netty.NettyWebServer  : Netty started on port 8090 (http)
2024-07-25T00:34:18.656+08:00  INFO 6314 --- [main] r.h.a.e.controller.DefaultController     : Starting controller run.halo.app.metrics.VisitedEventReconciler
2024-07-25T00:34:18.684+08:00  INFO 6314 --- [main] r.h.a.e.controller.DefaultController     : Starting controller run.halo.app.content.TagPostCountUpdater
2024-07-25T00:34:18.684+08:00  INFO 6314 --- [run.halo.app.metrics.VisitedEventReconciler-t-1] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.metrics.VisitedEventReconciler-worker-1 started
2024-07-25T00:34:18.691+08:00  INFO 6314 --- [main] r.h.a.e.controller.DefaultController     : Starting controller run.halo.app.content.CategoryPostCountUpdater
2024-07-25T00:34:18.691+08:00  INFO 6314 --- [run.halo.app.content.TagPostCountUpdater-t-1] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.content.TagPostCountUpdater-worker-1 started
2024-07-25T00:34:18.695+08:00  INFO 6314 --- [main] r.h.a.e.controller.DefaultController     : Starting controller run.halo.app.metrics.VotedEventReconciler
2024-07-25T00:34:18.700+08:00  INFO 6314 --- [main] r.h.a.e.controller.DefaultController     : Starting controller run.halo.app.content.PostHideFromListStateUpdater
2024-07-25T00:34:18.701+08:00  INFO 6314 --- [run.halo.app.content.CategoryPostCountUpdater-t-1] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.content.CategoryPostCountUpdater-worker-1 started
2024-07-25T00:34:18.706+08:00  INFO 6314 --- [main] r.h.a.e.controller.DefaultController     : Starting controller run.halo.app.metrics.ReplyEventReconciler
2024-07-25T00:34:18.700+08:00  INFO 6314 --- [run.halo.app.metrics.VotedEventReconciler-t-1] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.metrics.VotedEventReconciler-worker-1 started
2024-07-25T00:34:18.710+08:00  INFO 6314 --- [main] r.h.a.e.controller.DefaultController     : Starting controller run.halo.app.metrics.PostStatsUpdater
2024-07-25T00:34:18.710+08:00  INFO 6314 --- [run.halo.app.metrics.ReplyEventReconciler-t-1] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.metrics.ReplyEventReconciler-worker-1 started
2024-07-25T00:34:18.709+08:00  INFO 6314 --- [run.halo.app.content.PostHideFromListStateUpdater-t-1] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.content.PostHideFromListStateUpdater-worker-1 started
2024-07-25T00:34:18.715+08:00  INFO 6314 --- [main] r.h.a.e.controller.DefaultController     : Starting controller run.halo.app.notification.DefaultNotificationSender
2024-07-25T00:34:18.715+08:00  INFO 6314 --- [run.halo.app.metrics.PostStatsUpdater-t-1] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.metrics.PostStatsUpdater-worker-1 started
2024-07-25T00:34:18.720+08:00  INFO 6314 --- [run.halo.app.notification.DefaultNotificationSender-t-1] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.notification.DefaultNotificationSender-worker-1 started
2024-07-25T00:34:18.722+08:00  INFO 6314 --- [run.halo.app.notification.DefaultNotificationSender-t-2] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.notification.DefaultNotificationSender-worker-2 started
2024-07-25T00:34:18.726+08:00  INFO 6314 --- [run.halo.app.notification.DefaultNotificationSender-t-3] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.notification.DefaultNotificationSender-worker-3 started
2024-07-25T00:34:18.727+08:00  INFO 6314 --- [run.halo.app.notification.DefaultNotificationSender-t-4] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.notification.DefaultNotificationSender-worker-4 started
2024-07-25T00:34:18.733+08:00  INFO 6314 --- [run.halo.app.notification.DefaultNotificationSender-t-5] r.h.a.e.controller.DefaultController     : Controller worker run.halo.app.notification.DefaultNotificationSender-worker-5 started
2024-07-25T00:34:19.718+08:00  INFO 6314 --- [main] r.h.a.e.ReactiveExtensionClientImpl      : Start building index for all extensions, please wait...
2024-07-25T00:34:22.146+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/roles, please wait...
2024-07-25T00:34:22.470+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/roles built successfully, cost 325 ms
2024-07-25T00:34:22.520+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/plugin.halo.run/plugins, please wait...
2024-07-25T00:34:22.524+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/plugin.halo.run/plugins built successfully, cost 3 ms
2024-07-25T00:34:22.572+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/plugin.halo.run/searchengines, please wait...
2024-07-25T00:34:22.575+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/plugin.halo.run/searchengines built successfully, cost 2 ms
2024-07-25T00:34:22.737+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/plugin.halo.run/extensionpointdefinitions, please wait...
2024-07-25T00:34:22.756+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/plugin.halo.run/extensionpointdefinitions built successfully, cost 18 ms
2024-07-25T00:34:22.841+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/plugin.halo.run/extensiondefinitions, please wait...
2024-07-25T00:34:22.851+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/plugin.halo.run/extensiondefinitions built successfully, cost 11 ms
2024-07-25T00:34:22.901+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/rolebindings, please wait...
2024-07-25T00:34:22.904+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/rolebindings built successfully, cost 4 ms
2024-07-25T00:34:22.999+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/users, please wait...
2024-07-25T00:34:23.013+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/users built successfully, cost 15 ms
2024-07-25T00:34:23.065+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/plugin.halo.run/reverseproxies, please wait...
2024-07-25T00:34:23.067+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/plugin.halo.run/reverseproxies built successfully, cost 3 ms
2024-07-25T00:34:23.201+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/settings, please wait...
2024-07-25T00:34:23.209+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/settings built successfully, cost 7 ms
2024-07-25T00:34:23.258+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/annotationsettings, please wait...
2024-07-25T00:34:23.262+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/annotationsettings built successfully, cost 4 ms
2024-07-25T00:34:23.354+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/configmaps, please wait...
2024-07-25T00:34:23.362+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/configmaps built successfully, cost 7 ms
2024-07-25T00:34:23.409+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/secrets, please wait...
2024-07-25T00:34:23.412+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/secrets built successfully, cost 3 ms
2024-07-25T00:34:23.545+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/theme.halo.run/themes, please wait...
2024-07-25T00:34:23.550+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/theme.halo.run/themes built successfully, cost 4 ms
2024-07-25T00:34:23.599+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/menus, please wait...
2024-07-25T00:34:23.602+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/menus built successfully, cost 3 ms
2024-07-25T00:34:23.650+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/menuitems, please wait...
2024-07-25T00:34:23.653+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/menuitems built successfully, cost 3 ms
2024-07-25T00:34:23.708+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/content.halo.run/posts, please wait...
2024-07-25T00:34:23.713+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/content.halo.run/posts built successfully, cost 5 ms
2024-07-25T00:34:23.762+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/content.halo.run/categories, please wait...
2024-07-25T00:34:23.766+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/content.halo.run/categories built successfully, cost 4 ms
2024-07-25T00:34:23.814+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/content.halo.run/tags, please wait...
2024-07-25T00:34:23.817+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/content.halo.run/tags built successfully, cost 3 ms
2024-07-25T00:34:23.867+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/content.halo.run/snapshots, please wait...
2024-07-25T00:34:23.870+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/content.halo.run/snapshots built successfully, cost 3 ms
2024-07-25T00:34:23.918+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/content.halo.run/comments, please wait...
2024-07-25T00:34:23.922+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/content.halo.run/comments built successfully, cost 4 ms
2024-07-25T00:34:23.981+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/content.halo.run/replies, please wait...
2024-07-25T00:34:23.985+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/content.halo.run/replies built successfully, cost 4 ms
2024-07-25T00:34:24.033+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/content.halo.run/singlepages, please wait...
2024-07-25T00:34:24.036+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/content.halo.run/singlepages built successfully, cost 3 ms
2024-07-25T00:34:24.107+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/storage.halo.run/groups, please wait...
2024-07-25T00:34:24.111+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/storage.halo.run/groups built successfully, cost 4 ms
2024-07-25T00:34:24.174+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/storage.halo.run/policies, please wait...
2024-07-25T00:34:24.179+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/storage.halo.run/policies built successfully, cost 4 ms
2024-07-25T00:34:24.229+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/storage.halo.run/attachments, please wait...
2024-07-25T00:34:24.233+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/storage.halo.run/attachments built successfully, cost 3 ms
2024-07-25T00:34:24.300+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/storage.halo.run/policytemplates, please wait...
2024-07-25T00:34:24.303+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/storage.halo.run/policytemplates built successfully, cost 4 ms
2024-07-25T00:34:24.352+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/metrics.halo.run/counters, please wait...
2024-07-25T00:34:24.355+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/metrics.halo.run/counters built successfully, cost 4 ms
2024-07-25T00:34:24.434+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/auth.halo.run/authproviders, please wait...
2024-07-25T00:34:24.439+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/auth.halo.run/authproviders built successfully, cost 5 ms
2024-07-25T00:34:24.488+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/auth.halo.run/userconnections, please wait...
2024-07-25T00:34:24.491+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/auth.halo.run/userconnections built successfully, cost 3 ms
2024-07-25T00:34:24.541+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/security.halo.run/personalaccesstokens, please wait...
2024-07-25T00:34:24.544+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/security.halo.run/personalaccesstokens built successfully, cost 3 ms
2024-07-25T00:34:24.593+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/security.halo.run/remembermetokens, please wait...
2024-07-25T00:34:24.597+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/security.halo.run/remembermetokens built successfully, cost 3 ms
2024-07-25T00:34:24.649+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/security.halo.run/devices, please wait...
2024-07-25T00:34:24.652+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/security.halo.run/devices built successfully, cost 3 ms
2024-07-25T00:34:24.701+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/migration.halo.run/backups, please wait...
2024-07-25T00:34:24.704+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/migration.halo.run/backups built successfully, cost 3 ms
2024-07-25T00:34:24.829+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/notification.halo.run/reasontypes, please wait...
2024-07-25T00:34:24.839+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/notification.halo.run/reasontypes built successfully, cost 10 ms
2024-07-25T00:34:24.886+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/notification.halo.run/reasons, please wait...
2024-07-25T00:34:24.889+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/notification.halo.run/reasons built successfully, cost 3 ms
2024-07-25T00:34:24.993+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/notification.halo.run/notificationtemplates, please wait...
2024-07-25T00:34:25.004+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/notification.halo.run/notificationtemplates built successfully, cost 11 ms
2024-07-25T00:34:25.051+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/notification.halo.run/subscriptions, please wait...
2024-07-25T00:34:25.054+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/notification.halo.run/subscriptions built successfully, cost 4 ms
2024-07-25T00:34:25.122+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/notification.halo.run/notifierDescriptors, please wait...
2024-07-25T00:34:25.126+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/notification.halo.run/notifierDescriptors built successfully, cost 4 ms
2024-07-25T00:34:25.173+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Start building index for type: /registry/notification.halo.run/notifications, please wait...
2024-07-25T00:34:25.177+08:00  INFO 6314 --- [main] r.h.a.e.index.IndexerFactoryImpl         : Index for type: /registry/notification.halo.run/notifications built successfully, cost 4 ms
2024-07-25T00:34:25.183+08:00  INFO 6314 --- [main] r.h.a.e.ReactiveExtensionClientImpl      : Successfully built index in 5464ms, Preparing to lunch application...
2024-07-25T00:34:25.200+08:00  INFO 6314 --- [main] run.halo.app.Application                 : Started Application in 214.319 seconds (process running for 230.986)
2024-07-25T00:34:26.612+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:27.319+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:28.023+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:28.165+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:28.369+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:28.492+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:28.614+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:28.770+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:28.903+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:29.385+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:29.506+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:29.743+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:29.883+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:29.998+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:30.114+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:30.272+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:30.389+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:30.505+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:30.658+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:30.773+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:30.924+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:31.039+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:31.486+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:31.609+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:31.743+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:31.878+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:31.997+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:32.112+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:32.255+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:32.367+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:32.522+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:32.638+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only
2024-07-25T00:34:32.782+08:00  WARN 6314 --- [main] io.r2dbc.h2.H2Connection                 : Option{name='readOnly', sensitive=false} + isn't supported in H2 at the transaction level. You must set it on conenction URL. See http://www.h2database.com/html/features.html#read_only

附加信息

命令正常运行日志： halo-log-2024-07-25 09_21.log systemctl运行错误日志： halo.log

JohnNiang commented 2 months ago

/triage duplicate

Duplicates of https://github.com/halo-dev/halo/issues/5322

See https://github.com/r2dbc/r2dbc-h2/issues/247 for more

另外，在发起 Issue 之前，建议先搜索一下相关的 Issue。

/close

f2c-ci-robot[bot] commented 2 months ago

@JohnNiang: Closing this issue.

In response to [this](https://github.com/halo-dev/halo/issues/6373#issuecomment-2249224525): >/triage duplicate > >Duplicates of https://github.com/halo-dev/halo/issues/5322 > >See https://github.com/r2dbc/r2dbc-h2/issues/247 for more > >/close Instructions for interacting with me using PR comments are available [here](https://git.k8s.io/community/contributors/guide/pull-requests.md). If you have questions or suggestions related to my behavior, please file an issue against the [kubernetes/test-infra](https://github.com/kubernetes/test-infra/issues/new?title=Prow%20issue:) repository.
timelyRain666 commented 2 months ago

/triage duplicate

Duplicates of #5322

See r2dbc/r2dbc-h2#247 for more

另外，在发起 Issue 之前，建议先搜索一下相关的 Issue。

/close

谢谢回复，https://github.com/halo-dev/halo/issues/5322 这个之前搜到issue看过了，排查过不是插件的问题，也不是内存的问题，有部分日志没发完整，我这里提示很多地方间断提示H2Connection的警告过后，服务就突然Current command vanished from the unit file, execution of the command list won't be resumed. 挂了。

解决办法是，使用jar部署并使用systemd作为服务运行时，在/etc/systemd/system/halo.service的ExecStart中--spring.config.additional-location=optional:file: 后面指定好application.yaml

image

修改文档这里的提供配置，例如：--spring.config.additional-location=optional:file:/root/halo/application.yaml

guqing commented 2 months ago

日志看起来 halo 是正常停止的，建议检查一下你的 halo.service 是否正确，你可以先不配置 halo.service 来启动并指定你自己的配置文件--spring.config.additional-location 试试就知道了