search

leelance / spring-boot-all

spring-boot,mybatis,activemq,redis,email, freemarker,shiro,websocket,sitemesh,ehcache,easyui,kindeditor,quartz,springfox,swagger,jpa,hibernate,querydsl,netty
Apache License 2.0
1.95k stars 1.25k forks source link

Error managing cluster: Failure obtaining db row lock: Table 'demo-schema.QRTZ_LOCKS' doesn't exist #1

Closed mond-liu closed 7 years ago

mond-liu commented 7 years ago

作者您好，您的例子，我把数据库放本地没问题，但配置成远程数据库，数据库一样的，却会报如题错误，不知道为何会出现如此情况，望回复

leelance commented 7 years ago

@mond-liu 您好，我这个demo当时在window下面的 我的mysql设置了lower_case_table_names=1 忽略表名大小写， 你可以在mysql配置文件/etc/my.cnf 加入lower_case_table_names=1 默认是lower_case_table_names=0 不忽略大小写

你可以通过这个查看mysql是否忽略了大小写：show variables like "%case%";

mond-liu commented 7 years ago

@leelance 确实是这个问题，非常感谢

leelance commented 7 years ago

@mond-liu 那问题我关了