Uploaded image for project: 'PUBLIC - Liferay Commerce'
  1. PUBLIC - Liferay Commerce
  2. COMMERCE-7039

Unknown column 'cpattachme0_.cdnEnabled' error during startup after upgrade

    Description

    Steps to Reproduce:

    1. Download the attached 7.4.0 database dump, and import to MySQL.
    2. Upgrade database to master.
    3. Start portal.

    Expected Result:
    No error during portal startup.

    Actual Result:
    Below error occurs when startup portal:

    2021-08-06 08:49:37.891 ERROR [liferay/scheduler_dispatch-5][JDBCExceptionReporter:234] Unknown column 'cpattachme0_.cdnEnabled' in 'field list'
    2021-08-06 08:49:37.896 ERROR [liferay/scheduler_dispatch-5][ParallelDestination:59] Unable to process message {destinationName=liferay/scheduler_dispatch, response=null, responseDestinationName=null, responseId=null, payload=null, values={GROUP_NAME=com.liferay.commerce.product.definitions.web.internal.messaging.CheckCPAttachmentFileEntryMessageListener, companyId=0, groupId=0, DESTINATION_NAME=liferay/scheduler_dispatch, EXCEPTIONS_MAX_SIZE=0, [email protected], STORAGE_TYPE=MEMORY_CLUSTERED, JOB_NAME=com.liferay.commerce.product.definitions.web.internal.messaging.CheckCPAttachmentFileEntryMessageListener}}
    com.liferay.portal.kernel.messaging.MessageListenerException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
    	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:41) ~[portal-kernel.jar:?]
    	at com.liferay.portal.kernel.scheduler.messaging.SchedulerEventMessageListenerWrapper._processMessage(SchedulerEventMessageListenerWrapper.java:127) ~[portal-kernel.jar:?]
    	at com.liferay.portal.kernel.scheduler.messaging.SchedulerEventMessageListenerWrapper.receive(SchedulerEventMessageListenerWrapper.java:98) ~[portal-kernel.jar:?]
    	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74) ~[portal-kernel.jar:?]
    	at com.liferay.portal.messaging.internal.ParallelDestination$1.run(ParallelDestination.java:56) [bundleFile:?]
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_162]
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_162]
    	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_162]
    Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
    	at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:634) ~[portal-kernel.jar:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2194) ~[?:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2079) ~[?:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2036) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntriesByDisplayDate(CPAttachmentFileEntryLocalServiceImpl.java:269) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntriesByDisplayDate(CPAttachmentFileEntryLocalServiceImpl.java:719) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntries(CPAttachmentFileEntryLocalServiceImpl.java:250) ~[?:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_162]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_162]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_162]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_162]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
    	at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80) ~[?:?]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
    	at com.sun.proxy.$Proxy1075.checkCPAttachmentFileEntries(Unknown Source) ~[?:?]
    	at com.liferay.commerce.product.definitions.web.internal.messaging.CheckCPAttachmentFileEntryMessageListener.doReceive(CheckCPAttachmentFileEntryMessageListener.java:78) ~[?:?]
    	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:31) ~[portal-kernel.jar:?]
    	... 7 more
    Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
    	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:39) ~[portal-impl.jar:?]
    	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:124) ~[portal-impl.jar:?]
    	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:104) ~[portal-impl.jar:?]
    	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:61) ~[portal-kernel.jar:?]
    	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:53) ~[portal-kernel.jar:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2184) ~[?:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2079) ~[?:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2036) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntriesByDisplayDate(CPAttachmentFileEntryLocalServiceImpl.java:269) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntriesByDisplayDate(CPAttachmentFileEntryLocalServiceImpl.java:719) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntries(CPAttachmentFileEntryLocalServiceImpl.java:250) ~[?:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_162]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_162]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_162]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_162]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
    	at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80) ~[?:?]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
    	at com.sun.proxy.$Proxy1075.checkCPAttachmentFileEntries(Unknown Source) ~[?:?]
    	at com.liferay.commerce.product.definitions.web.internal.messaging.CheckCPAttachmentFileEntryMessageListener.doReceive(CheckCPAttachmentFileEntryMessageListener.java:78) ~[?:?]
    	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:31) ~[portal-kernel.jar:?]
    	... 7 more
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.doList(Loader.java:2545) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.list(Loader.java:2271) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:940) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) ~[hibernate-core.jar:3.6.10.Final]
    	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:112) ~[portal-impl.jar:?]
    	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:104) ~[portal-impl.jar:?]
    	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:61) ~[portal-kernel.jar:?]
    	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:53) ~[portal-kernel.jar:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2184) ~[?:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2079) ~[?:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2036) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntriesByDisplayDate(CPAttachmentFileEntryLocalServiceImpl.java:269) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntriesByDisplayDate(CPAttachmentFileEntryLocalServiceImpl.java:719) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntries(CPAttachmentFileEntryLocalServiceImpl.java:250) ~[?:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_162]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_162]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_162]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_162]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
    	at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80) ~[?:?]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
    	at com.sun.proxy.$Proxy1075.checkCPAttachmentFileEntries(Unknown Source) ~[?:?]
    	at com.liferay.commerce.product.definitions.web.internal.messaging.CheckCPAttachmentFileEntryMessageListener.doReceive(CheckCPAttachmentFileEntryMessageListener.java:78) ~[?:?]
    	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:31) ~[portal-kernel.jar:?]
    	... 7 more
    Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'cpattachme0_.cdnEnabled' in 'field list'
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql.jar:8.0.21]
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql.jar:8.0.21]
    	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql.jar:8.0.21]
    	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql.jar:8.0.21]
    	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) ~[mysql.jar:8.0.21]
    	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[hikaricp.jar:?]
    	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[hikaricp.jar:?]
    	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.doQuery(Loader.java:802) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.doList(Loader.java:2542) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.list(Loader.java:2271) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:940) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) ~[hibernate-core.jar:3.6.10.Final]
    	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:112) ~[portal-impl.jar:?]
    	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:104) ~[portal-impl.jar:?]
    	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:61) ~[portal-kernel.jar:?]
    	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:53) ~[portal-kernel.jar:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2184) ~[?:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2079) ~[?:?]
    	at com.liferay.commerce.product.service.persistence.impl.CPAttachmentFileEntryPersistenceImpl.findByLtD_S(CPAttachmentFileEntryPersistenceImpl.java:2036) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntriesByDisplayDate(CPAttachmentFileEntryLocalServiceImpl.java:269) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntriesByDisplayDate(CPAttachmentFileEntryLocalServiceImpl.java:719) ~[?:?]
    	at com.liferay.commerce.product.service.impl.CPAttachmentFileEntryLocalServiceImpl.checkCPAttachmentFileEntries(CPAttachmentFileEntryLocalServiceImpl.java:250) ~[?:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_162]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_162]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_162]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_162]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
    	at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80) ~[?:?]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
    	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
    	at com.sun.proxy.$Proxy1075.checkCPAttachmentFileEntries(Unknown Source) ~[?:?]
    	at com.liferay.commerce.product.definitions.web.internal.messaging.CheckCPAttachmentFileEntryMessageListener.doReceive(CheckCPAttachmentFileEntryMessageListener.java:78) ~[?:?]
    	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:31) ~[portal-kernel.jar:?]
    	... 7 more
    

    And also happens when reindex after upgrade.

    2021-08-06 08:53:21.908 ERROR [default-13][JDBCExceptionReporter:234] Unknown column 'this_.cdnEnabled' in 'field list'
    2021-08-06 08:53:21.910 ERROR [default-13][BasePersistenceImpl:628] Caught unexpected exception
    org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.doList(Loader.java:2545) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.list(Loader.java:2271) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) ~[hibernate-core.jar:3.6.10.Final]
    	at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:140) ~[portal-impl.jar:?]
    	at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:126) ~[portal-impl.jar:?]
    	at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.findWithDynamicQuery(BasePersistenceImpl.java:515) [portal-kernel.jar:?]
    	at com.liferay.commerce.product.service.base.CPAttachmentFileEntryLocalServiceBaseImpl.dynamicQuery(CPAttachmentFileEntryLocalServiceBaseImpl.java:222) [bundleFile:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_162]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_162]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_162]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_162]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) [portal-impl.jar:?]
    	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) [portal-impl.jar:?]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) [portal-impl.jar:?]
    	at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80) [bundleFile:?]
    	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) [portal-impl.jar:?]
    	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) [portal-impl.jar:?]
    	at com.sun.proxy.$Proxy1075.dynamicQuery(Unknown Source) [?:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_162]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_162]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_162]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_162]
    	at com.liferay.portal.kernel.dao.orm.DefaultActionableDynamicQuery.executeDynamicQuery(DefaultActionableDynamicQuery.java:349) [portal-kernel.jar:?]
    	at com.liferay.portal.kernel.dao.orm.DefaultActionableDynamicQuery$1.call(DefaultActionableDynamicQuery.java:272) [portal-kernel.jar:?]
    	at com.liferay.portal.kernel.dao.orm.DefaultActionableDynamicQuery$1.call(DefaultActionableDynamicQuery.java:268) [portal-kernel.jar:?]
    	at com.liferay.portal.kernel.dao.orm.DefaultActionableDynamicQuery.doPerformActions(DefaultActionableDynamicQuery.java:326) [portal-kernel.jar:?]
    	at com.liferay.portal.kernel.dao.orm.IndexableActionableDynamicQuery.doPerformActions(IndexableActionableDynamicQuery.java:107) [portal-kernel.jar:?]
    	at com.liferay.portal.kernel.dao.orm.DefaultActionableDynamicQuery.performActions(DefaultActionableDynamicQuery.java:86) [portal-kernel.jar:?]
    	at com.liferay.portal.kernel.dao.orm.IndexableActionableDynamicQuery.performActions(IndexableActionableDynamicQuery.java:65) [portal-kernel.jar:?]
    	at com.liferay.commerce.product.internal.search.CPAttachmentFileEntryIndexer.reindexCPAttachmentFileEntries(CPAttachmentFileEntryIndexer.java:317) [bundleFile:?]
    	at com.liferay.commerce.product.internal.search.CPAttachmentFileEntryIndexer.doReindex(CPAttachmentFileEntryIndexer.java:286) [bundleFile:?]
    	at com.liferay.portal.kernel.search.BaseIndexer.reindex(BaseIndexer.java:517) [portal-kernel.jar:?]
    	at com.liferay.portal.search.internal.SearchEngineInitializer.reindex(SearchEngineInitializer.java:192) [bundleFile:?]
    	at com.liferay.portal.search.internal.SearchEngineInitializer$1.call(SearchEngineInitializer.java:145) [bundleFile:?]
    	at com.liferay.portal.search.internal.SearchEngineInitializer$1.call(SearchEngineInitializer.java:136) [bundleFile:?]
    	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_162]
    	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_162]
    	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_162]
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_162]
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_162]
    	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_162]
    Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'this_.cdnEnabled' in 'field list'
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql.jar:8.0.21]
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql.jar:8.0.21]
    	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql.jar:8.0.21]
    	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql.jar:8.0.21]
    	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) ~[mysql.jar:8.0.21]
    	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[hikaricp.jar:?]
    	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[hikaricp.jar:?]
    	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.doQuery(Loader.java:802) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) ~[hibernate-core.jar:3.6.10.Final]
    	at org.hibernate.loader.Loader.doList(Loader.java:2542) ~[hibernate-core.jar:3.6.10.Final]
    	... 43 more
    

      Attachments

        Issue Links

          Activity

            People

            Assignee:
            andrea.sbarra Andrea Sbarra
            Reporter:
            summer.zhang Summer Zhang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                7.4.3 CE GA4
                Master