[LPS-79930] Portal boot failed with mysql 5.6 and encoding utf8mb4, Specified key was too long - Liferay Issues

XML

Word

Printable

Details

Type: Bug
Status: Closed
Resolution: Won't Fix
Affects Version/s: Master
Fix Version/s: 7.1.0 Beta 1
Component/s: Environments > Databases
Labels:
- profiq

Databases:

MySQL 5.6

Description

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

Steps to reproduce:

In mysql create database `CREATE DATABASE lportal CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;`
Start liferay with script startup.sh
Basic configuration is loaded, select database mysql and write username and password
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

Reporter:: Michal Kalita

Participants of an Issue:: Michael Saechang, Michal Kalita

Recent user:: Michael Saechang

Votes:: 0 Vote for this issue

Watchers:: 0 Start watching this issue

Dates

Created:: 20/Apr/18 5:14 AM

Updated:: 31/May/18 11:24 AM

Resolved:: 02/May/18 2:43 PM

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

Packages

Version	Package
7.1.0 Beta 1