[JIRA] [integrity-plugin] (JENKINS-14675) Schema 'DBUSER' does not exist error in integrity plugin
SCM/JIRA link daemon commented on JENKINS-14675 Schema 'DBUSER' does not exist error in integrity plugin Code changed in jenkins User: Cletus D'Souza Path: src/main/java/hudson/scm/DerbyUtils.java src/main/java/hudson/scm/IntegrityCMProject.java src/main/java/hudson/scm/IntegrityCheckpointAction.java src/main/java/hudson/scm/IntegrityDeleteNonMembersTask.java src/main/java/hudson/scm/IntegritySCM.java http://jenkins-ci.org/commit/integrity-plugin/fcdc20ec7f63153531b484b3173a2e8373b94c9d Log: Additional changes to completely isolate DB access via static synchronized functions. Relevant issues are: JENKINS-25228 - Using the integrity-plugin together with concurrent builds causes SQL Exceptions JENKINS-14675 - Schema 'DBUSER' does not exist error in integrity plugin JENKINS-25450 - Unexpected behavior of Jenkins Integrity plugin after SQL Exception inside plugin (no error returned to 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/d/optout.
[JIRA] [integrity-plugin] (JENKINS-14675) Schema 'DBUSER' does not exist error in integrity plugin
SCM/JIRA link daemon commented on JENKINS-14675 Schema 'DBUSER' does not exist error in integrity plugin Code changed in jenkins User: Cletus D'Souza Path: pom.xml src/main/java/hudson/scm/DerbyUtils.java src/main/java/hudson/scm/IntegrityCMProject.java src/main/java/hudson/scm/IntegrityRevisionState.java src/main/java/hudson/scm/IntegritySCM.java src/main/resources/hudson/scm/IntegritySCM/config.jelly src/main/resources/hudson/scm/IntegritySCM/global.jelly http://jenkins-ci.org/commit/integrity-plugin/43ad415f293ffc23861b23fa4caae3d7ef52da7c Log: Moved from single derby db for each job/build to a single db for the entire Jenkins instance. Relevant issues are: JENKINS-25228 - Using the integrity-plugin together with concurrent builds causes SQL Exceptions JENKINS-14675 - Schema 'DBUSER' does not exist error in integrity plugin JENKINS-25450 - Unexpected behavior of Jenkins Integrity plugin after SQL Exception inside plugin (no error returned to 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/d/optout.
[JIRA] [integrity-plugin] (JENKINS-14675) Schema 'DBUSER' does not exist error in integrity plugin
Cletus D'Souza resolved JENKINS-14675 as Duplicate Schema 'DBUSER' does not exist error in integrity plugin Closing this out as it is a duplicate of JENKINS-25228 Change By: Cletus D'Souza (03/Feb/15 7:48 AM) Status: Reopened Resolved Resolution: Duplicate 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/d/optout.
[JIRA] [integrity-plugin] (JENKINS-14675) Schema 'DBUSER' does not exist error in integrity plugin
Cletus D'Souza commented on JENKINS-14675 Schema 'DBUSER' does not exist error in integrity plugin Are there any new updates on a potential root cause for this error that I can chase down? 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/d/optout.
[JIRA] [integrity-plugin] (JENKINS-14675) Schema 'DBUSER' does not exist error in integrity plugin
Thorsten Liepert commented on JENKINS-14675 Schema 'DBUSER' does not exist error in integrity plugin We see the same issue here and recreating or starting with a clean workspace seems to solve the problem at first and then any time later it reappears Here an freshly generated Debug-Log: Feb 06, 2014 12:16:51 PM [DEBUG] IntegritySCM - Start execution of checkout() routine...! Feb 06, 2014 12:16:51 PM [DEBUG] IntegritySCM - buildEnvVars() invoked...! Feb 06, 2014 12:16:51 PM [DEBUG] IntegritySCM - Creating Integrity API Session... Feb 06, 2014 12:16:51 PM [DEBUG] IntegritySCM - api ping --user=jenkins --port=7001 --hostname=*** – returned exit code 0 Feb 06, 2014 12:16:51 PM [DEBUG] IntegritySCM - Successfully established connection jenkins@***:7001 Feb 06, 2014 12:16:51 PM [DEBUG] IntegritySCM - Preparing to execute si projectinfo for *** Feb 06, 2014 12:16:56 PM [DEBUG] IntegritySCM - si projectinfo --user=jenkins --port=7001 --hostname=**l --project=** – returned exit code 0 Feb 06, 2014 12:16:56 PM [DEBUG] IntegritySCM - si projectinfo --user=jenkins --port=7001 --hostname=*** --project=*** – returned 0 Feb 06, 2014 12:16:56 PM [DEBUG] IntegritySCM - Preparing to execute si viewproject for *** Feb 06, 2014 12:16:57 PM [DEBUG] IntegritySCM - Executed si viewproject --user=jenkins --port=7001 --hostname=*** --recurse --project=*** --fields=name,context,cpid,memberrev,membertimestamp,memberdescription,type – with interim Feb 06, 2014 12:16:57 PM [DEBUG] IntegritySCM - Attempting to open connection to database: /var/lib/jenkins/jobs/**/builds/2014-02-06_12-15-08/IntegritySCM/** Feb 06, 2014 12:17:00 PM [INFO] IntegritySCM - SQL Exception caught... Feb 06, 2014 12:17:00 PM [INFO] IntegritySCM - java.sql.SQLException: Failed to create database '/var/lib/jenkins/jobs/**/builds/2014-02-06_12-15-08/IntegritySCM/**', see the next exception for details. Feb 06, 2014 12:17:00 PM [DEBUG] IntegritySCM - Attempting to shut down database: /var/lib/jenkins/jobs/**/builds/2014-02-06_12-15-08/IntegritySCM/* Feb 06, 2014 12:17:00 PM [INFO] IntegritySCM - Failed to shutdown database connection! Feb 06, 2014 12:17:00 PM [INFO] IntegritySCM - SQL Error Code: 4 Feb 06, 2014 12:17:00 PM [INFO] IntegritySCM - SQL Error State: XJ004 Feb 06, 2014 12:17:00 PM [INFO] IntegritySCM - Database '/var/lib/jenkins/jobs/***/builds/2014-02-06_12-15-08/IntegritySCM/CGW' not found. Feb 06, 2014 12:17:00 PM [INFO] IntegritySCM - java.sql.SQLException: Database '/var/lib/jenkins/jobs/**/builds/2014-02-06_12-15-08/IntegritySCM/**' not found. Feb 06, 2014 12:17:00 PM org.apache.commons.httpclient.HttpMethodBase readResponseBody Warnung: Unsupported transfer encoding: Feb 06, 2014 12:17:00 PM org.apache.commons.httpclient.HttpMethodBase readResponseBody Information: Response content is not chunk-encoded Feb 06, 2014 12:17:00 PM [DEBUG] IntegritySCM - Successfully disconnected connection jenkins@:7001 Feb 06, 2014 12:17:00 PM [DEBUG] IntegritySCM - buildEnvVars() invoked...! Feb 06, 2014 12:17:00 PM [DEBUG] IntegritySCM - buildEnvVars() invoked...! 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-14675) Schema 'DBUSER' does not exist error in integrity plugin
Cletus D'Souza commented on JENKINS-14675 Schema 'DBUSER' does not exist error in integrity plugin The common theme here seems to be when migrating from an older version of the plugin to a newer version. Especially when there's been architectural changes with the way the plugin stores retrieves its cache information. While I make an attempt to prevent such changes, it can't be avoided completely. This is especially true in the past. Going forward, I don't anticipate any major changes to the plugin's architecture as it relates the the derby database. Can I get a consensus that re-creating the job and/or repeated builds (which is essentially re-creating the derby db) resolves this issue? Thanks! Cletus 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-14675) Schema 'DBUSER' does not exist error in integrity plugin
Gregory Pierre commented on JENKINS-14675 Schema 'DBUSER' does not exist error in integrity plugin I worked around the problem by rebuilding every single job twice which is cumbersome. I would be great to avoid similar problems for future upgrades. 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-14675) Schema 'DBUSER' does not exist error in integrity plugin
Gregory Pierre commented on JENKINS-14675 Schema 'DBUSER' does not exist error in integrity plugin We have the same problem on our environment. 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-14675) Schema 'DBUSER' does not exist error in integrity plugin
Cletus D'Souza resolved JENKINS-14675 as Incomplete Schema 'DBUSER' does not exist error in integrity plugin Closing due to lack of response from reporter. Change By: Cletus D'Souza (11/Jun/13 4:14 AM) Status: Open Resolved Fix Version/s: current Resolution: Incomplete 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.
