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

Sharding upgrade is broken after LPS-77654

    Details

      Description

      Reproduction steps:
      0) Have a 6.2 installed with portal-136-6210
      1) Configure it to use sharding:

      a) Create two database: sharda, shardb
      b) Configure portal-ext to use sharding:

      # MySQL
      jdbc.default.url=jdbc\:mysql\://localhost/sharda
      jdbc.default.driverClassName=com.mysql.jdbc.Driver
      jdbc.default.username=root
      jdbc.default.password=liferay
      
      
      jdbc.one.url=jdbc\:mysql\://localhost/shardb
      jdbc.one.driverClassName=com.mysql.jdbc.Driver
      jdbc.one.username=root
      jdbc.one.password=liferay
      
      shard.selector=com.liferay.portal.dao.shard.ManualShardSelector
      
      spring.configs=\
          META-INF/base-spring.xml,\
          \
          META-INF/hibernate-spring.xml,\
          META-INF/infrastructure-spring.xml,\
          META-INF/management-spring.xml,\
          \
          META-INF/util-spring.xml,\
          \
          META-INF/jpa-spring.xml,\
          \
          META-INF/executor-spring.xml,\
          \
          META-INF/audit-spring.xml,\
          META-INF/cluster-spring.xml,\
          META-INF/editor-spring.xml,\
          META-INF/jcr-spring.xml,\
          META-INF/ldap-spring.xml,\
          META-INF/messaging-core-spring.xml,\
          META-INF/messaging-misc-spring.xml,\
          META-INF/mobile-device-spring.xml,\
          META-INF/notifications-spring.xml,\
          META-INF/poller-spring.xml,\
          META-INF/rules-spring.xml,\
          META-INF/scheduler-spring.xml,\
          META-INF/scripting-spring.xml,\
          META-INF/search-spring.xml,\
          META-INF/workflow-spring.xml,\
          \
          META-INF/counter-spring.xml,\
          META-INF/mail-spring.xml,\
          META-INF/portal-spring.xml,\
          META-INF/portlet-container-spring.xml,\
          META-INF/staging-spring.xml,\
          META-INF/virtual-layouts-spring.xml,\
          \
          #META-INF/dynamic-data-source-spring.xml,\
          META-INF/shard-data-source-spring.xml,\
          #META-INF/memcached-spring.xml,\
          #META-INF/monitoring-spring.xml,\
          \
          classpath*:META-INF/ext-spring.xml
      

      3) Start 6.2
      4) Go to Control Panel -> System Admin -> Instances
      5) Create a new instance to the "one" database
      6) Shut down

      7) Have a DXP with latest fixpack (right now it's de-50)
      8) Configure upgrade tool to upgrade the default shard, please read:
      https://customer.liferay.com/documentation/7.0/deploy/-/official_documentation/deployment/upgrading-sharded-environment

      Result so far:
      sharda database is upgraded.
      By default shardb uses the sharda classname table, now during the sharda upgrade, sharda's classname table is copied to shard b.
      The first problem here, that the Upgraded classname table is copied.
      https://github.com/liferay/liferay-portal-ee/blob/7.0.x/portal-impl/src/com/liferay/portal/upgrade/UpgradeProcess_7_0_0.java#L71
      upgrade(UpgradeKernelPackage.class); upgrades the classnames
      upgrade(UpgradeSharding.class); copies the classnames to the shards

      So for example in 6.2 the value related to Company looks like: com.liferay.portal.model.Company
      In 7.0, it's: com.liferay.portal.kernel.model.Company
      It's going to cause a problem,
      Fix suggestion: the 6.2 values should be copied, not the 7.0

      9) Configure upgrade tool to upgrade the other shard, please read:
      https://customer.liferay.com/documentation/7.0/deploy/-/official_documentation/deployment/upgrading-sharded-environment

      Result:

      2018-06-27 10:19:03.155 ERROR [main][DBUpgrader:114] Unable to execute verify process: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.GroupFriendlyURLException
      com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.GroupFriendlyURLException
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:75)
              at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
              at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
              at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
              at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:182)
              at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:87)
              at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:249)
              at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:102)
              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.verify.VerifyException: com.liferay.portal.kernel.exception.GroupFriendlyURLException
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:75)
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
              at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:33)
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
              ... 12 more
      Caused by: com.liferay.portal.kernel.exception.GroupFriendlyURLException
              at com.liferay.portal.service.impl.GroupLocalServiceImpl.validateFriendlyURL(GroupLocalServiceImpl.java:4759)
              at com.liferay.portal.service.impl.GroupLocalServiceImpl.addGroup(GroupLocalServiceImpl.java:347)
              at com.liferay.portal.service.impl.GroupLocalServiceImpl.addGroup(GroupLocalServiceImpl.java:435)
              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.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
              at com.sun.proxy.$Proxy79.addGroup(Unknown Source)
              at com.liferay.portal.service.impl.GroupLocalServiceImpl.checkCompanyGroup(GroupLocalServiceImpl.java:650)
              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.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
              at com.sun.proxy.$Proxy79.checkCompanyGroup(Unknown Source)
              at com.liferay.portal.kernel.service.GroupLocalServiceUtil.checkCompanyGroup(GroupLocalServiceUtil.java:209)
              at com.liferay.portal.verify.VerifyGroup.verifyCompanyGroups(VerifyGroup.java:101)
              at com.liferay.portal.verify.VerifyGroup.doVerify(VerifyGroup.java:68)
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
              ... 15 more
      com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.GroupFriendlyURLException
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:75)
              at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
              at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
              at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
              at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:182)
              at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:87)
              at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:249)
              at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:102)
              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.verify.VerifyException: com.liferay.portal.kernel.exception.GroupFriendlyURLException
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:75)
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
              at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:33)
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
              ... 12 more
      Caused by: com.liferay.portal.kernel.exception.GroupFriendlyURLException
              at com.liferay.portal.service.impl.GroupLocalServiceImpl.validateFriendlyURL(GroupLocalServiceImpl.java:4759)
              at com.liferay.portal.service.impl.GroupLocalServiceImpl.addGroup(GroupLocalServiceImpl.java:347)
              at com.liferay.portal.service.impl.GroupLocalServiceImpl.addGroup(GroupLocalServiceImpl.java:435)
              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.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
              at com.sun.proxy.$Proxy79.addGroup(Unknown Source)
              at com.liferay.portal.service.impl.GroupLocalServiceImpl.checkCompanyGroup(GroupLocalServiceImpl.java:650)
              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.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
              at com.sun.proxy.$Proxy79.checkCompanyGroup(Unknown Source)
              at com.liferay.portal.kernel.service.GroupLocalServiceUtil.checkCompanyGroup(GroupLocalServiceUtil.java:209)
              at com.liferay.portal.verify.VerifyGroup.verifyCompanyGroups(VerifyGroup.java:101)
              at com.liferay.portal.verify.VerifyGroup.doVerify(VerifyGroup.java:68)
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
              ... 15 more
      

      Analyses result:
      As the 7.0 values are copied to the 6.2 shardb table:
      When the upgrade goes to here: https://github.com/liferay/liferay-portal-ee/blob/7.0.x/portal-impl/src/com/liferay/portal/upgrade/v7_0_0/UpgradeKernelPackage.java#L41
      The getClassNames() will gives back these classnames:
      https://github.com/liferay/liferay-portal-ee/blob/7.0.x/portal-impl/src/com/liferay/portal/upgrade/v7_0_0/UpgradeKernelPackage.java#L265
      These classnames are the 7.0 classnames.
      As the preventDuplicates is true (since this fix: https://github.com/liferay/liferay-portal-ee/commit/59ce77c6936c509032c69f233c38d0ef9fc19007#diff-e3d234a2193691413e17e092a5e98f89R45 , fix suggestion2: if we change the value to false, then the issue won't come)
      the _executeDelete method will delete the classnames.
      Later the classnames will be generated with new classnameids and it causes a lot of problem as the related content's classnameids' are not updated.

      In our case (the above exception): This line checks if there is any groups with Company's classnameid, as it has new classnameid it won't find any then it wants to add a new group (global group):
      https://github.com/liferay/liferay-portal-ee/blob/7.0.x/portal-impl/src/com/liferay/portal/service/impl/GroupLocalServiceImpl.java#L644
      But it will fail with the friendlyurl validation: https://github.com/liferay/liferay-portal-ee/blob/7.0.x/portal-impl/src/com/liferay/portal/service/impl/GroupLocalServiceImpl.java#L4756
      As here we check if there is a group in the company with friendlurl /global, and it exists and fails.

      Suggestion:
      Customer suggested to change the order of these calls in https://github.com/liferay/liferay-portal-ee/blob/7.0.x/portal-impl/src/com/liferay/portal/upgrade/UpgradeProcess_7_0_0.java#L71

      From:
      upgrade(UpgradeKernelPackage.class);
      upgrade(UpgradeSharding.class);
      To:
      upgrade(UpgradeSharding.class);
      upgrade(UpgradeKernelPackage.class);

      I tried it and it solved the issue, however a new issue came. I'm not sure if it's caused by this change or a completely new issue, please advise:

      2018-06-28 12:25:59.999 ERROR [main][com_liferay_portal_upgrade_impl:97] Invocation to listener threw exception
      java.lang.RuntimeException: com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.calendar.service_2.7.15 [144] has invalid content in tables.sql:_create table Calendar (_    uuid_ VARCHAR(75) null,_   calendarId LONG not null primary key,_  groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_        resourceBlockId LONG,_     calendarResourceId LONG,_       name STRING null,_      description STRING null,_       timeZoneId VARCHAR(75) null,_   color INTEGER,_ defaultCalendar BOOLEAN,_       enableComments BOOLEAN,_        enableRatings BOOLEAN,_    lastPublishDate DATE null_);__create table CalendarBooking (_   uuid_ VARCHAR(75) null,_        calendarBookingId LONG not null primary key,_   groupId LONG,_  companyId LONG,_        userId LONG,_      userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_    resourceBlockId LONG,_      calendarId LONG,_       calendarResourceId LONG,_       parentCalendarBookingId LONG,_     vEventUid VARCHAR(255) null,_   title STRING null,_     description TEXT null,_ location STRING null,_  startTime LONG,_        endTime LONG,_  allDay BOOLEAN,_        recurrence STRING null,_        firstReminder LONG,_       firstReminderType VARCHAR(75) null,_    secondReminder LONG,_   secondReminderType VARCHAR(75) null,_   lastPublishDate DATE null,_     status INTEGER,_        statusByUserId LONG,_   statusByUserName VARCHAR(75) null,_        statusDate DATE null_);__create table CalendarNotificationTemplate (_   uuid_ VARCHAR(75) null,_        calendarNotificationTemplateId LONG not null primary key,_      groupId LONG,_     companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_        calendarId LONG,_       notificationType VARCHAR(75) null,_     notificationTypeSettings VARCHAR(75) null,_        notificationTemplateType VARCHAR(75) null,_     subject VARCHAR(75) null,_      body TEXT null,_        lastPublishDate DATE null_);__create table CalendarResource (_     uuid_ VARCHAR(75) null,_        calendarResourceId LONG not null primary key,_  groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_   resourceBlockId LONG,_  classNameId LONG,_      classPK LONG,_  classUuid VARCHAR(75) null,_    code_ VARCHAR(75) null,_        name STRING null,_      description STRING null,_       active_ BOOLEAN,_  lastPublishDate DATE null_); [Sanitized]
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfosRunnable.run(ReleaseManagerOSGiCommands.java:564)
              at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:106)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.executeUpgradeInfos(ReleaseManagerOSGiCommands.java:337)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.doExecute(ReleaseManagerOSGiCommands.java:280)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:505)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:495)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$DefaultEmitter.emit(ServiceTrackerMapImpl.java:222)
              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:261)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$ServiceReferenceServiceTrackerCustomizer.addingService(ServiceTrackerMapImpl.java:248)
              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.trackInitial(AbstractTracked.java:183)
              at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
              at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl.open(ServiceTrackerMapImpl.java:94)
              at com.liferay.osgi.service.tracker.collections.map.ServiceTrackerMapFactory.openMultiValueMap(ServiceTrackerMapFactory.java:244)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.activate(ReleaseManagerOSGiCommands.java:240)
              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 org.apache.felix.scr.impl.inject.BaseMethod.invokeMethod(BaseMethod.java:224)
              at org.apache.felix.scr.impl.inject.BaseMethod.access$500(BaseMethod.java:39)
              at org.apache.felix.scr.impl.inject.BaseMethod$Resolved.invoke(BaseMethod.java:617)
              at org.apache.felix.scr.impl.inject.BaseMethod.invoke(BaseMethod.java:501)
              at org.apache.felix.scr.impl.inject.ActivateMethod.invoke(ActivateMethod.java:302)
              at org.apache.felix.scr.impl.inject.ActivateMethod.invoke(ActivateMethod.java:294)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:297)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:108)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:906)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:879)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:748)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1012)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:968)
              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:127)
              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.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:886)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:873)
              at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:132)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.registerService(AbstractComponentManager.java:940)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:740)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1012)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:968)
              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:127)
              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:355)
              at com.liferay.portal.tools.DBUpgrader._registerModuleServiceLifecycle(DBUpgrader.java:412)
              at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:108)
              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.upgrade.UpgradeException: Bundle com.liferay.calendar.service_2.7.15 [144] has invalid content in tables.sql:_create table Calendar (_     uuid_ VARCHAR(75) null,_        calendarId LONG not null primary key,_     groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_        resourceBlockId LONG,_  calendarResourceId LONG,_  name STRING null,_      description STRING null,_       timeZoneId VARCHAR(75) null,_   color INTEGER,_ defaultCalendar BOOLEAN,_       enableComments BOOLEAN,_        enableRatings BOOLEAN,_    lastPublishDate DATE null_);__create table CalendarBooking (_   uuid_ VARCHAR(75) null,_    calendarBookingId LONG not null primary key,_       groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_        createDate DATE null,_  modifiedDate DATE null,_        resourceBlockId LONG,_  calendarId LONG,_       calendarResourceId LONG,_       parentCalendarBookingId LONG,_  vEventUid VARCHAR(255) null,_      title STRING null,_     description TEXT null,_ location STRING null,_  startTime LONG,_        endTime LONG,_  allDay BOOLEAN,_        recurrence STRING null,_        firstReminder LONG,_       firstReminderType VARCHAR(75) null,_    secondReminder LONG,_   secondReminderType VARCHAR(75) null,_   lastPublishDate DATE null,_     status INTEGER,_        statusByUserId LONG,_   statusByUserName VARCHAR(75) null,_        statusDate DATE null_);__create table CalendarNotificationTemplate (_   uuid_ VARCHAR(75) null,_        calendarNotificationTemplateId LONG not null primary key,_      groupId LONG,_  companyId LONG,_   userId LONG,_   userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_        calendarId LONG,_       notificationType VARCHAR(75) null,_     notificationTypeSettings VARCHAR(75) null,_        notificationTemplateType VARCHAR(75) null,_     subject VARCHAR(75) null,_  body TEXT null,_    lastPublishDate DATE null_);__create table CalendarResource (_  uuid_ VARCHAR(75) null,_
      calendarResourceId LONG not null primary key,_  groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_        resourceBlockId LONG,_     classNameId LONG,_      classPK LONG,_  classUuid VARCHAR(75) null,_    code_ VARCHAR(75) null,_        name STRING null,_      description STRING null,_       active_ BOOLEAN,_       lastPublishDate DATE null_); [Sanitized]
              at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension$1.upgrade(ModuleApplicationContextExtender.java:321)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfosRunnable.run(ReleaseManagerOSGiCommands.java:539)
              ... 82 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'calendar' already exists
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
              at com.mysql.jdbc.Util.getInstance(Util.java:386)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
              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:2788)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1816)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1730)
              at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
              at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:294)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
              at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:449)
              at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:506)
              at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension$1.upgrade(ModuleApplicationContextExtender.java:317)
              ... 83 more
      2018-06-28 12:26:00.040 ERROR [main][com_liferay_portal_upgrade_impl:97] Invocation to listener threw exception
      java.lang.RuntimeException: com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.portal.workflow.kaleo.forms.service_1.1.22 [195] has invalid content in tables.sql:_create table KaleoProcess (_        uuid_ VARCHAR(75) null,_        kaleoProcessId LONG not null primary key,_      groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_   DDLRecordSetId LONG,_   DDMTemplateId LONG,_    workflowDefinitionName VARCHAR(75) null,_       workflowDefinitionVersion INTEGER_);__create table KaleoProcessLink (_  kaleoProcessLinkId LONG not null primary key,_     kaleoProcessId LONG,_   workflowTaskName VARCHAR(75) null,_     DDMTemplateId LONG_); [Sanitized]
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfosRunnable.run(ReleaseManagerOSGiCommands.java:564)
              at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:106)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.executeUpgradeInfos(ReleaseManagerOSGiCommands.java:337)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.doExecute(ReleaseManagerOSGiCommands.java:280)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:505)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:495)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$DefaultEmitter.emit(ServiceTrackerMapImpl.java:222)
              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:261)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$ServiceReferenceServiceTrackerCustomizer.addingService(ServiceTrackerMapImpl.java:248)
              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.trackInitial(AbstractTracked.java:183)
              at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
              at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl.open(ServiceTrackerMapImpl.java:94)
              at com.liferay.osgi.service.tracker.collections.map.ServiceTrackerMapFactory.openMultiValueMap(ServiceTrackerMapFactory.java:244)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.activate(ReleaseManagerOSGiCommands.java:240)
              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 org.apache.felix.scr.impl.inject.BaseMethod.invokeMethod(BaseMethod.java:224)
              at org.apache.felix.scr.impl.inject.BaseMethod.access$500(BaseMethod.java:39)
              at org.apache.felix.scr.impl.inject.BaseMethod$Resolved.invoke(BaseMethod.java:617)
              at org.apache.felix.scr.impl.inject.BaseMethod.invoke(BaseMethod.java:501)
              at org.apache.felix.scr.impl.inject.ActivateMethod.invoke(ActivateMethod.java:302)
              at org.apache.felix.scr.impl.inject.ActivateMethod.invoke(ActivateMethod.java:294)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:297)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:108)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:906)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:879)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:748)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1012)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:968)
              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:127)
              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.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:886)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:873)
              at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:132)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.registerService(AbstractComponentManager.java:940)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:740)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1012)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:968)
              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:127)
              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:355)
              at com.liferay.portal.tools.DBUpgrader._registerModuleServiceLifecycle(DBUpgrader.java:412)
              at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:108)
              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.upgrade.UpgradeException: Bundle com.liferay.portal.workflow.kaleo.forms.service_1.1.22 [195] has invalid content in tables.sql:_create table KaleoProcess (_      uuid_ VARCHAR(75) null,_   kaleoProcessId LONG not null primary key,_      groupId LONG,_  companyId LONG,_    userId LONG,_       userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_        DDLRecordSetId LONG,_      DDMTemplateId LONG,_    workflowDefinitionName VARCHAR(75) null,_       workflowDefinitionVersion INTEGER_);__create table KaleoProcessLink (_  kaleoProcessLinkId LONG not null primary key,_     kaleoProcessId LONG,_   workflowTaskName VARCHAR(75) null,_     DDMTemplateId LONG_); [Sanitized]
              at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension$1.upgrade(ModuleApplicationContextExtender.java:321)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfosRunnable.run(ReleaseManagerOSGiCommands.java:539)
              ... 82 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kaleoprocess' already exists
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
              at com.mysql.jdbc.Util.getInstance(Util.java:386)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
              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:2788)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1816)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1730)
              at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
              at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:294)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
              at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:449)
              at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:506)
              at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension$1.upgrade(ModuleApplicationContextExtender.java:317)
              ... 83 more
      2018-06-28 12:26:00.097 ERROR [main][com_liferay_portal_upgrade_impl:97] Invocation to listener threw exception
      java.lang.RuntimeException: com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.portal.workflow.kaleo.service_2.0.46 [201] has invalid content in tables.sql:_create table KaleoAction (_    kaleoActionId LONG not null primary key,_  groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoClassName VARCHAR(200) null,_ kaleoClassPK LONG,_     kaleoDefinitionId LONG,_        kaleoNodeName VARCHAR(200) null,_   name VARCHAR(200) null,_    description STRING null,_       executionType VARCHAR(20) null,_        script TEXT null,_ scriptLanguage VARCHAR(75) null,_       scriptRequiredContexts STRING null,_    priority INTEGER_);__create table KaleoCondition (_     kaleoConditionId LONG not null primary key,_    groupId LONG,_  companyId LONG,_   userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoDefinitionId LONG,_        kaleoNodeId LONG,_      script TEXT null,_      scriptLanguage VARCHAR(75) null,_  scriptRequiredContexts STRING null_);__create table KaleoDefinition (_  kaleoDefinitionId LONG not null primary key,_   groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_       createDate DATE null,_  modifiedDate DATE null,_        name VARCHAR(200) null,_        title STRING null,_     description STRING null,_       content TEXT null,_     version INTEGER,_
      active_ BOOLEAN,_       startKaleoNodeId LONG_);__create table KaleoInstance (_ kaleoInstanceId LONG not null primary key,_     groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_       createDate DATE null,_  modifiedDate DATE null,_        kaleoDefinitionId LONG,_        kaleoDefinitionName VARCHAR(200) null,_ kaleoDefinitionVersion INTEGER,_        rootKaleoInstanceTokenId LONG,_ className VARCHAR(200) null,_      classPK LONG,_  completed BOOLEAN,_     completionDate DATE null,_  workflowContext TEXT null_);__create table KaleoInstanceToken (_    kaleoInstanceTokenId LONG not null primary key,_   groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoDefinitionId LONG,_        kaleoInstanceId LONG,_  parentKaleoInstanceTokenId LONG,_  currentKaleoNodeId LONG,_       currentKaleoNodeName VARCHAR(200) null,_        className VARCHAR(200) null,_   classPK LONG,_  completed BOOLEAN,_     completionDate DATE null_);__create table KaleoLog (_      kaleoLogId LONG not null primary key,_  groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_
      kaleoClassName VARCHAR(200) null,_      kaleoClassPK LONG,_     kaleoDefinitionId LONG,_        kaleoInstanceId LONG,_  kaleoInstanceTokenId LONG,_     kaleoTaskInstanceTokenId LONG,_ kaleoNodeName VARCHAR(200) null,_  terminalKaleoNode BOOLEAN,_     kaleoActionId LONG,_    kaleoActionName VARCHAR(200) null,_ kaleoActionDescription STRING null,_        previousKaleoNodeId LONG,_      previousKaleoNodeName VARCHAR(200) null,_  previousAssigneeClassName VARCHAR(200) null,_   previousAssigneeClassPK LONG,_  currentAssigneeClassName VARCHAR(200) null,_    currentAssigneeClassPK LONG,_   type_ VARCHAR(50) null,_        comment_ TEXT null,_       startDate DATE null,_   endDate DATE null,_     duration LONG,_ workflowContext TEXT null_);__create table KaleoNode (_ kaleoNodeId LONG not null primary key,_ groupId LONG,_  companyId LONG,_
      userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_    kaleoDefinitionId LONG,_    name VARCHAR(200) null,_        metadata STRING null,_  description STRING null,_
      type_ VARCHAR(20) null,_        initial_ BOOLEAN,_      terminal BOOLEAN_);__create table KaleoNotification (_  kaleoNotificationId LONG not null primary key,_ groupId LONG,_  companyId LONG,_        userId LONG,_      userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoClassName VARCHAR(200) null,_      kaleoClassPK LONG,_     kaleoDefinitionId LONG,_        kaleoNodeName VARCHAR(200) null,_  name VARCHAR(200) null,_        description STRING null,_       executionType VARCHAR(20) null,_        template TEXT null,_    templateLanguage VARCHAR(75) null,_     notificationTypes VARCHAR(25) null_);__create table KaleoNotificationRecipient (_  kaleoNotificationRecipientId LONG not null primary key,_        groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_     modifiedDate DATE null,_        kaleoDefinitionId LONG,_        kaleoNotificationId LONG,_      recipientClassName VARCHAR(200) null,_  recipientClassPK LONG,_ recipientRoleType INTEGER,_        recipientScript TEXT null,_     recipientScriptLanguage VARCHAR(75) null,_      recipientScriptContexts STRING null,_   address VARCHAR(255) null,_     notificationReceptionType VARCHAR(3) null_);__create table KaleoTask (_    kaleoTaskId LONG not null primary key,_ groupId LONG,_  companyId LONG,_    userId LONG,_       userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoDefinitionId LONG,_   kaleoNodeId LONG,_      name VARCHAR(200) null,_        description STRING null_);__create table KaleoTaskAssignment (_ kaleoTaskAssignmentId LONG not null primary key,_       groupId LONG,_     companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoClassName VARCHAR(200) null,_      kaleoClassPK LONG,_     kaleoDefinitionId LONG,_   kaleoNodeId LONG,_      assigneeClassName VARCHAR(200) null,_   assigneeClassPK LONG,_  assigneeActionId VARCHAR(75) null,_     assigneeScript TEXT null,_      assigneeScriptLanguage VARCHAR(75) null,_  assigneeScriptRequiredContexts STRING null_);__create table KaleoTaskAssignmentInstance (_  kaleoTaskAssignmentInstanceId LONG not null primary key,_   groupId LONG,_  companyId LONG,_        userId LONG,_      userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoDefinitionId LONG,_        kaleoInstanceId LONG,_  kaleoInstanceTokenId LONG,_     kaleoTaskInstanceTokenId LONG,_    kaleoTaskId LONG,_      kaleoTaskName VARCHAR(200) null,_       assigneeClassName VARCHAR(200) null,_   assigneeClassPK LONG,_  completed BOOLEAN,_     completionDate DATE null_);__create table KaleoTaskInstanceToken (_        kaleoTaskInstanceTokenId LONG not null primary key,_    groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_   kaleoDefinitionId LONG,_        kaleoInstanceId LONG,_  kaleoInstanceTokenId LONG,_     kaleoTaskId LONG,_      kaleoTaskName VARCHAR(200) null,_       className VARCHAR(200) null,_   classPK LONG,_  completionUserId LONG,_    completed BOOLEAN,_     completionDate DATE null,_      dueDate DATE null,_ workflowContext TEXT null_);__create table KaleoTimer (_    kaleoTimerId LONG not null primary key,_        groupId LONG,_     companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoClassName VARCHAR(200) null,_      kaleoClassPK LONG,_     kaleoDefinitionId LONG,_   name VARCHAR(75) null,_ blocking BOOLEAN,_      description STRING null,_   duration DOUBLE,_   scale VARCHAR(75) null,_        recurrenceDuration DOUBLE,_     recurrenceScale VARCHAR(75) null_);__create table KaleoTimerInstanceToken (_       kaleoTimerInstanceTokenId LONG not null primary key,_   groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_     modifiedDate DATE null,_        kaleoClassName VARCHAR(200) null,_      kaleoClassPK LONG,_     kaleoDefinitionId LONG,_        kaleoInstanceId LONG,_  kaleoInstanceTokenId LONG,_     kaleoTaskInstanceTokenId LONG,_    kaleoTimerId LONG,_     kaleoTimerName VARCHAR(200) null,_      blocking BOOLEAN,_      completionUserId LONG,_ completed BOOLEAN,_     completionDate DATE null,_      workflowContext TEXT null_);__create table KaleoTransition (_      kaleoTransitionId LONG not null primary key,_   groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_   kaleoDefinitionId LONG,_        kaleoNodeId LONG,_      name VARCHAR(200) null,_        description STRING null,_       sourceKaleoNodeId LONG,_        sourceKaleoNodeName VARCHAR(200) null,_    targetKaleoNodeId LONG,_        targetKaleoNodeName VARCHAR(200) null,_ defaultTransition BOOLEAN_); [Sanitized]
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfosRunnable.run(ReleaseManagerOSGiCommands.java:564)
              at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:106)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.executeUpgradeInfos(ReleaseManagerOSGiCommands.java:337)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.doExecute(ReleaseManagerOSGiCommands.java:280)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:505)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:495)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$DefaultEmitter.emit(ServiceTrackerMapImpl.java:222)
              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:261)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$ServiceReferenceServiceTrackerCustomizer.addingService(ServiceTrackerMapImpl.java:248)
              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.trackInitial(AbstractTracked.java:183)
              at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
              at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl.open(ServiceTrackerMapImpl.java:94)
              at com.liferay.osgi.service.tracker.collections.map.ServiceTrackerMapFactory.openMultiValueMap(ServiceTrackerMapFactory.java:244)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.activate(ReleaseManagerOSGiCommands.java:240)
              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 org.apache.felix.scr.impl.inject.BaseMethod.invokeMethod(BaseMethod.java:224)
              at org.apache.felix.scr.impl.inject.BaseMethod.access$500(BaseMethod.java:39)
              at org.apache.felix.scr.impl.inject.BaseMethod$Resolved.invoke(BaseMethod.java:617)
              at org.apache.felix.scr.impl.inject.BaseMethod.invoke(BaseMethod.java:501)
              at org.apache.felix.scr.impl.inject.ActivateMethod.invoke(ActivateMethod.java:302)
              at org.apache.felix.scr.impl.inject.ActivateMethod.invoke(ActivateMethod.java:294)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:297)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:108)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:906)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:879)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:748)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1012)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:968)
              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:127)
              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.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:886)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:873)
              at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:132)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.registerService(AbstractComponentManager.java:940)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:740)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1012)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:968)
              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:127)
              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:355)
              at com.liferay.portal.tools.DBUpgrader._registerModuleServiceLifecycle(DBUpgrader.java:412)
              at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:108)
              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.upgrade.UpgradeException: Bundle com.liferay.portal.workflow.kaleo.service_2.0.46 [201] has invalid content in tables.sql:_create table KaleoAction (_     kaleoActionId LONG not null primary key,_  groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoClassName VARCHAR(200) null,_      kaleoClassPK LONG,_        kaleoDefinitionId LONG,_        kaleoNodeName VARCHAR(200) null,_       name VARCHAR(200) null,_        description STRING null,_       executionType VARCHAR(20) null,_        script TEXT null,_ scriptLanguage VARCHAR(75) null,_       scriptRequiredContexts STRING null,_    priority INTEGER_);__create table KaleoCondition (_     kaleoConditionId LONG not null primary key,_    groupId LONG,_  companyId LONG,_   userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoDefinitionId LONG,_        kaleoNodeId LONG,_      script TEXT null,_      scriptLanguage VARCHAR(75) null,_  scriptRequiredContexts STRING null_);__create table KaleoDefinition (_  kaleoDefinitionId LONG not null primary key,_   groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_       createDate DATE null,_  modifiedDate DATE null,_        name VARCHAR(200) null,_        title STRING null,_     description STRING null,_       content TEXT null,_     version INTEGER,_
      active_ BOOLEAN,_       startKaleoNodeId LONG_);__create table KaleoInstance (_ kaleoInstanceId LONG not null primary key,_     groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_       createDate DATE null,_  modifiedDate DATE null,_        kaleoDefinitionId LONG,_        kaleoDefinitionName VARCHAR(200) null,_ kaleoDefinitionVersion INTEGER,_        rootKaleoInstanceTokenId LONG,_ className VARCHAR(200) null,_      classPK LONG,_  completed BOOLEAN,_     completionDate DATE null,_  workflowContext TEXT null_);__create table KaleoInstanceToken (_    kaleoInstanceTokenId LONG not null primary key,_   groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoDefinitionId LONG,_        kaleoInstanceId LONG,_  parentKaleoInstanceTokenId LONG,_  currentKaleoNodeId LONG,_       currentKaleoNodeName VARCHAR(200) null,_        className VARCHAR(200) null,_   classPK LONG,_  completed BOOLEAN,_     completionDate DATE null_);__create table KaleoLog (_      kaleoLogId LONG not null primary key,_  groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_
      kaleoClassName VARCHAR(200) null,_      kaleoClassPK LONG,_     kaleoDefinitionId LONG,_        kaleoInstanceId LONG,_  kaleoInstanceTokenId LONG,_     kaleoTaskInstanceTokenId LONG,_ kaleoNodeName VARCHAR(200) null,_  terminalKaleoNode BOOLEAN,_     kaleoActionId LONG,_    kaleoActionName VARCHAR(200) null,_ kaleoActionDescription STRING null,_        previousKaleoNodeId LONG,_      previousKaleoNodeName VARCHAR(200) null,_  previousAssigneeClassName VARCHAR(200) null,_   previousAssigneeClassPK LONG,_  currentAssigneeClassName VARCHAR(200) null,_    currentAssigneeClassPK LONG,_   type_ VARCHAR(50) null,_        comment_ TEXT null,_       startDate DATE null,_   endDate DATE null,_     duration LONG,_ workflowContext TEXT null_);__create table KaleoNode (_ kaleoNodeId LONG not null primary key,_ groupId LONG,_  companyId LONG,_
      userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_    kaleoDefinitionId LONG,_    name VARCHAR(200) null,_        metadata STRING null,_  description STRING null,_
      type_ VARCHAR(20) null,_        initial_ BOOLEAN,_      terminal BOOLEAN_);__create table KaleoNotification (_  kaleoNotificationId LONG not null primary key,_ groupId LONG,_  companyId LONG,_        userId LONG,_      userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoClassName VARCHAR(200) null,_      kaleoClassPK LONG,_     kaleoDefinitionId LONG,_        kaleoNodeName VARCHAR(200) null,_  name VARCHAR(200) null,_        description STRING null,_       executionType VARCHAR(20) null,_        template TEXT null,_    templateLanguage VARCHAR(75) null,_     notificationTypes VARCHAR(25) null_);__create table KaleoNotificationRecipient (_  kaleoNotificationRecipientId LONG not null primary key,_        groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_     modifiedDate DATE null,_        kaleoDefinitionId LONG,_        kaleoNotificationId LONG,_      recipientClassName VARCHAR(200) null,_  recipientClassPK LONG,_ recipientRoleType INTEGER,_        recipientScript TEXT null,_     recipientScriptLanguage VARCHAR(75) null,_      recipientScriptContexts STRING null,_   address VARCHAR(255) null,_     notificationReceptionType VARCHAR(3) null_);__create table KaleoTask (_    kaleoTaskId LONG not null primary key,_ groupId LONG,_  companyId LONG,_    userId LONG,_       userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoDefinitionId LONG,_   kaleoNodeId LONG,_      name VARCHAR(200) null,_        description STRING null_);__create table KaleoTaskAssignment (_ kaleoTaskAssignmentId LONG not null primary key,_       groupId LONG,_     companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoClassName VARCHAR(200) null,_      kaleoClassPK LONG,_     kaleoDefinitionId LONG,_   kaleoNodeId LONG,_      assigneeClassName VARCHAR(200) null,_   assigneeClassPK LONG,_  assigneeActionId VARCHAR(75) null,_     assigneeScript TEXT null,_      assigneeScriptLanguage VARCHAR(75) null,_  assigneeScriptRequiredContexts STRING null_);__create table KaleoTaskAssignmentInstance (_  kaleoTaskAssignmentInstanceId LONG not null primary key,_   groupId LONG,_  companyId LONG,_        userId LONG,_      userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoDefinitionId LONG,_        kaleoInstanceId LONG,_  kaleoInstanceTokenId LONG,_     kaleoTaskInstanceTokenId LONG,_    kaleoTaskId LONG,_      kaleoTaskName VARCHAR(200) null,_       assigneeClassName VARCHAR(200) null,_   assigneeClassPK LONG,_  completed BOOLEAN,_     completionDate DATE null_);__create table KaleoTaskInstanceToken (_        kaleoTaskInstanceTokenId LONG not null primary key,_    groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_   kaleoDefinitionId LONG,_        kaleoInstanceId LONG,_  kaleoInstanceTokenId LONG,_     kaleoTaskId LONG,_      kaleoTaskName VARCHAR(200) null,_       className VARCHAR(200) null,_   classPK LONG,_  completionUserId LONG,_    completed BOOLEAN,_     completionDate DATE null,_      dueDate DATE null,_ workflowContext TEXT null_);__create table KaleoTimer (_    kaleoTimerId LONG not null primary key,_        groupId LONG,_     companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_        kaleoClassName VARCHAR(200) null,_      kaleoClassPK LONG,_     kaleoDefinitionId LONG,_   name VARCHAR(75) null,_ blocking BOOLEAN,_      description STRING null,_   duration DOUBLE,_   scale VARCHAR(75) null,_        recurrenceDuration DOUBLE,_     recurrenceScale VARCHAR(75) null_);__create table KaleoTimerInstanceToken (_       kaleoTimerInstanceTokenId LONG not null primary key,_   groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_     modifiedDate DATE null,_        kaleoClassName VARCHAR(200) null,_      kaleoClassPK LONG,_     kaleoDefinitionId LONG,_        kaleoInstanceId LONG,_  kaleoInstanceTokenId LONG,_     kaleoTaskInstanceTokenId LONG,_    kaleoTimerId LONG,_     kaleoTimerName VARCHAR(200) null,_      blocking BOOLEAN,_      completionUserId LONG,_ completed BOOLEAN,_     completionDate DATE null,_      workflowContext TEXT null_);__create table KaleoTransition (_      kaleoTransitionId LONG not null primary key,_   groupId LONG,_  companyId LONG,_        userId LONG,_   userName VARCHAR(200) null,_    createDate DATE null,_  modifiedDate DATE null,_   kaleoDefinitionId LONG,_        kaleoNodeId LONG,_      name VARCHAR(200) null,_        description STRING null,_       sourceKaleoNodeId LONG,_        sourceKaleoNodeName VARCHAR(200) null,_    targetKaleoNodeId LONG,_        targetKaleoNodeName VARCHAR(200) null,_ defaultTransition BOOLEAN_); [Sanitized]
              at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension$1.upgrade(ModuleApplicationContextExtender.java:321)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfosRunnable.run(ReleaseManagerOSGiCommands.java:539)
              ... 82 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kaleoaction' already exists
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
              at com.mysql.jdbc.Util.getInstance(Util.java:386)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
              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:2788)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1816)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1730)
              at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
              at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:294)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
              at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:449)
              at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:506)
              at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension$1.upgrade(ModuleApplicationContextExtender.java:317)
              ... 83 more
      2018-06-28 12:26:00.946 ERROR [main][com_liferay_portal_upgrade_impl:97] Invocation to listener threw exception
      java.lang.RuntimeException: com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.marketplace.service_2.1.28 [435] has invalid content in tables.sql:_create table Marketplace_App (_  uuid_ VARCHAR(75) null,_   appId LONG not null primary key,_       companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_        remoteAppId LONG,_      title VARCHAR(75) null,_   description STRING null,_       category VARCHAR(75) null,_     iconURL STRING null,_   version VARCHAR(75) null,_      required BOOLEAN_);__create table Marketplace_Module (_ uuid_ VARCHAR(75) null,_   moduleId LONG not null primary key,_    companyId LONG,_        appId LONG,_    bundleSymbolicName VARCHAR(500) null,_  bundleVersion VARCHAR(75) null,_        contextName VARCHAR(75) null_); [Sanitized]
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfosRunnable.run(ReleaseManagerOSGiCommands.java:564)
              at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:106)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.executeUpgradeInfos(ReleaseManagerOSGiCommands.java:337)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.doExecute(ReleaseManagerOSGiCommands.java:280)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:505)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:495)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$DefaultEmitter.emit(ServiceTrackerMapImpl.java:222)
              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:261)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$ServiceReferenceServiceTrackerCustomizer.addingService(ServiceTrackerMapImpl.java:248)
              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.trackInitial(AbstractTracked.java:183)
              at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
              at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl.open(ServiceTrackerMapImpl.java:94)
              at com.liferay.osgi.service.tracker.collections.map.ServiceTrackerMapFactory.openMultiValueMap(ServiceTrackerMapFactory.java:244)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.activate(ReleaseManagerOSGiCommands.java:240)
              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 org.apache.felix.scr.impl.inject.BaseMethod.invokeMethod(BaseMethod.java:224)
              at org.apache.felix.scr.impl.inject.BaseMethod.access$500(BaseMethod.java:39)
              at org.apache.felix.scr.impl.inject.BaseMethod$Resolved.invoke(BaseMethod.java:617)
              at org.apache.felix.scr.impl.inject.BaseMethod.invoke(BaseMethod.java:501)
              at org.apache.felix.scr.impl.inject.ActivateMethod.invoke(ActivateMethod.java:302)
              at org.apache.felix.scr.impl.inject.ActivateMethod.invoke(ActivateMethod.java:294)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:297)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:108)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:906)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:879)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:748)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1012)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:968)
              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:127)
              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.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:886)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:873)
              at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:132)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.registerService(AbstractComponentManager.java:940)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:740)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1012)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:968)
              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:127)
              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:355)
              at com.liferay.portal.tools.DBUpgrader._registerModuleServiceLifecycle(DBUpgrader.java:412)
              at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:108)
              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.upgrade.UpgradeException: Bundle com.liferay.marketplace.service_2.1.28 [435] has invalid content in tables.sql:_create table Marketplace_App (_   uuid_ VARCHAR(75) null,_
      appId LONG not null primary key,_       companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_        remoteAppId LONG,_      title VARCHAR(75) null,_   description STRING null,_       category VARCHAR(75) null,_     iconURL STRING null,_   version VARCHAR(75) null,_      required BOOLEAN_);__create table Marketplace_Module (_ uuid_ VARCHAR(75) null,_
      moduleId LONG not null primary key,_    companyId LONG,_        appId LONG,_    bundleSymbolicName VARCHAR(500) null,_  bundleVersion VARCHAR(75) null,_        contextName VARCHAR(75) null_); [Sanitized]
              at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension$1.upgrade(ModuleApplicationContextExtender.java:321)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfosRunnable.run(ReleaseManagerOSGiCommands.java:539)
              ... 82 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'marketplace_app' already exists
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
              at com.mysql.jdbc.Util.getInstance(Util.java:386)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
              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:2788)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1816)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1730)
              at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
              at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:294)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
              at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:449)
              at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:506)
              at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension$1.upgrade(ModuleApplicationContextExtender.java:317)
              ... 83 more
      2018-06-28 12:26:00.984 ERROR [main][com_liferay_portal_upgrade_impl:97] Invocation to listener threw exception
      java.lang.RuntimeException: com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.sync.service_1.5.2 [444] has invalid content in tables.sql:_create table SyncDLFileVersionDiff (_    syncDLFileVersionDiffId LONG not null primary key,_        fileEntryId LONG,_      sourceFileVersionId LONG,_  targetFileVersionId LONG,_  dataFileEntryId LONG,_  size_ LONG,_    expirationDate DATE null_);__create table SyncDLObject (_  syncDLObjectId LONG not null primary key,_      companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_     createTime LONG,_       modifiedTime LONG,_     repositoryId LONG,_     parentFolderId LONG,_      treePath STRING null,_  name VARCHAR(255) null,_        extension VARCHAR(75) null,_    mimeType VARCHAR(75) null,_     description STRING null,_       changeLog VARCHAR(75) null,_    extraSettings TEXT null,_  version VARCHAR(75) null,_      versionId LONG,_        size_ LONG,_    checksum VARCHAR(75) null,_     event VARCHAR(75) null,_        lanTokenKey VARCHAR(75) null,_  lastPermissionChangeDate DATE null,_       lockExpirationDate DATE null,_  lockUserId LONG,_       lockUserName VARCHAR(75) null,_ type_ VARCHAR(75) null,_        typePK LONG,_   typeUuid VARCHAR(75) null_);__create table SyncDevice (_   uuid_ VARCHAR(75) null,_        syncDeviceId LONG not null primary key,_        companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_
      type_ VARCHAR(75) null,_        buildNumber LONG,_      featureSet INTEGER,_    hostname VARCHAR(75) null,_     status INTEGER_); [Sanitized]
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfosRunnable.run(ReleaseManagerOSGiCommands.java:564)
              at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:106)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.executeUpgradeInfos(ReleaseManagerOSGiCommands.java:337)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.doExecute(ReleaseManagerOSGiCommands.java:280)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:505)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:495)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$DefaultEmitter.emit(ServiceTrackerMapImpl.java:222)
              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:261)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$ServiceReferenceServiceTrackerCustomizer.addingService(ServiceTrackerMapImpl.java:248)
              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.trackInitial(AbstractTracked.java:183)
              at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
              at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
              at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl.open(ServiceTrackerMapImpl.java:94)
              at com.liferay.osgi.service.tracker.collections.map.ServiceTrackerMapFactory.openMultiValueMap(ServiceTrackerMapFactory.java:244)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.activate(ReleaseManagerOSGiCommands.java:240)
              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 org.apache.felix.scr.impl.inject.BaseMethod.invokeMethod(BaseMethod.java:224)
              at org.apache.felix.scr.impl.inject.BaseMethod.access$500(BaseMethod.java:39)
              at org.apache.felix.scr.impl.inject.BaseMethod$Resolved.invoke(BaseMethod.java:617)
              at org.apache.felix.scr.impl.inject.BaseMethod.invoke(BaseMethod.java:501)
              at org.apache.felix.scr.impl.inject.ActivateMethod.invoke(ActivateMethod.java:302)
              at org.apache.felix.scr.impl.inject.ActivateMethod.invoke(ActivateMethod.java:294)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:297)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:108)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:906)
              at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:879)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:748)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1012)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:968)
              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:127)
              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.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:886)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:873)
              at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:132)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.registerService(AbstractComponentManager.java:940)
              at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:740)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1012)
              at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:968)
              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:127)
              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:355)
              at com.liferay.portal.tools.DBUpgrader._registerModuleServiceLifecycle(DBUpgrader.java:412)
              at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:108)
              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.upgrade.UpgradeException: Bundle com.liferay.sync.service_1.5.2 [444] has invalid content in tables.sql:_create table SyncDLFileVersionDiff (_     syncDLFileVersionDiffId LONG not null primary key,_        fileEntryId LONG,_      sourceFileVersionId LONG,_      targetFileVersionId LONG,_      dataFileEntryId LONG,_  size_ LONG,_    expirationDate DATE null_);__create table SyncDLObject (_  syncDLObjectId LONG not null primary key,_      companyId LONG,_        userId LONG,_   userName VARCHAR(75) null,_     createTime LONG,_       modifiedTime LONG,_     repositoryId LONG,_     parentFolderId LONG,_      treePath STRING null,_  name VARCHAR(255) null,_        extension VARCHAR(75) null,_    mimeType VARCHAR(75) null,_     description STRING null,_       changeLog VARCHAR(75) null,_    extraSettings TEXT null,_  version VARCHAR(75) null,_      versionId LONG,_        size_ LONG,_    checksum VARCHAR(75) null,_     event VARCHAR(75) null,_        lanTokenKey VARCHAR(75) null,_  lastPermissionChangeDate DATE null,_       lockExpirationDate DATE null,_  lockUserId LONG,_       lockUserName VARCHAR(75) null,_ type_ VARCHAR(75) null,_        typePK LONG,_   typeUuid VARCHAR(75) null_);__create table SyncDevice (_
      uuid_ VARCHAR(75) null,_        syncDeviceId LONG not null primary key,_        companyId LONG,_    userId LONG,_       userName VARCHAR(75) null,_     createDate DATE null,_  modifiedDate DATE null,_        type_ VARCHAR(75) null,_   buildNumber LONG,_      featureSet INTEGER,_    hostname VARCHAR(75) null,_ status INTEGER_); [Sanitized]
              at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension$1.upgrade(ModuleApplicationContextExtender.java:321)
              at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfosRunnable.run(ReleaseManagerOSGiCommands.java:539)
              ... 82 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'syncdlfileversiondiff' already exists
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
              at com.mysql.jdbc.Util.getInstance(Util.java:386)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
              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:2788)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1816)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1730)
              at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
              at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:294)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
              at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:449)
              at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:506)
              at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension$1.upgrade(ModuleApplicationContextExtender.java:317)
              ... 83 more
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                raven.song Raven Song
                Reporter:
                norbert.kocsis Norbert Kocsis
                Participants of an Issue:
                Recent user:
                Clarissa Velazquez
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  30 weeks, 3 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP81
                  7.0.X
                  7.1.3 CE GA4
                  7.1.10 DXP FP11
                  7.1.X
                  Master