. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.1.1.RELEASE) 2023-09-16 14:37:46.888 INFO 24833 --- [ main] com.vone.mq.MqApplication : Starting MqApplication v0.0.1-SNAPSHOT on minike with PID 24833 (/volume2/web/minike/vmq/vmq.war started by kch in /volume2/web/minike/vmq) 2023-09-16 14:37:46.902 INFO 24833 --- [ main] com.vone.mq.MqApplication : No active profile set, falling back to default profiles: default 2023-09-16 14:37:50.373 INFO 24833 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data repositories in DEFAULT mode. 2023-09-16 14:37:50.700 INFO 24833 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 296ms. Found 4 repository interfaces. 2023-09-16 14:37:52.329 INFO 24833 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$eae5c63f] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2023-09-16 14:37:53.934 INFO 24833 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 9513 (http) 2023-09-16 14:37:54.062 INFO 24833 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2023-09-16 14:37:54.063 INFO 24833 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet Engine: Apache Tomcat/9.0.13 2023-09-16 14:37:54.103 INFO 24833 --- [ main] o.a.catalina.core.AprLifecycleListener : The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib] 2023-09-16 14:37:57.589 INFO 24833 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2023-09-16 14:37:57.589 INFO 24833 --- [ main] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 10451 ms 2023-09-16 14:37:58.123 INFO 24833 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2023-09-16 14:37:58.800 INFO 24833 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2023-09-16 14:37:59.027 INFO 24833 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [ name: default ...] 2023-09-16 14:37:59.331 INFO 24833 --- [ main] org.hibernate.Version : HHH000412: Hibernate Core {5.3.7.Final} 2023-09-16 14:37:59.337 INFO 24833 --- [ main] org.hibernate.cfg.Environment : HHH000206: hibernate.properties not found 2023-09-16 14:37:59.873 INFO 24833 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.0.4.Final} 2023-09-16 14:38:00.669 INFO 24833 --- [ main] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.H2Dialect Hibernate: create table pay_order (id bigint not null, close_date bigint not null, create_date bigint not null, is_auto integer not null, notify_url varchar(255), order_id varchar(255), param varchar(255), pay_date bigint not null, pay_id varchar(255), pay_url varchar(255), price double not null, really_price double not null, return_url varchar(255), state integer not null, type integer not null, primary key (id)) Hibernate: create table pay_qrcode (id bigint not null, pay_url varchar(255), price double not null, type integer not null, primary key (id)) Hibernate: create table setting (vkey varchar(255) not null, vvalue varchar(255), primary key (vkey)) Hibernate: create table tmp_price (price varchar(255) not null, primary key (price)) Hibernate: create sequence hibernate_sequence start with 1 increment by 1 2023-09-16 14:38:03.467 INFO 24833 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2023-09-16 14:38:06.537 INFO 24833 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2023-09-16 14:38:06.739 WARN 24833 --- [ main] aWebConfiguration$JpaWebMvcConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning 2023-09-16 14:38:07.117 INFO 24833 --- [ main] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page: ServletContext resource [/index.html] 2023-09-16 14:38:07.633 INFO 24833 --- [ main] o.s.s.c.ThreadPoolTaskScheduler : Initializing ExecutorService 'taskScheduler' 开始清理过期订单... Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? 2023-09-16 14:38:08.173 INFO 24833 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 9513 (http) with context path '' 2023-09-16 14:38:08.183 INFO 24833 --- [ main] com.vone.mq.MqApplication : Started MqApplication in 22.949 seconds (JVM running for 25.862) 开始初始化操作... java.util.NoSuchElementException: No value present at java.util.Optional.get(Optional.java:135) at com.vone.mq.service.QuartzService.timerToZZP(QuartzService.java:30) 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.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? 2023-09-16 14:38:08.215 ERROR 24833 --- [ scheduling-1] o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in scheduled task. java.util.NoSuchElementException: No value present at java.util.Optional.get(Optional.java:135) ~[na:1.8.0_275] at com.vone.mq.service.QuartzService.timerToZZP(QuartzService.java:45) ~[classes!/:0.0.1-SNAPSHOT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_275] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_275] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_275] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_275] at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84) ~[spring-context-5.1.3.RELEASE.jar!/:5.1.3.RELEASE] at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.1.3.RELEASE.jar!/:5.1.3.RELEASE] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_275] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [na:1.8.0_275] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_275] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [na:1.8.0_275] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_275] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_275] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_275] 2023-09-16 14:38:08.236 INFO 24833 --- [ main] o.h.h.i.QueryTranslatorFactoryInitiator : HHH000397: Using ASTQueryTranslatorFactory Hibernate: select count(*) as col_0_0_ from setting setting0_ 检测到系统为首次启动，正在进行数据库初始化... Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: insert into setting (vvalue, vkey) values (?, ?) 系统启动完成！ 开始清理过期订单... Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: update pay_order p set p.close_date=?,p.state=-1 where p.create_date= ? and create_date <= ? Hibernate: select count(*) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select count(*) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select count(*) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select sum(price) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select sum(price) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select count(*) from pay_order where state = ? Hibernate: select sum(price) from pay_order where state = ? Hibernate: select sum(price) from pay_order where state = ? Hibernate: select payqrcode0_.id as id1_1_, payqrcode0_.pay_url as pay_url2_1_, payqrcode0_.price as price3_1_, payqrcode0_.type as type4_1_ from pay_qrcode payqrcode0_ where payqrcode0_.type=1 order by payqrcode0_.id desc limit ? Hibernate: select payqrcode0_.id as id1_1_, payqrcode0_.pay_url as pay_url2_1_, payqrcode0_.price as price3_1_, payqrcode0_.type as type4_1_ from pay_qrcode payqrcode0_ where payqrcode0_.type=1 order by payqrcode0_.id desc limit ? Hibernate: select setting0_.vkey as vkey1_2_, setting0_.vvalue as vvalue2_2_ from setting setting0_ Hibernate: select setting0_.vkey as vkey1_2_, setting0_.vvalue as vvalue2_2_ from setting setting0_ Hibernate: select setting0_.vkey as vkey1_2_, setting0_.vvalue as vvalue2_2_ from setting setting0_ Hibernate: select setting0_.vkey as vkey1_2_, setting0_.vvalue as vvalue2_2_ from setting setting0_ 开始清理过期订单... Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: update pay_order p set p.close_date=?,p.state=-1 where p.create_date= ? and create_date <= ? Hibernate: select count(*) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select count(*) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select count(*) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select sum(price) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select sum(price) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select count(*) from pay_order where state = ? Hibernate: select sum(price) from pay_order where state = ? Hibernate: select sum(price) from pay_order where state = ? 开始清理过期订单... Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: update pay_order p set p.close_date=?,p.state=-1 where p.create_date= ? and create_date <= ? Hibernate: select count(*) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select count(*) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select count(*) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select sum(price) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select sum(price) from pay_order where create_date >= ? and create_date <= ? and state = ? Hibernate: select count(*) from pay_order where state = ? Hibernate: select sum(price) from pay_order where state = ? Hibernate: select sum(price) from pay_order where state = ? Hibernate: select setting0_.vkey as vkey1_2_, setting0_.vvalue as vvalue2_2_ from setting setting0_ Hibernate: select setting0_.vkey as vkey1_2_, setting0_.vvalue as vvalue2_2_ from setting setting0_ Hibernate: select setting0_.vkey as vkey1_2_, setting0_.vvalue as vvalue2_2_ from setting setting0_ Hibernate: select setting0_.vkey as vkey1_2_, setting0_.vvalue as vvalue2_2_ from setting setting0_ 开始清理过期订单... Hibernate: select setting0_.vkey as vkey1_2_0_, setting0_.vvalue as vvalue2_2_0_ from setting setting0_ where setting0_.vkey=? Hibernate: update pay_order p set p.close_date=?,p.state=-1 where p.create_date