Details

    • Type: Bug Bug
    • Status: Closed
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      Snow Leopard
    • Similar Issues:
      Show 5 results 

      Description

      When using Mysql 5, I see the following "Specified key was too long" errors:

      Loading jar:file:/Users/ianw/my/cbs/cb.1.liferay.sdk/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
      Loading jar:file:/Users/ianw/my/cbs/cb.1.liferay.sdk/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
      Loading file:/Users/ianw/my/cbs/cb.1.liferay.sdk/webapps/ROOT/WEB-INF/classes/portal-ext.properties
      10:46:45,362 INFO [DialectDetector:69] Determining dialect for MySQL 5
      10:46:45,490 INFO [DialectDetector:49] Using dialect org.hibernate.dialect.MySQLDialect
      10:46:51,837 INFO [PortalImpl:276] Global lib directory /Users/ianw/my/cbs/cb.1.liferay.sdk/lib/ext/
      10:46:51,840 INFO [PortalImpl:296] Portal lib directory /Users/ianw/my/cbs/cb.1.liferay.sdk/webapps/ROOT/WEB-INF/lib/
      Starting Liferay Portal Community Edition 6.0.4 CE (Bunyan / Build 6004 / July 21, 2010)
      10:47:28,823 ERROR [JDBCExceptionReporter:101] Table 'lpsdk.lock_' doesn't exist
      10:47:30,136 WARN [ReleaseLocalServiceImpl:143] Table 'lpsdk.release_' doesn't exist
      10:47:30,139 INFO [ReleaseLocalServiceImpl:84] Create tables and populate with default data
      10:48:12,413 WARN [BaseDB:370] Specified key was too long; max key length is 1000 bytes: create unique index IX_2F8FED9C on DLFileVersion (groupId, folderId, name, version);
      10:48:12,416 ERROR [BaseDB:377] create unique index IX_2F8FED9C on DLFileVersion (groupId, folderId, name, version);
      10:48:48,225 WARN [BaseDB:370] Specified key was too long; max key length is 1000 bytes: create index IX_2200AA69 on ResourcePermission (companyId, name, scope, primKey);
      10:48:48,228 ERROR [BaseDB:377] create index IX_2200AA69 on ResourcePermission (companyId, name, scope, primKey);
      10:48:48,235 WARN [BaseDB:370] Specified key was too long; max key length is 1000 bytes: create unique index IX_8D83D0CE on ResourcePermission (companyId, name, scope, primKey, roleId);
      10:48:48,236 ERROR [BaseDB:377] create unique index IX_8D83D0CE on ResourcePermission (companyId, name, scope, primKey, roleId);
      10:49:07,921 WARN [BaseDB:370] Specified key was too long; max key length is 1000 bytes: create index IX_89509087 on User_ (companyId, openId);
      10:49:07,924 ERROR [BaseDB:377] create index IX_89509087 on User_ (companyId, openId);
      10:49:15,712 INFO [BaseDB:397] Database does not support case sensitive queries
      10:49:18,203 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyProcessSuite
      10:49:18,209 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyProperties
      10:49:18,211 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyMySQL
      10:49:18,250 INFO [VerifyMySQL:36] Updating table Account_ to use engine InnoDB
      10:49:18,307 INFO [VerifyMySQL:36] Updating table Counter to use engine InnoDB
      10:49:18,464 INFO [VerifyMySQL:36] Updating table CyrusUser to use engine InnoDB
      10:49:18,612 INFO [VerifyMySQL:36] Updating table CyrusVirtual to use engine InnoDB
      10:49:18,790 INFO [VerifyMySQL:36] Updating table QUARTZ_BLOB_TRIGGERS to use engine InnoDB
      10:49:18,939 INFO [VerifyMySQL:36] Updating table QUARTZ_CALENDARS to use engine InnoDB
      10:49:19,097 INFO [VerifyMySQL:36] Updating table QUARTZ_CRON_TRIGGERS to use engine InnoDB
      10:49:19,265 INFO [VerifyMySQL:36] Updating table QUARTZ_JOB_DETAILS to use engine InnoDB
      10:49:19,411 INFO [VerifyMySQL:36] Updating table QUARTZ_JOB_LISTENERS to use engine InnoDB
      10:49:19,554 INFO [VerifyMySQL:36] Updating table QUARTZ_LOCKS to use engine InnoDB
      10:49:19,701 INFO [VerifyMySQL:36] Updating table QUARTZ_PAUSED_TRIGGER_GRPS to use engine InnoDB
      10:49:19,846 INFO [VerifyMySQL:36] Updating table QUARTZ_SCHEDULER_STATE to use engine InnoDB
      10:49:19,981 INFO [VerifyMySQL:36] Updating table QUARTZ_SIMPLE_TRIGGERS to use engine InnoDB
      10:49:20,117 INFO [VerifyMySQL:36] Updating table QUARTZ_TRIGGER_LISTENERS to use engine InnoDB
      10:49:20,252 INFO [VerifyMySQL:36] Updating table SocialEquityHistory to use engine InnoDB
      10:49:20,409 INFO [VerifyMySQL:36] Updating table Vocabulary to use engine InnoDB
      10:49:20,567 INFO [VerifyMySQL:36] Updating table address to use engine InnoDB
      10:49:20,714 INFO [VerifyMySQL:36] Updating table announcementsdelivery to use engine InnoDB
      10:49:20,858 INFO [VerifyMySQL:36] Updating table announcementsentry to use engine InnoDB
      10:49:20,991 INFO [VerifyMySQL:36] Updating table announcementsflag to use engine InnoDB
      10:49:21,127 INFO [VerifyMySQL:36] Updating table assetcategory to use engine InnoDB
      10:49:21,274 INFO [VerifyMySQL:36] Updating table assetcategoryproperty to use engine InnoDB
      10:49:21,420 INFO [VerifyMySQL:36] Updating table assetentries_assetcategories to use engine InnoDB
      10:49:21,567 INFO [VerifyMySQL:36] Updating table assetentries_assettags to use engine InnoDB
      10:49:21,725 INFO [VerifyMySQL:36] Updating table assetentry to use engine InnoDB
      10:49:21,892 INFO [VerifyMySQL:36] Updating table assetlink to use engine InnoDB
      10:49:22,072 INFO [VerifyMySQL:36] Updating table assettag to use engine InnoDB
      10:49:22,229 INFO [VerifyMySQL:36] Updating table assettagproperty to use engine InnoDB
      10:49:22,388 INFO [VerifyMySQL:36] Updating table assettagstats to use engine InnoDB
      10:49:22,546 INFO [VerifyMySQL:36] Updating table assetvocabulary to use engine InnoDB
      10:49:22,702 INFO [VerifyMySQL:36] Updating table blogsentry to use engine InnoDB
      10:49:22,850 INFO [VerifyMySQL:36] Updating table blogsstatsuser to use engine InnoDB
      10:49:23,005 INFO [VerifyMySQL:36] Updating table bookmarksentry to use engine InnoDB
      10:49:23,153 INFO [VerifyMySQL:36] Updating table bookmarksfolder to use engine InnoDB
      10:49:23,340 INFO [VerifyMySQL:36] Updating table browsertracker to use engine InnoDB
      10:49:23,478 INFO [VerifyMySQL:36] Updating table calevent to use engine InnoDB
      10:49:23,638 INFO [VerifyMySQL:36] Updating table classname_ to use engine InnoDB
      10:49:23,821 INFO [VerifyMySQL:36] Updating table company to use engine InnoDB
      10:49:23,975 INFO [VerifyMySQL:36] Updating table contact_ to use engine InnoDB
      10:49:24,142 INFO [VerifyMySQL:36] Updating table country to use engine InnoDB
      10:49:24,294 INFO [VerifyMySQL:36] Updating table dlfileentry to use engine InnoDB
      10:49:24,447 INFO [VerifyMySQL:36] Updating table dlfilerank to use engine InnoDB
      10:49:24,580 INFO [VerifyMySQL:36] Updating table dlfileshortcut to use engine InnoDB
      10:49:24,715 INFO [VerifyMySQL:36] Updating table dlfileversion to use engine InnoDB
      10:49:24,849 INFO [VerifyMySQL:36] Updating table dlfolder to use engine InnoDB
      10:49:24,984 INFO [VerifyMySQL:36] Updating table emailaddress to use engine InnoDB
      10:49:25,130 INFO [VerifyMySQL:36] Updating table expandocolumn to use engine InnoDB
      10:49:25,266 INFO [VerifyMySQL:36] Updating table expandorow to use engine InnoDB
      10:49:25,424 INFO [VerifyMySQL:36] Updating table expandotable to use engine InnoDB
      10:49:25,583 INFO [VerifyMySQL:36] Updating table expandovalue to use engine InnoDB
      10:49:25,740 INFO [VerifyMySQL:36] Updating table group_ to use engine InnoDB
      10:49:25,898 INFO [VerifyMySQL:36] Updating table groups_orgs to use engine InnoDB
      10:49:26,054 INFO [VerifyMySQL:36] Updating table groups_permissions to use engine InnoDB
      10:49:26,212 INFO [VerifyMySQL:36] Updating table groups_roles to use engine InnoDB
      10:49:26,369 INFO [VerifyMySQL:36] Updating table groups_usergroups to use engine InnoDB
      10:49:26,529 INFO [VerifyMySQL:36] Updating table igfolder to use engine InnoDB
      10:49:26,686 INFO [VerifyMySQL:36] Updating table igimage to use engine InnoDB
      10:49:26,842 INFO [VerifyMySQL:36] Updating table image to use engine InnoDB
      10:49:26,987 INFO [VerifyMySQL:36] Updating table journalarticle to use engine InnoDB
      10:49:27,134 INFO [VerifyMySQL:36] Updating table journalarticleimage to use engine InnoDB
      10:49:27,303 INFO [VerifyMySQL:36] Updating table journalarticleresource to use engine InnoDB
      10:49:27,461 INFO [VerifyMySQL:36] Updating table journalcontentsearch to use engine InnoDB
      10:49:27,641 INFO [VerifyMySQL:36] Updating table journalfeed to use engine InnoDB
      10:49:27,787 INFO [VerifyMySQL:36] Updating table journalstructure to use engine InnoDB
      10:49:27,956 INFO [VerifyMySQL:36] Updating table journaltemplate to use engine InnoDB
      10:49:28,115 INFO [VerifyMySQL:36] Updating table layout to use engine InnoDB
      10:49:28,293 INFO [VerifyMySQL:36] Updating table layoutprototype to use engine InnoDB
      10:49:28,438 INFO [VerifyMySQL:36] Updating table layoutset to use engine InnoDB
      10:49:28,584 INFO [VerifyMySQL:36] Updating table layoutsetprototype to use engine InnoDB
      10:49:28,743 INFO [VerifyMySQL:36] Updating table listtype to use engine InnoDB
      10:49:28,903 INFO [VerifyMySQL:36] Updating table lock_ to use engine InnoDB
      10:49:29,069 INFO [VerifyMySQL:36] Updating table mbban to use engine InnoDB
      10:49:29,226 INFO [VerifyMySQL:36] Updating table mbcategory to use engine InnoDB
      10:49:29,385 INFO [VerifyMySQL:36] Updating table mbdiscussion to use engine InnoDB
      10:49:29,565 INFO [VerifyMySQL:36] Updating table mbmailinglist to use engine InnoDB
      10:49:29,734 INFO [VerifyMySQL:36] Updating table mbmessage to use engine InnoDB
      10:49:29,879 INFO [VerifyMySQL:36] Updating table mbmessageflag to use engine InnoDB
      10:49:30,026 INFO [VerifyMySQL:36] Updating table mbstatsuser to use engine InnoDB
      10:49:30,171 INFO [VerifyMySQL:36] Updating table mbthread to use engine InnoDB
      10:49:30,329 INFO [VerifyMySQL:36] Updating table membershiprequest to use engine InnoDB
      10:49:30,508 INFO [VerifyMySQL:36] Updating table organization_ to use engine InnoDB
      10:49:30,654 INFO [VerifyMySQL:36] Updating table orggrouppermission to use engine InnoDB
      10:49:30,801 INFO [VerifyMySQL:36] Updating table orggrouprole to use engine InnoDB
      10:49:30,960 INFO [VerifyMySQL:36] Updating table orglabor to use engine InnoDB
      10:49:31,117 INFO [VerifyMySQL:36] Updating table passwordpolicy to use engine InnoDB
      10:49:31,284 INFO [VerifyMySQL:36] Updating table passwordpolicyrel to use engine InnoDB
      10:49:31,419 INFO [VerifyMySQL:36] Updating table passwordtracker to use engine InnoDB
      10:49:31,555 INFO [VerifyMySQL:36] Updating table permission_ to use engine InnoDB
      10:49:31,712 INFO [VerifyMySQL:36] Updating table phone to use engine InnoDB
      10:49:31,870 INFO [VerifyMySQL:36] Updating table pluginsetting to use engine InnoDB
      10:49:32,227 INFO [VerifyMySQL:36] Updating table pollschoice to use engine InnoDB
      10:49:32,388 INFO [VerifyMySQL:36] Updating table pollsquestion to use engine InnoDB
      10:49:32,556 INFO [VerifyMySQL:36] Updating table pollsvote to use engine InnoDB
      10:49:32,703 INFO [VerifyMySQL:36] Updating table portlet to use engine InnoDB
      10:49:32,872 INFO [VerifyMySQL:36] Updating table portletitem to use engine InnoDB
      10:49:33,018 INFO [VerifyMySQL:36] Updating table portletpreferences to use engine InnoDB
      10:49:33,175 INFO [VerifyMySQL:36] Updating table quartz_fired_triggers to use engine InnoDB
      10:49:33,321 INFO [VerifyMySQL:36] Updating table quartz_triggers to use engine InnoDB
      10:49:33,465 INFO [VerifyMySQL:36] Updating table ratingsentry to use engine InnoDB
      10:49:33,613 INFO [VerifyMySQL:36] Updating table ratingsstats to use engine InnoDB
      10:49:33,771 INFO [VerifyMySQL:36] Updating table region to use engine InnoDB
      10:49:33,920 INFO [VerifyMySQL:36] Updating table release_ to use engine InnoDB
      10:49:34,063 INFO [VerifyMySQL:36] Updating table resource_ to use engine InnoDB
      10:49:34,210 INFO [VerifyMySQL:36] Updating table resourceaction to use engine InnoDB
      10:49:34,355 INFO [VerifyMySQL:36] Updating table resourcecode to use engine InnoDB
      10:49:34,515 INFO [VerifyMySQL:36] Updating table resourcepermission to use engine InnoDB
      10:49:34,681 INFO [VerifyMySQL:36] Updating table role_ to use engine InnoDB
      10:49:34,840 INFO [VerifyMySQL:36] Updating table roles_permissions to use engine InnoDB
      10:49:35,007 INFO [VerifyMySQL:36] Updating table scframeworkversi_scproductvers to use engine InnoDB
      10:49:35,166 INFO [VerifyMySQL:36] Updating table scframeworkversion to use engine InnoDB
      10:49:35,324 INFO [VerifyMySQL:36] Updating table sclicense to use engine InnoDB
      10:49:35,479 INFO [VerifyMySQL:36] Updating table sclicenses_scproductentries to use engine InnoDB
      10:49:35,626 INFO [VerifyMySQL:36] Updating table scproductentry to use engine InnoDB
      10:49:35,772 INFO [VerifyMySQL:36] Updating table scproductscreenshot to use engine InnoDB
      10:49:35,919 INFO [VerifyMySQL:36] Updating table scproductversion to use engine InnoDB
      10:49:36,076 INFO [VerifyMySQL:36] Updating table servicecomponent to use engine InnoDB
      10:49:36,223 INFO [VerifyMySQL:36] Updating table shard to use engine InnoDB
      10:49:36,379 INFO [VerifyMySQL:36] Updating table shoppingcart to use engine InnoDB
      10:49:36,537 INFO [VerifyMySQL:36] Updating table shoppingcategory to use engine InnoDB
      10:49:36,694 INFO [VerifyMySQL:36] Updating table shoppingcoupon to use engine InnoDB
      10:49:36,851 INFO [VerifyMySQL:36] Updating table shoppingitem to use engine InnoDB
      10:49:36,996 INFO [VerifyMySQL:36] Updating table shoppingitemfield to use engine InnoDB
      10:49:37,145 INFO [VerifyMySQL:36] Updating table shoppingitemprice to use engine InnoDB
      10:49:37,303 INFO [VerifyMySQL:36] Updating table shoppingorder to use engine InnoDB
      10:49:37,469 INFO [VerifyMySQL:36] Updating table shoppingorderitem to use engine InnoDB
      10:49:37,627 INFO [VerifyMySQL:36] Updating table socialactivity to use engine InnoDB
      10:49:37,784 INFO [VerifyMySQL:36] Updating table socialequityassetentry to use engine InnoDB
      10:49:37,940 INFO [VerifyMySQL:36] Updating table socialequitylog to use engine InnoDB
      10:49:38,088 INFO [VerifyMySQL:36] Updating table socialequitysetting to use engine InnoDB
      10:49:38,233 INFO [VerifyMySQL:36] Updating table socialequityuser to use engine InnoDB
      10:49:38,369 INFO [VerifyMySQL:36] Updating table socialrelation to use engine InnoDB
      10:49:38,515 INFO [VerifyMySQL:36] Updating table socialrequest to use engine InnoDB
      10:49:38,661 INFO [VerifyMySQL:36] Updating table subscription to use engine InnoDB
      10:49:38,819 INFO [VerifyMySQL:36] Updating table tasksproposal to use engine InnoDB
      10:49:38,954 INFO [VerifyMySQL:36] Updating table tasksreview to use engine InnoDB
      10:49:39,100 INFO [VerifyMySQL:36] Updating table team to use engine InnoDB
      10:49:39,245 INFO [VerifyMySQL:36] Updating table ticket to use engine InnoDB
      10:49:39,393 INFO [VerifyMySQL:36] Updating table user_ to use engine InnoDB
      10:49:39,550 INFO [VerifyMySQL:36] Updating table usergroup to use engine InnoDB
      10:49:39,696 INFO [VerifyMySQL:36] Updating table usergroupgrouprole to use engine InnoDB
      10:49:39,865 INFO [VerifyMySQL:36] Updating table usergrouprole to use engine InnoDB
      10:49:40,000 INFO [VerifyMySQL:36] Updating table useridmapper to use engine InnoDB
      10:49:40,145 INFO [VerifyMySQL:36] Updating table users_groups to use engine InnoDB
      10:49:40,280 INFO [VerifyMySQL:36] Updating table users_orgs to use engine InnoDB
      10:49:40,415 INFO [VerifyMySQL:36] Updating table users_permissions to use engine InnoDB
      10:49:40,551 INFO [VerifyMySQL:36] Updating table users_roles to use engine InnoDB
      10:49:40,686 INFO [VerifyMySQL:36] Updating table users_teams to use engine InnoDB
      10:49:40,821 INFO [VerifyMySQL:36] Updating table users_usergroups to use engine InnoDB
      10:49:40,956 INFO [VerifyMySQL:36] Updating table usertracker to use engine InnoDB
      10:49:41,102 INFO [VerifyMySQL:36] Updating table usertrackerpath to use engine InnoDB
      10:49:41,259 INFO [VerifyMySQL:36] Updating table webdavprops to use engine InnoDB
      10:49:41,406 INFO [VerifyMySQL:36] Updating table website to use engine InnoDB
      10:49:41,541 INFO [VerifyMySQL:36] Updating table wikinode to use engine InnoDB
      10:49:41,698 INFO [VerifyMySQL:36] Updating table wikipage to use engine InnoDB
      10:49:41,855 INFO [VerifyMySQL:36] Updating table wikipageresource to use engine InnoDB
      10:49:42,001 INFO [VerifyMySQL:36] Updating table workflowdefinitionlink to use engine InnoDB
      10:49:42,147 INFO [VerifyMySQL:36] Updating table workflowinstancelink to use engine InnoDB
      10:49:42,304 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyCounter
      10:49:42,395 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyUUID
      10:49:42,417 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyRole
      10:49:42,423 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyBlogs
      10:49:42,532 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyBookmarks
      10:49:42,550 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyCalendar
      10:49:42,560 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyDocumentLibrary
      10:49:42,570 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyGroup
      10:49:42,595 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyImageGallery
      10:49:42,603 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyJournal
      10:49:42,625 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyLayout
      10:49:42,633 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyMessageBoards
      10:49:42,668 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyOrganization
      10:49:42,671 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifySocial
      10:49:42,672 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyUser
      10:49:42,694 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyWiki

        Activity

        Hide
        Ian White added a comment -

        The problem is related to using MySL with UTF-8 encoding - it makes the key storage much larger apparently.

        FIX: stop using MySQL and start using postgreSQL. It's much faster anyway.

        IMHO, don't expect MySQL to get any better now that Oracle own it !

        Show
        Ian White added a comment - The problem is related to using MySL with UTF-8 encoding - it makes the key storage much larger apparently. FIX: stop using MySQL and start using postgreSQL. It's much faster anyway. IMHO, don't expect MySQL to get any better now that Oracle own it !
        Hide
        Michael Saechang added a comment -

        MySQL Issue

        Show
        Michael Saechang added a comment - MySQL Issue

          People

          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Days since last comment:
              4 years, 5 weeks ago

              Development

                Structure Helper Panel