Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

Data too long for column 'values_url'

#506

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.

Reported by Bryan Fransman · January 20th, 2012 @ 05:28 AM

State: new
Milestone: none
Assigned to: nobody

Activity

  1. Greg Schueler
    Greg Schueler
    • Tag set to bug, field, rdb
    • Milestone set to Rundeck 1.4.2
    • Milestone order changed from 124 to 0

    January 20th, 2012 @ 11:12 AM

  2. Greg Schueler
    Greg Schueler
    • State changed from new to needs_verification

    January 23rd, 2012 @ 02:05 PM

  3. Greg Schueler
    Greg Schueler

    reverted my simple fix because it broke :(

    may have to change the java class used for valuesUrl field from URL to String

    January 24th, 2012 @ 03:43 PM

  4. Greg Schueler
    Greg Schueler
    • State changed from needs_verification to open

    January 24th, 2012 @ 03:43 PM

  5. Greg Schueler
    Greg Schueler
    • State changed from open to needs_verification

    January 25th, 2012 @ 05:42 PM

  6. Greg Schueler
    Greg Schueler
    • Assigned user set to Greg Schueler

    January 26th, 2012 @ 09:45 AM

  7. Greg Schueler
    Greg Schueler

    setting valuesUrl in GUI doesn't work

    February 9th, 2012 @ 03:13 PM

  8. Greg Schueler
    Greg Schueler

    February 9th, 2012 @ 04:39 PM

  9. Greg Schueler
    Greg Schueler

    February 9th, 2012 @ 04:39 PM

  10. Greg Schueler
    Greg Schueler
    • State changed from needs_verification to resolved

    February 10th, 2012 @ 09:55 AM

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.