search

MyCATApache / Mycat-Web

Apache License 2.0
189 stars 222 forks source link

mycat1.6 监控都没数据 #118

Closed cjldw closed 7 years ago

cjldw commented 7 years ago

查看报错信息 database is locked? 

查询失败,系统异常!case:
↵### Error querying database.
  Cause: java.sql.SQLException: [SQLITE_BUSY]  The database file is locked (database is locked)↵
### The error may exist in file [/data/app/mycat-web/mycat-web/WEB-INF/classes/mybatis/mycat/syssqlslowMapper.xml]↵
### The error may involve SYSSQLSLOW.sqlslow-Inline↵
### The error occurred while setting parameters↵
### SQL: select START_TIME,START_TM,EXECUTE_TIME,USER,CONTENT as "SQL",DB_NAME as "DATASOURCE",IPAddr from t_mycat_syssqlslow     WHERE  DB_NAME = ?                and START_TM between ? and ?             and EXECUTE_TIME >= ?      order by START_TIME desc↵
### Cause: java.sql.SQLException: [SQLITE_BUSY]  The database file is locked (database is locked)↵; uncategorized SQLException for SQL []; SQL state [null]; error code [5]; [SQLITE_BUSY]  The database file is locked (database is locked); nested exception is java.sql.SQLException: [SQLITE_BUSY]  The database file is locked (database is locked)