EFAK
EFAK copied to clipboard
[SQLITE_ERROR] no such function: from_unixtime
When using SQLite, the error is thrown constantly:
org.springframework.jdbc.UncategorizedSQLException:
### Error querying database. Cause: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such function: from_unixtime)
### The error may exist in org/smartloli/kafka/eagle/web/dao/TopicDao.xml
### The error may involve org.smartloli.kafka.eagle.web.dao.TopicDao.queryProducerHistoryBar
### The error occurred while executing a query
### SQL: select tm,sum(new_diffval) as total from ( select tm,max(diffval) as new_diffval from ke_logsize where cluster=? and diffval > 0 and tm between ? and ? group by from_unixtime(timespan/1000,'%Y-%m-%d %H:%i:%s'),tm )a group by tm
### Cause: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such function: from_unixtime)
; uncategorized SQLException; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such function: from_unixtime); nested exception is org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such function: from_unixtime)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)