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

Missing upgrade warning message when attempting to directly upgrade from portal 6.0

    Details

    • Branch Version/s:
      7.2.x
    • Backported to Branch:
      Committed
    • Fix Priority:
      2

      Description

      Steps to reproduce:

      1. Populate database with the attached data (Portal EE 6.0.12)
      2. Run upgrade tool

      Expected result:
      Message given to user:

      You must first upgrade to Liferay Portal 6200
      

      Actual result:

      2019-11-27 00:42:41.930 ERROR [main][JDBCExceptionReporter:234] Unknown column 'releaseimp0_.state_' in 'field list'2019-11-27 00:42:41.930 ERROR [main][JDBCExceptionReporter:234] Unknown column 'releaseimp0_.state_' in 'field list'com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.liferay.portal.model.impl.ReleaseImpl#1] at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:446) at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.fetchByPrimaryKey(BasePersistenceImpl.java:171) at com.liferay.portal.service.persistence.impl.ReleasePersistenceImpl.findByPrimaryKey(ReleasePersistenceImpl.java:679) at com.liferay.portal.service.persistence.impl.ReleasePersistenceImpl.findByPrimaryKey(ReleasePersistenceImpl.java:704) at com.liferay.portal.service.base.ReleaseLocalServiceBaseImpl.getRelease(ReleaseLocalServiceBaseImpl.java:222) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) at com.sun.proxy.$Proxy270.getRelease(Unknown Source) at com.liferay.portal.kernel.service.ReleaseLocalServiceUtil.getRelease(ReleaseLocalServiceUtil.java:267) at com.liferay.portal.tools.DBUpgrader.checkRequiredBuildNumber(DBUpgrader.java:69) at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:154) at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:109) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.liferay.portal.model.impl.ReleaseImpl#1] at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:39) at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:194) at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.fetchByPrimaryKey(BasePersistenceImpl.java:156) ... 21 moreCaused by: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.liferay.portal.model.impl.ReleaseImpl#1] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.loadEntity(Loader.java:2041) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:269) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998) at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:191) ... 22 moreCaused by: java.sql.SQLSyntaxErrorException: Unknown column 'releaseimp0_.state_' in 'field list' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955) at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1005) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.loadEntity(Loader.java:2037) ... 34 more 

      Reproducible on:
      6.0.12 > Master: 6db75964492e75ae4b717b17526dfaf3b73c26bb

      Not reproducible on:
      6.1.30 > Master: 6db75964492e75ae4b717b17526dfaf3b73c26bb
      6.0.12 > 7.2.x: 7908416e01514fda66350c463747deb62b3c3995

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              koor.gai Koor Gai
              Reporter:
              koor.gai Koor Gai
              Participants of an Issue:
              Recent user:
              Jason Pince
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                22 weeks, 2 days ago

                  Packages

                  Version Package
                  7.2.10 DXP FP8
                  7.2.10.2 DXP SP3
                  7.2.X
                  7.3.4 CE GA5
                  7.3.5 CE GA6
                  7.3.10 DXP GA1
                  Master