Uploaded image for project: 'Jenkins'
  1. Jenkins
  2. JENKINS-18335

PTC Integrity Plugin throws SQL Exception: Der Datenstrom- oder LOB-Wert kann nicht mehrmals abgerufen werden

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Fix
    • Icon: Major Major
    • integrity-plugin
    • Jenkins ver. 1.494 and ver. 1.518
      PTC Integrity Plugin 1.16 and 1.17
      Ubuntu 12.04 LTS 64Bit

      After an upgrade from working 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/XXXXX/workspace
      Change Log: http://192.168.100.211:8080/jenkins/job/XXXXX/10/changes
      Build Log: http://192.168.100.211:8080/jenkins/job/XXXXX/10/console
      Preparing to execute si projectinfo for #/repository/xxxxx
      Preparing to execute si viewproject for #/repository/xxxxx
      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/XXXXX/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/XXXXX/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/XXXXX/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/XXXXX/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/XXXXX/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/XXXXX/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/XXXXX/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/XXXXX/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/xxxxx 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] IntegritySCM - New Integrity SCM cache tables successfully created!
      Jun 13, 2013 2:51:00 PM
      SEVERE: Jun 13, 2013 2:51:00 PM [DEBUG] IntegritySCM - Integrity SCM cache tables do not exist, creating...
      Jun 13, 2013 2:51:00 PM
      SEVERE: Jun 13, 2013 2:51:00 PM [DEBUG] IntegritySCM - Das Schema 'DBUSER' ist nicht vorhanden.
      Jun 13, 2013 2:50:58 PM
      SEVERE: Jun 13, 2013 2:50:58 PM [DEBUG] IntegritySCM - Attempting to open connection to database: /build/jenkins/jobs/XXXXX/builds/2013-06-13_14-50-56/IntegritySCM
      Jun 13, 2013 2:50:58 PM
      SEVERE: Jun 13, 2013 2:50:58 PM [DEBUG] IntegritySCM - Executed si viewproject --user=Username --port=7001 --hostname=mks --recurse --project=#/repository/xxxxx --fields=name,context,cpid,memberrev,membertimestamp,memberdescription,type – with interim
      Jun 13, 2013 2:50:58 PM
      SEVERE: Jun 13, 2013 2:50:58 PM [DEBUG] IntegritySCM - Preparing to execute si viewproject for #/repository/xxxxx
      Jun 13, 2013 2:50:58 PM
      SEVERE: Jun 13, 2013 2:50:58 PM [DEBUG] IntegritySCM - si projectinfo --user=Username --port=7001 --hostname=mks --project=#/repository/xxxxx – returned 0
      Jun 13, 2013 2:50:58 PM
      SEVERE: Jun 13, 2013 2:50:58 PM [DEBUG] IntegritySCM - si projectinfo --user=Username --port=7001 --hostname=mks --project=#/repository/xxxxx – returned exit code 0
      Jun 13, 2013 2:50:58 PM
      SEVERE: Jun 13, 2013 2:50:58 PM [DEBUG] IntegritySCM - Preparing to execute si projectinfo for #/repository/xxxxx
      Jun 13, 2013 2:50:58 PM
      SEVERE: Jun 13, 2013 2:50:58 PM [DEBUG] IntegritySCM - Successfully established connection Jenkins@mks:7001
      Jun 13, 2013 2:50:58 PM
      SEVERE: Jun 13, 2013 2:50:58 PM [DEBUG] IntegritySCM - api ping --user=Username --port=7001 --hostname=mks – returned exit code 0
      Jun 13, 2013 2:50:57 PM
      SEVERE: Jun 13, 2013 2:50:57 PM [DEBUG] IntegritySCM - Creating Integrity API Session...
      Jun 13, 2013 2:50:57 PM
      SEVERE: Jun 13, 2013 2:50:57 PM [DEBUG] IntegritySCM - Start execution of checkout() routine...!
      Jun 13, 2013 2:50:56 PM
      SEVERE: Jun 13, 2013 2:50:56 PM [DEBUG] IntegritySCM - IntegritySCM.getDescriptor() invoked...!
      Jun 13, 2013 2:50:55 PM
      SEVERE: Jun 13, 2013 2:50:55 PM [DEBUG] IntegritySCM - IntegritySCM.getDescriptor() invoked...!
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - defaultPassword = xxxxxxxxxxxxxxxxxxxxxxxxxxxx
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - defaultUserName = xxxxx
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - mks.defaultUserName = xxxxx
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - defaultSecure = false
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - mks.defaultSecure = null
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - defaultIPPort = 0
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - mks.defaultIPPort = 0
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - defaultPort = 7001
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - mks.defaultPort = 7001
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - defaultIPHostName = null
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - mks.defaultIPHostName =
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - defaultHostName = mks
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - mks.defaultHostName = mks
      Jun 13, 2013 2:50:15 PM
      SEVERE: Jun 13, 2013 2:50:15 PM [DEBUG] IntegritySCM - Request to configure IntegritySCM (SCMDescriptor) invoked...

            cdsouza Cletus D'Souza
            tobiasw Tobias Weier
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: