quartz 1.x版本出现OPTION SQL_SELECT_LIMIT=DEFAULT错误解决方案
来源:互联网 发布:中文域名续费价格 编辑:程序博客网 时间:2024/06/05 16:57
之所以出现这个问题,是因为使用了quartz的分布式部署方案,提高任务平台的可靠性,由于公司内部框架的限制,只能使用基于spring2.5,也就限制了使用quartz 的1.x版本,但是公司的数据库挺新的,5.6.。。。
问题错误异常为:
[ERROR 2016-01-06 16:57:44.849] [QuartzScheduler_CRMscheduler-zc-miui-fi-stag00.bj1452070593162_ClusterManager] [] org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3853) [ClusterManager: Error managing cluster: Failure identifying failed instances when checking-in: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1]
org.quartz.JobPersistenceException: Failure identifying failed instances when checking-in: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1 [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.findFailedInstances(JobStoreSupport.java:3307)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.clusterCheckIn(JobStoreSupport.java:3360)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3216)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3847)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3883)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1544)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2212)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectSchedulerStateRecords(StdJDBCDelegate.java:3273)
出现这种错误,首先找了谷歌,得到的结果貌似就是与mysql版本不兼容,再不能改变线上数据库的情况下,只能另想其他方案(我测试过的,但是测试环境的mysql版本是5.5 ,木有发现问题)
解决方案,将mysql的connector升级为5.1.31,然后重新运行,问题解决。
- quartz 1.x版本出现OPTION SQL_SELECT_LIMIT=DEFAULT错误解决方案
- 错误:OPTION SQL_SELECT_LIMIT=DEFAULT
- Mysql OPTION SQL_SELECT_LIMIT=DEFAULT 错误
- OPTION SQL_SELECT_LIMIT=DEFAULT java连接mysql错误
- 转:OPTION SQL_SELECT_LIMIT=DEFAULT java连接mysql错误
- kettle-error-OPTION SQL_SELECT_LIMIT=DEFAULT
- Mysql异常'SET OPTION SQL_SELECT_LIMIT=DEFAULT'
- 使用hive OPTION SQL_SELECT_LIMIT=DEFAULT
- quartz报错:OPTION SQL_SELECT_LIMIT=1
- Myeclipse使用DB Browser连接数据库错误:OPTION SQL_SELECT_LIMIT=DEFAULT
- kettle开发中的OPTION SQL_SELECT_LIMIT=DEFAULT报错
- Kettle中 "'SET OPTION SQL_SELECT_LIMIT=DEFAULT"异常
- MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT’
- kettle3使用mysql5.6出现OPTION SQL_SELECT_LIMIT=1的问题
- MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
- dbvis MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at lin
- dbvis MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at lin
- 关于初次搭建环境切换老版本出现错误gcc: error: unrecognized command line option ‘-mthumb’的解决方案
- windows下 tomcat 免安装版添加到开机启动
- 使用ASI框架进行文件下载
- iOS 大头针从天而降动画
- 再生核希尔伯特空间2---概念
- hadoop系列:zookeeper(1)——zookeeper单点和集群安装
- quartz 1.x版本出现OPTION SQL_SELECT_LIMIT=DEFAULT错误解决方案
- CentOS启用sudo方法
- Gradle project refresh failed after AndroidStudio update
- Android开发之Intent.Action
- 真无限循环的ViewPager——解决两端滑动的平滑问题
- Html5添加产品图片360度旋转插件教程
- Linux里利用grep和find查找文件内容
- RNN review笔记
- Unity中加载模型