-
Notifications
You must be signed in to change notification settings - Fork 2k
Description
Cachecloud 3.2 运行7天后开始报错app_client_value_minute_stats表不存在,但是源码中给出的初始化SQL中并没有这张表的创建语句,这是bug么?
2024-05-17 10:00:00.075 ERROR 5726 --- [zThreadPool-123] c.s.c.s.app.impl.AppDailyDataCenterImpl :
Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'cachecloud.app_client_value_minute_stats' doesn't exist
The error may exist in class path resource [mapper/AppClientValueStatDao.xml]
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: select distribute_type, sum(count) as count from app_client_value_minute_stats where app_id=? and collect_time between ? and ? group by distribute_type order by distribute_type
Cause: java.sql.SQLSyntaxErrorException: Table 'cachecloud.app_client_value_minute_stats' doesn't exist
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'cachecloud.app_client_value_minute_stats' doesn't exist
org.springframework.jdbc.BadSqlGrammarException:
Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'cachecloud.app_client_value_minute_stats' doesn't exist
The error may exist in class path resource [mapper/AppClientValueStatDao.xml]
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: select distribute_type, sum(count) as count from app_client_value_minute_stats where app_id=? and collect_time between ? and ? group by distribute_type order by distribute_type
Cause: java.sql.SQLSyntaxErrorException: Table 'cachecloud.app_client_value_minute_stats' doesn't exist
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'cachecloud.app_client_value_minute_stats' doesn't exist
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:235)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy82.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy139.getAppValueDistriList(Unknown Source)
at com.sohu.cache.stats.app.impl.AppDailyDataCenterImpl.getAppClientValueSizeDistributeCountMap(AppDailyDataCenterImpl.java:209)
at com.sohu.cache.stats.app.impl.AppDailyDataCenterImpl.generateAppDaily(AppDailyDataCenterImpl.java:165)
at com.sohu.cache.stats.app.impl.AppDailyDataCenterImpl.sendAppDailyEmail(AppDailyDataCenterImpl.java:88)
at com.sohu.cache.stats.app.impl.AppDailyDataCenterImpl.sendAppDailyEmail(AppDailyDataCenterImpl.java:74)
at com.sohu.cache.schedule.jobs.AppDailyJob.action(AppDailyJob.java:35)
at com.sohu.cache.schedule.jobs.CacheBaseJob.execute(CacheBaseJob.java:33)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
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:750)
Caused by: java.sql.SQLSyntaxErrorException: Table 'cachecloud.app_client_value_minute_stats' doesn't exist
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.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
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:324)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at sun.reflect.GeneratedMethodAccessor243.invoke(Unknown Source)
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:433)
... 16 common frames omitted