xxl-job-admin报错如下:
org.springframework.jdbc.UncategorizedSQLException:
Error querying database. Cause: java.sql.SQLException: Tablespace is missing for table xxl_job
.XXL_JOB_QRTZ_TRIGGER_LOG
.
The error may exist in class path resource [mybatis-mapper/XxlJobLogMapper.xml]
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: SELECT count(1) FROM XXL_JOB_QRTZ_TRIGGER_LOG AS t
Cause: java.sql.SQLException: Tablespace is missing for table xxl_job
.XXL_JOB_QRTZ_TRIGGER_LOG
.
; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1812]; Tablespace is missing for table xxl_job
.XXL_JOB_QRTZ_TRIGGER_LOG
.; nested exception is java.sql.SQLException: Tablespace is missing for table xxl_job
.XXL_JOB_QRTZ_TRIGGER_LOG
.
原因:XXL_JOB_QRTZ_TRIGGER_LOG 表空间满了
解决:将数据备份,然后整表删除,重新创建表无需导入数据。