search

oddfar / campus-imaotai

i茅台app自动预约，每日自动预约，支持docker一键部署（本项目不提供成品，使用的是已淘汰的算法）
https://oddfar.github.io/campus-doc/campus-imaotai
Apache License 2.0
4.08k stars 1.33k forks source link

[bug]: Debian11部署成功，手动预约可以成功，自动预约不行 #183

Closed xiankaiyao closed 7 months ago

xiankaiyao commented 8 months ago

手动预约可以成功，自动预约不行，查看[campus-imaotai]日志错误信息如下：

Description: Config data resource 'file [/home/campus/conf/application-prod.yml]' via location '/home/campus/conf/application-prod.yml' does not exist Action: Check that the value '/home/campus/conf/application-prod.yml' is correct, or prefix it with 'optional:' q2024-01-09 09:34:38 |ERROR |LoggingFailureAnalysisReporter.java:40 |

报错文件不存在，但是实际文件地址：/home/xky/campus-imt-V1.0.11/campus/conf/application-prod.yml 改了还不行 image

版本情况:

campus-imaotai:1.0.11

campus框架:1.1.9

微信图片编辑_20240109093924

snapea commented 8 months ago

试一下把你的文件yml文件移动到指定目录啊/home/campus/conf/application-prod.yml

xiankaiyao commented 8 months ago

试一下把你的文件yml文件移动到指定目录啊/home/campus/conf/application-prod.yml

试了不行，不知道是不是这个错误导致的不能自动预约

xiankaiyao commented 8 months ago

面板日志中不显示预约成功，查看后台日志只显示“「刷新数据」开始刷新版本号，预约item，门店shop列表 ”，但是不成功。 image

image

日志： at com.oddfar.campus.business.controller.IUserController$$EnhancerBySpringCGLIB$$56e9176e.edit() at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) at org.springframework.web.servlet.FrameworkServlet.doPut(FrameworkServlet.java:920) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) at javax.servlet.http.HttpServlet.service(HttpServlet.java:750) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:121) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.oddfar.campus.framework.security.filter.JwtAuthenticationTokenFilter.doFilterInternal(JwtAuthenticationTokenFilter.java:45) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) 2024-01-09 15:08:00 |INFO |IMTServiceImpl.java:126 |「发送验证码返回」：{"code":2000} 2024-01-09 18:28:14 |INFO |IMTServiceImpl.java:515 |申购结果查询开始========================= 2024-01-09 18:28:15 |INFO |IMTServiceImpl.java:544 |申购结果查询结束========================= 2024-01-10 08:59:50 |INFO |CampusIMTTask.java:61 |「刷新数据」开始刷新版本号，预约item，门店shop列表

Y843512864 commented 8 months ago

一样的情况，时间设了3分钟，9点14分登录平台发现还没执行 image

xiankaiyao commented 8 months ago

重启[campus-server]后日志： . _ _ /\ / '_ () \ \ \ \ ( ( )\ | ' | '| | ' \/ ` | \ \ \ \ \/ )| |)| | | | | || (_| | ) ) ) ) ' |__| .|| ||| |_, | / / / / =========||==============|__/=//// :: Spring Boot :: (v2.5.15) 2024-01-10 09:48:00 |INFO |Version.java:21 |HV000001: Hibernate Validator 6.2.5.Final 2024-01-10 09:48:00 |INFO |StartupInfoLogger.java:55 |Starting CampusApplication using Java 1.8.0312 on 7517d6bfa6b7 with PID 1 (/home/campus/app.jar started by root in /home/campus) 2024-01-10 09:48:00 |DEBUG |StartupInfoLogger.java:56 |Running with Spring Boot v2.5.15, Spring v5.3.27 2024-01-10 09:48:00 |INFO |SpringApplication.java:686 |The following 1 profile is active: "prod" 2024-01-10 09:48:03 |INFO |DirectJDKLog.java:173 |Initializing ProtocolHandler ["http-nio-8160"] 2024-01-10 09:48:03 |INFO |DirectJDKLog.java:173 |Starting service [Tomcat] 2024-01-10 09:48:03 |INFO |DirectJDKLog.java:173 |Starting Servlet engine: [Apache Tomcat/9.0.75] 2024-01-10 09:48:03 |INFO |DirectJDKLog.java:173 |Initializing Spring embedded WebApplicationContext 2024-01-10 09:48:04 |DEBUG |GenericFilterBean.java:242 |Filter 'jwtAuthenticationTokenFilter' configured for use 2024-01-10 09:48:04 |INFO |HikariDataSource.java:80 |master - Starting... 2024-01-10 09:48:05 |INFO |HikariDataSource.java:82 |master - Start completed. 2024-01-10 09:48:05 |INFO |DynamicRoutingDataSource.java:160 |dynamic-datasource - add a datasource named [master] success 2024-01-10 09:48:05 |INFO |DynamicRoutingDataSource.java:243 |dynamic-datasource initial loaded [1] datasource,primary datasource named [master] | |. | | | |\/|)(| | |\ |)|||\ / |
3.5.4.1 2024-01-10 09:48:09 |INFO |JacksonConfig.java:46 |初始化 jackson 配置 2024-01-10 09:48:10 |INFO |DirectJDKLog.java:173 |Starting ProtocolHandler ["http-nio-8160"] 2024-01-10 09:48:10 |INFO |StartupInfoLogger.java:61 |Started CampusApplication in 11.284 seconds (JVM running for 12.079) 2024-01-10 09:49:06 |INFO |DirectJDKLog.java:173 |Initializing Spring DispatcherServlet 'dispatcherServlet'

xiankaiyao commented 8 months ago

campus-mysql日志： root@debian11:/home/xky# docker logs campus-mysql 2024-01-09 06:34:17+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started. 2024-01-09 06:34:18+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-01-09 06:34:18+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started. 2024-01-09 06:34:18+00:00 [Note] [Entrypoint]: Initializing database files 2024-01-09T06:34:18.420608Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2024-01-09T06:34:18.923404Z 0 [Warning] InnoDB: New log files created, LSN=45790 2024-01-09T06:34:19.010903Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2024-01-09T06:34:19.023511Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 1dfafd70-aeb9-11ee-8c2a-0242ac130002. 2024-01-09T06:34:19.024595Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2024-01-09T06:34:19.357152Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2024-01-09T06:34:19.357179Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2024-01-09T06:34:19.358301Z 0 [Warning] CA certificate ca.pem is self signed. 2024-01-09T06:34:19.432657Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2024-01-09 06:34:21+00:00 [Note] [Entrypoint]: Database files initialized 2024-01-09 06:34:21+00:00 [Note] [Entrypoint]: Starting temporary server 2024-01-09 06:34:21+00:00 [Note] [Entrypoint]: Waiting for server startup 2024-01-09T06:34:22.180659Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2024-01-09T06:34:22.184476Z 0 [Note] mysqld (mysqld 5.7.44) starting as process 126 ... 2024-01-09T06:34:22.191271Z 0 [Note] InnoDB: PUNCH HOLE support available 2024-01-09T06:34:22.191307Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2024-01-09T06:34:22.191314Z 0 [Note] InnoDB: Uses event mutexes 2024-01-09T06:34:22.191320Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2024-01-09T06:34:22.191374Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2024-01-09T06:34:22.191394Z 0 [Note] InnoDB: Using Linux native AIO 2024-01-09T06:34:22.191962Z 0 [Note] InnoDB: Number of pools: 1 2024-01-09T06:34:22.192252Z 0 [Note] InnoDB: Using CPU crc32 instructions 2024-01-09T06:34:22.196086Z 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M 2024-01-09T06:34:22.206207Z 0 [Note] InnoDB: Completed initialization of buffer pool 2024-01-09T06:34:22.209354Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2024-01-09T06:34:22.222340Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2024-01-09T06:34:22.242091Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2024-01-09T06:34:22.242228Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2024-01-09T06:34:22.298171Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2024-01-09T06:34:22.299838Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2024-01-09T06:34:22.299860Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2024-01-09T06:34:22.301436Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 2768291 2024-01-09T06:34:22.301706Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2024-01-09T06:34:22.302171Z 0 [Note] Plugin 'FEDERATED' is disabled. 2024-01-09T06:34:22.303221Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240109 6:34:22 2024-01-09T06:34:22.310778Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2024-01-09T06:34:22.310799Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2024-01-09T06:34:22.310806Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2024-01-09T06:34:22.310809Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2024-01-09T06:34:22.311635Z 0 [Warning] CA certificate ca.pem is self signed. 2024-01-09T06:34:22.311731Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2024-01-09T06:34:22.313689Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2024-01-09T06:34:22.329820Z 0 [Note] Event Scheduler: Loaded 0 events 2024-01-09T06:34:22.330244Z 0 [Note] mysqld: ready for connections. Version: '5.7.44' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL) 2024-01-09 06:34:22+00:00 [Note] [Entrypoint]: Temporary server started. '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2024-01-09T06:34:23.036640Z 3 [Note] InnoDB: Stopping purge 2024-01-09T06:34:23.045413Z 3 [Note] InnoDB: Resuming purge 2024-01-09T06:34:23.046722Z 3 [Note] InnoDB: Stopping purge 2024-01-09T06:34:23.048711Z 3 [Note] InnoDB: Resuming purge 2024-01-09T06:34:23.049401Z 3 [Note] InnoDB: Stopping purge 2024-01-09T06:34:23.051319Z 3 [Note] InnoDB: Resuming purge 2024-01-09T06:34:23.052448Z 3 [Note] InnoDB: Stopping purge 2024-01-09T06:34:23.053970Z 3 [Note] InnoDB: Resuming purge Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it. 2024-01-09 06:34:25+00:00 [Note] [Entrypoint]: Creating database campus_imaotai

2024-01-09 06:34:25+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/campus_imaotai-V1.0.5.sql

2024-01-09 06:34:25+00:00 [Note] [Entrypoint]: Stopping temporary server 2024-01-09T06:34:25.331396Z 0 [Note] Giving 0 client threads a chance to die gracefully 2024-01-09T06:34:25.331430Z 0 [Note] Shutting down slave threads 2024-01-09T06:34:25.331438Z 0 [Note] Forcefully disconnecting 0 remaining clients 2024-01-09T06:34:25.331453Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2024-01-09T06:34:25.331532Z 0 [Note] Binlog end 2024-01-09T06:34:25.335047Z 0 [Note] Shutting down plugin 'ngram' 2024-01-09T06:34:25.335073Z 0 [Note] Shutting down plugin 'partition' 2024-01-09T06:34:25.335079Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2024-01-09T06:34:25.335086Z 0 [Note] Shutting down plugin 'ARCHIVE' 2024-01-09T06:34:25.335137Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2024-01-09T06:34:25.335233Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2024-01-09T06:34:25.335254Z 0 [Note] Shutting down plugin 'MyISAM' 2024-01-09T06:34:25.335312Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2024-01-09T06:34:25.335330Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2024-01-09T06:34:25.335336Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2024-01-09T06:34:25.335341Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2024-01-09T06:34:25.335347Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2024-01-09T06:34:25.335391Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2024-01-09T06:34:25.335397Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2024-01-09T06:34:25.335403Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2024-01-09T06:34:25.335445Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2024-01-09T06:34:25.335453Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2024-01-09T06:34:25.335458Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2024-01-09T06:34:25.335464Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2024-01-09T06:34:25.335470Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2024-01-09T06:34:25.335476Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2024-01-09T06:34:25.335482Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2024-01-09T06:34:25.335520Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2024-01-09T06:34:25.335528Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2024-01-09T06:34:25.335533Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2024-01-09T06:34:25.335539Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2024-01-09T06:34:25.335548Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2024-01-09T06:34:25.335552Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2024-01-09T06:34:25.335558Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2024-01-09T06:34:25.335564Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2024-01-09T06:34:25.335607Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2024-01-09T06:34:25.335615Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2024-01-09T06:34:25.335621Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2024-01-09T06:34:25.335626Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2024-01-09T06:34:25.335632Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2024-01-09T06:34:25.335639Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2024-01-09T06:34:25.335645Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2024-01-09T06:34:25.335690Z 0 [Note] Shutting down plugin 'InnoDB' 2024-01-09T06:34:25.335802Z 0 [Note] InnoDB: FTS optimize thread exiting. 2024-01-09T06:34:25.335985Z 0 [Note] InnoDB: Starting shutdown... 2024-01-09T06:34:25.436229Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2024-01-09T06:34:25.436581Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 240109 6:34:25 2024-01-09T06:34:27.247410Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12387116 2024-01-09T06:34:27.252866Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2024-01-09T06:34:27.252900Z 0 [Note] Shutting down plugin 'MEMORY' 2024-01-09T06:34:27.252909Z 0 [Note] Shutting down plugin 'CSV' 2024-01-09T06:34:27.252955Z 0 [Note] Shutting down plugin 'sha256_password' 2024-01-09T06:34:27.252965Z 0 [Note] Shutting down plugin 'mysql_native_password' 2024-01-09T06:34:27.253198Z 0 [Note] Shutting down plugin 'binlog' 2024-01-09T06:34:27.254531Z 0 [Note] mysqld: Shutdown complete

2024-01-09 06:34:27+00:00 [Note] [Entrypoint]: Temporary server stopped

2024-01-09 06:34:27+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.

2024-01-09T06:34:27.544826Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2024-01-09T06:34:27.547873Z 0 [Note] mysqld (mysqld 5.7.44) starting as process 1 ... 2024-01-09T06:34:27.552819Z 0 [Note] InnoDB: PUNCH HOLE support available 2024-01-09T06:34:27.552861Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2024-01-09T06:34:27.552866Z 0 [Note] InnoDB: Uses event mutexes 2024-01-09T06:34:27.552871Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2024-01-09T06:34:27.552876Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2024-01-09T06:34:27.552880Z 0 [Note] InnoDB: Using Linux native AIO 2024-01-09T06:34:27.553284Z 0 [Note] InnoDB: Number of pools: 1 2024-01-09T06:34:27.553462Z 0 [Note] InnoDB: Using CPU crc32 instructions 2024-01-09T06:34:27.556613Z 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M 2024-01-09T06:34:27.564143Z 0 [Note] InnoDB: Completed initialization of buffer pool 2024-01-09T06:34:27.567154Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2024-01-09T06:34:27.580040Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2024-01-09T06:34:27.590440Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2024-01-09T06:34:27.590514Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2024-01-09T06:34:27.656021Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2024-01-09T06:34:27.656876Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2024-01-09T06:34:27.656897Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2024-01-09T06:34:27.658215Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 12387116 2024-01-09T06:34:27.658476Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2024-01-09T06:34:27.658788Z 0 [Note] Plugin 'FEDERATED' is disabled. 2024-01-09T06:34:27.663310Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240109 6:34:27 2024-01-09T06:34:27.666719Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2024-01-09T06:34:27.666739Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2024-01-09T06:34:27.666745Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2024-01-09T06:34:27.666748Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2024-01-09T06:34:27.667524Z 0 [Warning] CA certificate ca.pem is self signed. 2024-01-09T06:34:27.667580Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2024-01-09T06:34:27.667972Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2024-01-09T06:34:27.668024Z 0 [Note] IPv6 is available. 2024-01-09T06:34:27.668042Z 0 [Note] - '::' resolves to '::'; 2024-01-09T06:34:27.668067Z 0 [Note] Server socket created on IP: '::'. 2024-01-09T06:34:27.670446Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2024-01-09T06:34:27.685451Z 0 [Note] Event Scheduler: Loaded 0 events 2024-01-09T06:34:27.685828Z 0 [Note] mysqld: ready for connections. Version: '5.7.44' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2024-01-09T06:35:56.192194Z 2 [Note] InnoDB: Stopping purge 2024-01-09T06:35:56.195046Z 2 [Note] InnoDB: Resuming purge 2024-01-09T06:35:57.273323Z 2 [Note] InnoDB: Stopping purge 2024-01-09T06:35:57.275938Z 2 [Note] InnoDB: Resuming purge 2024-01-09T06:35:58.225530Z 2 [Note] InnoDB: Stopping purge 2024-01-09T06:35:58.228260Z 2 [Note] InnoDB: Resuming purge 2024-01-10T00:59:52.379491Z 332 [Note] InnoDB: Stopping purge 2024-01-10T00:59:52.382325Z 332 [Note] InnoDB: Resuming purge 2024-01-10T00:59:53.218005Z 332 [Note] InnoDB: Stopping purge 2024-01-10T00:59:53.220792Z 332 [Note] InnoDB: Resuming purge 2024-01-10T01:16:23.573214Z 340 [Note] InnoDB: Stopping purge 2024-01-10T01:16:23.575749Z 340 [Note] InnoDB: Resuming purge 2024-01-10T01:48:10.883135Z 358 [Note] InnoDB: Stopping purge 2024-01-10T01:48:10.885756Z 358 [Note] InnoDB: Resuming purge 2024-01-10T01:48:13.485355Z 358 [Note] InnoDB: Stopping purge 2024-01-10T01:48:13.487976Z 358 [Note] InnoDB: Resuming purge 2024-01-10T01:48:14.422556Z 358 [Note] InnoDB: Stopping purge 2024-01-10T01:48:14.424816Z 358 [Note] InnoDB: Resuming purge

xiankaiyao commented 8 months ago

redis日志 root@debian11:/home/xky# docker logs campus-redis 1:C 09 Jan 2024 06:34:17.995 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect. 1:C 09 Jan 2024 06:34:17.995 oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo 1:C 09 Jan 2024 06:34:17.995 Redis version=7.2.3, bits=64, commit=00000000, modified=0, pid=1, just started 1:C 09 Jan 2024 06:34:17.995 Configuration loaded 1:M 09 Jan 2024 06:34:17.996 monotonic clock: POSIX clock_gettime 1:M 09 Jan 2024 06:34:17.996 Running mode=standalone, port=6379. 1:M 09 Jan 2024 06:34:17.997 Server initialized 1:M 09 Jan 2024 06:34:17.997 Ready to accept connections tcp 1:M 09 Jan 2024 06:39:27.716 100 changes in 300 seconds. Saving... 1:M 09 Jan 2024 06:39:27.717 Background saving started by pid 21 21:C 09 Jan 2024 06:39:27.730 DB saved on disk 21:C 09 Jan 2024 06:39:27.731 Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB 1:M 09 Jan 2024 06:39:27.818 Background saving terminated with success 1:M 10 Jan 2024 00:59:50.641 1 changes in 3600 seconds. Saving... 1:M 10 Jan 2024 00:59:50.642 Background saving started by pid 22 22:C 10 Jan 2024 00:59:50.660 DB saved on disk 22:C 10 Jan 2024 00:59:50.661 Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB 1:M 10 Jan 2024 00:59:50.743 Background saving terminated with success 1:M 10 Jan 2024 01:04:51.030 100 changes in 300 seconds. Saving... 1:M 10 Jan 2024 01:04:51.031 Background saving started by pid 23 23:C 10 Jan 2024 01:04:51.045 DB saved on disk 23:C 10 Jan 2024 01:04:51.046 Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB 1:M 10 Jan 2024 01:04:51.132 Background saving terminated with success 1:M 10 Jan 2024 01:21:12.823 100 changes in 300 seconds. Saving... 1:M 10 Jan 2024 01:21:12.823 Background saving started by pid 24 24:C 10 Jan 2024 01:21:12.837 DB saved on disk 24:C 10 Jan 2024 01:21:12.839 Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB 1:M 10 Jan 2024 01:21:12.924 Background saving terminated with success 1:M 10 Jan 2024 01:48:14.405 100 changes in 300 seconds. Saving... 1:M 10 Jan 2024 01:48:14.406 Background saving started by pid 25 25:C 10 Jan 2024 01:48:14.420 DB saved on disk 25:C 10 Jan 2024 01:48:14.421 Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB 1:M 10 Jan 2024 01:48:14.507 Background saving terminated with success

Y843512864 commented 8 months ago

本地调试是好使的，部署后貌似定时任务没执行 image

xiankaiyao commented 8 months ago

本地调试是好使的，部署后貌似定时任务没执行 image

大佬解决了告诉我一下，我实在不会了

Y843512864 commented 8 months ago

本地调试是好使的，部署后貌似定时任务没执行 image

大佬解决了告诉我一下，我实在不会了 你把随机预约时间关了，不关应该也没问题，但是执行时间不是你设定的数字 image

lizhichao999 commented 4 months ago

本地调试是好使的，部署后貌似定时任务没执行 image

大佬解决了告诉我一下，我实在不会了

-- 使用PUBLIC关键字授予所有用户对某数据库的所有表的所有权限 GRANT ALL ON campus_imaotai.* TO root;