Rundeck 1.4.2-1

[chengkai liang]

After install this version to ubuntu, and try to load jobs I got this error in the log file:

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 options0_ where options0_.scheduled_execution_id=1' at line 1
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 6 more

Any idea what's going on?
-Chengkai

[Greg Schueler]

Hi Chengkai,

make sure you have the "rundeck.v14.rdbsupport=true" value set in your
rundeck-config.properties file:

http://rundeck.org/docs/administration/relational-database.html#enable-rdbsupport

[chengkai liang]

Any idea what caused this:

WARN HttpMethodBase: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
ERROR WebserviceHttpClientChannel: Unable to parse result document: Error on line 1 of document : The markup in the document following the root element must be well-formed. Nested exception: The markup in the document following the root element must be well-formed.
org.dom4j.DocumentException: Error on line 1 of document : The markup in the document following the root element must be well-formed. Nested exception: The markup in the document following the root element must be well-formed.
at org.dom4j.io.SAXReader.read(SAXReader.java:482)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)
at com.dtolabs.client.utils.WebserviceHttpClientChannel.postMakeRequest(WebserviceHttpClientChannel.java:238)
at com.dtolabs.client.utils.HttpClientChannel.makeRequest(HttpClientChannel.java:387)
at com.dtolabs.client.services.ServerService.makeRundeckRequest(ServerService.java:134)
at com.dtolabs.client.services.ServerService.makeRundeckRequest(ServerService.java:97)
at com.dtolabs.client.services.RundeckAPICentralDispatcher.loadJobs(RundeckAPICentralDispatcher.java:1061)
at com.dtolabs.rundeck.core.cli.jobs.JobsTool.loadAction(JobsTool.java:613)
at com.dtolabs.rundeck.core.cli.jobs.JobsTool.go(JobsTool.java:586)
at com.dtolabs.rundeck.core.cli.BaseTool.run(BaseTool.java:107)
at com.dtolabs.rundeck.core.cli.jobs.JobsTool.main(JobsTool.java:358)
Nested exception:
org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 24564; The markup in the document following the root element must be well-formed.
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.dom4j.io.SAXReader.read(SAXReader.java:465)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)
at com.dtolabs.client.utils.WebserviceHttpClientChannel.postMakeRequest(WebserviceHttpClientChannel.java:238)
at com.dtolabs.client.utils.HttpClientChannel.makeRequest(HttpClientChannel.java:387)
at com.dtolabs.client.services.ServerService.makeRundeckRequest(ServerService.java:134)
at com.dtolabs.client.services.ServerService.makeRundeckRequest(ServerService.java:97)
at com.dtolabs.client.services.RundeckAPICentralDispatcher.loadJobs(RundeckAPICentralDispatcher.java:1061)
at com.dtolabs.rundeck.core.cli.jobs.JobsTool.loadAction(JobsTool.java:613)
at com.dtolabs.rundeck.core.cli.jobs.JobsTool.go(JobsTool.java:586)
at com.dtolabs.rundeck.core.cli.BaseTool.run(BaseTool.java:107)
at com.dtolabs.rundeck.core.cli.jobs.JobsTool.main(JobsTool.java:358)
Error: Failed request to load jobs: Response content unexpectedly empty. OK

[Greg Schueler]

Do the jobs load OK if you do it through the web interface?

[chengkai liang]

I am using rd-jobs to load the xml file and get this error. The jobs are not loaded.