lkathous's recent timeline updates
lkathous

lkathous

🏢  Java开发
V2EX member #303626, joined on 2018-03-27 09:25:58 +08:00
lkathous's recent replies
Dec 10, 2020
Replied to a topic by 643785194 职场话题 女生走前端还是走安卓
前端
同白色,还在路上。白色绿色纠结了好久!
Sep 21, 2020
Replied to a topic by AILL 职场话题 想问一下各位国庆有几天假
8 天,补两天班,法定
大佬有找到解决方法吗?我也遇到了相同的问题
Oct 18, 2019
Replied to a topic by MrCard 程序员 你们都有双休吗?进来说说吧
1075。想申请加班换调休,老没有机会
深圳
走路 20 分钟,骑车 10 分钟
@xuxueli 好的,感谢!
xxl-job-admin 启动报错,数据库用的是 doc/db/tables_xxl_job.sql

```shell
### SQL: SELECT id FROM `XXL_JOB_QRTZ_TRIGGER_LOG` WHERE !( (trigger_code in (0, 200) and handle_code = 0) OR (handle_code = 200) ) AND `alarm_status` = 0 ORDER BY id ASC
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'alarm_status' in 'where clause'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'alarm_status' in 'where clause'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:230)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy61.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy65.findFailJobLogIds(Unknown Source)
at com.xxl.job.admin.core.thread.JobFailMonitorHelper$1.run(JobFailMonitorHelper.java:49)
at java.lang.Thread.run(Thread.java:748)
```
是数据库有改动吗
About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   2439 Online   Highest 6679   ·     Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 15ms · UTC 11:37 · PVG 19:37 · LAX 04:37 · JFK 07:37
♥ Do have faith in what you're doing.