[JIRA] (JENKINS-37396) java.io.NotSerializableException: groovy.sql.GroovyRowResult
Title: Message Title Jean KST updated an issue Jenkins / JENKINS-37396 java.io.NotSerializableException: groovy.sql.GroovyRowResult Change By: Jean KST Comment: Had a similar issue and upgrading to Groovy plugin 2.2 fixed it. Add Comment This message was sent by Atlassian Jira (v7.11.2#711002-sha1:fdc329d) -- You received this message because you are subscribed to the Google Groups "Jenkins Issues" group. To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-issues+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[JIRA] (JENKINS-37396) java.io.NotSerializableException: groovy.sql.GroovyRowResult
Title: Message Title Jean KST commented on JENKINS-37396 Re: java.io.NotSerializableException: groovy.sql.GroovyRowResult Had a similar issue and upgrading to Groovy plugin 2.2 fixed it. Add Comment This message was sent by Atlassian Jira (v7.11.2#711002-sha1:fdc329d) -- You received this message because you are subscribed to the Google Groups "Jenkins Issues" group. To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-issues+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[JIRA] (JENKINS-37396) java.io.NotSerializableException: groovy.sql.GroovyRowResult
Title: Message Title Sam Van Oort closed an issue as Not A Defect AFAICT workflow-api and workflow-cps should now handle nonserializable exceptions as of the latest versions. In general though, you should see an error if you try to save something nonserializable so I consider this not-a-defect... and in general doing this kind of inline DB querying within Pipelines is strongly discouraged. Jenkins / JENKINS-37396 java.io.NotSerializableException: groovy.sql.GroovyRowResult Change By: Sam Van Oort Status: Open Closed Resolution: Not A Defect Add Comment This message was sent by Atlassian JIRA (v7.3.0#73011-sha1:3c73d0e)
[JIRA] (JENKINS-37396) java.io.NotSerializableException: groovy.sql.GroovyRowResult
Title: Message Title Joe Roberts edited a comment on JENKINS-37396 Re: java.io.NotSerializableException: groovy.sql.GroovyRowResult After some testing it would appear that, in order to complete successfully, sql.close() must be the last command in the script. Anything else causes either a groovy.sql.Sql or if you remove the "sql.close" command, a groovy.sql.GroovyRowResult java.io.NotSerializableException. [Perhaps related to this?|http://stackoverflow.com/questions/37864542/jenkins-pipeline-notserializableexception-groovy-json-internal-lazymap] Add Comment This message was sent by Atlassian JIRA (v7.1.7#71011-sha1:2526d7c) -- You received this message because you are subscribed to the Google Groups "Jenkins Issues" group. To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-issues+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[JIRA] (JENKINS-37396) java.io.NotSerializableException: groovy.sql.GroovyRowResult
Title: Message Title Joe Roberts commented on JENKINS-37396 Re: java.io.NotSerializableException: groovy.sql.GroovyRowResult After some testing it would appear that, in order to complete successfully, sql.close() must be the last command in the script. Anything else causes either a groovy.sql.Sql or if you remove the "sql.close" command, a groovy.sql.GroovyRowResult java.io.NotSerializableException. Add Comment This message was sent by Atlassian JIRA (v7.1.7#71011-sha1:2526d7c) -- You received this message because you are subscribed to the Google Groups "Jenkins Issues" group. To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-issues+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[JIRA] (JENKINS-37396) java.io.NotSerializableException: groovy.sql.GroovyRowResult
Title: Message Title Daniel Spilker assigned an issue to Jesse Glick Jenkins / JENKINS-37396 java.io.NotSerializableException: groovy.sql.GroovyRowResult Change By: Daniel Spilker Assignee: Daniel Spilker Jesse Glick Add Comment This message was sent by Atlassian JIRA (v7.1.7#71011-sha1:2526d7c) -- You received this message because you are subscribed to the Google Groups "Jenkins Issues" group. To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-issues+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[JIRA] (JENKINS-37396) java.io.NotSerializableException: groovy.sql.GroovyRowResult
Title: Message Title Daniel Spilker updated an issue Jenkins / JENKINS-37396 java.io.NotSerializableException: groovy.sql.GroovyRowResult Change By: Daniel Spilker Component/s: workflow-plugin Component/s: job-dsl-plugin Add Comment This message was sent by Atlassian JIRA (v7.1.7#71011-sha1:2526d7c) -- You received this message because you are subscribed to the Google Groups "Jenkins Issues" group. To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-issues+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[JIRA] (JENKINS-37396) java.io.NotSerializableException: groovy.sql.GroovyRowResult
Title: Message Title Joe Roberts commented on JENKINS-37396 Re: java.io.NotSerializableException: groovy.sql.GroovyRowResult java.io.NotSerializableException: groovy.sql.GroovyRowResult at org.jboss.marshalling.river.RiverMarshaller.doWriteObject(RiverMarshaller.java:860) at org.jboss.marshalling.river.RiverMarshaller.doWriteObject(RiverMarshaller.java:569) at org.jboss.marshalling.river.BlockMarshaller.doWriteObject(BlockMarshaller.java:65) at org.jboss.marshalling.river.BlockMarshaller.writeObject(BlockMarshaller.java:56) at org.jboss.marshalling.MarshallerObjectOutputStream.writeObjectOverride(MarshallerObjectOutputStream.java:50) at org.jboss.marshalling.river.RiverObjectOutputStream.writeObjectOverride(RiverObjectOutputStream.java:179) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:344) at java.util.HashMap.internalWriteEntries(HashMap.java:1785) at java.util.HashMap.writeObject(HashMap.java:1362) at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.jboss.marshalling.reflect.SerializableClass.callWriteObject(SerializableClass.java:271) at org.jboss.marshalling.river.RiverMarshaller.doWriteSerializableObject(RiverMarshaller.java:976) at org.jboss.marshalling.river.RiverMarshaller.doWriteObject(RiverMarshaller.java:854) at org.jboss.marshalling.river.RiverMarshaller.doWriteFields(RiverMarshaller.java:1032) at org.jboss.marshalling.river.RiverMarshaller.doWriteSerializableObject(RiverMarshaller.java:988) at org.jboss.marshalling.river.RiverMarshaller.doWriteObject(RiverMarshaller.java:854) at org.jboss.marshalling.river.RiverMarshaller.doWriteFields(RiverMarshaller.java:1032) at org.jboss.marshalling.river.RiverMarshaller.doWriteSerializableObject(RiverMarshaller.java:988) at org.jboss.marshalling.river.RiverMarshaller.doWriteSerializableObject(RiverMarshaller.java:967) at org.jboss.marshalling.river.RiverMarshaller.doWriteObject(RiverMarshaller.java:854) at org.jboss.marshalling.river.RiverMarshaller.doWriteFields(RiverMarshaller.java:1032) at org.jboss.marshalling.river.RiverMarshaller.doWriteSerializableObject(RiverMarshaller.java:988) at org.jboss.marshalling.river.RiverMarshaller.doWriteSerializableObject(RiverMarshaller.java:967) at org.jboss.marshalling.river.RiverMarshaller.doWriteObject(RiverMarshaller.java:854) at org.jboss.marshalling.river.RiverMarshaller.doWriteFields(RiverMarshaller.java:1032) at org.jboss.marshalling.river.RiverMarshaller.doWriteSerializableObject(RiverMarshaller.java:988) at org.jboss.marshalling.river.RiverMarshaller.doWriteSerializableObject(RiverMarshaller.java:967) at org.jboss.marshalling.river.RiverMarshaller.doWriteSerializableObject(RiverMarshaller.java:967) at org.jboss.marshalling.river.RiverMarshaller.doWriteObject(RiverMarshaller.java:854) at org.jboss.marshalling.river.RiverMarshaller.doWriteFields(RiverMarshaller.java:1032) at org.jboss.marshalling.river.RiverMarshaller.doWriteSerializableObject(RiverMarshaller.java:988) at org.jboss.marshalling.river.RiverMarshaller.doWriteSerializableObject(RiverMarshaller.java:967) at org.jboss.marshalling.river.RiverMarshaller.doWriteObject(RiverMarshaller.java:854) at org.jboss.marshalling.river.RiverMarshaller.doWriteFields(RiverMarshaller.java:1032) at
[JIRA] (JENKINS-37396) java.io.NotSerializableException: groovy.sql.GroovyRowResult
Title: Message Title
Joe Roberts created an issue
Jenkins / JENKINS-37396
java.io.NotSerializableException: groovy.sql.GroovyRowResult
Issue Type:
Bug
Assignee:
Daniel Spilker
Components:
job-dsl-plugin
Created:
2016/Aug/13 10:13 PM
Environment:
Centos 7 (3.10.0-327.22.2.el7.x86_64) openjdk version "1.8.0_101" OpenJDK Runtime Environment (build 1.8.0_101-b13) OpenJDK 64-Bit Server VM (build 25.101-b13, mixed mode) Jenkins 2.17 Job DSL plugin 1.48
Priority:
Blocker
Reporter:
Joe Roberts
When querying a MySQL database to perform functions on the resulting GroovyRowResults, I receive a NotSerializableException when attempting to use a string value from a GroovyRowResult in a "sh" call. In my worflow library:
def mergeEmtTag(tag){
stage 'Connect to database'
def db = [url:'jdbc:mysql://localhost:3306/jenkins', user:'jenkins_user', password:'xx', driver:'com.mysql.jdbc.Driver']
def sql = Sql.newInstance(db.url, db.user, db.password, db.driver)
stage 'Retrieve all EMTs'
def rows = sql.rows("SELECT * FROM emts")
sql.close()
for ( i in rows ) {
sh """
if [ -d "${i.slug}" ]; then
mkdir "${i.slug}"
fi
"""
dir("${slug}"){
sh """
git clone "g...@bitbucket.org:/${row.slug}.git" .
cd $slug
git remote add upstream g...@bitbucket.org:xxx/emt-master.git
git checkout origin/master
git fetch --tags upstream
git merge "${tag}"
if [ \$? -ne 0 ]; then
