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

Portal boot failed with mysql 5.6 and encoding utf8mb4, Specified key was too long

    Details

    • Databases:
      MySQL 5.6

      Description

      Portal don't start up with mysql 5.6 and default encoding utf8mb4

      Steps to reproduce:

      1. In mysql create database `CREATE DATABASE lportal CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;`
      2. Start liferay with script startup.sh
      3. Basic configuration is loaded, select database mysql and write username and password
      4. Run shutdown.sh, wait for java process is stopped, run startup.sh

      Content of `portal-setup-wizard.properties`

      [email protected]
      admin.email.from.name=Test Test
      company.default.locale=en_US
      company.default.web.id=liferay.com
      default.admin.email.address.prefix=test
      jdbc.default.driverClassName=com.mysql.jdbc.Driver
      jdbc.default.password=
      jdbc.default.url=jdbc:mysql://localhost/lportal?characterEncoding=UTF-8&dontTrackOpenResources=true&holdResultsOpenOverStatementClose=true&useFastDateParsing=false&useUnicode=true
      jdbc.default.username=root
      liferay.home=/home/profiq/bundles
      setup.wizard.add.sample.data=on
      setup.wizard.enabled=false
      

      Log after restart

      20-Apr-2018 11:45:09.474 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/9.0.6
      20-Apr-2018 11:45:09.478 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Mar 5 2018 09:34:35 UTC
      20-Apr-2018 11:45:09.478 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         9.0.6.0
      20-Apr-2018 11:45:09.478 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
      20-Apr-2018 11:45:09.478 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            3.10.0-693.21.1.el7.x86_64
      20-Apr-2018 11:45:09.478 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
      20-Apr-2018 11:45:09.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.el7_4.x86_64/jre
      20-Apr-2018 11:45:09.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_161-b14
      20-Apr-2018 11:45:09.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
      20-Apr-2018 11:45:09.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /home/profiq/bundles/tomcat-9.0.6
      20-Apr-2018 11:45:09.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /home/profiq/bundles/tomcat-9.0.6
      20-Apr-2018 11:45:09.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/home/profiq/bundles/tomcat-9.0.6/conf/logging.properties
      20-Apr-2018 11:45:09.480 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
      20-Apr-2018 11:45:09.480 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
      20-Apr-2018 11:45:09.480 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
      20-Apr-2018 11:45:09.480 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF8
      20-Apr-2018 11:45:09.480 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.net.preferIPv4Stack=true
      20-Apr-2018 11:45:09.480 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.loader.WebappClassLoader.ENABLE_CLEAR_REFERENCES=false
      20-Apr-2018 11:45:09.480 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Duser.timezone=GMT
      20-Apr-2018 11:45:09.480 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024m
      20-Apr-2018 11:45:09.481 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxMetaspaceSize=512m
      20-Apr-2018 11:45:09.481 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
      20-Apr-2018 11:45:09.481 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/home/profiq/bundles/tomcat-9.0.6
      20-Apr-2018 11:45:09.481 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/home/profiq/bundles/tomcat-9.0.6
      20-Apr-2018 11:45:09.481 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/home/profiq/bundles/tomcat-9.0.6/temp
      20-Apr-2018 11:45:09.481 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
      20-Apr-2018 11:45:09.627 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
      20-Apr-2018 11:45:09.645 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
      20-Apr-2018 11:45:09.655 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
      20-Apr-2018 11:45:09.657 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
      20-Apr-2018 11:45:09.657 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 832 ms
      20-Apr-2018 11:45:09.693 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
      20-Apr-2018 11:45:09.693 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/9.0.6
      20-Apr-2018 11:45:09.705 INFO [main] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying deployment descriptor [/home/profiq/bundles/tomcat-9.0.6/conf/Catalina/localhost/ROOT.xml]
      20-Apr-2018 11:45:09.735 WARNING [main] org.apache.catalina.startup.HostConfig.deployDescriptor The path attribute with value [] in deployment descriptor [/home/profiq/bundles/tomcat-9.0.6/conf/Catalina/localhost/ROOT.xml] has been ignored
      20-Apr-2018 11:45:23.645 INFO [main] org.apache.catalina.core.ApplicationContext.log No Spring WebApplicationInitializer types detected on classpath
      Loading jar:file:/home/profiq/bundles/tomcat-9.0.6/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
      Loading jar:file:/home/profiq/bundles/tomcat-9.0.6/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
      Loading jar:file:/home/profiq/bundles/tomcat-9.0.6/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
      Loading file:/home/profiq/bundles/portal-setup-wizard.properties
      2018-04-20 11:45:27.451 INFO  [main][HikariDataSource:95] HikariPool-1 - Starting...
      2018-04-20 11:45:27.937 INFO  [main][HikariDataSource:107] HikariPool-1 - Start completed.
      2018-04-20 11:45:27.943 INFO  [main][DialectDetector:77] Determine dialect for MySQL 5.6
      2018-04-20 11:45:28.088 INFO  [main][DialectDetector:155] Found dialect org.hibernate.dialect.MySQLDialect
      2018-04-20 11:45:30.535 INFO  [main][HikariDataSource:95] HikariPool-2 - Starting...
      2018-04-20 11:45:30.544 INFO  [main][HikariDataSource:107] HikariPool-2 - Start completed.
      2018-04-20 11:45:31.374 INFO  [main][BundleStartStopLogger:35] STARTED org.eclipse.osgi_3.10.200.v20150831-0856 [0]
      2018-04-20 11:45:31.584 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.osgi.felix.file.install.configuration.cleaner_2.0.0 [1]
      2018-04-20 11:45:31.587 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.osgi.util_4.0.0 [2]
      2018-04-20 11:45:31.588 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.bundle.blacklist.api_1.0.0 [3]
      2018-04-20 11:45:31.588 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.bundle.blacklist.impl_1.0.0 [4]
      2018-04-20 11:45:31.631 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.classloader.tracker_2.0.0 [5]
      2018-04-20 11:45:31.631 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.component.blacklist.api_2.0.0 [6]
      2018-04-20 11:45:31.634 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.component.blacklist.impl_2.0.0 [7]
      2018-04-20 11:45:31.635 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.configuration.metatype.api_1.0.0 [8]
      2018-04-20 11:45:31.637 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.configuration.persistence.api_1.0.0 [9]
      2018-04-20 11:45:31.733 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:38] STOPPED com.liferay.portal.configuration.persistence.impl_1.0.0 [10]
      2018-04-20 11:45:31.738 ERROR [Framework Event Dispatcher: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][com_liferay_portal_configuration_persistence_impl:97] FrameworkEvent ERROR 
      org.osgi.framework.BundleException: Exception in com.liferay.portal.configuration.persistence.internal.activator.ConfigurationPersistenceBundleActivator.start() of bundle com.liferay.portal.configuration.persistence.impl.
      	at org.eclipse.osgi.internal.framework.BundleContextImpl.startActivator(BundleContextImpl.java:795)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl.start(BundleContextImpl.java:724)
      	at org.eclipse.osgi.internal.framework.EquinoxBundle.startWorker0(EquinoxBundle.java:951)
      	at org.eclipse.osgi.internal.framework.EquinoxBundle$EquinoxModule.startWorker(EquinoxBundle.java:328)
      	at org.eclipse.osgi.container.Module.doStart(Module.java:566)
      	at org.eclipse.osgi.container.Module.start(Module.java:434)
      	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1582)
      	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1562)
      	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.doContainerStartLevel(ModuleContainer.java:1533)
      	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1476)
      	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1)
      	at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
      	at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340)
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
      	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.configuration.persistence.internal.ConfigurationPersistenceManager.createConfigurationTable(ConfigurationPersistenceManager.java:268)
      	at com.liferay.portal.configuration.persistence.internal.ConfigurationPersistenceManager.start(ConfigurationPersistenceManager.java:171)
      	at com.liferay.portal.configuration.persistence.internal.activator.ConfigurationPersistenceBundleActivator.start(ConfigurationPersistenceBundleActivator.java:65)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:774)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:1)
      	at java.security.AccessController.doPrivileged(Native Method)
      	at org.eclipse.osgi.internal.framework.BundleContextImpl.startActivator(BundleContextImpl.java:767)
      	... 12 more
      2018-04-20 11:45:31.782 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.log4j.extender_3.0.0 [11]
      2018-04-20 11:45:31.784 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.lpkg.deployer.api_1.0.0 [12]
      2018-04-20 11:45:31.795 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.lpkg.deployer.impl_1.0.0 [13]
      2018-04-20 11:45:31.799 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.osgi.web.portlet.tracker_3.0.0 [14]
      2018-04-20 11:45:31.801 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.osgi.web.servlet.api_1.0.0 [15]
      2018-04-20 11:45:31.803 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.osgi.web.servlet.context.helper.api_1.0.0 [16]
      2018-04-20 11:45:31.805 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.osgi.web.servlet.context.helper.impl_1.0.0 [17]
      2018-04-20 11:45:31.812 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.osgi.web.servlet.jsp.compiler_3.0.0 [18]
      2018-04-20 11:45:31.815 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.osgi.web.wab.extender_3.0.0 [19]
      2018-04-20 11:45:31.817 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.osgi.web.wab.generator.api_1.0.0 [20]
      2018-04-20 11:45:31.830 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.osgi.web.wab.generator.impl_1.0.0 [21]
      2018-04-20 11:45:31.833 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.osgi.web.wab.reference.support_2.0.0 [22]
      2018-04-20 11:45:31.835 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.osgi.web.wab.spring.bridge.api_1.0.0 [23]
      2018-04-20 11:45:31.836 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.profile.api_2.0.0 [24]
      2018-04-20 11:45:31.838 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.profile.impl_2.0.0 [25]
      2018-04-20 11:45:31.846 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.social.activity.extender_1.0.0 [26]
      2018-04-20 11:45:31.848 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.target.platform.indexer.api_1.0.0 [27]
      2018-04-20 11:45:31.850 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.portal.target.platform.indexer.impl_1.0.0 [28]
      2018-04-20 11:45:31.851 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.sun.el.javax.el_3.0.0 [29]
      2018-04-20 11:45:31.852 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED javax.servlet.jsp-api_2.3.2.b01 [30]
      2018-04-20 11:45:31.854 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED javax.servlet.jsp.jstl-api_1.2.1 [31]
      2018-04-20 11:45:31.855 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED javax.servlet.jsp.jstl_1.2.3.LIFERAY-PATCHED-2 [32]
      2018-04-20 11:45:31.857 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.commons.fileupload_1.3.2 [33]
      2018-04-20 11:45:31.857 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.commons.io_2.2.0 [34]
      2018-04-20 11:45:33.828 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.felix.bundlerepository_2.0.2.LIFERAY-PATCHED-1 [35]
      2018-04-20 11:45:33.854 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.felix.configadmin_1.8.8 [36]
      2018-04-20 11:45:33.855 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.felix.dependencymanager_3.2.0 [37]
      2018-04-20 11:45:33.860 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.felix.dependencymanager.shell_3.2.0 [38]
      2018-04-20 11:45:33.889 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.felix.eventadmin_1.4.6 [39]
      2018-04-20 11:45:34.050 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.felix.fileinstall_3.5.4.LIFERAY-PATCHED-2 [40]
      2018-04-20 11:45:34.063 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.felix.gogo.command_0.12.0 [41]
      2018-04-20 11:45:34.082 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.felix.gogo.runtime_0.10.0 [42]
      2018-04-20 11:45:34.098 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.felix.gogo.shell_0.10.0 [43]
      2018-04-20 11:45:34.997 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][DefaultLPKGDeployer:303] Start refreshing uninstalled orphan bundles
      2018-04-20 11:45:35.007 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][DefaultLPKGDeployer:311] Finished refreshing uninstalled orphan bundles
      [main] INFO osgi.logging.org_eclipse_osgi - ServiceEvent REGISTERED {org.eclipse.osgi.service.security.TrustEngine}={service.ranking=-2147483648, osgi.signedcontent.trust.engine=org.eclipse.osgi, service.id=23, service.bundleid=0, service.scope=singleton}
      [main] INFO osgi.logging.org_eclipse_osgi - ServiceEvent REGISTERED {org.eclipse.osgi.signedcontent.SignedContentFactory}={service.id=24, service.bundleid=0, service.scope=singleton}
      [main] INFO osgi.logging.org_eclipse_osgi - ServiceEvent REGISTERED {org.eclipse.osgi.service.debug.DebugOptionsListener}={service.ranking=2147483647, listener.symbolic.name=org.eclipse.osgi, service.pid=0.org.eclipse.osgi.internal.debug.Debug, service.vendor=Eclipse.org - Equinox, service.id=25, service.bundleid=0, service.scope=singleton}
      [main] INFO osgi.logging.org_eclipse_osgi - ServiceEvent REGISTERED {org.eclipse.osgi.service.debug.DebugOptionsListener}={service.ranking=2147483647, listener.symbolic.name=org.eclipse.osgi, service.pid=0.org.eclipse.osgi.container.ModuleContainer, service.vendor=Eclipse.org - Equinox, service.id=26, service.bundleid=0, service.scope=singleton}
      [Framework stop] INFO osgi.logging.org_eclipse_osgi - ServiceEvent UNREGISTERING {org.osgi.framework.hooks.resolver.ResolverHookFactory}={service.id=22, service.bundleid=0, service.scope=singleton}
      2018-04-20 11:45:51.118 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][LPKGIndexValidator:170] Passed integrity check
      2018-04-20 11:45:51.148 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.apache.felix.scr_2.0.6 [44]
      2018-04-20 11:45:51.172 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.eclipse.equinox.console_1.1.100.v20141023-1406 [45]
      2018-04-20 11:45:51.176 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.eclipse.equinox.http.servlet_1.2.2.v20180212-2026 [46]
      2018-04-20 11:45:51.184 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.eclipse.equinox.metatype_1.4.200.v20150715-1528 [47]
      2018-04-20 11:45:51.185 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.osgi.service.http_3.5.0.LIFERAY-PATCHED-2 [48]
      2018-04-20 11:45:51.186 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED org.osgi.service.metatype_1.3.0.201505202024 [49]
      2018-04-20 11:45:51.187 INFO  [Start Level: Equinox Container: d05d0d51-9044-0018-1b67-d316ee5c35bf][BundleStartStopLogger:35] STARTED com.liferay.util.taglib_3.0.0 [51]
      

      Actual Result > Liferay portal not start up

      Problem is only with encoding utf8mb4. I recreate database with encoding utf8 and portal started.

      Expected Result > Start liferay portal without errors

      Priority L3 + S5 = 5 

      Reproducible:
      Liferay portal nightly 3e7844263ed6e00160da66ae9b30934e66e366bb
      CentOS Linux release 7.4.1708 (Core)
      Mysql 5.6.40 x86_64
      openjdk version "1.8.0_161"

        Attachments

          Activity

            People

            Assignee:
            michael.saechang Michael Saechang
            Reporter:
            michal.kalita Michal Kalita
            Participants of an Issue:
            Recent user:
            Michael Saechang
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              3 years, 26 weeks, 3 days ago

                Packages

                Version Package
                7.1.0 Beta 1