[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Cletus D'Souza resolved JENKINS-18335 as Won't Fix PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden Issue is resolved by using a compatible version of Derby Change By: Cletus D'Souza (18/Jun/13 8:58 PM) Status: In Progress Resolved Fix Version/s: current Resolution: Won't Fix This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira -- 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/groups/opt_out.
[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Cletus D'Souza commented on JENKINS-18335 PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden That being the case, any objections if I close this issue? This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira -- 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/groups/opt_out.
[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Cletus D'Souza started work on JENKINS-18335 PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden Change By: Cletus D'Souza (17/Jun/13 11:36 PM) Status: Open In Progress This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira -- 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/groups/opt_out.
[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Tobias Weier commented on JENKINS-18335 PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden That was the right hint. If have changed glassfish's derby database from 10.8.1.2 version to 10.5.3.0 - and the integrity plugin is working now. Thank you for your support. This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira -- 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/groups/opt_out.
[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Cletus D'Souza commented on JENKINS-18335 PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden Could it be the version of Derby that comes with Glassfish vs the version of Derby shipped with the Integrity plugin? This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira -- 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/groups/opt_out.
[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Tobias Weier edited a comment on JENKINS-18335 PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden I have found the point, that obviously produces the error in the updated plugin: We operate in an JEE Application Server - GlassFish Server Open Source Edition (3.1.2.2). If I start Jenkins as a normal java process, the upgraded plugin is working (after deletion of prior builds). Do you have any ideas, why the environment of the application server leads to this error in the plugin? This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira -- 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/groups/opt_out.
[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Tobias Weier commented on JENKINS-18335 PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden I have found the point, that obviously produces the error in the updated plugin: We operate in an JEE Application Server - GlassFish Server Open Source Edition (3.1.2.2). If I start Jenkins as a normal java process, the upgraded plugin is working (after deletion of prior builds). Do you have any ideas, why the environment of the application server produces this error? This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira -- 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/groups/opt_out.
[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Cletus D'Souza commented on JENKINS-18335 PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden Reproduce the error on a new job and send the 'full' debug log output. With regard to the transition from 1.12 to 1.13 there was an architectural change in caching. From a serialized file system object to a database. Unfortunately, there's nothin I could do to maintain backward compatibility. This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira -- 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/groups/opt_out.
[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Tobias Weier commented on JENKINS-18335 PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden Your suggestion sounds like a lot of work - our Jenkins contains nearly 200 jobs with integrity-plugin usage and hundreds of builds in history of many jobs... In spite of that I have tried to getting the plugin version 1.17 to work (on a testsystem) - without success. *Reconfiguring existing jobs (remove all history builds, remove integrity-plugin usage and re-add usage) *New jobs (with and without copying configuration from other jobs) *Deinstallation of PTC Integrity Plugin 1.12 after deletion of all jobs and installation of PTC Integrity Plugin 1.17 *Complete deletion of jenkins configuration directory and installation of PTC Integrity Plugin 1.17 in a new empty Jenkins All attempts fails with the same SQLException. Do you have any further ideas? Many thanks in advance for your support. This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira -- 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/groups/opt_out.
[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Cletus D'Souza commented on JENKINS-18335 PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden Hi there is no upgrade from v1.12 to v1.13 and beyond. At v1.13 the caching architecture was changed. Hence you need to re-create your build job or delete or prior builds (re-configuring the build job). This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira -- 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/groups/opt_out.
[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Tobias Weier updated JENKINS-18335 PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden Change By: Tobias Weier (13/Jun/13 1:45 PM) Description: Upgrading the After an upgrade from working PTC Integrity Plugin with version 1.12 of PTC Integrity Plugin to a higher version 1.16/1.17 - the plugin fails always with SQLException.Console output shows:[EnvInject] - Loading node environment variables.Building in workspace /build/jenkins/jobs/X/workspaceChange Log: http://192.168.100.211:8080/jenkins/job/X/10/changesBuild Log: http://192.168.100.211:8080/jenkins/job/X/10/consolePreparing to execute si projectinfo for #/repository/xPreparing to execute si viewproject for #/repository/xA SQL Exception was caught!Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werdenDer Versuch wurde ignoriert, eine E-Mail an eine leere Liste von Empfängern zu verschicken.Finished: FAILUREJenkins Log shows following:Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Successfully disconnected connection Jenkins@mks:7001Jun 13, 2013 2:51:56 PM org.apache.commons.httpclient.HttpMethodBase readResponseBodyINFO: Response content is not chunk-encodedJun 13, 2013 2:51:56 PM org.apache.commons.httpclient.HttpMethodBase readResponseBodyWARNING: Unsupported transfer encoding: Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - java.sql.SQLNonTransientConnectionException: Die Datenbank '/build/jenkins/jobs/X/builds/2013-06-13_14-50-56/IntegritySCM' wird heruntergefahren.Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - Die Datenbank '/build/jenkins/jobs/X/builds/2013-06-13_14-50-56/IntegritySCM' wird heruntergefahren.Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - Failed to shutdown database connection!Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Attempting to shut down database: /build/jenkins/jobs/X/builds/2013-06-13_14-50-56/IntegritySCMJun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - java.sql.SQLException: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werdenJun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - SQL Exception caught...Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - java.sql.SQLNonTransientConnectionException: Database '/build/jenkins/jobs/X/builds/2013-06-13_12-13-30/IntegritySCM' shutdown.Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - Database '/build/jenkins/jobs/X/builds/2013-06-13_12-13-30/IntegritySCM' shutdown.Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - Failed to shutdown database connection!Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Attempting to shut down database: /build/jenkins/jobs/X/builds/2013-06-13_12-13-30/IntegritySCMJun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Attempting to execute query SELECT NAME, MEMBER_ID, TIMESTAMP, DESCRIPTION, AUTHOR, CONFIG_PATH, REVISION, RELATIVEFILE, CHECKSUM FROM CM_PROJECT WHERE TYPE = 0 AND (DELTA IS NULL OR DELTA <> 3)Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Attempting to open connection to database: /build/jenkins/jobs/X/builds/2013-06-13_14-50-56/IntegritySCMJun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Attempting to open connection to database: /build/jenkins/jobs/X/builds/2013-06-13_12-13-30/IntegritySCMJun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Found previous project state in build 9Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Parsing project #/repository/x complete!Jun 13, 2013 2:51:00 PM SEVERE: Jun 13, 2013 2:51:00 PM [DEBUG] IntegritySCM - Attempting to execute query INSERT INTO CM_PROJECT (TYPE, NAME, MEMBER_ID, TIMESTAMP, DESCRIPTION, CONFIG_PATH, REVISION, RELATIVEFILE) VALUES (?, ?, ?, ?, ?, ?, ?, ?)Jun 13, 2013 2:51:00 PM SEVERE: Jun 13, 2013 2:51:00 PM [DEBUG] IntegritySC
[JIRA] [integrity-plugin] (JENKINS-18335) PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden
Tobias Weier created JENKINS-18335 PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden Issue Type: Bug Assignee: Cletus D'Souza Components: integrity-plugin Created: 13/Jun/13 1:15 PM Description: Upgrading the working PTC Integrity Plugin with version 1.12 to a higher version 1.16/1.17 the plugin fails always with SQLException. Console output shows: [EnvInject] - Loading node environment variables. Building in workspace /build/jenkins/jobs/X/workspace Change Log: http://192.168.100.211:8080/jenkins/job/X/10/changes Build Log: http://192.168.100.211:8080/jenkins/job/X/10/console Preparing to execute si projectinfo for #/repository/x Preparing to execute si viewproject for #/repository/x A SQL Exception was caught! Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden Der Versuch wurde ignoriert, eine E-Mail an eine leere Liste von Empfängern zu verschicken. Finished: FAILURE Jenkins Log shows following: Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Successfully disconnected connection Jenkins@mks:7001 Jun 13, 2013 2:51:56 PM org.apache.commons.httpclient.HttpMethodBase readResponseBody INFO: Response content is not chunk-encoded Jun 13, 2013 2:51:56 PM org.apache.commons.httpclient.HttpMethodBase readResponseBody WARNING: Unsupported transfer encoding: Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - java.sql.SQLNonTransientConnectionException: Die Datenbank '/build/jenkins/jobs/X/builds/2013-06-13_14-50-56/IntegritySCM' wird heruntergefahren. Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - Die Datenbank '/build/jenkins/jobs/X/builds/2013-06-13_14-50-56/IntegritySCM' wird heruntergefahren. Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - Failed to shutdown database connection! Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Attempting to shut down database: /build/jenkins/jobs/X/builds/2013-06-13_14-50-56/IntegritySCM Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - java.sql.SQLException: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - SQL Exception caught... Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - java.sql.SQLNonTransientConnectionException: Database '/build/jenkins/jobs/X/builds/2013-06-13_12-13-30/IntegritySCM' shutdown. Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - Database '/build/jenkins/jobs/X/builds/2013-06-13_12-13-30/IntegritySCM' shutdown. Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [INFO] IntegritySCM - Failed to shutdown database connection! Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Attempting to shut down database: /build/jenkins/jobs/X/builds/2013-06-13_12-13-30/IntegritySCM Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Attempting to execute query SELECT NAME, MEMBER_ID, TIMESTAMP, DESCRIPTION, AUTHOR, CONFIG_PATH, REVISION, RELATIVEFILE, CHECKSUM FROM CM_PROJECT WHERE TYPE = 0 AND (DELTA IS NULL OR DELTA <> 3) Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Attempting to open connection to database: /build/jenkins/jobs/X/builds/2013-06-13_14-50-56/IntegritySCM Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Attempting to open connection to database: /build/jenkins/jobs/X/builds/2013-06-13_12-13-30/IntegritySCM Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Found previous project state in build 9 Jun 13, 2013 2:51:56 PM SEVERE: Jun 13, 2013 2:51:56 PM [DEBUG] IntegritySCM - Parsing project #/repository/x complete! Jun 13, 2013 2:51:00 PM SEVERE: Jun 13, 2013 2:51:00 PM [DEBUG] IntegritySCM - Attempting to execute query INSERT
