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

Starting up ee-6.2.x on MySQL 5.6 throws "create index IX_..." console errors


    • Fix Priority:
    • Databases:
      MySQL 5.6


      Steps to reproduce:

      1. Startup ee-6.2.x tomcat (with MySQL 5.6)

      Expected result:
      No console errors will be thrown on startup.

      Actual result:
      The following is thrown on startup:

      INFO: Deploying configuration descriptor L:\private\ee-6.2.x-bundles\tomcat-7.0.62\conf\Catalina\localhost\ROOT.xml
      Oct 07, 2015 3:26:57 PM org.apache.catalina.startup.TldConfig execute
      INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
      Loading jar:file:/L:/private/ee-6.2.x-bundles/tomcat-7.0.62/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
      Loading jar:file:/L:/private/ee-6.2.x-bundles/tomcat-7.0.62/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
      Loading file:/L:/private/ee-6.2.x-bundles/tomcat-7.0.62/webapps/ROOT/WEB-INF/classes/portal-ext.properties
      Oct 07, 2015 3:26:58 PM org.apache.catalina.core.ApplicationContext log
      INFO: Initializing Spring root WebApplicationContext
      15:27:02,145 INFO  [localhost-startStop-1][DialectDetector:71] Determine dialect for MySQL 5
      15:27:02,174 INFO  [localhost-startStop-1][DialectDetector:136] Found dialect org.hibernate.dialect.MySQLDialect
      Starting Liferay Portal Community Edition 6.2.10 EE GA1 (Newton / Build 6210 / November 1, 2013)
      15:27:21,042 INFO  [localhost-startStop-1][StartupAction:98] There are no patches installed
      15:27:21,152 ERROR [localhost-startStop-1][JDBCExceptionReporter:82] Table 'lportal2.lock_' doesn't exist
      15:27:21,157 WARN  [localhost-startStop-1][StartupAction:148] Unable to clear locks because Lock table does not exist
      15:27:21,510 WARN  [localhost-startStop-1][ReleaseLocalServiceImpl:171] Table 'lportal2.release_' doesn't exist
      15:27:21,532 INFO  [localhost-startStop-1][ReleaseLocalServiceImpl:84] Create tables and populate with default data
      15:27:36,734 WARN  [localhost-startStop-1][BaseDB:457] Specified key was too long; max key length is 767 bytes: create index IX_7020130F on SCProductVersion (directDownloadURL);_ [Sanitized]
      15:27:36,735 ERROR [localhost-startStop-1][BaseDB:464] create index IX_7020130F on SCProductVersion (directDownloadURL);
      15:27:38,818 WARN  [localhost-startStop-1][BaseDB:457] Specified key was too long; max key length is 767 bytes: create index IX_89509087 on User_ (companyId, openId);_ [Sanitized]
      15:27:38,819 ERROR [localhost-startStop-1][BaseDB:464] create index IX_89509087 on User_ (companyId, openId);
      15:27:40,181 INFO  [localhost-startStop-1][BaseDB:484] Database does not support case sensitive queries
      15:27:40,875 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyProcessSuite
      15:27:40,876 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyProperties
      15:27:40,896 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyDB2
      15:27:40,897 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyMySQL
      15:27:40,917 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyOracle
      15:27:40,918 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifySQLServer




            michael.yu Michael Yu (Inactive)
            brian.wulbern Brian Wulbern
            Participants of an Issue:
            Recent user:
            Esther Sanz
            0 Vote for this issue
            1 Start watching this issue


              Days since last comment:
              5 years, 14 weeks, 5 days ago


                Version Package
                6.2.X EE