Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-91601

No current transaction executor when executing upgrade on SQL Server

    Details

    • Fix Priority:
      4

      Description

      Steps to Reproduce:

      1. Import the linked database dump (lportal.bak) into SQL Server 2017
      2. Disable Indexing
      3. Execute upgrade tool

      Expected Result:
      No errors on upgrade

      Actual Result:

      ERROR [ForkJoinPool-1-worker-7][BasePersistenceImpl:437] Caught unexpected exception
      java.lang.IllegalStateException: No current transaction executor
      at com.liferay.portal.dao.orm.hibernate.VerifySessionFactoryWrapper._verify(VerifySessionFactoryWrapper.java:131)
      at com.liferay.portal.dao.orm.hibernate.VerifySessionFactoryWrapper.openSession(VerifySessionFactoryWrapper.java:98)
      at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.openSession(BasePersistenceImpl.java:431)
      at com.liferay.portal.service.persistence.impl.GroupPersistenceImpl.findByG_C_C_P(GroupPersistenceImpl.java:9568)
      at com.liferay.portal.service.persistence.impl.GroupPersistenceImpl.findByG_C_C_P(GroupPersistenceImpl.java:9477)
      at com.liferay.portal.service.impl.GroupLocalServiceImpl$1.findTreeModels(GroupLocalServiceImpl.java:2598)
      at com.liferay.portal.kernel.tree.TreePathUtil$RecursiveRebuildTreeTask.compute(TreePathUtil.java:132)
      at java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:189)
      at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
      at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
      at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)
      at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)
      

      Note: No functional impact observed

      Steps used to generate the database dump:

      1. Using 7.0.1 SP10
      2. Using SQL Server 2017
        • Create database
      3. Create database using https://github.com/yasuflatland-lf/liferay-dummy-factory/tree/7.0.x
      4. Portal-ext properties:
        • jdbc.default.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
        • jdbc.default.url=jdbc:sqlserver://localhost;databaseName=lportal
        • jdbc.default.username=sa
        • jdbc.default.password=<password>
      5. Downloading mssql jdbc jar file latest (used 7.2)
        • Place jar file ${liferay_home}/tomcat/lib/ext
      6. Go to Control Panel > Apps > Dummy Factory
        • Organizations created 750
        • Sites created 500
        • Pages created 600
        • (Before creating users go to Control Panel > Configuration > Server Administration > Log Levels > Add Category, add com.liferay.support.tools and set to INFO) Users created 1000
        • Web Content created 500
        • Documents created 600
        • Message Boards created 550
        • Category/Vocabulary created 700
        • Blogs created 800
        • Wiki created 850

      How to setup SQL Server 2017 using Docker:

      1. Download driver from https://www.microsoft.com/en-us/download/details.aspx?id=57782
      2. Add to the bundle
      3. docker run --name <container-name> -e ACCEPT_EULA=Y -e SA_PASSWORD=liferay123 -e MSSQL_PID=Developer -p 1433:1433 -d mcr.microsoft.com/mssql/server:2017-latest-ubuntu
      4. docker copy lportal.bak <container-name>:/
      5. docker exec -it <container-name> bash
      6. /opt/mssql-tools//bin/sqlcmd -S localhost -U sa -P liferay123
      7. restore database lportal from disk='/lportal.bak'
      8. Portal-ext:
        jdbc.default.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
        jdbc.default.url=jdbc:sqlserver://0.0.0.0;databaseName=lportal
        jdbc.default.username=sa
        jdbc.default.password=liferay123
        

       

      Reproduced on:
      7.0.10 SP10 > Master-private
      Commit: ae556a3047d963040004456b0c58d2eb6d15381d
      Base Branch Commit: 957fd902d224ff7175944441f4f8a7274f00d6f3

      Not Reproducible on:
      MySQL 5.7 + Similar data volume
      SQL Server 2017 + No portal data

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                support-lep@liferay.com SE Support
                Reporter:
                joshua.itagaki Joshua Itagaki
                Participants of an Issue:
                Recent user:
                Victor Ware
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Days since last comment:
                  36 weeks, 4 days ago

                  Packages

                  Version Package