[LPS-33259] key too long for mysql database - Liferay Issues

XML

Word

Printable

Details

Type: Bug
Status: Closed
Resolution: Duplicate
Affects Version/s: 6.1.1 CE GA2, 6.2.0 CE M4
Fix Version/s: 6.1.1 CE GA2, 6.2.0 CE M4, 6.2.0 CE RC5
Component/s: Legacy, Legacy > Administration UI
Labels:
- community-verifier
Environment:
Windows 7 + MySQL 5.5+

Fix Priority:
3

Description

I am installing liferay-portal-tomcat-6.1.1-ce-ga2-20120731132656558. This is a clean install on a windows 7 machine (no previous version has been installed on the machine). I'm using MySql (mysql-installer-community-5.6.10.1). This was also a fresh install of MySql. to get it to semi-work, I had to replace the mysql.jar (mysql connector jar) with mysql-connector-java-5.1.23-bin.jar. However, I still see some troubling error messages. In particular, I'm concerned about the "Specified key was too long" messages. I'm assuming the 'lportal.lock_' message is just a result of it being the first time everything was started and I don't need to worry about that.

00:48:59,429 INFO [pool-2-thread-1][DialectDetector:71] Determine dialect for MySQL 5
00:48:59,458 INFO [pool-2-thread-1][DialectDetector:136] Found dialect org.hibernate.dialect.MySQLDialect
00:49:56,195 ERROR [pool-2-thread-1][JDBCExceptionReporter:76] Table 'lportal.lock_' doesn't exist
00:49:56,699 WARN [pool-2-thread-1][ReleaseLocalServiceImpl:151] Table 'lportal.release_' doesn't exist
00:49:56,700 INFO [pool-2-thread-1][ReleaseLocalServiceImpl:84] Create tables and populate with default data
01:00:22,390 WARN [pool-2-thread-1][BaseDB:428] Specified key was too long; max key length is 767 bytes: create index IX_7020130F on SCProductVersion (directDownloadURL);

01:00:22,391 ERROR [pool-2-thread-1][BaseDB:435] create index IX_7020130F on SCProductVersion (directDownloadURL);
01:01:47,407 WARN [pool-2-thread-1][BaseDB:428] Specified key was too long; max key length is 767 bytes: create index IX_89509087 on User_ (companyId, openId);

01:01:47,408 ERROR [pool-2-thread-1][BaseDB:435] create index IX_89509087 on User_ (companyId, openId);
01:02:57,745 INFO [pool-2-thread-1][BaseDB:455] Database does not support case sensitive queries
01:03:03,216 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProcessSuite
01:03:03,217 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProperties
01:03:03,227 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyDB2
01:03:03,228 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyMySQL
01:03:03,270 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
01:03:03,271 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifySQLServer
01:03:03,272 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyCounter
01:03:03,402 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyUUID
01:03:03,408 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyPermission
01:03:06,324 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyRole
01:03:06,325 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyAsset
01:03:06,329 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.util.UpgradeAssetPublisherManualEntries
01:03:06,330 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyBlogs
01:03:06,362 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyBookmarks
01:03:06,365 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyCalendar
01:03:06,702 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyDocumentLibrary
01:03:06,762 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyGroup
01:03:06,777 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyJournal
01:03:06,795 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyLayout
01:03:06,808 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyMessageBoards
01:03:06,824 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOrganization
01:03:06,825 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyResourcePermissions
01:03:06,826 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifySocial
01:03:06,827 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyUser
01:03:06,835 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyWiki
01:03:06,922 INFO [pool-2-thread-1][ServerDetector:154] Server supports hot deploy
01:03:06,928 INFO [pool-2-thread-1][PluginPackageUtil:1030] Reading plugin package for the root context
01:03:18,301 INFO [pool-2-thread-1][AutoDeployDir:85] Creating missing directory C:\liferay\bundles\deploy
01:03:18,303 INFO [pool-2-thread-1][AutoDeployDir:106] Auto deploy scanner started for C:\liferay\bundles\deploy

The only thing I've changed was to add the portal-ext.properties file in to define the mysql instance.

Attachments

Issue Links

is duplicated by

LPS-34881 key too long for mysql database

Closed

is fixed by

LPS-58589 Fix ServiceBuilder MySQL 5.6 indexes generation compatibility issue

Closed

Activity

People

Assignee:: Miguel Ángel Pastor Olivar (Inactive)

Reporter:: Scott Smith (Inactive)

Participants of an Issue:: Aniceto P Madrid, JR Houn, Miguel Ángel Pastor Olivar, Mika Koivisto, Philippe, Scott Smith, Tamas Molnar

Recent user:: Marta Elicegui

Votes:: 3 Vote for this issue

Watchers:: 10 Start watching this issue

Dates

Created:: 22/Feb/13 5:26 PM

Updated:: 30/Mar/22 3:27 AM

Resolved:: 22/Jun/16 1:20 AM

Days since last comment:: 5 years, 47 weeks, 6 days ago

Packages

Version	Package
6.1.1 CE GA2
6.2.0 CE M4
6.2.0 CE RC5