这是一个自动化的托管系统，目前支持网易云，bilibili，米游社原神签到，测试地址https://auto.oldwu.top

Last update: Jan 1, 2023

Related tags

Spring Boot autoplan

Overview

AutoPlan_Helper

这是一个自动化的托管系统，目前支持网易云签到刷歌，bilibili，米游社原神签到

目前项目属于测试阶段，可能会有些莫名其妙的bug，敬请谅解

如果觉得好用，点个star吧

开源地址

wyt1215819315 / autoplan

目前已经实现

b站每日自动经验任务
b站赛事预测赚硬币任务
网易云自动签到刷歌任务
米游社原神签到领奖励任务以及米游币任务

测试服务器地址

点击打开

本人不会利用任何cookie，但是为了安全考虑，建议还是自己搭建运行环境

项目结构

采用Springboot + Thymeleaf + layui制作

数据库：mysql

登录安全验证及权限管理：spring-security

定时任务核心：quartz（从pearadmin中抠过来的）

使用说明

bilibili

支持b站签到任务以及赛事预测任务已实现扫码登录

cookie登录请参考BILIBILI-HELPER-PRE以获取cookie值

网易云

都是字面意思

米游社

只支持原神签到任务和米游币任务

更多使用说明请查看

项目部署

首先准备好application.yml配置文件，模板文件可以在项目根目录找到或Releases中附，或者可以直接复制以下内容：

server:
  #服务器端口
  port: 26666
spring:
  #数据库连接配置
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://数据库地址:3306/数据库名称?characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai
    username: 数据库用户名
    password: 数据库密码
  main:
    allow-bean-definition-overriding: true
  mvc: #静态文件
    static-path-pattern: /static/**
mybatis:
  #mapper配置文件
  mapper-locations: classpath:mapper/*.xml,classpath:mapper/**/*.xml
  type-aliases-package: com.oldwu.entity
  #开启驼峰命名
  configuration:
    map-underscore-to-camel-case: true
#    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

在mysql中创建数据库并导入sql
接下来你可以选择两种方式部署：

使用 Releases 中打包好的jar运行

将application.yml修改正确并放入jar包同级目录中
使用java -jar xxx.jar运行

自行编译

导入idea并下载依赖（请使用JDK1.8）
在resources文件夹放入application.yml配置文件（可选，你可以选择外置配置文件）
使用maven install打包成jar
使用java -jar xxx.jar运行

注册账号，并将其定为管理员账户，步骤：
1. 查看sys_user表中你的账号对应的id
2. 进入sys_role_user表中找到对应的user_id
3. 将对应行的sys_role_id值改为1
一些定时任务的配置请登录管理员账号在自动任务管理中查看

一些问题

代码不是一般的乱，（非常非常乱....而且很多地方不符合规范），本人萌新一枚，请大佬多多指教
由于BILIBILI-HELPER-PRE项目大多采用static变量，因此无法多线程运行，也无法手动执行

未来

管理员功能：查看日志，删除任务等
统一推送，即不用填写多个，仅需在个人中心绑定一个即可
手动执行b站任务

更新日志

21.8.29 更新了b站二维码登录以及任务删除功能
21.8.30 增加了网易云推送，改变了日志表结构
21.8.31 增加了米游社原神签到，修复了网易云刷歌不计数的问题（摔、垃圾网易云json数组外边还要加引号）
21.9.2 增加了编辑参数编辑功能
21.9.3 增加了网易云任务和米游社任务的手动执行开关
21.9.4 增加了米游社cookie字段，使其能够执行米游币任务
21.9.5 修复了非管理员无法使用单次执行任务的问题，修复了米游社任务无权限访问的问题，修复了bilibili直播送礼物报错的问题
21.9.6 增加了bilibili赛事预测,修复了网易云uid超出int范围导致任务中断的问题
21.9.15 尝试更新了BILIBILI-HELPER至1.1.5，可以改善部分任务中出现的null错误

鸣谢

Comments

自建无法注册账号（更新：1.8版本已修复）

注册输入信息后显示

Whitelabel Error Page

This application has no explicit mapping for /error, so you are seeing this as a fallback.
Fri Jan 14 15:05:20 CST 2022
There was an unexpected error (type=Internal Server Error, status=500).

opened by Lemonawa 7

小白尽力了，真跑不起来，我太菜了。。

跑了两个服务器，按照教程都试过了也百度过错误提示还是爆出长长一串 HikariPool-1 - Starting... 2022-03-18 22:11:34.316 ERROR 19081 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) [HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) [HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115) [HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-4.0.3.jar!/:na] at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159) [spring-jdbc-5.3.15.jar!/:5.3.15] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117) [spring-jdbc-5.3.15.jar!/:5.3.15] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) [spring-jdbc-5.3.15.jar!/:5.3.15] at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80) [mybatis-spring-2.0.6.jar!/:2.0.6] at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67) [mybatis-spring-2.0.6.jar!/:2.0.6] at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337) [mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86) [mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) [mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) [mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) [mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) [mybatis-3.5.7.jar!/:3.5.7] at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) [mybatis-plus-extension-3.4.3.4.jar!/:3.4.3.4] at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) [mybatis-3.5.7.jar!/:3.5.7] at com.sun.proxy.$Proxy95.query(Unknown Source) [na:na] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) [mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) [mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) [mybatis-3.5.7.jar!/:3.5.7] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_322] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_322] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_322] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_322] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) [mybatis-spring-2.0.6.jar!/:2.0.6] at com.sun.proxy.$Proxy82.selectList(Unknown Source) [na:na] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) [mybatis-spring-2.0.6.jar!/:2.0.6] at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166) [mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77) [mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) [mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) [mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at com.sun.proxy.$Proxy94.selectByExample(Unknown Source) [na:na] at com.oldwu.task.quartz.QuartzSchedulerUtil.init(QuartzSchedulerUtil.java:43) [classes!/:0.0.1-SNAPSHOT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_322] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_322] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_322] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_322] at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) [spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:953) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) ~[spring-context-5.3.15.jar!/:5.3.15] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.15.jar!/:5.3.15] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:732) ~[spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:414) ~[spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:302) ~[spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303) ~[spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) ~[spring-boot-2.6.3.jar!/:2.6.3] at com.AutoPlanApplication.main(AutoPlanApplication.java:14) ~[classes!/:0.0.1-SNAPSHOT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_322] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_322] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_322] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_322] at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) ~[auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88) ~[auto_plan.jar:0.0.1-SNAPSHOT] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_322] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_322] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_322] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_322] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.NativeSession.connect(NativeSession.java:120) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] ... 101 common frames omitted Caused by: java.net.NoRouteToHostException: No route to host (Host unreachable) at java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:1.8.0_322] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[na:1.8.0_322] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[na:1.8.0_322] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[na:1.8.0_322] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:1.8.0_322] at java.net.Socket.connect(Socket.java:607) ~[na:1.8.0_322] at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:156) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] ... 104 common frames omitted

2022-03-18 22:11:34.321 WARN 19081 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'quartzJobController': Unsatisfied dependency expressed through field 'sysQuartzJobService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysQuartzJobService': Unsatisfied dependency expressed through field 'quartzSchedulerUtil'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzSchedulerUtil': Invocation of init method failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 2022-03-18 22:11:34.322 INFO 19081 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler_$NON_CLUSTERED shutting down. 2022-03-18 22:11:34.322 INFO 19081 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler$NON_CLUSTERED paused. 2022-03-18 22:11:34.323 INFO 19081 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler$_NON_CLUSTERED shutdown complete. 2022-03-18 22:11:34.329 INFO 19081 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat] 2022-03-18 22:11:34.347 INFO 19081 --- [ main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2022-03-18 22:11:34.372 ERROR 19081 --- [ main] o.s.boot.SpringApplication : Application run failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'quartzJobController': Unsatisfied dependency expressed through field 'sysQuartzJobService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysQuartzJobService': Unsatisfied dependency expressed through field 'quartzSchedulerUtil'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzSchedulerUtil': Invocation of init method failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:953) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) ~[spring-context-5.3.15.jar!/:5.3.15] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.15.jar!/:5.3.15] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:732) [spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:414) [spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:302) [spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303) [spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) [spring-boot-2.6.3.jar!/:2.6.3] at com.AutoPlanApplication.main(AutoPlanApplication.java:14) [classes!/:0.0.1-SNAPSHOT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_322] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_322] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_322] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_322] at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) [auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) [auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) [auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88) [auto_plan.jar:0.0.1-SNAPSHOT] Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysQuartzJobService': Unsatisfied dependency expressed through field 'quartzSchedulerUtil'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzSchedulerUtil': Invocation of init method failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) ~[spring-beans-5.3.15.jar!/:5.3.15] ... 28 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzSchedulerUtil': Invocation of init method failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) ~[spring-beans-5.3.15.jar!/:5.3.15] ... 42 common frames omitted Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96) ~[mybatis-spring-2.0.6.jar!/:2.0.6] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) ~[mybatis-spring-2.0.6.jar!/:2.0.6] at com.sun.proxy.$Proxy82.selectList(Unknown Source) ~[na:na] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) ~[mybatis-spring-2.0.6.jar!/:2.0.6] at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166) ~[mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77) ~[mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) ~[mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) ~[mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at com.sun.proxy.$Proxy94.selectByExample(Unknown Source) ~[na:na] at com.oldwu.task.quartz.QuartzSchedulerUtil.init(QuartzSchedulerUtil.java:43) ~[classes!/:0.0.1-SNAPSHOT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_322] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_322] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_322] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_322] at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333) ~[spring-beans-5.3.15.jar!/:5.3.15] at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157) ~[spring-beans-5.3.15.jar!/:5.3.15] ... 54 common frames omitted Caused by: org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.7.jar!/:3.5.7] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_322] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_322] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_322] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_322] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.6.jar!/:2.0.6] ... 69 common frames omitted Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83) ~[spring-jdbc-5.3.15.jar!/:5.3.15] at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80) ~[mybatis-spring-2.0.6.jar!/:2.0.6] at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67) ~[mybatis-spring-2.0.6.jar!/:2.0.6] at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.7.jar!/:3.5.7] at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) ~[mybatis-plus-extension-3.4.3.4.jar!/:3.4.3.4] at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) ~[mybatis-3.5.7.jar!/:3.5.7] at com.sun.proxy.$Proxy95.query(Unknown Source) ~[na:na] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) ~[mybatis-3.5.7.jar!/:3.5.7] ... 76 common frames omitted Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115) ~[HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-4.0.3.jar!/:na] at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159) ~[spring-jdbc-5.3.15.jar!/:5.3.15] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117) ~[spring-jdbc-5.3.15.jar!/:5.3.15] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) ~[spring-jdbc-5.3.15.jar!/:5.3.15] ... 88 common frames omitted Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_322] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_322] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_322] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_322] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.NativeSession.connect(NativeSession.java:120) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] ... 101 common frames omitted Caused by: java.net.NoRouteToHostException: No route to host (Host unreachable) at java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:1.8.0_322] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[na:1.8.0_322] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[na:1.8.0_322] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[na:1.8.0_322] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:1.8.0_322] at java.net.Socket.connect(Socket.java:607) ~[na:1.8.0_322] at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:156) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63) ~[mysql-connector-java-8.0.27.jar!/:8.0.27] ... 104 common frames omitted

opened by A13437858 3
请老哥看看这个报错个人认为是数据库配置填写有误，但个人认为没有填错
██ ██ ░██ ██████ ░██

██████ ██ ██ ██████ ██████ ░██░░░██ ░██ ██████ ███████ ░░░░░░██ ░██ ░██░░░██░ ██░░░░██░██ ░██ ░██ ░░░░░░██ ░░██░░░██ ███████ ░██ ░██ ░██ ░██ ░██░██████ ░██ ███████ ░██ ░██ ██░░░░██ ░██ ░██ ░██ ░██ ░██░██░░░ ░██ ██░░░░██ ░██ ░██ ░░████████░░██████ ░░██ ░░██████ ░██ ███░░████████ ███ ░██ ░░░░░░░░ ░░░░░░ ░░ ░░░░░░ ░░ ░░░ ░░░░░░░░ ░░░ ░░

2022-09-11 06:23:44.973 INFO 1367742 --- [ main] com.AutoPlanApplication : Starting AutoPlanApplication v0.0.1-SNAPSHOT using Java 17.0.4 on VM-4-10-ubuntu with PID 1367742 (/root/autoplan/auto_plan.jar started by root in /root/autoplan) 2022-09-11 06:23:44.978 INFO 1367742 --- [ main] com.AutoPlanApplication : No active profile set, falling back to 1 default profile: "default" 2022-09-11 06:23:47.348 INFO 1367742 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 26666 (http) 2022-09-11 06:23:47.367 INFO 1367742 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2022-09-11 06:23:47.367 INFO 1367742 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.60] 2022-09-11 06:23:47.480 INFO 1367742 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2022-09-11 06:23:47.480 INFO 1367742 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2434 ms Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter. Registered plugin: 'com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor@5c10f1c3' Parsed mapper file: 'class path resource [mapper/UserDaoMapper.xml]' Parsed mapper file: 'class path resource [mapper/SysUserInfoDao.xml]' Parsed mapper file: 'class path resource [mapper/AutoLogDao.xml]' Parsed mapper file: 'class path resource [mapper/mihuyou/AutoMihayouDao.xml]' Parsed mapper file: 'class path resource [mapper/UserDaoMapper.xml]' Parsed mapper file: 'class path resource [mapper/bilibili/AutoBilibiliDao.xml]' Parsed mapper file: 'class path resource [mapper/bilibili/BiliUserDao.xml]' Parsed mapper file: 'class path resource [mapper/netmusic/AutoNetmusicDao.xml]' Parsed mapper file: 'class path resource [mapper/SysUserInfoDao.xml]' Parsed mapper file: 'class path resource [mapper/AutoLogDao.xml]' Parsed mapper file: 'class path resource [mapper/quartzJob/SysQuartzJobLogMapper.xml]' Parsed mapper file: 'class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]' Parsed mapper file: 'URL [jar:file:/root/autoplan/auto_plan.jar!/BOOT-INF/lib/mybatis-enhance-actable-1.5.0.RELEASE.jar!/com/gitee/sunchenbin/mybatis/actable/mapping/common/BaseCRUDMapper.xml]' Parsed mapper file: 'URL [jar:file:/root/autoplan/auto_plan.jar!/BOOT-INF/lib/mybatis-enhance-actable-1.5.0.RELEASE.jar!/com/gitee/sunchenbin/mybatis/actable/mapping/common/BaseMysqlCRUDMapper.xml]' Parsed mapper file: 'URL [jar:file:/root/autoplan/auto_plan.jar!/BOOT-INF/lib/mybatis-enhance-actable-1.5.0.RELEASE.jar!/com/gitee/sunchenbin/mybatis/actable/mapping/system/CreateMysqlTablesMapper.xml]' _ _ |_ _ |. ___ _ | _ | | |/|)(| | |\ |)|||\ / |
3.4.3.4 2022-09-11 06:23:48.538 INFO 1367742 --- [ main] org.quartz.impl.StdSchedulerFactory : Using default implementation for ThreadExecutor 2022-09-11 06:23:48.543 INFO 1367742 --- [ main] org.quartz.simpl.SimpleThreadPool : Job execution threads will use class loader of thread: main 2022-09-11 06:23:48.555 INFO 1367742 --- [ main] org.quartz.core.SchedulerSignalerImpl : Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-11 06:23:48.555 INFO 1367742 --- [ main] org.quartz.core.QuartzScheduler : Quartz Scheduler v.2.3.2 created. 2022-09-11 06:23:48.556 INFO 1367742 --- [ main] org.quartz.simpl.RAMJobStore : RAMJobStore initialized. 2022-09-11 06:23:48.557 INFO 1367742 --- [ main] org.quartz.core.QuartzScheduler : Scheduler meta-data: Quartz Scheduler (v2.3.2) 'DefaultQuartzScheduler' with instanceId 'NON_CLUSTERED' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

2022-09-11 06:23:48.557 INFO 1367742 --- [ main] org.quartz.impl.StdSchedulerFactory : Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties' 2022-09-11 06:23:48.557 INFO 1367742 --- [ main] org.quartz.impl.StdSchedulerFactory : Quartz scheduler version: 2.3.2 Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4a9e6faf] was not registered for synchronization because synchronization is not active 2022-09-11 06:23:48.608 INFO 1367742 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2022-09-11 06:23:48.869 INFO 1367742 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. JDBC Connection [HikariProxyConnection@234223040 wrapping com.mysql.cj.jdbc.ConnectionImpl@308a6984] will not be managed by Spring ==> Preparing: select id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status from t_sys_quartz_job ==> Parameters: Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4a9e6faf] 2022-09-11 06:23:48.979 WARN 1367742 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysQuartzJobService': Unsatisfied dependency expressed through field 'quartzSchedulerUtil'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzSchedulerUtil': Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample-Inline

The error occurred while setting parameters

SQL: select id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status from t_sys_quartz_job

Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist 2022-09-11 06:23:48.979 INFO 1367742 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler_$NON_CLUSTERED shutting down. 2022-09-11 06:23:48.980 INFO 1367742 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler$NON_CLUSTERED paused. 2022-09-11 06:23:48.981 INFO 1367742 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler$_NON_CLUSTERED shutdown complete. 2022-09-11 06:23:48.981 INFO 1367742 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2022-09-11 06:23:48.993 INFO 1367742 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed. 2022-09-11 06:23:48.998 INFO 1367742 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat] 2022-09-11 06:23:49.013 INFO 1367742 --- [ main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2022-09-11 06:23:49.052 ERROR 1367742 --- [ main] o.s.boot.SpringApplication : Application run failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysQuartzJobService': Unsatisfied dependency expressed through field 'quartzSchedulerUtil'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzSchedulerUtil': Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample-Inline

The error occurred while setting parameters

SQL: select id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status from t_sys_quartz_job

Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:953) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) ~[spring-context-5.3.18.jar!/:5.3.18] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.18.jar!/:5.3.18] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.6.6.jar!/:2.6.6] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:740) ~[spring-boot-2.6.6.jar!/:2.6.6] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:415) ~[spring-boot-2.6.6.jar!/:2.6.6] at org.springframework.boot.SpringApplication.run(SpringApplication.java:303) ~[spring-boot-2.6.6.jar!/:2.6.6] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1312) ~[spring-boot-2.6.6.jar!/:2.6.6] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1301) ~[spring-boot-2.6.6.jar!/:2.6.6] at com.AutoPlanApplication.main(AutoPlanApplication.java:14) ~[classes!/:0.0.1-SNAPSHOT] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[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:568) ~[na:na] at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) ~[auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88) ~[auto_plan.jar:0.0.1-SNAPSHOT] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzSchedulerUtil': Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample-Inline

The error occurred while setting parameters

SQL: select id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status from t_sys_quartz_job

Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) ~[spring-beans-5.3.18.jar!/:5.3.18] ... 28 common frames omitted Caused by: org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample-Inline

The error occurred while setting parameters

SQL: select id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status from t_sys_quartz_job

Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) ~[spring-jdbc-5.3.18.jar!/:5.3.18] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.18.jar!/:5.3.18] at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) ~[mybatis-spring-2.0.6.jar!/:2.0.6] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) ~[mybatis-spring-2.0.6.jar!/:2.0.6] at jdk.proxy2/jdk.proxy2.$Proxy82.selectList(Unknown Source) ~[na:na] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) ~[mybatis-spring-2.0.6.jar!/:2.0.6] at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166) ~[mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77) ~[mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) ~[mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) ~[mybatis-plus-core-3.4.3.4.jar!/:3.4.3.4] at jdk.proxy2/jdk.proxy2.$Proxy94.selectByExample(Unknown Source) ~[na:na] at com.oldwu.task.quartz.QuartzSchedulerUtil.init(QuartzSchedulerUtil.java:43) ~[classes!/:0.0.1-SNAPSHOT] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[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:568) ~[na:na] at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333) ~[spring-beans-5.3.18.jar!/:5.3.18] at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157) ~[spring-beans-5.3.18.jar!/:5.3.18] ... 40 common frames omitted Caused by: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.28.jar!/:8.0.28] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.28.jar!/:8.0.28] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-8.0.28.jar!/:8.0.28] at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371) ~[mysql-connector-java-8.0.28.jar!/:8.0.28] at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar!/:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[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:568) ~[na:na] at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) ~[mybatis-3.5.7.jar!/:3.5.7] at jdk.proxy3/jdk.proxy3.$Proxy98.execute(Unknown Source) ~[na:na] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.5.7.jar!/:3.5.7] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[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:568) ~[na:na] at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) ~[mybatis-3.5.7.jar!/:3.5.7] at jdk.proxy2/jdk.proxy2.$Proxy96.query(Unknown Source) ~[na:na] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.7.jar!/:3.5.7] at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) ~[mybatis-plus-extension-3.4.3.4.jar!/:3.4.3.4] at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) ~[mybatis-3.5.7.jar!/:3.5.7] at jdk.proxy2/jdk.proxy2.$Proxy95.query(Unknown Source) ~[na:na] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) ~[mybatis-3.5.7.jar!/:3.5.7] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.7.jar!/:3.5.7] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[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:568) ~[na:na] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.6.jar!/:2.0.6] ... 55 common frames omitted
opened by NNanfeng 2
第一次接触java项目，有大佬解答一下这是什么问题吗？

. ____ _ __ _ _ /\ / ' __ _ () __ __ _ \ \ \
( ( )__ | '_ | '| | ' / ` | \ \ \
\/ __)| |)| | | | | || (| | ) ) ) ) ' || .__|| ||| |_, | / / / / =========||==============|/=//// :: Spring Boot :: (v2.6.3)

2022-03-25 10:56:08.923 INFO 32734 --- [ main] com.AutoPlanApplication : Starting AutoPlanApplication v0.0.1-SNAPSHOT using Java 1.8.0-internal on root with PID 32734 (/www/wwwroot/dg.tingkai.tk/auto_plan-https.jar started by springboot in /www/wwwroot/dg.tingkai.tk) 2022-03-25 10:56:08.933 INFO 32734 --- [ main] com.AutoPlanApplication : No active profile set, falling back to default profiles: default 2022-03-25 10:56:11.968 WARN 32734 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.support.BeanDefinitionOverrideException: Invalid bean definition with name 'customUserService' defined in class path resource [com/oldwu/config/WebSecurityConfig.class]: Cannot register bean definition [Root bean: class [null]; scope=; abstract=false; lazyInit=null; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=webSecurityConfig; factoryMethodName=customUserService; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [com/oldwu/config/WebSecurityConfig.class]] for bean 'customUserService': There is already [Generic bean: class [com.oldwu.security.CustomUserService]; scope=singleton; abstract=false; lazyInit=null; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in URL [jar:file:/www/wwwroot/dg.tingkai.tk/auto_plan-https.jar!/BOOT-INF/classes!/com/oldwu/security/CustomUserService.class]] bound. 2022-03-25 10:56:12.013 INFO 32734 --- [ main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2022-03-25 10:56:12.055 ERROR 32734 --- [ main] o.s.b.d.LoggingFailureAnalysisReporter :

APPLICATION FAILED TO START

Description:

The bean 'customUserService', defined in class path resource [com/oldwu/config/WebSecurityConfig.class], could not be registered. A bean with that name has already been defined in URL [jar:file:/www/wwwroot/dg.tingkai.tk/auto_plan-https.jar!/BOOT-INF/classes!/com/oldwu/security/CustomUserService.class] and overriding is disabled.

Action:

Consider renaming one of the beans or enabling overriding by setting spring.main.allow-bean-definition-overriding=true

opened by ghost 2
宝塔里面项目日志没报错也运行起来了就是打不开网页

. ____ _ __ _ _ /\ / ' __ _ () __ __ _ \ \ \
( ( )__ | '_ | '| | ' / ` | \ \ \
\/ __)| |)| | | | | || (| | ) ) ) ) ' || .__|| ||| |_, | / / / / =========||==============|/=//// :: Spring Boot :: (v2.6.3)

2022-03-24 10:00:39.127 INFO 1708642 --- [ main] com.AutoPlanApplication : Starting AutoPlanApplication v0.0.1-SNAPSHOT using Java 1.8.0_312 on VM-20-5-centos with PID 1708642 (/www/wwwroot/auto_plan.jar started by springboot in /www/wwwroot) 2022-03-24 10:00:39.130 INFO 1708642 --- [ main] com.AutoPlanApplication : No active profile set, falling back to default profiles: default 2022-03-24 10:00:41.108 INFO 1708642 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 26666 (http) 2022-03-24 10:00:41.118 INFO 1708642 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2022-03-24 10:00:41.119 INFO 1708642 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.56] 2022-03-24 10:00:41.184 INFO 1708642 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2022-03-24 10:00:41.184 INFO 1708642 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1987 ms _ _ |_ _ |. ___ _ | _ | | |/|)(| | |\ |)|||
/ | 3.4.3.4 2022-03-24 10:00:42.340 INFO 1708642 --- [ main] org.quartz.impl.StdSchedulerFactory : Using default implementation for ThreadExecutor 2022-03-24 10:00:42.343 INFO 1708642 --- [ main] org.quartz.simpl.SimpleThreadPool : Job execution threads will use class loader of thread: main 2022-03-24 10:00:42.368 INFO 1708642 --- [ main] org.quartz.core.SchedulerSignalerImpl : Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-03-24 10:00:42.368 INFO 1708642 --- [ main] org.quartz.core.QuartzScheduler : Quartz Scheduler v.2.3.2 created. 2022-03-24 10:00:42.369 INFO 1708642 --- [ main] org.quartz.simpl.RAMJobStore : RAMJobStore initialized. 2022-03-24 10:00:42.370 INFO 1708642 --- [ main] org.quartz.core.QuartzScheduler : Scheduler meta-data: Quartz Scheduler (v2.3.2) 'DefaultQuartzScheduler' with instanceId 'NON_CLUSTERED' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

2022-03-24 10:00:42.370 INFO 1708642 --- [ main] org.quartz.impl.StdSchedulerFactory : Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties' 2022-03-24 10:00:42.370 INFO 1708642 --- [ main] org.quartz.impl.StdSchedulerFactory : Quartz scheduler version: 2.3.2 2022-03-24 10:00:42.414 INFO 1708642 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2022-03-24 10:00:42.630 INFO 1708642 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2022-03-24 10:00:42.695 INFO 1708642 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started. 2022-03-24 10:00:42.865 INFO 1708642 --- [ main] c.g.s.m.a.m.handler.StartUpHandlerImpl : databaseType=mysql，开始执行mysql的处理方法 2022-03-24 10:00:43.376 INFO 1708642 --- [ main] o.s.s.web.DefaultSecurityFilterChain : Will secure any request with [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@49c90a9c, org.springframework.security.web.context.SecurityContextPersistenceFilter@69504ae9, org.springframework.security.web.header.HeaderWriterFilter@2657d4dd, org.springframework.security.web.authentication.logout.LogoutFilter@5c7bfdc1, com.oldwu.security.validate.ValidateCodeFilter@1165b38, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@1f9f6368, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@28cda624, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@7eecb5b8, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@2d29b4ee, org.springframework.security.web.session.SessionManagementFilter@47caedad, org.springframework.security.web.access.ExceptionTranslationFilter@446a1e84, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@7486b455] 2022-03-24 10:00:43.663 INFO 1708642 --- [ main] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page template: index 2022-03-24 10:00:43.923 INFO 1708642 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 26666 (http) with context path '' 2022-03-24 10:00:43.936 INFO 1708642 --- [ main] com.AutoPlanApplication : Started AutoPlanApplication in 5.429 seconds (JVM running for 5.92)

---------上面的日志是宝塔里面的日志-------下面的日志是我服务器手动启动项目报错-------

. ____ _ __ _ _ /\ / ' __ _ () __ __ _ \ \ \
( ( )__ | '_ | '| | ' / ` | \ \ \
\/ __)| |)| | | | | || (| | ) ) ) ) ' || .__|| ||| |_, | / / / / =========||==============|/=//// :: Spring Boot :: (v2.6.3)

2022-03-24 10:01:56.107 INFO 1712661 --- [ main] com.AutoPlanApplication : Starting AutoPlanApplication v0.0.1-SNAPSHOT using Java 1.8.0_312 on VM-20-5-centos with PID 1712661 (/www/wwwroot/auto_plan.jar started by root in /www/wwwroot) 2022-03-24 10:01:56.110 INFO 1712661 --- [ main] com.AutoPlanApplication : No active profile set, falling back to default profiles: default 2022-03-24 10:01:58.186 INFO 1712661 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 26666 (http) 2022-03-24 10:01:58.198 INFO 1712661 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2022-03-24 10:01:58.199 INFO 1712661 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.56] 2022-03-24 10:01:58.254 INFO 1712661 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2022-03-24 10:01:58.254 INFO 1712661 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2054 ms _ _ |_ _ |. ___ _ | _ | | |/|)(| | |\ |)|||\ / |
3.4.3.4 2022-03-24 10:01:59.424 INFO 1712661 --- [ main] org.quartz.impl.StdSchedulerFactory : Using default implementation for ThreadExecutor 2022-03-24 10:01:59.431 INFO 1712661 --- [ main] org.quartz.simpl.SimpleThreadPool : Job execution threads will use class loader of thread: main 2022-03-24 10:01:59.467 INFO 1712661 --- [ main] org.quartz.core.SchedulerSignalerImpl : Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-03-24 10:01:59.467 INFO 1712661 --- [ main] org.quartz.core.QuartzScheduler : Quartz Scheduler v.2.3.2 created. 2022-03-24 10:01:59.468 INFO 1712661 --- [ main] org.quartz.simpl.RAMJobStore : RAMJobStore initialized. 2022-03-24 10:01:59.469 INFO 1712661 --- [ main] org.quartz.core.QuartzScheduler : Scheduler meta-data: Quartz Scheduler (v2.3.2) 'DefaultQuartzScheduler' with instanceId 'NON_CLUSTERED' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

2022-03-24 10:01:59.470 INFO 1712661 --- [ main] org.quartz.impl.StdSchedulerFactory : Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties' 2022-03-24 10:01:59.470 INFO 1712661 --- [ main] org.quartz.impl.StdSchedulerFactory : Quartz scheduler version: 2.3.2 2022-03-24 10:01:59.541 INFO 1712661 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2022-03-24 10:01:59.792 INFO 1712661 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2022-03-24 10:01:59.880 INFO 1712661 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler_$NON_CLUSTERED started. 2022-03-24 10:02:00.076 INFO 1712661 --- [ main] c.g.s.m.a.m.handler.StartUpHandlerImpl : databaseType=mysql，开始执行mysql的处理方法 2022-03-24 10:02:00.546 INFO 1712661 --- [ main] o.s.s.web.DefaultSecurityFilterChain : Will secure any request with [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@3b35a229, org.springframework.security.web.context.SecurityContextPersistenceFilter@5c7bfdc1, org.springframework.security.web.header.HeaderWriterFilter@126253fd, org.springframework.security.web.authentication.logout.LogoutFilter@2584b82d, com.oldwu.security.validate.ValidateCodeFilter@1f2586d6, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@1224144a, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@71687585, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@1b919693, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@9816741, org.springframework.security.web.session.SessionManagementFilter@475c9c31, org.springframework.security.web.access.ExceptionTranslationFilter@1500b2f3, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@69ee81fc] 2022-03-24 10:02:00.771 INFO 1712661 --- [ main] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page template: index 2022-03-24 10:02:00.995 WARN 1712661 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Failed to start bean 'webServerStartStop'; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat server 2022-03-24 10:02:00.997 INFO 1712661 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler$NON_CLUSTERED shutting down. 2022-03-24 10:02:00.997 INFO 1712661 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler$NON_CLUSTERED paused. 2022-03-24 10:02:00.998 INFO 1712661 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler$_NON_CLUSTERED shutdown complete. 2022-03-24 10:02:01.002 INFO 1712661 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2022-03-24 10:02:01.024 INFO 1712661 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed. 2022-03-24 10:02:01.027 INFO 1712661 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat] 2022-03-24 10:02:01.042 INFO 1712661 --- [ main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2022-03-24 10:02:01.069 ERROR 1712661 --- [ main] o.s.boot.SpringApplication : Application run failed

org.springframework.context.ApplicationContextException: Failed to start bean 'webServerStartStop'; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat server at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:181) ~[spring-context-5.3.15.jar!/:5.3.15] at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54) ~[spring-context-5.3.15.jar!/:5.3.15] at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356) ~[spring-context-5.3.15.jar!/:5.3.15] at java.lang.Iterable.forEach(Iterable.java:75) ~[na:1.8.0_312] at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:155) ~[spring-context-5.3.15.jar!/:5.3.15] at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123) ~[spring-context-5.3.15.jar!/:5.3.15] at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:935) ~[spring-context-5.3.15.jar!/:5.3.15] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586) ~[spring-context-5.3.15.jar!/:5.3.15] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:732) [spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:414) [spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:302) [spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303) [spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) [spring-boot-2.6.3.jar!/:2.6.3] at com.AutoPlanApplication.main(AutoPlanApplication.java:14) [classes!/:0.0.1-SNAPSHOT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_312] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_312] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_312] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_312] at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) [auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) [auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) [auto_plan.jar:0.0.1-SNAPSHOT] at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88) [auto_plan.jar:0.0.1-SNAPSHOT] Caused by: org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat server at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.start(TomcatWebServer.java:229) ~[spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.web.servlet.context.WebServerStartStopLifecycle.start(WebServerStartStopLifecycle.java:43) ~[spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178) ~[spring-context-5.3.15.jar!/:5.3.15] ... 22 common frames omitted Caused by: java.lang.IllegalArgumentException: standardService.connector.startFailed at org.apache.catalina.core.StandardService.addConnector(StandardService.java:238) ~[tomcat-embed-core-9.0.56.jar!/:na] at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.addPreviouslyRemovedConnectors(TomcatWebServer.java:282) ~[spring-boot-2.6.3.jar!/:2.6.3] at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.start(TomcatWebServer.java:213) ~[spring-boot-2.6.3.jar!/:2.6.3] ... 24 common frames omitted Caused by: org.apache.catalina.LifecycleException: Protocol handler start failed at org.apache.catalina.connector.Connector.startInternal(Connector.java:1075) ~[tomcat-embed-core-9.0.56.jar!/:na] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) ~[tomcat-embed-core-9.0.56.jar!/:na] at org.apache.catalina.core.StandardService.addConnector(StandardService.java:234) ~[tomcat-embed-core-9.0.56.jar!/:na] ... 26 common frames omitted Caused by: java.net.BindException: 地址已在使用 at sun.nio.ch.Net.bind0(Native Method) ~[na:1.8.0_312] at sun.nio.ch.Net.bind(Net.java:461) ~[na:1.8.0_312] at sun.nio.ch.Net.bind(Net.java:453) ~[na:1.8.0_312] at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:222) ~[na:1.8.0_312] at org.apache.tomcat.util.net.NioEndpoint.initServerSocket(NioEndpoint.java:273) ~[tomcat-embed-core-9.0.56.jar!/:na] at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:228) ~[tomcat-embed-core-9.0.56.jar!/:na] at org.apache.tomcat.util.net.AbstractEndpoint.bindWithCleanup(AbstractEndpoint.java:1213) ~[tomcat-embed-core-9.0.56.jar!/:na] at org.apache.tomcat.util.net.AbstractEndpoint.start(AbstractEndpoint.java:1299) ~[tomcat-embed-core-9.0.56.jar!/:na] at org.apache.coyote.AbstractProtocol.start(AbstractProtocol.java:614) ~[tomcat-embed-core-9.0.56.jar!/:na] at org.apache.catalina.connector.Connector.startInternal(Connector.java:1072) ~[tomcat-embed-core-9.0.56.jar!/:na] ... 28 common frames omitted

请教大佬怎么解决

opened by YuFengShiSan 2
B站比赛预测失败问题（附个人解决办法）

偶然间发现B站比赛竞猜只有第一个能够预测成功，其余均失败。手动第二次运行，第二个预测成功，也就是说，每次运行都能够成功一个竞猜，怀疑B站竞猜接口对同一用户短时间内连续竞猜做了限制。我个人的解决办法是L在竞猜方法里做了线程sleep，每次竞猜延迟一秒钟。经测试，问题暂时已经解决。不知道其他人有没有遇到这个问题。以上希望能给遇到同样问题的同学一点解决思路。具体修改为：bili.util.BiliTaskUtil.java类中添加Thread.sleep(1000)；

opened by Jch8353 0

Releases(v2.11)

v2.11(Nov 26, 2022)

新增小米运动，支持定时，步数可以同步到微信、支付宝。修复定时任务管理分页查询问题。

本次更新需要执行如下sql才能正常使用

# 任务记录表
CREATE TABLE `auto_xiaomi`
(
    `id`                INT(11)     NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `user_id`           INT(11)     NULL DEFAULT NULL COMMENT '外键约束user_id',
    `phone`             VARCHAR(50) NOT NULL COMMENT '小米账号' COLLATE 'utf8mb4_general_ci',
    `password`          VARCHAR(50) NOT NULL COMMENT '密码' COLLATE 'utf8mb4_general_ci',
    `steps`             VARCHAR(5)  NULL DEFAULT NULL COMMENT '步数' COLLATE 'utf8mb4_general_ci',
    `previous_occasion` VARCHAR(5)  NULL DEFAULT NULL COMMENT '上次提交的步数' COLLATE 'utf8mb4_general_ci',
    `name`              VARCHAR(50) NULL DEFAULT NULL COMMENT '任务名称' COLLATE 'utf8mb4_general_ci',
    `status`            VARCHAR(10) NULL DEFAULT NULL COMMENT '任务状态' COLLATE 'utf8mb4_general_ci',
    `random_or_not`     CHAR(1)     NULL DEFAULT NULL COMMENT '是否随机：0否，1是' COLLATE 'utf8mb4_general_ci',
    `enable`            VARCHAR(50) NULL DEFAULT NULL COMMENT '任务是否开启' COLLATE 'utf8mb4_general_ci',
    `enddate`           DATETIME    NULL DEFAULT NULL COMMENT '任务结束时间',
    `webhook`           TEXT        NULL DEFAULT NULL COMMENT '推送地址json' COLLATE 'utf8mb4_general_ci',
    `CREATED_TIME`      DATETIME    NULL DEFAULT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `userid` (`user_id`) USING BTREE,
    CONSTRAINT `auto_xiaomi_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`) ON UPDATE RESTRICT ON DELETE RESTRICT
)
    COLLATE = 'utf8mb4_general_ci'
    ENGINE = InnoDB
;

# 定时任务执行sql
INSERT INTO `t_sys_quartz_job`
VALUES ('684022184875790336', '小米自动刷步数', 'DEFAULT', 'xiaomiTask.doAutoCheck()', '0 0 12 * * ? *', '3', '1', 0);
INSERT INTO `t_sys_quartz_job`
VALUES ('684022184905150464', '小米运动定时重置任务状态', 'DEFAULT', 'xiaomiTask.resetStatus()', '0 0 0 * * ? *', '3', '1', 0);

Source code(tar.gz)
Source code(zip)
application.yml(1.78 KB)
auto_plan.jar(45.09 MB)

v2.10(Oct 10, 2022)

1、Fixed the Security Issues 2、修复 https://github.com/wyt1215819315/autoplan/issues/88 问题
Source code(tar.gz)
Source code(zip)
application-example.yml(1.78 KB)
auto_plan.jar(45.03 MB)
v2.9(Sep 30, 2022)
更新到salt版本为2.38.1

新增自动清理日志

修复定时任务日志查看分页问题 (感谢@mowei1600更改的代码）

Source code(tar.gz)
Source code(zip)
application-example.yml(1.84 KB)
auto_plan.jar(44.88 MB)
v2.8(Aug 11, 2022)
修复定时任务新增，修改操作提交两次的bug 由mowei1600提出#81，表示感谢

Source code(tar.gz)
Source code(zip)
application-example.yml(238.79 KB)
auto_plan.jar(44.87 MB)
v2.7(Sep 30, 2022)

修复点赞帖子、分享帖子失效bug
Source code(tar.gz)
Source code(zip)
application-example.yml(1.84 KB)
auto_plan.jar(44.87 MB)
v2.6(Sep 30, 2022)

修改readme文件
Source code(tar.gz)
Source code(zip)
application-example.yml(1.84 KB)
auto_plan.jar(44.54 MB)
v2.5beta(May 24, 2022)
重构了bili-helper，可以支持手动运行任务

省略一万字，懒得写，更新了啥自己看提交记录

记得登录管理员账号在bili任务管理中点击“转json”转换bili-helper的配置，并备份旧数据库，数据不会丢失，旧的数据库结构无法满足新版本配置文件的自动建表actable.model.pack项增加了一个路径需要注意，别的没有变动
Source code(tar.gz)
Source code(zip)
application-example.yml(1.64 KB)
auto_plan.jar(44.52 MB)
v2.3(Apr 23, 2022)

Source code(tar.gz)
Source code(zip)
auto_plan.jar(44.84 MB)
v2.2(Mar 21, 2022)
解决https页面跳转http页面被拦截的问题，本次更新分为2个包，分别为http和https的包，等待@MuXia-0326大佬完成动态适配后会重新合为一个包，请大家根据自己的需要选择，没有配置过ssl证书的默认选http就行

解决切换页面有概率不加载公告问题解决注销有概率报错问题

修复米游社任务部分情况下用户登录失败时可能导致空指针报错，然后使整个任务队列都爆炸的问题

Source code(tar.gz)
Source code(zip)
auto_plan-http.jar(44.84 MB)
auto_plan-https.jar(44.84 MB)
v2.1-fix(Feb 18, 2022)

修复网易云任务登录校验失败的问题
Source code(tar.gz)
Source code(zip)
auto_plan-autobuild.zip(41.00 MB)
v2.1(Feb 3, 2022)
2.0版本必更！ 修改了mybatis-plus的配置，需要修改配置文件，详情请查看application-example 更新内容：

修复mybatis-plus自动编号造成的bili任务添加失败问题，推荐2.0版本的使用者进行更新！后续会对部分关联表操作进行事务处理

推送测试支持回显错误信息便于用户排查

修复推送提示信息显示错误

首页公告改为从后台读取，并支持markdown格式

首页公告支持markdown编辑器进行编辑操作

替换大部分静态文件为jsdelivr cdn

增加原来被遗忘的删除任务功能

Source code(tar.gz)
Source code(zip)
application-example.yml(1.62 KB)
auto_plan.jar(44.84 MB)
auto_plan.sql(22.44 KB)
v2.0(Jan 26, 2022)
22.1.26更新内容 此版本为大版本更新，如果从1.x-2.x升级必须要更新yml配置文件！！！

重构了所有页面，所有请求均改为前后端分离

增加登录注册验证码校验

修复网易云登录时可能出现的乱码问题

个人任务管理支持头像展示

增加actable自动建表，以后更改表结构时无需手动更改（第一次使用时还是需要导入sql）

将mybatis换为mybatis-plus，精简了大量xml文件最后祝大家新年快乐！

Source code(tar.gz)
Source code(zip)
application-example.yml(1.57 KB)
auto_plan.jar(44.80 MB)
auto_plan.sql(21.07 KB)
v1.8(Jan 14, 2022)

此为大版本2.0更新前的最后一版，更新了若干内容
Source code(tar.gz)
Source code(zip)
application-example.yml(730 bytes)
auto_plan.jar(38.67 MB)
auto_plan.sql(20.91 KB)
v1.5(Dec 11, 2021)

修复log4j2漏洞 bug修复
Source code(tar.gz)
Source code(zip)
application-example.yml(730 bytes)
auto_plan.jar(38.68 MB)
auto_plan.sql(16.64 KB)
v1.3(Oct 5, 2021)

增加了全局webhook，更改webhook的传入方式为json字符串，增加生成器页面用来生成webhook.json 增加了一个sys_user_info表来储存用户信息
Source code(tar.gz)
Source code(zip)
application-example.yml(730 bytes)
auto_plan.jar(37.88 MB)
auto_plan.sql(16.64 KB)
v1.2(Oct 3, 2021)

修复了部分bug，更改了部分数据表字段名称使其更统一，增加bilibili反向赛事预测这两天数据表有一点改动，怪我之前没规划好搁那能跑就行
Source code(tar.gz)
Source code(zip)
application-example.yml(730 bytes)
auto_plan.jar(37.82 MB)
auto_plan.sql(15.89 KB)
v1.1.1(Oct 1, 2021)

由于layui官方cdn已停止服务，现将cdn改为本地文件
Source code(tar.gz)
Source code(zip)
auto_plan.jar(37.82 MB)
v1.1(Sep 16, 2021)

Source code(tar.gz)
Source code(zip)
application-example.yml(730 bytes)
auto_plan.jar(37.48 MB)
v1.0(Sep 13, 2021)

Source code(tar.gz)
Source code(zip)
auto_plan.zip(31.16 MB)

这是一个自动化的托管系统，目前支持网易云，bilibili，米游社原神签到，测试地址https://auto.oldwu.top

Related tags

Overview

AutoPlan_Helper

开源地址

目前已经实现

测试服务器地址

项目结构

使用说明

bilibili

网易云

米游社

项目部署

一些问题

未来

更新日志

鸣谢

Comments

自建无法注册账号（更新：1.8版本已修复）

小白尽力了，真跑不起来，我太菜了。。

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

请老哥看看这个报错 个人认为是数据库配置填写有误，但个人认为没有填错

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample-Inline

The error occurred while setting parameters

SQL: select id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status from t_sys_quartz_job

Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample-Inline

The error occurred while setting parameters

SQL: select id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status from t_sys_quartz_job

Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample-Inline

The error occurred while setting parameters

SQL: select id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status from t_sys_quartz_job

Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

The error may exist in class path resource [mapper/quartzJob/SysQuartzJobMapper.xml]

The error may involve com.oldwu.dao.SysQuartzJobMapper.selectByExample-Inline

The error occurred while setting parameters

SQL: select id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status from t_sys_quartz_job

Cause: java.sql.SQLSyntaxErrorException: Table 'autoplan.t_sys_quartz_job' doesn't exist

第一次接触java项目，有大佬解答一下这是什么问题吗？

宝塔里面项目日志没报错 也运行起来了 就是打不开网页

B站比赛预测失败问题（附个人解决办法）

Releases(v2.11)

v2.11(Nov 26, 2022)

请老哥看看这个报错个人认为是数据库配置填写有误，但个人认为没有填错

宝塔里面项目日志没报错也运行起来了就是打不开网页

bilibili B站哔哩哔哩 acfun A站樱花动漫番剧下载器（Video Downloader）:smiley: 仅供学习交流求 star orz

bilibili B站哔哩哔哩 acfun A站樱花动漫番剧下载器（Video Downloader）:smiley: 仅供学习交流求 star orz