#506 ✓resolved
Bryan Fransman

Data too long for column 'values_url'

Reported by Bryan Fransman | January 20th, 2012 @ 05:28 AM | in Rundeck 1.4.2 (closed)

Per Greg Schueler:

Hi Bryan, This looks like another field that needs to be changed to 'text' type for mysql/rdb use. Can you file a bug in the tracker?

I can confirm updating the data type to 'text' resolves the issue detailed below.

Details:

I'm running into an odd exception when attempting to add an option
with "Remote URL" for allowed values.

Environment:
Run Deck installed RPM (rundeck-1.4.1-1.2, rundeck-config-1.4.1-1.2)
MySQL 5.0.67

Exception:
ERROR JDBCExceptionReporter: Data truncation: Data too long for column
'values_url' at row 1 ERROR GrailsExceptionResolver: Exception occurred when processing
request: [POST] /job/index
Stacktrace follows:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
column 'values_url' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3595) 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.executeUpdate(PreparedStatement.java:
2415)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:
2333)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:
2318)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:
105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:
105)
at ScheduledExecutionController $_closure16.doCall(ScheduledExecutionController.groovy:1052) at ScheduledExecutionController.invokeMethod(ScheduledExecutionController.groovy)
at ScheduledExecutionController $_closure15.doCall(ScheduledExecutionController.groovy:717) at ScheduledExecutionController $_closure15.doCall(ScheduledExecutionController.groovy)

I have confirmed that values_url is tinyblob, and that the URL I'm
using does not exceed the requirements.

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

(DEPRECATED) Please use github issues for issue tracking at http://github.com/dtolabs/rundeck/issues

Shared Ticket Bins

People watching this ticket

Tags

Pages