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
-
Greg Schueler January 20th, 2012 @ 11:12 AM
- Tag set to bug, field, rdb
- Milestone set to Rundeck 1.4.2
- Milestone order changed from 124 to 0
-
Greg Schueler January 23rd, 2012 @ 02:05 PM
- State changed from new to needs_verification
(from [173bc3a808acd013eace38369441ce581aad1703]) Change valuesUrl to text field type for rdb
[#506 state:needs_verification] https://github.com/dtolabs/rundeck/commit/173bc3a808acd013eace38369...
-
Greg Schueler January 24th, 2012 @ 03:43 PM
reverted my simple fix because it broke :(
may have to change the java class used for valuesUrl field from URL to String
-
Greg Schueler January 24th, 2012 @ 03:43 PM
- State changed from needs_verification to open
-
Greg Schueler January 25th, 2012 @ 05:42 PM
- State changed from open to needs_verification
(from [378d575ef64a5ece53ccaaef8f55d3ad0edca5ce]) Add secondary valuesUrlLong field for rdb
[#506 state:needs_verification] https://github.com/dtolabs/rundeck/commit/378d575ef64a5ece53ccaaef8...
-
Greg Schueler January 26th, 2012 @ 09:45 AM
- Assigned user set to Greg Schueler
-
Greg Schueler February 9th, 2012 @ 04:39 PM
(from [6a30e99772b9df4d91076b8a9716de92f5f4da8a]) Fix valuesUrl input to option from params/memo [#506] https://github.com/dtolabs/rundeck/commit/6a30e99772b9df4d91076b8a9...
-
Greg Schueler February 9th, 2012 @ 04:39 PM
(from [c5750f5ad099012737acfbf64c431b744b87b588]) Remove no-longer-used transient property of Option class [#506] https://github.com/dtolabs/rundeck/commit/c5750f5ad099012737acfbf64...
-
Greg Schueler February 10th, 2012 @ 09:55 AM
- State changed from needs_verification to resolved
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.
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