-
Bug
-
Resolution: Cannot Reproduce
-
Major
-
Windows 7 64 bit, MKS Integrity Client 2009 (Build: 4.10.0.9049), Jenkins 1.476, integrity-plugin 1.14
Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin:
Started by an SCM change
Building in workspace d:\Jenkins\jobs\xxx\workspace
Change Log: http://xxxjenkinsxxx/job/xxx/38/changes
Build Log: http://xxxjenkinsxxx/job/xxx/38/console
Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL
Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL
A SQL Exception was caught!
Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details.
Archiving artifacts
Skipping Cobertura coverage report as build was not UNSTABLE or better ...
Recording test results
Finished: FAILURE
Here the requested debug output:
Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Start execution of checkout() routine...!
Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Creating Integrity API Session...
Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - api ping --user=xxx --port=xxx --hostname=xxx – returned exit code 0
Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Successfully established connection xxx@xxx:xxx
Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxxxx
Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - si projectinfo --user=xxx --port=xxx --hostname=xxx --project=#p=d:/mks/archives/src/xxx.pj#d=xxx – returned exit code 0Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - si projectinfo --user=xxx --port=xxx --hostname=xxx --project=#p=d:/mks/archives/src/xxx.pj#d=xxxxxx – returned 0
Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxxxx
Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Executed si viewproject --user=xxx --port=7001 --hostname=xxx --recurse --project=#p=d:/mks/archives/src/xxx.pj#d=xxxxxx --fi
elds=name,context,cpid,memberrev,membertimestamp,memberdescription – with interim
Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Attempting to open connection to database: d:\Jenkins\jobs\xxx\builds\2012-08-13_15-56-09\IntegritySCM
Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - SQL Exception caught...
Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - java.sql.SQLException: Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-13_15-56-09/IntegritySCM', see the next exception for
details.
Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Attempting to shut down database: d:\Jenkins\jobs\xxx\builds\2012-08-13_15-56-09\IntegritySCM
Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - Failed to shutdown database connection!
Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - Database 'd:/Jenkins/jobs/xxx/builds/2012-08-13_15-56-09/IntegritySCM' not found.
Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - java.sql.SQLException: Database 'd:/Jenkins/jobs/xxx/builds/2012-08-13_15-56-09/IntegritySCM' not found.
?[33mAug 13, 2012 3:56:10 PM org.apache.commons.httpclient.HttpMethodBase readResponseBody
WARNING: Unsupported transfer encoding:
?[0mAug 13, 2012 3:56:10 PM org.apache.commons.httpclient.HttpMethodBase readResponseBody
INFO: Response content is not chunk-encoded
Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Successfully disconnected connection xxx@xxx:7001
[JENKINS-14703] PTC Integrity Plugin throws/catches SQL Exception in Combination with Locale Plugin
| Description |
Original:
Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin: {{Started by an SCM change Building in workspace d:\Jenkins\jobs\CT_ZT6BAL\workspace Change Log: http://frl1dtwg.auto.contiwan.com/job/CT_ZT6BAL/38/changes Build Log: http://frl1dtwg.auto.contiwan.com/job/CT_ZT6BAL/38/console Preparing to execute si projectinfo for #p=d:/mks/archives/src/CT_ZT6.pj#d=ZT6BAL Preparing to execute si viewproject for #p=d:/mks/archives/src/CT_ZT6.pj#d=ZT6BAL {color:red}A SQL Exception was caught!{color} Failed to create database 'd:/Jenkins/jobs/CT_ZT6BAL/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details. Archiving artifacts Skipping Cobertura coverage report as build was not UNSTABLE or better ... Recording test results Finished: FAILURE}} |
New:
Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin: {{monospaced}} Started by an SCM change Building in workspace d:\Jenkins\jobs\xxx\workspace Change Log: http://xxxjenkinsxxx/job/xxx/38/changes Build Log: http://xxxjenkinsxxx/job/xxx/38/console Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL {color:red}A SQL Exception was caught!{color} Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details. Archiving artifacts Skipping Cobertura coverage report as build was not UNSTABLE or better ... Recording test results Finished: FAILURE {{monospaced}} |
| Description |
Original:
Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin: {{monospaced}} Started by an SCM change Building in workspace d:\Jenkins\jobs\xxx\workspace Change Log: http://xxxjenkinsxxx/job/xxx/38/changes Build Log: http://xxxjenkinsxxx/job/xxx/38/console Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL {color:red}A SQL Exception was caught!{color} Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details. Archiving artifacts Skipping Cobertura coverage report as build was not UNSTABLE or better ... Recording test results Finished: FAILURE {{monospaced}} |
New:
Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin: {{Started by an SCM change}} {{Building in workspace d:\Jenkins\jobs\xxx\workspace}} {{Change Log: http://xxxjenkinsxxx/job/xxx/38/changes}} {{Build Log: http://xxxjenkinsxxx/job/xxx/38/console}} {{Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL}} {{Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL}} {{{color:red}A SQL Exception was caught!{color}}} {{Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details.}} {{Archiving artifacts}} {{Skipping Cobertura coverage report as build was not UNSTABLE or better ...}} {{Recording test results}} {{Finished: FAILURE}} |
| Description |
Original:
Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin: {{Started by an SCM change}} {{Building in workspace d:\Jenkins\jobs\xxx\workspace}} {{Change Log: http://xxxjenkinsxxx/job/xxx/38/changes}} {{Build Log: http://xxxjenkinsxxx/job/xxx/38/console}} {{Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL}} {{Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL}} {{{color:red}A SQL Exception was caught!{color}}} {{Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details.}} {{Archiving artifacts}} {{Skipping Cobertura coverage report as build was not UNSTABLE or better ...}} {{Recording test results}} {{Finished: FAILURE}} |
New:
Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin: {{Started by an SCM change}} {{Building in workspace d:\Jenkins\jobs\xxx\workspace }} {{Change Log: http://xxxjenkinsxxx/job/xxx/38/changes }} {{Build Log: http://xxxjenkinsxxx/job/xxx/38/console }} {{Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL}} {{Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL}} {{{color:red}A SQL Exception was caught!{color}}} {{Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details.}} {{Archiving artifacts}} {{Skipping Cobertura coverage report as build was not UNSTABLE or better ...}} {{Recording test results}} {{Finished: FAILURE}} |
| Description |
Original:
Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin: {{Started by an SCM change}} {{Building in workspace d:\Jenkins\jobs\xxx\workspace }} {{Change Log: http://xxxjenkinsxxx/job/xxx/38/changes }} {{Build Log: http://xxxjenkinsxxx/job/xxx/38/console }} {{Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL}} {{Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL}} {{{color:red}A SQL Exception was caught!{color}}} {{Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details.}} {{Archiving artifacts}} {{Skipping Cobertura coverage report as build was not UNSTABLE or better ...}} {{Recording test results}} {{Finished: FAILURE}} |
New:
Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin: {quote} Started by an SCM change Building in workspace d:\Jenkins\jobs\xxx\workspace Change Log: http://xxxjenkinsxxx/job/xxx/38/changes Build Log: http://xxxjenkinsxxx/job/xxx/38/console Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL {color:red}A SQL Exception was caught!{color} Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details. Archiving artifacts Skipping Cobertura coverage report as build was not UNSTABLE or better ... Recording test results Finished: FAILURE {quote} |
| Description |
Original:
Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin: {quote} Started by an SCM change Building in workspace d:\Jenkins\jobs\xxx\workspace Change Log: http://xxxjenkinsxxx/job/xxx/38/changes Build Log: http://xxxjenkinsxxx/job/xxx/38/console Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL {color:red}A SQL Exception was caught!{color} Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details. Archiving artifacts Skipping Cobertura coverage report as build was not UNSTABLE or better ... Recording test results Finished: FAILURE {quote} |
New:
Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin: {quote} Started by an SCM change Building in workspace d:\Jenkins\jobs\xxx\workspace Change Log: http://xxxjenkinsxxx/job/xxx/38/changes Build Log: http://xxxjenkinsxxx/job/xxx/38/console Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL {color:red}A SQL Exception was caught!{color} Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details. Archiving artifacts Skipping Cobertura coverage report as build was not UNSTABLE or better ... Recording test results Finished: FAILURE {quote} Here the requested debug output: {quote} Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Start execution of checkout() routine...! Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Creating Integrity API Session... Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - api ping --user=xxx --port=xxx --hostname=xxx -- returned exit code 0 Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Successfully established connection xxx@xxx:xxx Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxxxx Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - si projectinfo --user=xxx --port=xxx --hostname=xxx --project=#p=d:/mks/archives/src/xxx.pj#d=xxx -- returned exit code 0 Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - si projectinfo --user=xxx --port=xxx --hostname=xxx --project=#p=d:/mks/archives/src/xxx.pj#d=xxxxxx -- returned 0 Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxxxx Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Executed si viewproject --user=xxx --port=7001 --hostname=xxx --recurse --project=#p=d:/mks/archives/src/xxx.pj#d=xxxxxx --fi elds=name,context,cpid,memberrev,membertimestamp,memberdescription -- with interim Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Attempting to open connection to database: d:\Jenkins\jobs\xxx\builds\2012-08-13_15-56-09\IntegritySCM Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - SQL Exception caught... Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - java.sql.SQLException: Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-13_15-56-09/IntegritySCM', see the next exception for details. Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Attempting to shut down database: d:\Jenkins\jobs\xxx\builds\2012-08-13_15-56-09\IntegritySCM Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - Failed to shutdown database connection! Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - Database 'd:/Jenkins/jobs/xxx/builds/2012-08-13_15-56-09/IntegritySCM' not found. Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - java.sql.SQLException: Database 'd:/Jenkins/jobs/xxx/builds/2012-08-13_15-56-09/IntegritySCM' not found. ?[33mAug 13, 2012 3:56:10 PM org.apache.commons.httpclient.HttpMethodBase readResponseBody WARNING: Unsupported transfer encoding: ?[0mAug 13, 2012 3:56:10 PM org.apache.commons.httpclient.HttpMethodBase readResponseBody INFO: Response content is not chunk-encoded Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Successfully disconnected connection xxx@xxx:7001 {quote} |
First: Thanks for your fast responses!
Second: I updated the description with Integrity debug output. It is copied from command line as Jenkins is not creating log files anymore. Don't know why, maybe because I start it manually as a logged in user (I had some problems with Windows service in the past). Can someone tell me how to create the log files? Piping in the command line? Thanks, Karsten
Thorsten Liepert
added a comment - This Issue reapears on Jenkins 1.549 and PTC Plugin 1.22. After Rolling back to 1.20 erverything works fine again.
Thorsten Liepert
added a comment - This Issue reapears on Jenkins 1.549 and PTC Plugin 1.22. After Rolling back to 1.20 erverything works fine again. Also occurs with Jenkins ver. 1.546 and integrity-plugin 1.22, downgrading to integrity-plugin 1.20 or integrity-plugin 1.16 doesn't help.
If I remove the "Default Language" setting from the Locale plugin (leave field empty) and remove the checkmark from "Ignore browser preference and force this language to all users", then the SQL Exception disappears (the mere presence of the Locale plugin as an installed plugin apparently isn't harmful, it seems that the observed behavior is connected to the field "Default Language" in the Locale plugin).
Please submit the stacktrace from jenkins.err.log. Also turn up debug logging (see wiki for details) and provide more information to better diagnose the problem.