systemctl start halo启动的时候报错。

wenchao

启动失败，测试的时候是成功的，但是按照教程做到最后启动失败，数据库用的是mysql5.7

[root@wenchao system]# /usr/bin/java -server -Xms256m -Xmx256m -jar /home/halo/app/halo.jar

    __  __      __
   / / / /___ _/ /___
  / /_/ / __ `/ / __ \
 / __  / /_/ / / /_/ /
/_/ /_/\__,_/_/\____/

Version: 1.4.8
2021-05-27 10:59:54.233  INFO 1387 --- [           main] run.halo.app.Application                 : Starting 

database succeed.
2021-05-27 11:00:23.506  INFO 1387 --- [           main] run.halo.app.listener.StartedListener    : Halo started at         http://127.0.0.1:8090
2021-05-27 11:00:23.506  INFO 1387 --- [           main] run.halo.app.listener.StartedListener    : Halo admin started at   http://127.0.0.1:8090/admin
2021-05-27 11:00:23.506  INFO 1387 --- [           main] run.halo.app.listener.StartedListener    : Halo has started successfully!

用systemctl start halo启动的时候就报错


2021-05-27 14:27:29.454  INFO 12916 --- [main] o.f.core.internal.command.DbValidate     : Successfully validated 4 migrations (execution time 00:00.004s)
2021-05-27 14:27:29.477  INFO 12916 --- [main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2021-05-27 14:27:29.519 ERROR 12916 --- [main] o.s.boot.SpringApplication               : Application run failed

org.flywaydb.core.internal.exception.FlywaySqlException:
Unable to check whether schema `halodb` is empty
------------------------------------------------
SQL State  : HY000
Error Code : 1577
Message    : Cannot proceed because system tables used by Event Scheduler were found damaged at server start

        at org.flywaydb.core.internal.database.base.Schema.empty(Schema.java:100) ~[flyway-core-7.5.1.jar!/:na]
        at org.flywaydb.core.Flyway$1.execute(Flyway.java:180) ~[flyway-core-7.5.1.jar!/:na]
        at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) ~[flyway-core-7.5.1.jar!/:na]
        at org.flywaydb.core.Flyway.execute(Flyway.java:570) ~[flyway-core-7.5.1.jar!/:na]
        at org.flywaydb.core.Flyway.migrate(Flyway.java:165) ~[flyway-core-7.5.1.jar!/:na]
        at run.halo.app.listener.StartedListener.migrate(StartedListener.java:123) ~[classes!/:1.4.8]
        at run.halo.app.listener.StartedListener.onApplicationEvent(StartedListener.java:76) ~[classes!/:1.4.8]
        at run.halo.app.listener.StartedListener.onApplicationEvent(StartedListener.java:47) ~[classes!/:1.4.8]
        at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176) ~[spring-context-5.3.5.jar!/:5.3.5]
        at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169) ~[spring-context-5.3.5.jar!/:5.3.5]
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143) ~[spring-context-5.3.5.jar!/:5.3.5]
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:421) ~[spring-context-5.3.5.jar!/:5.3.5]
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:378) ~[spring-context-5.3.5.jar!/:5.3.5]
        at org.springframework.boot.context.event.EventPublishingRunListener.started(EventPublishingRunListener.java:105) ~[spring-boot-2.5.0-M3.jar!/:2.5.0-M3]
        at org.springframework.boot.SpringApplicationRunListeners.lambda$started$5(SpringApplicationRunListeners.java:75) ~[spring-boot-2.5.0-M3.jar!/:2.5.0-M3]
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1541) ~[na:na]
        at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:117) ~[spring-boot-2.5.0-M3.jar!/:2.5.0-M3]
        at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:111) ~[spring-boot-2.5.0-M3.jar!/:2.5.0-M3]
        at org.springframework.boot.SpringApplicationRunListeners.started(SpringApplicationRunListeners.java:75) ~[spring-boot-2.5.0-M3.jar!/:2.5.0-M3]
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:334) ~[spring-boot-2.5.0-M3.jar!/:2.5.0-M3]
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:1325) ~[spring-boot-2.5.0-M3.jar!/:2.5.0-M3]
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:1314) ~[spring-boot-2.5.0-M3.jar!/:2.5.0-M3]
        at run.halo.app.Application.main(Application.java:21) ~[classes!/:1.4.8]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
        at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[halo.jar:1.4.8]

wenchao

跪求大佬帮忙，第一次加入大家的伙伴圈。

Ryan Wang 👍

先停掉，然后用 java -jar 的方式启动会这样吗？

wenchao

Ryan Wang 👍
用java-jar 启动就是正常的。网页也能访问。
[root@wenchao home]# ls
admin chenyeye halo
[root@wenchao home]# cd halo/
[root@wenchao halo]# ls
app
[root@wenchao halo]# cd app/
[root@wenchao app]# ls
halo.jar mysql57-community-release-el7-10.noarch.rpm
[root@wenchao app]# java -jar halo.jar

2021-05-28 10:26:43.079 INFO 1224 --- [ main] o.f.c.internal.license.VersionPrinter : Flyway Community Edition 7.5.1 by Redgate
2021-05-28 10:26:43.132 INFO 1224 --- [ main] o.f.core.internal.command.DbValidate : Successfully validated 4 migrations (execution time 00:00.024s)
2021-05-28 10:26:43.206 INFO 1224 --- [ main] o.f.core.internal.command.DbMigrate : Current version of schema "PUBLIC": 4
2021-05-28 10:26:43.219 INFO 1224 --- [ main] o.f.core.internal.command.DbMigrate : Schema "PUBLIC" is up to date. No migration necessary.
2021-05-28 10:26:43.222 INFO 1224 --- [ main] run.halo.app.listener.StartedListener : Migrate database succeed.
2021-05-28 10:26:43.778 INFO 1224 --- [ main] run.halo.app.listener.StartedListener : Halo started at http://127.0.0.1:8090
2021-05-28 10:26:43.779 INFO 1224 --- [ main] run.halo.app.listener.StartedListener : Halo admin started at http://127.0.0.1:8090/admin
2021-05-28 10:26:43.779 INFO 1224 --- [ main] run.halo.app.listener.StartedListener : Halo has started successfully!

Ryan Wang 👍

wenchao 提供一下 halo.service

wenchao

Ryan Wang 👍
[Unit]
Description=Halo Service
Documentation=https://halo.run
After=network-online.target
Wants=network-online.target

[Service]
Type=simple
User=halo
ExecStart=/usr/bin/java -server -Xms256m -Xmx256m -jar /home/halo/app/halo.jar
ExecStop=/bin/kill -s QUIT $MAINPID
Restart=always
StandOutput=syslog

StandError=inherit

[Install]
WantedBy=multi-user.target

Ryan Wang 👍

wenchao User=halo

你这里用的 halo 账户，但是你用 java -jar 运行的时候是 root 账户，两者用到的工作目录是不一样的，你得确认一下。

wenchao

Ryan Wang 👍
我切换到halo用户运行java -jar也是可以得
[root@wenchao system]# vim halo.service
[root@wenchao system]# su halo
[halo@wenchao system]$ cd ~
[halo@wenchao ~]$ ls
app
[halo@wenchao ~]$ cd a
bash: cd: a: No such file or directory
[halo@wenchao ~]$ cd app/
[halo@wenchao app]$ ls
halo.jar mysql57-community-release-el7-10.noarch.rpm
[halo@wenchao app]$ java -jar halo.jar

2021-05-28 11:05:34.345 INFO 1339 --- [ main] o.f.core.internal.command.DbMigrate : Schema halodb is up to date. No migration necessary.
2021-05-28 11:05:34.366 INFO 1339 --- [ main] run.halo.app.listener.StartedListener : Migrate database succeed.
2021-05-28 11:05:34.793 INFO 1339 --- [ main] run.halo.app.listener.StartedListener : Halo started at http://127.0.0.1:8090
2021-05-28 11:05:34.793 INFO 1339 --- [ main] run.halo.app.listener.StartedListener : Halo admin started at http://127.0.0.1:8090/admin
2021-05-28 11:05:34.793 INFO 1339 --- [ main] run.halo.app.listener.StartedListener : Halo has started successfully!

wenchao

Ryan Wang 👍 ☺他等了一天，服务器重启过，他自己就好了。。。。

wenchao

🤣😂谁能拯救我啊，还没入坑就要放弃了吗？

cetr

wenchao 用你 halo.service 里 ExecStart= 后面那段启动测试，不要用java -jar

wenchao

cetr
用ExecStart= 后面的也能成功。
[halo@wenchao app]$ /usr/bin/java -server -Xms256m -Xmx256m -jar /home/halo/app/halo.jar

__  __      __

/ / / /___ / /__
/ // / __ `/ / __ \
/ __ / // / / // /
// //_,//____/

Version: 1.4.8
2021-05-28 17:42:56.926 INFO 1851 --- [ main] run.halo.app.Application 。。。。

2021-05-28 17:43:31.954 INFO 1851 --- [ main] o.f.core.internal.command.DbMigrate : Current version of schema halodb: 4
2021-05-28 17:43:31.956 INFO 1851 --- [ main] o.f.core.internal.command.DbMigrate : Schema halodb is up to date. No migration necessary.
2021-05-28 17:43:31.964 INFO 1851 --- [ main] run.halo.app.listener.StartedListener : Migrate database succeed.
2021-05-28 17:43:32.410 INFO 1851 --- [ main] run.halo.app.listener.StartedListener : Halo started at http://127.0.0.1:8090
2021-05-28 17:43:32.411 INFO 1851 --- [ main] run.halo.app.listener.StartedListener : Halo admin started at http://127.0.0.1:8090/admin
2021-05-28 17:43:32.411 INFO 1851 --- [ main] run.halo.app.listener.StartedListener : Halo has started successfully!

cetr

wenchao 加我qq，2058930674

wenchao

cetr 谢谢