Error and unable to save configuration changes for Global Database->MySQL

[letuyetvu3]

Jenkins and plugins versions report

Environment

```text Jenkins: 2.361.3.4 OS: Linux - 3.10.0-1160.76.1.el7.x86_64 Java: 11.0.17 - Oracle Corporation (Java HotSpot(TM) 64-Bit Server VM) --- Conjur:0.5 Parameterized-Remote-Trigger:3.1.5.1 accelerated-build-now-plugin:1.0.1 ace-editor:1.1 active-directory:2.26 all-changes:1.5 analysis-core:1.96 android-emulator:3.1.3 android-lint:2.6 ant:481.v7b_09e538fcca antisamy-markup-formatter:2.7 any-buildstep:0.1 apache-httpcomponents-client-4-api:4.5.13-138.v4e7d9a_7b_a_e61 artifactory:3.17.4 async-http-client:1.7.24.3 audit-trail:3.11 authentication-tokens:1.4 aws-credentials:191.vcb_f183ce58b_9 aws-device-farm:1.30 aws-java-sdk:1.12.287-357.vf82d85a_6eefd aws-java-sdk-cloudformation:1.12.287-357.vf82d85a_6eefd aws-java-sdk-codebuild:1.12.287-357.vf82d85a_6eefd aws-java-sdk-ec2:1.12.287-357.vf82d85a_6eefd aws-java-sdk-ecr:1.12.287-357.vf82d85a_6eefd aws-java-sdk-ecs:1.12.287-357.vf82d85a_6eefd aws-java-sdk-efs:1.12.287-357.vf82d85a_6eefd aws-java-sdk-elasticbeanstalk:1.12.287-357.vf82d85a_6eefd aws-java-sdk-iam:1.12.287-357.vf82d85a_6eefd aws-java-sdk-logs:1.12.287-357.vf82d85a_6eefd aws-java-sdk-minimal:1.12.287-357.vf82d85a_6eefd aws-java-sdk-sns:1.12.287-357.vf82d85a_6eefd aws-java-sdk-sqs:1.12.287-357.vf82d85a_6eefd aws-java-sdk-ssm:1.12.287-357.vf82d85a_6eefd blueocean:1.25.8 blueocean-autofavorite:1.2.5 blueocean-bitbucket-pipeline:1.25.8 blueocean-commons:1.25.8 blueocean-config:1.25.8 blueocean-core-js:1.25.8 blueocean-dashboard:1.25.8 blueocean-display-url:2.4.1 blueocean-events:1.25.8 blueocean-git-pipeline:1.25.8 blueocean-github-pipeline:1.25.8 blueocean-i18n:1.25.8 blueocean-jira:1.25.8 blueocean-jwt:1.25.8 blueocean-personalization:1.25.8 blueocean-pipeline-api-impl:1.25.8 blueocean-pipeline-editor:1.25.8 blueocean-pipeline-scm-api:1.25.8 blueocean-rest:1.25.8 blueocean-rest-impl:1.25.8 blueocean-web:1.25.8 bootstrap4-api:4.6.0-5 bootstrap5-api:5.2.1-3 bouncycastle-api:2.26 branch-api:2.1046.v0ca_37783ecc5 build-cause-run-condition:0.1 build-environment:1.7 build-monitor-plugin:1.13+build.202205140447 build-name-setter:2.2.0 build-node-column:0.1 build-pipeline-plugin:1.5.8 build-timeout:1.24 build-token-root:151.va_e52fe3215fc build-view-column:0.3 build-with-parameters:76.v9382db_f78962 built-on-column:1.3 caffeine-api:2.9.3-65.v6a_47d0f4d1fe checks-api:1.7.5 cloudbees-aborted-builds:1.19 cloudbees-administrative-monitors:1.0.6 cloudbees-analytics:1.43 cloudbees-assurance:2.276.0.23 cloudbees-aws-cli:1.5.20 cloudbees-aws-deployer:1.21 cloudbees-bitbucket-branch-source:791.vb_eea_a_476405b cloudbees-blueocean-default-theme:0.8 cloudbees-consolidated-build-view:1.6.1 cloudbees-credentials:3.3 cloudbees-cyberark-credentials:1.0.17 cloudbees-even-scheduler:3.14 cloudbees-folder:6.758.vfd75d09eea_a_1 cloudbees-folders-plus:3.29 cloudbees-groovy-view:1.14 cloudbees-jsync-archiver:5.25 cloudbees-label-throttling-plugin:3.9 cloudbees-license:9.69 cloudbees-long-running-build:1.19 cloudbees-monitoring:2.16 cloudbees-nodes-plus:1.25 cloudbees-platform-common:1.19 cloudbees-platform-data:1.30 cloudbees-plugin-usage:2.17 cloudbees-quiet-start:1.8 cloudbees-request-filter:1.7 cloudbees-ssh-slaves:2.19 cloudbees-support:3.31 cloudbees-template:4.58 cloudbees-uc-data-api:4.50 cloudbees-unified-ui:1.23 cloudbees-view-creation-filter:1.9 cloudbees-wasted-minutes-tracker:3.8 cloudbees-workflow-template:3.19 cloudbees-workflow-ui:2.9 command-launcher:90.v669d7ccb_7c31 commons-lang3-api:3.12.0-36.vd97de6465d5b_ commons-text-api:1.10.0-27.vb_fa_3896786a_7 conditional-buildstep:1.4.2 config-file-provider:3.11.1 copy-data-to-workspace-plugin:1.0 copyartifact:1.47 credentials:1189.vf61b_a_5e2f62e credentials-binding:523.vd859a_4b_122e6 cucumber-reports:5.7.4 custom-job-icon:0.2 cvs:2.19.1 dashboard-view:2.447.vda_124dd35f11 data-tables-api:1.12.1-4 database:148.v4a_ff2ca_608b_7 database-mysql:1.4 database-sqlserver:1.0 deployed-on-column:1.9 deployer-framework:88.ve78a_92f39e8e description-column-plugin:1.3 disk-usage:0.28 display-url-api:2.3.6 docker-build-publish:1.4.0 docker-commons:1.21 docker-java-api:3.0.14 docker-traceability:1.2 docker-workflow:521.v1a_a_dd2073b_2e dockerhub-notification:2.6.2.1 dtkit-api:3.0.2 durable-task:501.ve5d4fc08b0be ec2-deployment-dashboard:1.0.10 echarts-api:5.4.0-1 email-ext:2.92 email-ext-recipients-column:27.vb_9404db_b_018d emailext-template:1.5 envinject:2.881.v37c62073ff97 envinject-api:1.199.v3ce31253ed13 extended-choice-parameter:356.va_90a_94ca_62ec extensible-choice-parameter:1.8.0 external-monitor-job:203.v683c09d993b_9 extra-columns:1.25 extreme-notification:1.6 ez-templates:1.3.5 favorite:2.4.1 flexible-publish:0.16.1 font-awesome-api:6.2.0-3 ghprb:1.42.2 git:4.12.1 git-client:3.12.1 git-server:99.va_0826a_b_cdfa_d git-validated-merge:3.34 github:1.35.0 github-api:1.303-400.v35c2d8258028 github-branch-pr-change-filter:1.2.4 github-branch-source:1695.v88de84e9f6b_9 github-organization-folder:1.6 github-pull-request-build:1.15 github-pullrequest:0.4.0 gradle:1.40 groovy:453.vcdb_a_c5c99890 handlebars:3.0.8 handy-uri-templates-2-api:2.1.8-22.v77d5b_75e6953 hockeyapp:1.2.2 htmlpublisher:1.31 http-post:1.2 icon-shim:3.0.0 infradna-backup:3.38.56 instance-identity:116.vf8f487400980 instant-messaging:1.52 ionicons-api:28.va_f3a_84439e5f ivy:2.4 jackson2-api:2.13.4.20221013-295.v8e29ea_354141 jacoco:3.3.2 jakarta-activation-api:2.0.1-2 jakarta-mail-api:2.0.1-2 javadoc:226.v71211feb_e7e9 javax-activation-api:1.2.0-5 javax-mail-api:1.6.2-7 jaxb:2.3.6-2 jdk-tool:55.v1b_32b_6ca_f9ca jenkins-design-language:1.25.8 jenkins-multijob-plugin:623.v03401733c9a_9 jersey2-api:2.37-1 jira:3.8 jjwt-api:0.11.5-77.v646c772fddb_0 job-dsl:1.76 job-import-plugin:3.6 job-restrictions:0.8 jobConfigHistory:1176.v1b_4290db_41a_5 jobcopy-builder:1.4.2 jquery:1.12.4-1 jquery-detached:1.2.1 jquery3-api:3.6.1-2 jsch:0.1.55.61.va_e9ee26616e7 jsunit:1.6 junit:1143.1145.v81b_b_9579a_019 junit-sql-storage:104.vce793afab7b3 label-linked-jobs:6.0.1 ldap:2.12 lockable-resources:1069.v726298f53f8c log-parser:2.3.0 mail-watcher-plugin:1.17 mailcommander:1.0.0 mailer:438.v02c7f0a_12fa_4 mapdb-api:1.0.9-28.vf251ce40855d mask-passwords:3.3 matrix-auth:3.1.5 matrix-project:785.v06b_7f47b_c631 maven-plugin:3.19 mercurial:1260.vdfb_723cdcc81 metrics:4.2.10-389.v93143621b_050 mina-sshd-api-common:2.9.1-44.v476733c11f82 mina-sshd-api-core:2.9.1-44.v476733c11f82 mina-sshd-api-scp:2.9.1-44.v476733c11f82 mina-sshd-api-sftp:2.9.1-44.v476733c11f82 momentjs:1.1.1 monitoring:1.91.0 msbuild:1.30 multiple-scms:0.8 nectar-license:8.41 nectar-rbac:5.77 nectar-vmware:4.3.9 node-iterator-api:49.v58a_8b_35f8363 nodejs:1.5.1 nodelabelparameter:1.11.0 nowsecure-auto-security-test:1.25 okhttp-api:4.9.3-108.v0feda04578cf openid:2.4 openid4java:0.9.8.0 operations-center-agent:2.361.0.1 operations-center-analytics-config:2.89.0.2 operations-center-analytics-reporter:2.89.0.2 operations-center-client:2.361.0.1 operations-center-cloud:2.361.0.2 operations-center-context:2.361.0.3 operations-center-openid-cse:1.8.110 ownership:0.13.0 pam-auth:1.10 parameterized-scheduler:1.1 parameterized-trigger:2.45 performance:3.20 perfpublisher:8.09 periodicbackup:1.9 pipeline-build-step:2.18 pipeline-dependency-walker:1.0.0 pipeline-github-lib:38.v445716ea_edda_ pipeline-githubnotify-step:49.vf37bf92d2bc8 pipeline-graph-analysis:195.v5812d95a_a_2f9 pipeline-groovy-lib:613.v9c41a_160233f pipeline-input-step:456.vd8a_957db_5b_e9 pipeline-milestone-step:101.vd572fef9d926 pipeline-model-api:2.2118.v31fd5b_9944b_5 pipeline-model-declarative-agent:1.1.1 pipeline-model-definition:2.2118.v31fd5b_9944b_5 pipeline-model-extensions:2.2118.v31fd5b_9944b_5 pipeline-rest-api:2.24.2 pipeline-stage-step:296.v5f6908f017a_5 pipeline-stage-tags-metadata:2.2118.v31fd5b_9944b_5 pipeline-stage-view:2.24.2 pipeline-utility-steps:2.14.0 plain-credentials:139.ved2b_9cf7587b plugin-util-api:2.17.0 popper-api:1.16.1-3 popper2-api:2.11.6-2 port-allocator:1.8 postbuildscript:2.9.0 preSCMbuildstep:36.vca_61785795a_2 prereq-buildstep:1.1 promoted-builds:892.vd6219fc0a_efb publish-over:0.22 publish-over-ftp:1.17 pubsub-light:1.17 rebuild:1.34 repository-connector:2.2.0 resource-disposer:0.20 role-strategy:569.v7476f8e4fe29 run-condition:1.5 saferestart:0.7 saml:4.372.v89f13e4c9e97 schedule-build:345.vc2d8f6ef9182 scm-api:621.vda_a_b_055e58f7 scm-filter-branch-pr:0.5.1 scoring-load-balancer:1.0.1 script-security:1190.v65867a_a_47126 scriptler:3.5 simple-parameterized-builds-report:1.5 skip-plugin:4.12 slack:631.v40deea_40323b slave-setup:1.10 slave-status:1.6 snakeyaml-api:1.32-86.ve3f030a_75631 sse-gateway:1.26 ssh-agent:295.v9ca_a_1c7cc3a_a_ ssh-credentials:305.v8f4381501156 ssh-slaves:2.846.v1b_70190624f5 sshd:3.249.v2dc2ea_416e33 strict-crumb-issuer:2.1.0 structs:324.va_f5d6774f3a_d subversion:2.16.0 support-core:1206.1208.v9b_7a_1d48db_0f template-project:1.5.2 timestamper:1.20 tmpcleaner:1.3 token-macro:308.v4f2b_ed62b_b_16 translation:1.15 trilead-api:2.72.v2a_3236754f73 unique-id:2.2.1 uno-choice:2.6.4 user-activity-monitoring:1.9 variant:59.vf075fe829ccb versioncolumn:87.v8fe7c090a_d3b view-job-filters:2.3 wikitext:3.15 windows-slaves:1.8.1 workflow-aggregator:590.v6a_d052e5a_a_b_5 workflow-api:1198.v4596ea_5329b_6 workflow-basic-steps:994.vd57e3ca_46d24 workflow-cps:2803.v1a_f77ffcc773 workflow-cps-checkpoint:2.13 workflow-cps-global-lib:588.v576c103a_ff86 workflow-durable-task-step:1199.v02b_9244f8064 workflow-job:1239.v71b_b_a_124a_725 workflow-multibranch:716.vc692a_e52371b_ workflow-scm-step:400.v6b_89a_1317c9a_ workflow-step-api:639.v6eca_cd8c04a_a_ workflow-support:839.v35e2736cfd5c ws-cleanup:0.43 xcode-plugin:2.0.17-565.v1c48051d46ef xshell:122.v18d68d5fc26e xunit:3.1.2 zephyr-for-jira-test-management:1.5 ```

What Operating System are you using (both controller, and any agents involved in the problem)?

Jenkins controller: Virtualization: vmware Operating System: Red Hat Enterprise Linux Server 7.9 (Maipo) CPE OS Name: cpe:/o:redhat:enterprise_linux:7.9:GA:server Kernel: Linux 3.10.0-1160.76.1.el7.x86_64 Architecture: x86-64

MySQL server: Virtualization: vmware Operating System: Red Hat Enterprise Linux Server 7.9 (Maipo) CPE OS Name: cpe:/o:redhat:enterprise_linux:7.9:GA:server Kernel: Linux 3.10.0-1160.80.1.el7.x86_64 Architecture: x86-64

Reproduction steps

1.

2. Press Save, then we encounter Jenkins Error.

Expected Results

We expect to successfully save the configuration changes

Actual Results

But we encounter Jenkins error

Anything else?

We do the above Global database setting so we can use the MySQL database to store JUnit result there. We also did the setting for JUnit

We have contacted CloudBees to help us debugging this problem. But they said since both the "Database" plugin and the "MySQL database" driver plugin are 3rd party community plugins, they couldn't help further and suggest me to contact the maintainers.

[timja]

What's in the error log?

[letuyetvu3]

Where should I get the error log for this on Jenkins? I only see the Oops message.

By the way, I also want to correct the info of the earlier upload screen shot of the Validation Query. That query syntax was incorrect. It should be select * from SAMPLE; With the correct syntax of the query, we still couldn't save the configuration.

[letuyetvu3]

I found the log system-log.txt

[timja]

The log is pointing at https://github.com/jenkinsci/zephyr-for-jira-test-management-plugin can you try disable that plugin and save it again?

[letuyetvu3]

OK. Jenkins is restarting now after disabled plugin to take effect. Will let you know soon

[letuyetvu3]

Thanks so much. I was able to save it when disabled the zephry-for-jira plugin.

I am going to ask you to help with another issue. In my currently query that I saved successfully, I put "useSSL=false" in the Additional Properties box. Without that property, the plugin by default does useSSL so when I do "Test Connection", it gives error

UsingSSL-error.txt

[timja]

Good to hear you got it working