Details
-
Bug
-
Status: Closed
-
Resolution: No Longer Reproducible
-
Master
-
5
-
- LocalFile.DocumentsandmediaUpgrade#ViewDMArchive73101
- LocalFile.MultiFactorAuthenticationUpgrade#ViewMFAConfigurationInInstanceLevelAfterUpgrade7310
- LocalFile.MultiFactorAuthenticationUpgrade#ViewMFAConfigurationInSystemLevelAfterUpgrade7310
- LocalFile.PageEditorUpgrade#ConfigureContainerStylesAfterUpgrade73101
- LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive7310
- LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchiveAutoUpgrade7310
- LocalFile.SAMLUpgrade#ViewSAMLConfigurationAfterUpgrade7310
- LocalFile.SAMLUpgrade#ViewSAMLWithEncryptionConfigurationAfterUpgrade7310
- LocalFile.SiteUpgrade#ViewCustomSiteSettingAfterUpgrade73101
- LocalFile.StagingUpgrade#PublishArticleCreatedByDeletedUserAfterUpgrade621021
- LocalFile.StagingUpgrade#ViewStagingDefaultSettingAfterUpgrade621021
- LocalFile.StagingUpgrade#ViewStagingDefaultSettingAfterUpgrade73101
- LocalFile.WebContentUpgrade#AddWCWithFirstComplexStructure
- LocalFile.WebContentUpgrade#AddWCWithSecondComplexStructure
- LocalFile.WebContentUpgrade#ViewAndEditWebContentWCStructureWCTemplateWCDAndAssetPublisher7310
- LocalFile.WebContentUpgrade#ViewWebContentWithNoDisplayPageTemplateArchive73101
- LocalFile.WebContentUpgrade#ViewWebContentWithPredefinedValueInWebContentFieldArchive73101
-
76
Description
Steps to Reproduce:
- Import the attached 7310 database of DB2 11.1.
- Upgrade database to master by executing upgrade client tool.
Expected Results:
Upgrade completes successfully without error.
Actual Results:
Upgrade Failed with below error:
ERROR [main][UpgradeStepRegistratorTracker:144] Failed upgrade process for module com.liferay.commerce.account.service
[parallel] com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;able COMMERCEACCOUNT;IMMEDIATE, DRIVER=4.24.92
[parallel] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:109)
[parallel] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:127)
[parallel] at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor$UpgradeInfosRunnable.run(UpgradeExecutor.java:199)
[parallel] at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:134)
[parallel] at com.liferay.portal.upgrade.internal.executor.SwappedLogExecutor.execute(SwappedLogExecutor.java:51)
[parallel] at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.executeUpgradeInfos(UpgradeExecutor.java:154)
[parallel] at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.execute(UpgradeExecutor.java:117)
[parallel] at com.liferay.portal.upgrade.internal.registry.UpgradeStepRegistratorTracker$UpgradeStepRegistratorServiceTrackerCustomizer.addingService(UpgradeStepRegistratorTracker.java:137)
[parallel] at com.liferay.portal.upgrade.internal.registry.UpgradeStepRegistratorTracker$UpgradeStepRegistratorServiceTrackerCustomizer.addingService(UpgradeStepRegistratorTracker.java:86)
[parallel] at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:943)
[parallel] at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:1)
[parallel] at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
[parallel] at org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
[parallel] at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:321)
[parallel] at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:264)
[parallel] at com.liferay.osgi.util.ServiceTrackerFactory.open(ServiceTrackerFactory.java:104)
[parallel] at com.liferay.portal.upgrade.internal.registry.UpgradeStepRegistratorTracker.activate(UpgradeStepRegistratorTracker.java:61)
[parallel] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[parallel] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[parallel] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[parallel] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[parallel] at org.apache.felix.scr.impl.inject.methods.BaseMethod.invokeMethod(BaseMethod.java:228)
[parallel] at org.apache.felix.scr.impl.inject.methods.BaseMethod.access$500(BaseMethod.java:41)
[parallel] at org.apache.felix.scr.impl.inject.methods.BaseMethod$Resolved.invoke(BaseMethod.java:664)
[parallel] at org.apache.felix.scr.impl.inject.methods.BaseMethod.invoke(BaseMethod.java:510)
[parallel] at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:310)
[parallel] at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:300)
[parallel] at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:341)
[parallel] at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:114)
[parallel] at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:983)
[parallel] at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:956)
[parallel] at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:765)
[parallel] at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1053)
[parallel] at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1007)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1216)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1137)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.trackAdding(ServiceTracker.java:944)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.track(ServiceTracker.java:880)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1168)
[parallel] at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:125)
[parallel] at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:891)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:804)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:228)
[parallel] at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:469)
[parallel] at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:906)
[parallel] at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:892)
[parallel] at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:128)
[parallel] at org.apache.felix.scr.impl.manager.AbstractComponentManager.registerService(AbstractComponentManager.java:959)
[parallel] at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:732)
[parallel] at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1053)
[parallel] at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1007)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1216)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1137)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.trackAdding(ServiceTracker.java:944)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.track(ServiceTracker.java:880)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1168)
[parallel] at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:125)
[parallel] at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:891)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:804)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:228)
[parallel] at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:469)
[parallel] at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:906)
[parallel] at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:892)
[parallel] at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:128)
[parallel] at org.apache.felix.scr.impl.manager.AbstractComponentManager.registerService(AbstractComponentManager.java:959)
[parallel] at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:732)
[parallel] at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1053)
[parallel] at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1007)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1216)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1137)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.trackAdding(ServiceTracker.java:944)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.track(ServiceTracker.java:880)
[parallel] at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1168)
[parallel] at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:125)
[parallel] at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:891)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:804)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127)
[parallel] at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:228)
[parallel] at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:469)
[parallel] at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:487)
[parallel] at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:1004)
[parallel] at com.liferay.registry.internal.RegistryImpl.registerService(RegistryImpl.java:342)
[parallel] at com.liferay.portal.tools.DBUpgrader._registerModuleServiceLifecycle(DBUpgrader.java:233)
[parallel] at com.liferay.portal.tools.DBUpgrader._upgradeModules(DBUpgrader.java:294)
[parallel] at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:157)
[parallel] at com.liferay.portal.spring.context.PortalContextLoaderListener.contextInitialized(PortalContextLoaderListener.java:364)
[parallel] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)
[parallel] at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5177)
[parallel] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
[parallel] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717)
[parallel] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690)
[parallel] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:706)
[parallel] at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:631)
[parallel] at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1830)
[parallel] at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
[parallel] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
[parallel] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
[parallel] at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118)
[parallel] at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:526)
[parallel] at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:425)
[parallel] at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576)
[parallel] at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309)
[parallel] at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
[parallel] at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423)
[parallel] at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366)
[parallel] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936)
[parallel] at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:843)
[parallel] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
[parallel] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
[parallel] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
[parallel] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
[parallel] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
[parallel] at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
[parallel] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
[parallel] at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
[parallel] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
[parallel] at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
[parallel] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
[parallel] at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930)
[parallel] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
[parallel] at org.apache.catalina.startup.Catalina.start(Catalina.java:772)
[parallel] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[parallel] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[parallel] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[parallel] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[parallel] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:342)
[parallel] at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473)
[parallel] Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;able COMMERCEACCOUNT;IMMEDIATE, DRIVER=4.24.92
[parallel] at com.ibm.db2.jcc.am.b6.a(b6.java:810)
[parallel] at com.ibm.db2.jcc.am.b6.a(b6.java:66)
[parallel] at com.ibm.db2.jcc.am.b6.a(b6.java:140)
[parallel] at com.ibm.db2.jcc.am.k3.c(k3.java:2817)
[parallel] at com.ibm.db2.jcc.am.k3.d(k3.java:2801)
[parallel] at com.ibm.db2.jcc.am.k3.b(k3.java:2161)
[parallel] at com.ibm.db2.jcc.t4.ab.k(ab.java:445)
[parallel] at com.ibm.db2.jcc.t4.ab.c(ab.java:104)
[parallel] at com.ibm.db2.jcc.t4.p.b(p.java:38)
[parallel] at com.ibm.db2.jcc.t4.av.h(av.java:124)
[parallel] at com.ibm.db2.jcc.am.k3.ak(k3.java:2156)
[parallel] at com.ibm.db2.jcc.am.k3.a(k3.java:3359)
[parallel] at com.ibm.db2.jcc.am.k3.c(k3.java:783)
[parallel] at com.ibm.db2.jcc.am.k3.executeUpdate(k3.java:762)
[parallel] at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:117)
[parallel] at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
[parallel] at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:337)
[parallel] at com.liferay.portal.dao.db.DB2DB.runSQL(DB2DB.java:102)
[parallel] at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:303)
[parallel] at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:71)
[parallel] at com.liferay.commerce.account.internal.upgrade.v3_0_0.CommerceAccountUpgradeProcess.doUpgrade(CommerceAccountUpgradeProcess.java:109)
[parallel] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:104)
[parallel] ... 131 more
Attachments
Issue Links
- Discovered while testing
-
LPS-134771 Staging - Upstream Analysis - Week of 06/28/21
-
- Closed
-
-
LPS-135110 Staging - Upstream Analysis - Week of 7/5/21
-
- Closed
-
-
LPS-135444 Staging - Upstream Analysis - Week of 7/12/21
-
- Closed
-
-
LPS-135832 Staging - Upstream Analysis - Week of 7/19/21
-
- Closed
-
- relates
-
LPS-125701 Bridge CommerceAccount service to AccountEntry service
-
- Closed
-