Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-26558

MS SQL Server: fix TestSQLBackendSoftDelete tests and Docker leaks

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: QualifiedToSchedule
    • Component/s: Core VCS

      Description

      The JUnit tests fail and leak connections.
      The cleanup fails and leaks Docker containers.

          org.nuxeo.ecm.core.storage.sql.TestSQLBackendSoftDelete.testProxyDeepRemoval
          org.nuxeo.ecm.core.storage.sql.TestSQLBackendSoftDelete.testProxyQueryStartsWith
          org.nuxeo.ecm.core.storage.sql.TestSQLBackendSoftDelete.testQueryAncestorId
          org.nuxeo.ecm.core.storage.sql.TestSQLBackendSoftDelete.testRecursiveRemoval
          org.nuxeo.ecm.core.storage.sql.TestSQLBackendSoftDelete.testRecursiveRemoval2
          org.nuxeo.ecm.core.storage.sql.TestSQLBackendSoftDelete.testRecursiveRemoval3
          org.nuxeo.ecm.core.storage.sql.TestSQLBackendSoftDelete.testRecursiveRemovalBig
          org.nuxeo.ecm.core.storage.sql.TestSQLBackendSoftDelete.testSoftDelete
          org.nuxeo.ecm.core.storage.sql.TestSQLBackendSoftDelete.testSoftDeleteMax
          org.nuxeo.ecm.core.storage.sql.TestSQLBackendSoftDelete.testUpdateReadAclsDeadlock
      jenkins@static03:~$ docker ps |grep mssql
      be521ea1696f        masterftnuxeomasterservertomcatmssql201710cmis_db   "/bin/sh -c /opt/mss..."   8 days ago          Up 8 days           1433/tcp               masterftnuxeomasterservertomcatmssql201710cmis_db_1
      3ebc5d607559        masterftnuxeomasterservertomcatmssql20173cmis_db    "/bin/sh -c /opt/mss..."   12 days ago         Up 12 days          1433/tcp               masterftnuxeomasterservertomcatmssql20173cmis_db_1
      2c2895bed361        masternuxeomasterfullbuildmssql201721_db            "/bin/sh -c /opt/mss..."   2 weeks ago         Up 2 weeks                                 masternuxeomasterfullbuildmssql201721_db_1
      5f7fa22a9d00        mcr.microsoft.com/mssql/server:2017-latest-ubuntu   "/opt/mssql/bin/sqls..."   2 weeks ago         Up 2 weeks          1433/tcp               masternuxeomasterfullbuildmssql201715_db_1
      
      jenkins@static01:~$ docker ps|grep mssql
      a414e35ad064        masternuxeomasterfullbuildmssql201744_db                "/bin/sh -c /opt/mss..."   22 hours ago        Up 22 hours         1433/tcp                masternuxeomasterfullbuildmssql201744_db_1
      a9829c6be375        masternuxeomasterfullbuildmssql201742_db                "/bin/sh -c /opt/mss..."   2 days ago          Up 2 days           1433/tcp                masternuxeomasterfullbuildmssql201742_db_1
      
      Successfully built 7e9263b397a3
      Successfully tagged masternuxeomasterfullbuildmssql201744_db:latest
      Creating masternuxeomasterfullbuildmssql201744_db_1 ... 
      Creating masternuxeomasterfullbuildmssql201744_db_1
      [1A[2K
      Creating masternuxeomasterfullbuildmssql201744_db_1 ... [32mdone[0m
      [1BCreating masternuxeomasterfullbuildmssql201744_tests_1 ... 
      Creating masternuxeomasterfullbuildmssql201744_tests_1
      [1A[2K
      Creating masternuxeomasterfullbuildmssql201744_tests_1 ... [32mdone[0m
      [1BAttaching to masternuxeomasterfullbuildmssql201744_db_1, masternuxeomasterfullbuildmssql201744_tests_1
      tests_1  | *** Running /etc/my_init.d/00_regen_ssh_host_keys.sh...
      tests_1  | *** Running /etc/my_init.d/10_setup_environment.sh...
      tests_1  | Slave name: 1b0d6c99688d
      tests_1  | *** Running /etc/my_init.d/10_syslog-ng.init...
      tests_1  | *** Running /etc/my_init.d/20_update_slave_jar.sh...
      tests_1  | *** Running /etc/my_init.d/30_setup_rubygems.sh...
      tests_1  | *** Running /etc/rc.local...
      tests_1  | *** Booting runit daemon...
      tests_1  | *** Runit started as PID 49
      tests_1  | *** Running su - jenkins -c mvn -B -f /opt/jenkins/workspace/master/nuxeo-master-fullbuild-mssql-2017/pom.xml install -Pqa,addons,customdb,mssql -Dmaven.test.failure.ignore=true -Dnuxeo.tests.random.mode=STRICT...
      (...)
      tests_1  | [INFO] Running org.nuxeo.ecm.core.storage.sql.coremodel.TestSQLSecurityManager
      tests_1  | [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.557 s - in org.nuxeo.ecm.core.storage.sql.coremodel.TestSQLSecurityManager
      tests_1  | [INFO] Running org.nuxeo.ecm.core.storage.sql.TestSQLBackendNoProxies
      tests_1  | 2018-12-25 12:34:33,281 [main] WARN  [ConnectionFactoryImpl] cannot dispose connection manager of test
      Sending interrupt signal to process
      Cancelling nested steps due to timeout
      After 10s process did not stop
      [Pipeline] archive
      [Pipeline] step
      Recording test results
      [Pipeline] sh
      [nuxeo-master-fullbuild-mssql-2017] Running shell script
      + docker-compose -f integration/Jenkinsfiles/docker-compose-mssql-2017.yml down --rmi local --volumes --remove-orphans
      Stopping masternuxeomasterfullbuildmssql201744_tests_1 ... 
      Stopping masternuxeomasterfullbuildmssql201744_db_1 ... 
      [2A[2K
      Stopping masternuxeomasterfullbuildmssql201744_tests_1 ... [32mdone[0m
      [2BBody did not finish within grace period; terminating with extreme prejudice
      [Pipeline] }
      [Pipeline] // withEnv
      [Pipeline] step
      (...)
      [Pipeline] }
      [Pipeline] // stage
      [Pipeline] step
      (...)
      [Pipeline] step
      [Pipeline] }
      [Pipeline] // timestamps
      [Pipeline] }
      [Pipeline] // timeout
      [Pipeline] }
      [Pipeline] // node
      [Pipeline] End of Pipeline
      Timeout has been exceeded
      Finished: ABORTED

      Similar kind of failures and leaks in https://qa.nuxeo.org/jenkins/job/master/job/FT-nuxeo-master-server-tomcat-mssql-2017/

       3769 ?        Sl     1:05  |   \_ docker-containerd-shim -namespace moby -workdir /opt/varlib/docker/containerd/daemon/io.containerd.runtime.v1.linux/moby/96f42b90c71a58d1751853c21a745731b056c310a4a74b46a
       3812 ?        Ss     0:00  |   |   \_ [sqlservr]
       4079 ?        Zl     0:31  |   |       \_ [sqlservr] <defunct>
      31631 ?        Sl     0:41  |   \_ docker-containerd-shim -namespace moby -workdir /opt/varlib/docker/containerd/daemon/io.containerd.runtime.v1.linux/moby/2d59c4c834a6cd8b5ffada8bb27ba9ea7f65aadca068f6cbb
      31656 ?        Ss     0:00  |   |   \_ [sh]
      31870 ?        Zl     0:12  |   |       \_ [sqlservr] <defunct>
      19435 ?        Sl     0:35  |   \_ docker-containerd-shim -namespace moby -workdir /opt/varlib/docker/containerd/daemon/io.containerd.runtime.v1.linux/moby/ad06bceebf7573130246f38e6fdf926936365e3e1204ea841
      19454 ?        Ss     0:00  |   |   \_ [sh]
      19706 ?        Zl     7:46  |   |       \_ [sqlservr] <defunct>
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.