Details

    • Type: Regression Bug
    • Status: Closed
    • Resolution: Won't Fix
    • Affects Version/s: Master
    • Fix Version/s: None
    • Labels:
      None
    • Fix Priority:
      4

      Description

      Steps to reproduce:

      1. Startup liferay 6.2.x
      2. Create a structure with a date field (probably this specific data type isn't important to reproduce the issue).
      3. Create templates assigned to this structure.
      4. Create some journal articles using this structure and templates.
      5. Try to upgrade to latest master (Liferay 79 , using instructions: https://dev.liferay.com/discover/deployment/-/knowledge_base/7-0/upgrading-to-liferay-7). I used this command line:
        java -jar com.liferay.portal.tools.db.upgrade.client.jar -jvm-opts "-Dfile.encoding=UTF8 -Duser.country=US -Duser.language=en -Duser.timezone=EST -Xmx2048m -agentlib:jdwp=transport=dt_socket,address=8000,server=y,suspend=y"
        

      Expected behavior: upgrade completes succesfully
      Actual behavior: upgrade doesn't complete due to some DDM upgrade fail:

      10:16:58,206 INFO  [main][ServiceComponentLocalServiceImpl:317] Running Sync SQL scripts
      10:16:58,349 INFO  [main][UpgradeProcess:82] Upgrading com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping
      INFO - Upgrading com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping
      10:16:58,350 INFO  [main][LoggingTimer:70] Starting com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#setUpClassNameIds
      INFO - Starting com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#setUpClassNameIds
      10:16:58,353 INFO  [main][LoggingTimer:38] Completed com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#setUpClassNameIds in 3 ms
      INFO - Completed com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#setUpClassNameIds in 3 ms
      10:16:58,354 INFO  [main][LoggingTimer:70] Starting com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#upgradeExpandoStorageAdapter
      INFO - Starting com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#upgradeExpandoStorageAdapter
      10:16:58,355 INFO  [main][LoggingTimer:38] Completed com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#upgradeExpandoStorageAdapter in 1 ms
      INFO - Completed com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#upgradeExpandoStorageAdapter in 1 ms
      10:16:58,357 INFO  [main][LoggingTimer:70] Starting com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#upgradeStructuresAndAddStructureVersionsAndLayouts
      INFO - Starting com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#upgradeStructuresAndAddStructureVersionsAndLayouts
      10:17:27,219 INFO  [elasticsearch[Exterminator][management][T#1]][decider:160] [Exterminator] low disk watermark [85%] exceeded on [2BP-tozaTxO4af1uAL1dSA][Exterminator][/opt/liferay-portal-tomcat-master/data/elasticsearch/indices/LiferayElasticsearchCluster/nodes/0] free: 15.1gb[10.9%], replicas will not be assigned to this node
      10:17:57,222 INFO  [elasticsearch[Exterminator][management][T#3]][decider:160] [Exterminator] low disk watermark [85%] exceeded on [2BP-tozaTxO4af1uAL1dSA][Exterminator][/opt/liferay-portal-tomcat-master/data/elasticsearch/indices/LiferayElasticsearchCluster/nodes/0] free: 15.1gb[10.9%], replicas will not be assigned to this node
      10:18:20,021 INFO  [main][LoggingTimer:38] Completed com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#upgradeStructuresAndAddStructureVersionsAndLayouts in 81664 ms
      INFO - Completed com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping#upgradeStructuresAndAddStructureVersionsAndLayouts in 81664 ms
      10:18:20,022 INFO  [main][UpgradeProcess:97] Completed upgrade process com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping in 81673ms
      INFO - Completed upgrade process com.liferay.dynamic.data.mapping.upgrade.v1_0_0.UpgradeDynamicDataMapping in 81673ms
      10:18:20,025 ERROR [main][com_liferay_portal_upgrade:97] Invocation to listener threw exception 
      java.lang.RuntimeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Incorrect string value: '\xE9\x94\x80\xE5\x94\xAE...' for column 'name' at row 1
      	at com.liferay.portal.upgrade.internal.release.ReleaseManager$UpgradeInfosRunnable.run(ReleaseManager.java:402)
      	at com.liferay.portal.output.stream.container.OutputStreamContainerFactoryTracker.runWithSwappedLog(OutputStreamContainerFactoryTracker.java:100)
      	at com.liferay.portal.upgrade.internal.release.ReleaseManager.executeUpgradeInfos(ReleaseManager.java:241)
      	at com.liferay.portal.upgrade.internal.release.ReleaseManager.doExecute(ReleaseManager.java:225)
      	at com.liferay.portal.upgrade.internal.release.ReleaseManager$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManager.java:352)
      	at com.liferay.portal.upgrade.internal.release.ReleaseManager$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManager.java:342)
      	at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$DefaultEmitter.emit(ServiceTrackerMapImpl.java:225)
      	at com.liferay.osgi.service.tracker.collections.map.PropertyServiceReferenceMapper.map(PropertyServiceReferenceMapper.java:43)
      	at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$ServiceReferenceServiceTrackerCustomizer.addingService(ServiceTrackerMapImpl.java:264)
      	at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$ServiceReferenceServiceTrackerCustomizer.addingService(ServiceTrackerMapImpl.java:251)
      	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
      	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:1)
      	at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
      	at org.osgi.util.tracker.AbstractTracked.track(AbstractTracked.java:229)
      	at org.osgi.util.tracker.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:901)
      	at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:917)
      	at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
      	at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:482)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:1001)
      	at com.liferay.portal.upgrade.registry.UpgradeStepRegistratorTracker._register(UpgradeStepRegistratorTracker.java:154)
      	at com.liferay.portal.upgrade.registry.UpgradeStepRegistratorTracker.register(UpgradeStepRegistratorTracker.java:58)
      	at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension._processInitialUpgrade(ModuleApplicationContextExtender.java:256)
      	at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension.start(ModuleApplicationContextExtender.java:225)
      	at org.apache.felix.utils.extender.AbstractExtender.createExtension(AbstractExtender.java:259)
      	at org.apache.felix.utils.extender.AbstractExtender.modifiedBundle(AbstractExtender.java:232)
      	at org.apache.felix.utils.extender.AbstractExtender.addingBundle(AbstractExtender.java:192)
      	at org.osgi.util.tracker.BundleTracker$Tracked.customizerAdding(BundleTracker.java:469)
      	at org.osgi.util.tracker.BundleTracker$Tracked.customizerAdding(BundleTracker.java:1)
      	at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
      	at org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
      	at org.osgi.util.tracker.BundleTracker.open(BundleTracker.java:156)
      	at org.apache.felix.utils.extender.AbstractExtender.startTracking(AbstractExtender.java:150)
      	at org.apache.felix.utils.extender.AbstractExtender.doStart(AbstractExtender.java:142)
      	at org.apache.felix.utils.extender.AbstractExtender.start(AbstractExtender.java:114)
      	at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender.activate(ModuleApplicationContextExtender.java:75)
      	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:497)
      	at org.apache.felix.scr.impl.helper.BaseMethod.invokeMethod(BaseMethod.java:222)
      	at org.apache.felix.scr.impl.helper.BaseMethod.access$500(BaseMethod.java:37)
      	at org.apache.felix.scr.impl.helper.BaseMethod$Resolved.invoke(BaseMethod.java:615)
      	at org.apache.felix.scr.impl.helper.BaseMethod.invoke(BaseMethod.java:499)
      	at org.apache.felix.scr.impl.helper.ActivateMethod.invoke(ActivateMethod.java:295)
      	at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:302)
      	at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:113)
      	at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:866)
      	at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:833)
      	at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:724)
      	at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:954)
      	at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:915)
      	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1215)
      	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1136)
      	at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.trackAdding(ServiceTracker.java:945)
      	at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.track(ServiceTracker.java:881)
      	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1167)
      	at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:120)
      	at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:917)
      	at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
      	at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:482)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:1001)
      	at com.liferay.registry.internal.RegistryImpl.registerService(RegistryImpl.java:301)
      	at com.liferay.portal.tools.DBUpgrader._registerModuleServiceLifecycle(DBUpgrader.java:414)
      	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:110)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Incorrect string value: '\xE9\x94\x80\xE5\x94\xAE...' for column 'name' at row 1
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:91)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:122)
      	at com.liferay.portal.upgrade.internal.release.ReleaseManager$UpgradeInfosRunnable.run(ReleaseManager.java:381)
      	... 77 more
      Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xE9\x94\x80\xE5\x94\xAE...' for column 'name' at row 1
      	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)
      	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
      	at com.liferay.portal.kernel.dao.jdbc.AutoBatchPreparedStatementUtil$ConcurrentBatchInvocationHandler$1.call(AutoBatchPreparedStatementUtil.java:218)
      	at com.liferay.portal.kernel.dao.jdbc.AutoBatchPreparedStatementUtil$ConcurrentBatchInvocationHandler$1.call(AutoBatchPreparedStatementUtil.java:213)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:756)
      	at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:667)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: java.sql.SQLException: Incorrect string value: '\xE9\x94\x80\xE5\x94\xAE...' for column 'name' at row 1
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
      	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
      	... 7 more
      

        Attachments

          Activity

            People

            • Assignee:
              juan.gonzalez Juan Gonzalez (Inactive)
              Reporter:
              juan.gonzalez Juan Gonzalez (Inactive)
              Participants of an Issue:
              Recent user:
              Esther Sanz
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 19 weeks, 4 days ago

                Packages

                Version Package