Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Closed
timelyRain666 opened this issue Jul 25, 2024 · 4 comments
Closed

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

timelyRain666 opened this issue Jul 25, 2024 · 4 comments
Labels
triage/duplicate Indicates an issue is a duplicate of other open issue.

Comments

@timelyRain666
Copy link

系统信息

使用的哪种方式运行？

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
Copy link
Member

JohnNiang commented Jul 25, 2024 •
edited
Loading

/triage duplicate

Duplicates of #5322

See r2dbc/r2dbc-h2#247 for more

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

/close

@f2c-ci-robot f2c-ci-robot bot added the triage/duplicate Indicates an issue is a duplicate of other open issue. label Jul 25, 2024
@f2c-ci-robot f2c-ci-robot bot closed this as completed Jul 25, 2024
@f2c-ci-robot f2c-ci-robot
Copy link

f2c-ci-robot bot commented Jul 25, 2024

@JohnNiang: Closing this issue.

In response to this:

/triage duplicate

Duplicates of #5322

See r2dbc/r2dbc-h2#247 for more

/close

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the kubernetes/test-infra repository.

@timelyRain666
Copy link
Author

/triage duplicate

Duplicates of #5322

See r2dbc/r2dbc-h2#247 for more

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

/close

谢谢回复，#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
Copy link
Member

guqing commented Jul 25, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
triage/duplicate Indicates an issue is a duplicate of other open issue.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@JohnNiang @timelyRain666 @guqing