You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
354 lines
31 KiB
354 lines
31 KiB
09:00:09.890 [schedule-pool-2] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,504] - slow sql 9806 millis. SELECT 1 FROM DUAL[]
|
|
09:00:10.113 [quartzScheduler_Worker-1] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,504] - slow sql 9977 millis. SELECT 1 FROM DUAL[]
|
|
09:30:05.593 [quartzScheduler_Worker-3] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,504] - slow sql 5439 millis. select e.id, e.organ_code, e.organ_name, e.location, e.address, e.accuracy, e.dimension,e.copy_right,e.sort,
|
|
e.province_code,e.city_code,e.county_code,e.remark,e.contact_number,
|
|
e.is_organ,e.login_title, e.contact_person, e.contact_number, e.website_url, e.login_logo, e.login_background,
|
|
e.create_by, e.create_time, e.update_by, e.update_time, e.status, e.del_flag,e.territory,u.user_id,(select
|
|
r.role_id from sys_role r where r.role_key=e.organ_code ) as role_id from ti_enterprise_info e left join
|
|
sys_user u on e.organ_code = u.organ_code
|
|
WHERE u.user_type ='00'
|
|
and e.del_flag != '2'
|
|
order by e.sort asc, e.create_time desc[]
|
|
10:00:04.902 [schedule-pool-1] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,504] - slow sql 4611 millis. select t1.id from patrol_task t1
|
|
|
|
where 1=1 and (t1.patrol_customize_date < CURDATE()) and t1.del_flag !=2 and t1.patrol_type='2' and task_state=2[]
|
|
10:00:04.902 [quartzScheduler_Worker-1] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,504] - slow sql 4617 millis. select e.id, e.organ_code, e.organ_name, e.location, e.address, e.accuracy, e.dimension,e.copy_right,e.sort,
|
|
e.province_code,e.city_code,e.county_code,e.remark,e.contact_number,
|
|
e.is_organ,e.login_title, e.contact_person, e.contact_number, e.website_url, e.login_logo, e.login_background,
|
|
e.create_by, e.create_time, e.update_by, e.update_time, e.status, e.del_flag,e.territory,u.user_id,(select
|
|
r.role_id from sys_role r where r.role_key=e.organ_code ) as role_id from ti_enterprise_info e left join
|
|
sys_user u on e.organ_code = u.organ_code
|
|
WHERE u.user_type ='00'
|
|
and e.del_flag != '2'
|
|
order by e.sort asc, e.create_time desc[]
|
|
13:49:52.273 [schedule-pool-2] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
|
|
java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.String
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.lambda$getAppointmentLiveData$0(AppointmentStatisticsTask.java:40)
|
|
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
|
|
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.getAppointmentLiveData(AppointmentStatisticsTask.java:39)
|
|
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 org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
|
|
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
|
|
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
|
|
at java.util.concurrent.FutureTask.run(FutureTask.java)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
|
|
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)
|
|
13:51:13.144 [schedule-pool-1] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
|
|
java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.String
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.lambda$getAppointmentLiveData$0(AppointmentStatisticsTask.java:40)
|
|
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
|
|
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.getAppointmentLiveData(AppointmentStatisticsTask.java:39)
|
|
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 org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
|
|
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
|
|
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
|
|
at java.util.concurrent.FutureTask.run(FutureTask.java)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
|
|
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)
|
|
13:52:07.826 [schedule-pool-1] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
|
|
java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.String
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.lambda$getAppointmentLiveData$0(AppointmentStatisticsTask.java:40)
|
|
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
|
|
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.getAppointmentLiveData(AppointmentStatisticsTask.java:39)
|
|
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 org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
|
|
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
|
|
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
|
|
at java.util.concurrent.FutureTask.run(FutureTask.java)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
|
|
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)
|
|
13:53:01.986 [schedule-pool-1] ERROR c.a.d.f.s.StatFilter - [mergeSql,150] - merge sql error, dbType mysql, druid-1.2.15, sql : SELECT
|
|
t2.resource_code as resourceCode+"",
|
|
ifnull(SUM(CASE WHEN (t1.state = 0 or t1.state = 1 )THEN 1 ELSE 0 END), 0) as appointmentNumber,
|
|
ifnull(SUM(CASE WHEN t1.state = 1 THEN 1 ELSE 0 END), 0) as admissionNumber,
|
|
t1.organ_code as organCode
|
|
FROM
|
|
appointment_center_data t1
|
|
LEFT JOIN b_tour_info t2 on t1.scenic_name = t2.resource_name
|
|
WHERE 1=1
|
|
and DATE_FORMAT(t1.appointment_date,'%Y-%m-%d') = DATE_FORMAT(NOW(),'%Y-%m-%d')
|
|
GROUP BY t2.resource_code, t1.organ_code
|
|
com.alibaba.druid.sql.parser.ParserException: not supported.pos 52, line 2, column 46, token +
|
|
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:615)
|
|
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:101)
|
|
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:163)
|
|
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:134)
|
|
at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:148)
|
|
at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:672)
|
|
at com.alibaba.druid.filter.stat.StatFilter.statementPrepareAfter(StatFilter.java:325)
|
|
at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:118)
|
|
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:531)
|
|
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:326)
|
|
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:362)
|
|
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.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:55)
|
|
at com.sun.proxy.$Proxy110.prepareStatement(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86)
|
|
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:151)
|
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
|
at com.sun.proxy.$Proxy357.query(Unknown Source)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
|
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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
at com.sun.proxy.$Proxy108.selectList(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy309.getAppointmentNumberAndAdmissionNumber(Unknown Source)
|
|
at com.cjy.reservation.service.impl.AppointmentStatisticsTaskServiceImpl.getAppointmentNumberAndAdmissionNumber(AppointmentStatisticsTaskServiceImpl.java:22)
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.getAppointmentLiveData(AppointmentStatisticsTask.java:37)
|
|
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 org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
|
|
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
|
|
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
|
|
at java.util.concurrent.FutureTask.run(FutureTask.java)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
|
|
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)
|
|
13:53:04.544 [schedule-pool-1] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
|
|
org.springframework.jdbc.BadSqlGrammarException:
|
|
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+"",
|
|
ifnull(SUM(CASE WHEN (t1.state = 0 or t1.state = 1 )THEN 1 ELSE' at line 2
|
|
### The error may exist in file [/Users/liangjiawei/Downloads/项目/cjy/scenic_controls/cjy-project/target/classes/mapper/reservationAge/AppointmentStatisticsTaskMapper.xml]
|
|
### The error may involve defaultParameterMap
|
|
### The error occurred while setting parameters
|
|
### SQL: SELECT t2.resource_code as resourceCode+"", ifnull(SUM(CASE WHEN (t1.state = 0 or t1.state = 1 )THEN 1 ELSE 0 END), 0) as appointmentNumber, ifnull(SUM(CASE WHEN t1.state = 1 THEN 1 ELSE 0 END), 0) as admissionNumber, t1.organ_code as organCode FROM appointment_center_data t1 LEFT JOIN b_tour_info t2 on t1.scenic_name = t2.resource_name WHERE 1=1 and DATE_FORMAT(t1.appointment_date,'%Y-%m-%d') = DATE_FORMAT(NOW(),'%Y-%m-%d') GROUP BY t2.resource_code, t1.organ_code
|
|
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+"",
|
|
ifnull(SUM(CASE WHEN (t1.state = 0 or t1.state = 1 )THEN 1 ELSE' at line 2
|
|
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+"",
|
|
ifnull(SUM(CASE WHEN (t1.state = 0 or t1.state = 1 )THEN 1 ELSE' at line 2
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy108.selectList(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy309.getAppointmentNumberAndAdmissionNumber(Unknown Source)
|
|
at com.cjy.reservation.service.impl.AppointmentStatisticsTaskServiceImpl.getAppointmentNumberAndAdmissionNumber(AppointmentStatisticsTaskServiceImpl.java:22)
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.getAppointmentLiveData(AppointmentStatisticsTask.java:37)
|
|
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 org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
|
|
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
|
|
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
|
|
at java.util.concurrent.FutureTask.run(FutureTask.java)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
|
|
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)
|
|
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+"",
|
|
ifnull(SUM(CASE WHEN (t1.state = 0 or t1.state = 1 )THEN 1 ELSE' at line 2
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
|
|
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3446)
|
|
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434)
|
|
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444)
|
|
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:152)
|
|
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483)
|
|
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.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy111.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:151)
|
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
|
at com.sun.proxy.$Proxy357.query(Unknown Source)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
|
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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 24 common frames omitted
|
|
14:04:35.071 [http-nio-8080-exec-2] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,504] - slow sql 1996 millis. INSERT INTO appointment_center_data ( appointment_number, scenic_name,
|
|
appointment_date, appointment_slot,
|
|
appointment_people_name, appointment_people_phone,
|
|
certificate_type, documents_number,
|
|
verification_code, state, write_off_time,
|
|
data_sources,
|
|
organ_code,appointment_people_id)
|
|
VALUES
|
|
|
|
(?, ?, ?, ?,
|
|
?, ?, ?, ?, ?, ?, ?, ?,
|
|
?,?)
|
|
,
|
|
(?, ?, ?, ?,
|
|
?, ?, ?, ?, ?, ?, ?, ?,
|
|
?,?)["202308031500147977","沽源县博物馆","2023-08-03 00:00:00","10:00～18:00","张龙","15931678763","5501","130376477389323352",null,"0",null,"2",123,null,"202308031500149583","沽源县博物馆","2023-08-03 00:00:00","10:00～18:00","赵虎","15931678762","5501","130376477389323353",null,"0",null,"2",123,null]
|
|
17:19:19.799 [schedule-pool-1] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
|
|
java.lang.NullPointerException: null
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.lambda$getSexAppointmentLiveData$4(AppointmentStatisticsTask.java:113)
|
|
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
|
|
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.getSexAppointmentLiveData(AppointmentStatisticsTask.java:112)
|
|
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 org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
|
|
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
|
|
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
|
|
at java.util.concurrent.FutureTask.run(FutureTask.java)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
|
|
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)
|
|
17:20:23.969 [schedule-pool-3] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
|
|
java.lang.NullPointerException: null
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.lambda$getSexAppointmentLiveData$4(AppointmentStatisticsTask.java:113)
|
|
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
|
|
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.getSexAppointmentLiveData(AppointmentStatisticsTask.java:112)
|
|
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 org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
|
|
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
|
|
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
|
|
at java.util.concurrent.FutureTask.run(FutureTask.java)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
|
|
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)
|
|
17:22:05.367 [schedule-pool-1] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
|
|
java.lang.NullPointerException: null
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.lambda$getSexAppointmentLiveData$4(AppointmentStatisticsTask.java:113)
|
|
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
|
|
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.getSexAppointmentLiveData(AppointmentStatisticsTask.java:112)
|
|
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 org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
|
|
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
|
|
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
|
|
at java.util.concurrent.FutureTask.run(FutureTask.java)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
|
|
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)
|
|
17:23:11.235 [schedule-pool-1] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
|
|
java.lang.NullPointerException: null
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.lambda$getSexAppointmentLiveData$4(AppointmentStatisticsTask.java:113)
|
|
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
|
|
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.getSexAppointmentLiveData(AppointmentStatisticsTask.java:112)
|
|
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 org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
|
|
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
|
|
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
|
|
at java.util.concurrent.FutureTask.run(FutureTask.java)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
|
|
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)
|
|
17:24:34.943 [schedule-pool-3] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
|
|
java.lang.NullPointerException: null
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.lambda$getSexAppointmentLiveData$4(AppointmentStatisticsTask.java:113)
|
|
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
|
|
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
|
|
at com.cjy.reservation.task.AppointmentStatisticsTask.getSexAppointmentLiveData(AppointmentStatisticsTask.java:112)
|
|
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 org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
|
|
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
|
|
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
|
|
at java.util.concurrent.FutureTask.run(FutureTask.java)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
|
|
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
|
|
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)
|
|
|