wyt1215819315 / autoplan

这是一个自动化的托管系统,目前支持bilibili,米游社原神星铁等签到
https://auto.oldwu.top
Apache License 2.0
693 stars 176 forks source link

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

Closed NNanfeng closed 2 years ago

NNanfeng commented 2 years ago
                 ██                     ██
                ░██            ██████  ░██

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

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/autoplan.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_quartzjob' doesn't exist 2022-09-11 06:23:48.979 INFO 1367742 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler$_NONCLUSTERED shutting down. 2022-09-11 06:23:48.980 INFO 1367742 --- [ main] org.quartz.core.QuartzScheduler : Scheduler DefaultQuartzScheduler$_NONCLUSTERED 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

NNanfeng commented 2 years ago

YML 文件配置如下,密码有做处理而已 server:

服务器端口

port: 26666 spring:

数据库连接配置

datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/autoplan?characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai username: autoplan password: xxxxxxxx main: allow-bean-definition-overriding: true mvc: #静态资源 static-path-pattern: /static/** throw-exception-if-no-handler-found: true hiddenmethod: filter: enabled: true thymeleaf: prefix: classpath:/templates/ #在构建URL时预先查看名称的前缀 suffix: .html #构建URL时附加到查看名称的后缀 cache: false actable: table: auto: update model:

分号或者逗号隔开

pack: com.oldwu.entity;com.oldwu.domain;com.netmusic.model;com.miyoushe.model;com.bili.model

database: type: mysql index:

自己定义的索引前缀#该配置项不设置默认使用actableidx

prefix: INDEX_

unique:

自己定义的唯一约束前缀#该配置项不设置默认使用actableuni

prefix: INDEX_UNIQUE_

mybatis自有的配置信息,key也可能是:mybatis.mapperLocations

mybatis-plus: global-config: db-config: id-type: auto

mapper配置文件

mapper-locations: classpath:mapper/*.xml,classpath:mapper/*/.xml,classpath:com/gitee/sunchenbin/mybatis/actable/mapping//*.xml type-aliases-package: com.oldwu.entity

开启驼峰命名

configuration: map-underscore-to-camel-case: true

输出mybatis日志

log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

推送代理

proxy: push: enable: false port: 7890 ip: 127.0.0.1 type: http/socket

指定那种推送方式需要使用代理

use:
  - TelegramPush
  - DiscordPush

image

NNanfeng commented 2 years ago

解决了 更换mysql版本之后解决 现在使用的MySQL版本是8.0.24,之前使用的是5.5 .5