#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