Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Krzysztof Gołębiowski
Upgrade from 6.1.1 GA2 CE to 6.2 GA1 CE fails with SQLGrammarException
November 5, 2013 6:08 AM
Answer

Krzysztof Gołębiowski

Rank: Liferay Master

Posts: 508

Join Date: June 25, 2011

Recent Posts

Hello Everybody,
I just tried my first upgrade from 6.1.1 to 6.2 and failed emoticon I am migrating portal that contains wiki pages and few files in document library. Database is Postgres 9.1.9, operating system Ubuntu 11.10. I don't have any uncommon/suspicious entries in portal-ext.properties, no plugins installed. Log trace is as follows:


13:07:37,724 INFO [localhost-startStop-1][DialectDetector:71] Determine dialect for PostgreSQL 9
13:07:37,817 INFO [localhost-startStop-1][DialectDetector:136] Found dialect org.hibernate.dialect.PostgreSQLDialect
Starting Liferay Portal Community Edition 6.2.0 CE GA1 (Newton / Build 6200 / November 1, 2013)
13:08:29,610 INFO [localhost-startStop-1][BaseDB:481] Database supports case sensitive queries
13:08:30,493 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_2_0
13:08:30,499 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeSchema
13:08:31,669 WARN [localhost-startStop-1][BaseDB:457] ERROR: index "ix_8db864a9" does not exist: drop index IX_8DB864A9;_
13:08:32,143 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeAnnouncements
13:08:32,169 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeAssetPublisher
13:08:32,478 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeBlogs
13:08:32,611 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeBlogsAggregator
13:08:32,615 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeCalendar
13:08:33,095 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeCompany
13:08:33,394 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeCustomizablePortlets
13:08:33,412 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeDocumentLibrary
13:08:33,841 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeDynamicDataListDisplay
13:08:33,859 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeDynamicDataMapping
13:08:34,396 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeGroup
13:08:34,491 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeImageGallery
13:08:34,560 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeJournal
13:08:34,585 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeLayout
13:08:34,589 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutFriendlyURL
13:08:34,638 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutRevision
13:08:34,640 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutSet
13:08:34,643 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutSetBranch
13:08:34,645 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeMessageBoards
13:08:34,648 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeMessageBoardsAttachments
13:08:34,654 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradePortletItem
13:08:34,680 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradePortletPreferences
13:08:34,783 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeRepository
13:08:34,807 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeSearch
13:08:34,816 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeSocial
13:08:36,032 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeUser
13:08:36,063 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeWiki
13:08:36,090 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeWikiAttachments
13:08:37,509 INFO [localhost-startStop-1][BaseDB:75] Adding indexes
13:08:37,516 INFO [localhost-startStop-1][BaseDB:98] create index IX_381E55DA on Address (uuid_);
13:08:37,568 INFO [localhost-startStop-1][BaseDB:98] create index IX_8FCB620E on Address (uuid_, companyId);
13:08:37,592 INFO [localhost-startStop-1][BaseDB:98] create index IX_F2949120 on AnnouncementsEntry (uuid_, companyId);
13:08:37,595 INFO [localhost-startStop-1][BaseDB:98] create index IX_C7F39FCA on AssetCategory (groupId, name, vocabularyId);
13:08:37,598 INFO [localhost-startStop-1][BaseDB:98] create index IX_852EA801 on AssetCategory (groupId, parentCategoryId, name, vocabularyId);
13:08:37,601 INFO [localhost-startStop-1][BaseDB:98] create index IX_87603842 on AssetCategory (groupId, parentCategoryId, vocabularyId);
13:08:37,603 INFO [localhost-startStop-1][BaseDB:98] create index IX_BBAF6928 on AssetCategory (uuid_, companyId);
13:08:37,605 INFO [localhost-startStop-1][BaseDB:98] create index IX_FEC4A201 on AssetEntry (layoutUuid);
13:08:37,609 INFO [localhost-startStop-1][BaseDB:98] create index IX_C4E6FD10 on AssetVocabulary (uuid_, companyId);
13:08:37,611 INFO [localhost-startStop-1][BaseDB:98] create index IX_C5A6C78F on BackgroundTask (companyId);
13:08:37,613 INFO [localhost-startStop-1][BaseDB:98] create index IX_5A09E5D1 on BackgroundTask (groupId);
13:08:37,622 INFO [localhost-startStop-1][BaseDB:98] create index IX_98CC0AAB on BackgroundTask (groupId, name, taskExecutorClassName);
13:08:37,626 INFO [localhost-startStop-1][BaseDB:98] create index IX_579C63B0 on BackgroundTask (groupId, name, taskExecutorClassName, completed);
13:08:37,639 INFO [localhost-startStop-1][BaseDB:98] create index IX_C71C3B7 on BackgroundTask (groupId, status);
13:08:37,641 INFO [localhost-startStop-1][BaseDB:98] create index IX_A73B688A on BackgroundTask (groupId, taskExecutorClassName);
13:08:37,643 INFO [localhost-startStop-1][BaseDB:98] create index IX_7A9FF471 on BackgroundTask (groupId, taskExecutorClassName, completed);
13:08:37,645 INFO [localhost-startStop-1][BaseDB:98] create index IX_7E757D70 on BackgroundTask (groupId, taskExecutorClassName, status);
13:08:37,647 INFO [localhost-startStop-1][BaseDB:98] create index IX_C07CC7F8 on BackgroundTask (name);
13:08:37,649 INFO [localhost-startStop-1][BaseDB:98] create index IX_75638CDF on BackgroundTask (status);
13:08:37,651 INFO [localhost-startStop-1][BaseDB:98] create index IX_2FCFE748 on BackgroundTask (taskExecutorClassName, status);
13:08:37,653 INFO [localhost-startStop-1][BaseDB:98] create index IX_5E8307BB on BlogsEntry (uuid_, companyId);
13:08:37,655 INFO [localhost-startStop-1][BaseDB:98] create index IX_1F90CA2D on BookmarksEntry (companyId);
13:08:37,657 INFO [localhost-startStop-1][BaseDB:98] create index IX_276C8C13 on BookmarksEntry (companyId, status);
13:08:37,659 INFO [localhost-startStop-1][BaseDB:98] create index IX_146382F2 on BookmarksEntry (groupId, folderId, status);
13:08:37,661 INFO [localhost-startStop-1][BaseDB:98] create index IX_416AD7D5 on BookmarksEntry (groupId, status);
13:08:37,663 INFO [localhost-startStop-1][BaseDB:98] create index IX_C78B61AC on BookmarksEntry (groupId, userId, folderId, status);
13:08:37,678 INFO [localhost-startStop-1][BaseDB:98] create index IX_9D9CF70F on BookmarksEntry (groupId, userId, status);
13:08:37,682 INFO [localhost-startStop-1][BaseDB:98] create index IX_89BEDC4F on BookmarksEntry (uuid_, companyId);
13:08:37,684 INFO [localhost-startStop-1][BaseDB:98] create index IX_C27C9DBD on BookmarksFolder (companyId, status);
13:08:37,686 INFO [localhost-startStop-1][BaseDB:98] create index IX_D16018A6 on BookmarksFolder (groupId, parentFolderId, status);
13:08:37,695 INFO [localhost-startStop-1][BaseDB:98] create index IX_54F0ED65 on BookmarksFolder (uuid_, companyId);
13:08:37,698 INFO [localhost-startStop-1][BaseDB:98] create index IX_299639C6 on CalEvent (uuid_, companyId);
13:08:37,700 INFO [localhost-startStop-1][BaseDB:98] create index IX_B8C28C53 on Contact_ (accountId);
13:08:37,703 INFO [localhost-startStop-1][BaseDB:98] create index IX_791914FA on Contact_ (classNameId, classPK);
13:08:37,709 INFO [localhost-startStop-1][BaseDB:98] create index IX_6A6C1C85 on DDLRecord (companyId);
13:08:37,723 INFO [localhost-startStop-1][BaseDB:98] create index IX_384AB6F7 on DDLRecord (uuid_, companyId);
13:08:37,726 INFO [localhost-startStop-1][BaseDB:98] create index IX_5938C39F on DDLRecordSet (uuid_, companyId);
13:08:37,728 INFO [localhost-startStop-1][BaseDB:98] create index IX_3A9C0626 on DDMContent (uuid_, companyId);
13:08:37,729 INFO [localhost-startStop-1][BaseDB:98] create index IX_4FBAC092 on DDMStructure (companyId, classNameId);
13:08:37,731 INFO [localhost-startStop-1][BaseDB:98] create index IX_B6ED5E50 on DDMStructure (groupId, classNameId);
13:08:37,766 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_C8785130 on DDMStructure (groupId, classNameId, structureKey);
13:08:37,768 INFO [localhost-startStop-1][BaseDB:98] create index IX_43395316 on DDMStructure (groupId, parentStructureId);
13:08:37,770 INFO [localhost-startStop-1][BaseDB:98] create index IX_657899A8 on DDMStructure (parentStructureId);
13:08:37,772 INFO [localhost-startStop-1][BaseDB:98] create index IX_20FDE04C on DDMStructure (structureKey);
13:08:37,774 INFO [localhost-startStop-1][BaseDB:98] create index IX_F9FB8D60 on DDMStructure (uuid_, companyId);
13:08:37,785 INFO [localhost-startStop-1][BaseDB:98] create index IX_B6356F93 on DDMTemplate (classNameId, classPK, type_);
13:08:37,787 INFO [localhost-startStop-1][BaseDB:98] create index IX_32F83D16 on DDMTemplate (classPK);
13:08:37,789 INFO [localhost-startStop-1][BaseDB:98] create index IX_BD9A4A91 on DDMTemplate (groupId, classNameId);
13:08:37,791 INFO [localhost-startStop-1][BaseDB:98] create index IX_824ADC72 on DDMTemplate (groupId, classNameId, classPK);
13:08:37,792 INFO [localhost-startStop-1][BaseDB:98] create index IX_90800923 on DDMTemplate (groupId, classNameId, classPK, type_);
13:08:37,794 INFO [localhost-startStop-1][BaseDB:98] create index IX_F0C3449 on DDMTemplate (groupId, classNameId, classPK, type_, mode_);
13:08:37,796 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_E6DFAB84 on DDMTemplate (groupId, classNameId, templateKey);
13:08:37,798 INFO [localhost-startStop-1][BaseDB:98] create index IX_B1C33EA6 on DDMTemplate (groupId, classPK);
13:08:37,799 INFO [localhost-startStop-1][BaseDB:98] create index IX_127A35B0 on DDMTemplate (smallImageId);
13:08:37,801 INFO [localhost-startStop-1][BaseDB:98] create index IX_CAE41A28 on DDMTemplate (templateKey);
13:08:37,803 INFO [localhost-startStop-1][BaseDB:98] create index IX_D4C2C221 on DDMTemplate (uuid_, companyId);
13:08:37,805 INFO [localhost-startStop-1][BaseDB:98] create index IX_772ECDE7 on DLFileEntry (fileEntryTypeId);
13:08:37,813 INFO [localhost-startStop-1][BaseDB:98] create index IX_8F6C75D0 on DLFileEntry (folderId, name);
13:08:37,814 INFO [localhost-startStop-1][BaseDB:98] create index IX_D9492CF6 on DLFileEntry (mimeType);
13:08:37,817 INFO [localhost-startStop-1][BaseDB:98] create index IX_31079DE8 on DLFileEntry (uuid_, companyId);
13:08:37,819 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_5B6BEF5F on DLFileEntryType (groupId, fileEntryTypeKey);
13:08:37,821 INFO [localhost-startStop-1][BaseDB:98] create index IX_5B03E942 on DLFileEntryType (uuid_, companyId);
13:08:37,823 INFO [localhost-startStop-1][BaseDB:98] create index IX_4E96195B on DLFileRank (groupId, userId, active_);
13:08:37,825 INFO [localhost-startStop-1][BaseDB:98] create index IX_A4BB2E58 on DLFileShortcut (companyId);
13:08:37,826 INFO [localhost-startStop-1][BaseDB:98] create index IX_8571953E on DLFileShortcut (companyId, status);
13:08:37,828 INFO [localhost-startStop-1][BaseDB:98] create index IX_348DC3B2 on DLFileShortcut (groupId, folderId, active_);
13:08:37,830 INFO [localhost-startStop-1][BaseDB:98] create index IX_17EE3098 on DLFileShortcut (groupId, folderId, active_, status);
13:08:37,831 INFO [localhost-startStop-1][BaseDB:98] create index IX_29AE81C4 on DLFileShortcut (uuid_, companyId);
13:08:37,833 INFO [localhost-startStop-1][BaseDB:98] create index IX_F389330E on DLFileVersion (companyId);
13:08:37,834 INFO [localhost-startStop-1][BaseDB:98] create index IX_A0A283F4 on DLFileVersion (companyId, status);
13:08:37,836 INFO [localhost-startStop-1][BaseDB:98] create index IX_FFB3395C on DLFileVersion (mimeType);
13:08:37,838 INFO [localhost-startStop-1][BaseDB:98] create index IX_95E9E44E on DLFileVersion (uuid_, companyId);
13:08:37,840 INFO [localhost-startStop-1][BaseDB:98] create index IX_E79BE432 on DLFolder (companyId, status);
13:08:37,841 INFO [localhost-startStop-1][BaseDB:98] create index IX_F78286C5 on DLFolder (groupId, mountPoint, parentFolderId, hidden_);
13:08:37,843 INFO [localhost-startStop-1][BaseDB:98] create index IX_C88430AB on DLFolder (groupId, mountPoint, parentFolderId, hidden_, status);
13:08:37,845 INFO [localhost-startStop-1][BaseDB:98] create index IX_CE360BF6 on DLFolder (groupId, parentFolderId, hidden_, status);
13:08:37,863 INFO [localhost-startStop-1][BaseDB:98] create index IX_DA448450 on DLFolder (uuid_, companyId);
13:08:37,866 INFO [localhost-startStop-1][BaseDB:98] create index IX_3D8E1607 on DLSyncEvent (modifiedTime);
13:08:37,869 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_57D82B06 on DLSyncEvent (typePK);
13:08:37,871 INFO [localhost-startStop-1][BaseDB:98] create index IX_D24F3956 on EmailAddress (uuid_);
13:08:37,875 INFO [localhost-startStop-1][BaseDB:98] create index IX_F74AB912 on EmailAddress (uuid_, companyId);
13:08:37,877 INFO [localhost-startStop-1][BaseDB:98] create index IX_49EB3118 on ExpandoRow (classPK);
13:08:37,880 INFO [localhost-startStop-1][BaseDB:98] create index IX_B584B5CC on Group_ (companyId, classNameId);
13:08:37,883 INFO [localhost-startStop-1][BaseDB:98] create index IX_ABE2D54 on Group_ (companyId, classNameId, parentGroupId);
13:08:37,885 INFO [localhost-startStop-1][BaseDB:98] create index IX_5D75499E on Group_ (companyId, parentGroupId);
13:08:37,888 INFO [localhost-startStop-1][BaseDB:98] create index IX_6C499099 on Group_ (companyId, parentGroupId, site);
13:08:37,900 INFO [localhost-startStop-1][BaseDB:98] create index IX_63A2AABD on Group_ (companyId, site);
13:08:37,903 INFO [localhost-startStop-1][BaseDB:98] create index IX_F981514E on Group_ (uuid_);
13:08:37,904 INFO [localhost-startStop-1][BaseDB:98] create index IX_26CC761A on Group_ (uuid_, companyId);
13:08:37,912 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_754FBB1C on Group_ (uuid_, groupId);
13:08:37,916 INFO [localhost-startStop-1][BaseDB:98] create index IX_EA05E9E1 on JournalArticle (displayDate, status);
13:08:37,920 INFO [localhost-startStop-1][BaseDB:98] create index IX_5CD17502 on JournalArticle (groupId, folderId);
13:08:37,923 INFO [localhost-startStop-1][BaseDB:98] create index IX_F35391E8 on JournalArticle (groupId, folderId, status);
13:08:37,925 INFO [localhost-startStop-1][BaseDB:98] create index IX_D19C1B9F on JournalArticle (groupId, userId);
13:08:37,927 INFO [localhost-startStop-1][BaseDB:98] create index IX_43A0F80F on JournalArticle (groupId, userId, classNameId);
13:08:37,929 INFO [localhost-startStop-1][BaseDB:98] create index IX_3F1EA19E on JournalArticle (layoutUuid);
13:08:37,931 INFO [localhost-startStop-1][BaseDB:98] create index IX_89FF8B06 on JournalArticle (resourcePrimKey, indexable);
13:08:37,933 INFO [localhost-startStop-1][BaseDB:98] create index IX_451D63EC on JournalArticle (resourcePrimKey, indexable, status);
13:08:37,945 INFO [localhost-startStop-1][BaseDB:98] create index IX_71520099 on JournalArticle (uuid_, companyId);
13:08:37,947 INFO [localhost-startStop-1][BaseDB:98] create index IX_8DAF8A35 on JournalContentSearch (portletId);
13:08:37,950 INFO [localhost-startStop-1][BaseDB:98] create index IX_CB37A10F on JournalFeed (uuid_, companyId);
13:08:38,002 INFO [localhost-startStop-1][BaseDB:98] create index IX_E6E2725D on JournalFolder (companyId);
13:08:38,009 INFO [localhost-startStop-1][BaseDB:98] create index IX_C36B0443 on JournalFolder (companyId, status);
13:08:38,011 INFO [localhost-startStop-1][BaseDB:98] create index IX_742DEC1F on JournalFolder (groupId);
13:08:38,013 INFO [localhost-startStop-1][BaseDB:98] create index IX_E988689E on JournalFolder (groupId, name);
13:08:38,028 INFO [localhost-startStop-1][BaseDB:98] create index IX_190483C6 on JournalFolder (groupId, parentFolderId);
13:08:38,030 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_65026705 on JournalFolder (groupId, parentFolderId, name);
13:08:38,032 INFO [localhost-startStop-1][BaseDB:98] create index IX_EFD9CAC on JournalFolder (groupId, parentFolderId, status);
13:08:38,034 INFO [localhost-startStop-1][BaseDB:98] create index IX_63BDFA69 on JournalFolder (uuid_);
13:08:38,036 INFO [localhost-startStop-1][BaseDB:98] create index IX_54F89E1F on JournalFolder (uuid_, companyId);
13:08:38,038 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_E002061 on JournalFolder (uuid_, groupId);
13:08:38,040 INFO [localhost-startStop-1][BaseDB:98] create index IX_39A18ECC on Layout (sourcePrototypeLayoutUuid);
13:08:38,043 INFO [localhost-startStop-1][BaseDB:98] create index IX_2CE4BE84 on Layout (uuid_, companyId);
13:08:38,045 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_E118C537 on Layout (uuid_, groupId, privateLayout);
13:08:38,048 INFO [localhost-startStop-1][BaseDB:98] create index IX_EAB317C8 on LayoutFriendlyURL (companyId);
13:08:38,051 INFO [localhost-startStop-1][BaseDB:98] create index IX_742EF04A on LayoutFriendlyURL (groupId);
13:08:38,053 INFO [localhost-startStop-1][BaseDB:98] create index IX_CA713461 on LayoutFriendlyURL (groupId, privateLayout, friendlyURL);
13:08:38,056 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_A6FC2B28 on LayoutFriendlyURL (groupId, privateLayout, friendlyURL, languageId);
13:08:38,059 INFO [localhost-startStop-1][BaseDB:98] create index IX_83AE56AB on LayoutFriendlyURL (plid);
13:08:38,061 INFO [localhost-startStop-1][BaseDB:98] create index IX_59051329 on LayoutFriendlyURL (plid, friendlyURL);
13:08:38,063 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_C5762E72 on LayoutFriendlyURL (plid, languageId);
13:08:38,066 INFO [localhost-startStop-1][BaseDB:98] create index IX_9F80D54 on LayoutFriendlyURL (uuid_);
13:08:38,068 INFO [localhost-startStop-1][BaseDB:98] create index IX_F4321A54 on LayoutFriendlyURL (uuid_, companyId);
13:08:38,070 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_326525D6 on LayoutFriendlyURL (uuid_, groupId);
13:08:38,071 INFO [localhost-startStop-1][BaseDB:98] create index IX_63ED2532 on LayoutPrototype (uuid_, companyId);
13:08:38,075 INFO [localhost-startStop-1][BaseDB:98] create index IX_CCF0DA29 on LayoutSetBranch (groupId, privateLayout, master);
13:08:38,077 INFO [localhost-startStop-1][BaseDB:98] create index IX_D9FFCA84 on LayoutSetPrototype (uuid_, companyId);
13:08:38,080 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_228562AD on Lock_ (className, key_);
13:08:38,082 INFO [localhost-startStop-1][BaseDB:98] create index IX_2C418EAE on Lock_ (uuid_, companyId);
13:08:38,084 INFO [localhost-startStop-1][BaseDB:98] create index IX_8A13C634 on MBBan (uuid_);
13:08:38,087 INFO [localhost-startStop-1][BaseDB:98] create index IX_4F841574 on MBBan (uuid_, companyId);
13:08:38,091 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_2A3B68F6 on MBBan (uuid_, groupId);
13:08:38,093 INFO [localhost-startStop-1][BaseDB:98] create index IX_E15A5DB5 on MBCategory (companyId, status);
13:08:38,104 INFO [localhost-startStop-1][BaseDB:98] create index IX_C295DBEE on MBCategory (groupId, parentCategoryId, status);
13:08:38,109 INFO [localhost-startStop-1][BaseDB:98] create index IX_DA84A9F7 on MBCategory (groupId, status);
13:08:38,111 INFO [localhost-startStop-1][BaseDB:98] create index IX_13DF4E6D on MBCategory (uuid_, companyId);
13:08:38,113 INFO [localhost-startStop-1][BaseDB:98] create index IX_5477D431 on MBDiscussion (uuid_);
13:08:38,115 INFO [localhost-startStop-1][BaseDB:98] create index IX_7E965757 on MBDiscussion (uuid_, companyId);
13:08:38,116 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_F7AAC799 on MBDiscussion (uuid_, groupId);
13:08:38,118 INFO [localhost-startStop-1][BaseDB:98] create index IX_FC61676E on MBMailingList (uuid_, companyId);
13:08:38,120 INFO [localhost-startStop-1][BaseDB:98] create index IX_57CA9FEC on MBMessage (uuid_, companyId);
13:08:38,122 INFO [localhost-startStop-1][BaseDB:98] create index IX_7E264A0F on MBThread (uuid_);
13:08:38,124 INFO [localhost-startStop-1][BaseDB:98] create index IX_F8CA2AB9 on MBThread (uuid_, companyId);
13:08:38,127 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_3A200B7B on MBThread (uuid_, groupId);
13:08:38,128 INFO [localhost-startStop-1][BaseDB:98] create index IX_F36BBB83 on MBThreadFlag (uuid_);
13:08:38,130 INFO [localhost-startStop-1][BaseDB:98] create index IX_DCE308C5 on MBThreadFlag (uuid_, companyId);
13:08:38,132 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_FEB0FC87 on MBThreadFlag (uuid_, groupId);
13:08:38,133 INFO [localhost-startStop-1][BaseDB:98] create index IX_C58A516B on MDRAction (uuid_, companyId);
13:08:38,136 INFO [localhost-startStop-1][BaseDB:98] create index IX_7DEA8DF1 on MDRRule (uuid_, companyId);
13:08:38,139 INFO [localhost-startStop-1][BaseDB:98] create index IX_CC14DC2 on MDRRuleGroup (uuid_, companyId);
13:08:38,140 INFO [localhost-startStop-1][BaseDB:98] create index IX_25C9D1F7 on MDRRuleGroupInstance (uuid_, companyId);
13:08:38,142 INFO [localhost-startStop-1][BaseDB:98] create index IX_396D6B42 on Organization_ (uuid_);
13:08:38,144 INFO [localhost-startStop-1][BaseDB:98] create index IX_A9D85BA6 on Organization_ (uuid_, companyId);
13:08:38,145 INFO [localhost-startStop-1][BaseDB:98] create index IX_8FEE65F5 on PasswordPolicy (companyId);
13:08:38,147 INFO [localhost-startStop-1][BaseDB:98] create index IX_51437A01 on PasswordPolicy (uuid_);
13:08:38,149 INFO [localhost-startStop-1][BaseDB:98] create index IX_E4D7EF87 on PasswordPolicy (uuid_, companyId);
13:08:38,150 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_C3A17327 on PasswordPolicyRel (classNameId, classPK);
13:08:38,152 INFO [localhost-startStop-1][BaseDB:98] create index IX_EA6245A0 on Phone (uuid_);
13:08:38,154 INFO [localhost-startStop-1][BaseDB:98] create index IX_B271FA88 on Phone (uuid_, companyId);
13:08:38,155 INFO [localhost-startStop-1][BaseDB:98] create index IX_8AE746EF on PollsChoice (uuid_, companyId);
13:08:38,158 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_C222BD31 on PollsChoice (uuid_, groupId);
13:08:38,160 INFO [localhost-startStop-1][BaseDB:98] create index IX_F910BBB4 on PollsQuestion (uuid_, companyId);
13:08:38,162 INFO [localhost-startStop-1][BaseDB:98] create index IX_FD32EB70 on PollsVote (uuid_);
13:08:38,163 INFO [localhost-startStop-1][BaseDB:98] create index IX_7D8E92B8 on PollsVote (uuid_, companyId);
13:08:38,166 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_A88C673A on PollsVote (uuid_, groupId);
13:08:38,168 INFO [localhost-startStop-1][BaseDB:98] create index IX_C9A3FCE2 on PortletPreferences (ownerId, ownerType, portletId);
13:08:38,170 INFO [localhost-startStop-1][BaseDB:98] create index IX_A3B2A80C on PortletPreferences (ownerType, portletId);
13:08:38,175 INFO [localhost-startStop-1][BaseDB:98] create index IX_8E6DA3A1 on PortletPreferences (portletId);
13:08:38,178 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_60C8634C on Repository (groupId, name, portletId);
13:08:38,218 INFO [localhost-startStop-1][BaseDB:98] create index IX_F543EA4 on Repository (uuid_, companyId);
13:08:38,225 INFO [localhost-startStop-1][BaseDB:98] create index IX_D3B9AF62 on RepositoryEntry (uuid_, companyId);
13:08:38,243 INFO [localhost-startStop-1][BaseDB:98] create index IX_20A2E3D9 on ResourceBlockPermission (roleId);
13:08:38,246 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_8D83D0CE on ResourcePermission (companyId, name, scope, primKey, roleId);
13:08:38,277 INFO [localhost-startStop-1][BaseDB:98] create index IX_F3E1C6FC on Role_ (companyId, type_);
13:08:38,393 INFO [localhost-startStop-1][BaseDB:98] create index IX_F92B66E6 on Role_ (type_);
13:08:38,396 INFO [localhost-startStop-1][BaseDB:98] create index IX_26DB26C5 on Role_ (uuid_);
13:08:38,398 INFO [localhost-startStop-1][BaseDB:98] create index IX_B9FF6043 on Role_ (uuid_, companyId);
13:08:38,416 INFO [localhost-startStop-1][BaseDB:98] create index IX_F542E9BC on SocialActivity (activitySetId);
13:08:38,419 INFO [localhost-startStop-1][BaseDB:98] create index IX_D0E9029E on SocialActivity (classNameId, classPK, type_);
13:08:38,427 INFO [localhost-startStop-1][BaseDB:98] create index IX_D6666704 on SocialActivityCounter (groupId);
13:08:38,430 INFO [localhost-startStop-1][BaseDB:98] create index IX_18D4BAE5 on SocialActivityLimit (groupId);
13:08:38,432 INFO [localhost-startStop-1][BaseDB:98] create index IX_6F9EDE9F on SocialActivityLimit (userId);
13:08:38,437 INFO [localhost-startStop-1][BaseDB:98] create index IX_4460FA14 on SocialActivitySet (classNameId, classPK, type_);
13:08:38,443 INFO [localhost-startStop-1][BaseDB:98] create index IX_9E13F2DE on SocialActivitySet (groupId);
13:08:38,447 INFO [localhost-startStop-1][BaseDB:98] create index IX_9BE30DDF on SocialActivitySet (groupId, userId, classNameId, type_);
13:08:38,450 INFO [localhost-startStop-1][BaseDB:98] create index IX_F71071BD on SocialActivitySet (groupId, userId, type_);
13:08:38,462 INFO [localhost-startStop-1][BaseDB:98] create index IX_F80C4386 on SocialActivitySet (userId);
13:08:38,471 INFO [localhost-startStop-1][BaseDB:98] create index IX_62AC101A on SocialActivitySet (userId, classNameId, classPK, type_);
13:08:38,478 INFO [localhost-startStop-1][BaseDB:98] create index IX_8BE5F230 on SocialActivitySetting (groupId);
13:08:38,482 INFO [localhost-startStop-1][BaseDB:98] create index IX_9D22151E on SocialActivitySetting (groupId, classNameId);
13:08:38,485 INFO [localhost-startStop-1][BaseDB:98] create index IX_5B30F663 on SocialRelation (uuid_, companyId);
13:08:38,489 INFO [localhost-startStop-1][BaseDB:98] create index IX_8D42897C on SocialRequest (uuid_, companyId);
13:08:38,497 INFO [localhost-startStop-1][BaseDB:98] create index IX_72D73D39 on SystemEvent (groupId);
13:08:38,503 INFO [localhost-startStop-1][BaseDB:98] create index IX_7A2F0ECE on SystemEvent (groupId, classNameId, classPK);
13:08:38,514 INFO [localhost-startStop-1][BaseDB:98] create index IX_FFCBB747 on SystemEvent (groupId, classNameId, classPK, type_);
13:08:38,557 INFO [localhost-startStop-1][BaseDB:98] create index IX_A19C89FF on SystemEvent (groupId, systemEventSetKey);
13:08:38,585 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_B35F73D5 on TrashEntry (classNameId, classPK);
13:08:38,612 INFO [localhost-startStop-1][BaseDB:98] create index IX_2674F2A8 on TrashEntry (companyId);
13:08:38,629 INFO [localhost-startStop-1][BaseDB:98] create index IX_526A032A on TrashEntry (groupId);
13:08:38,637 INFO [localhost-startStop-1][BaseDB:98] create index IX_FC4EEA64 on TrashEntry (groupId, classNameId);
13:08:38,674 INFO [localhost-startStop-1][BaseDB:98] create index IX_6CAAE2E8 on TrashEntry (groupId, createDate);
13:08:38,689 INFO [localhost-startStop-1][BaseDB:98] create index IX_630A643B on TrashVersion (classNameId, classPK);
13:08:38,694 INFO [localhost-startStop-1][BaseDB:98] create index IX_55D44577 on TrashVersion (entryId);
13:08:38,700 INFO [localhost-startStop-1][BaseDB:98] create index IX_72D58D37 on TrashVersion (entryId, classNameId);
13:08:38,703 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_D639348C on TrashVersion (entryId, classNameId, classPK);
13:08:38,706 INFO [localhost-startStop-1][BaseDB:98] create index IX_5F1DD85A on UserGroup (uuid_);
13:08:38,709 INFO [localhost-startStop-1][BaseDB:98] create index IX_72394F8E on UserGroup (uuid_, companyId);
13:08:38,711 INFO [localhost-startStop-1][BaseDB:98] create index IX_C648700A on UserNotificationDelivery (userId);
13:08:38,714 INFO [localhost-startStop-1][BaseDB:98] create unique index IX_8B6E3ACE on UserNotificationDelivery (userId, portletId, classNameId, notificationType, deliveryType);
13:08:38,718 INFO [localhost-startStop-1][BaseDB:98] create index IX_24F1BF0 on UserNotificationEvent (userId, delivered);
13:08:38,724 INFO [localhost-startStop-1][BaseDB:98] create index IX_A6BAFDFE on UserNotificationEvent (uuid_, companyId);
13:08:38,728 INFO [localhost-startStop-1][BaseDB:98] create index IX_740C4D0C on User_ (companyId, createDate);
13:08:38,732 INFO [localhost-startStop-1][BaseDB:98] create index IX_BCFDA257 on User_ (companyId, createDate, modifiedDate);
13:08:38,734 INFO [localhost-startStop-1][BaseDB:98] create index IX_EE8ABD19 on User_ (companyId, modifiedDate);
13:08:38,737 INFO [localhost-startStop-1][BaseDB:98] create index IX_405CC0E on User_ (uuid_, companyId);
13:08:38,739 INFO [localhost-startStop-1][BaseDB:98] create index IX_76F15D13 on Website (uuid_);
13:08:38,741 INFO [localhost-startStop-1][BaseDB:98] create index IX_712BCD35 on Website (uuid_, companyId);
13:08:38,743 INFO [localhost-startStop-1][BaseDB:98] create index IX_B54332D6 on WikiNode (companyId, status);
13:08:38,746 INFO [localhost-startStop-1][BaseDB:98] create index IX_23325358 on WikiNode (groupId, status);
13:08:38,748 INFO [localhost-startStop-1][BaseDB:98] create index IX_E0E6D12C on WikiNode (uuid_, companyId);
13:08:38,749 INFO [localhost-startStop-1][BaseDB:98] create index IX_16E99B0A on WikiPage (groupId, nodeId, head);
13:08:38,753 INFO [localhost-startStop-1][BaseDB:98] create index IX_BA72B89A on WikiPage (groupId, nodeId, head, parentTitle, status);
13:08:38,757 INFO [localhost-startStop-1][BaseDB:98] create index IX_E0092FF0 on WikiPage (groupId, nodeId, head, status);
13:08:38,762 INFO [localhost-startStop-1][BaseDB:98] create index IX_941E429C on WikiPage (groupId, nodeId, status);
13:08:38,764 INFO [localhost-startStop-1][BaseDB:98] create index IX_5FF21CE6 on WikiPage (groupId, nodeId, title, head);
13:08:38,769 INFO [localhost-startStop-1][BaseDB:98] create index IX_CAA451D6 on WikiPage (groupId, userId, nodeId, status);
13:08:38,772 INFO [localhost-startStop-1][BaseDB:98] create index IX_40F94F68 on WikiPage (nodeId, head, redirectTitle, status);
13:08:38,774 INFO [localhost-startStop-1][BaseDB:98] create index IX_85E7CC76 on WikiPage (resourcePrimKey);
13:08:38,776 INFO [localhost-startStop-1][BaseDB:98] create index IX_E1F55FB on WikiPage (resourcePrimKey, nodeId, head);
13:08:38,787 INFO [localhost-startStop-1][BaseDB:98] create index IX_1725355C on WikiPage (resourcePrimKey, status);
13:08:38,790 INFO [localhost-startStop-1][BaseDB:98] create index IX_5DC4BD39 on WikiPage (uuid_, companyId);
13:08:38,873 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyProcessSuite
13:08:38,874 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyProperties
13:08:38,973 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyDB2
13:08:38,974 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyMySQL
13:08:38,975 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyOracle
13:08:38,975 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifySQLServer
13:08:38,979 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyUUID
13:08:39,911 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyPermission
13:08:40,718 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyGroup
13:08:42,220 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyRole
13:08:42,578 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyAsset
13:08:42,591 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.util.UpgradeAssetPublisherManualEntries
13:08:42,612 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyAuditedModel
13:08:43,283 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyBlogs
13:08:43,299 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyBookmarks
13:08:43,393 ERROR [localhost-startStop-1][JDBCExceptionReporter:82] ERROR: column "/0/" does not exist_ Position: 38
13:08:43,607 ERROR [localhost-startStop-1][MainServlet:209] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
at com.liferay.portal.events.StartupAction.run(StartupAction.java:74)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1238)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:206)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:656)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1635)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:61)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:111)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:76)
at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:46)
at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:146)
at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:67)
at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:240)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:206)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:68)
... 20 more
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:61)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:66)
at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:40)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:58)
... 28 more
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:76)
at com.liferay.portal.kernel.util.TreePathUtil.rebuildTree(TreePathUtil.java:156)
at com.liferay.portal.kernel.util.TreePathUtil.rebuildTree(TreePathUtil.java:91)
at com.liferay.portlet.bookmarks.service.impl.BookmarksEntryLocalServiceImpl.rebuildTree(BookmarksEntryLocalServiceImpl.java:441)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
at $Proxy190.rebuildTree(Unknown Source)
at com.liferay.portlet.bookmarks.service.BookmarksEntryLocalServiceUtil.rebuildTree(BookmarksEntryLocalServiceUtil.java:486)
at com.liferay.portal.verify.VerifyBookmarks.verifyTree(VerifyBookmarks.java:100)
at com.liferay.portal.verify.VerifyBookmarks.doVerify(VerifyBookmarks.java:37)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:58)
... 31 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:219)
at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396)
at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:73)
... 47 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "/0/" does not exist_ Position: 38
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147)
at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:210)
... 50 more
Stopping the server due to unexpected startup errors


That's all I know, any ideas? Maybe anybody had the same problem?

Regards,
KG
David H Nebinger
RE: Upgrade from 6.1.1 GA2 CE to 6.2 GA1 CE fails with SQLGrammarException
November 5, 2013 7:31 AM
Answer

David H Nebinger

Community Moderator

Rank: Liferay Legend

Posts: 11793

Join Date: September 1, 2006

Recent Posts

This kind of crap happens every time Liferay does a major new release. For some crazy reason folks jump on board the new release expecting everything to be perfect, and typically it is not.

6.0 was not really 'stable' until 6.0.6.

6.1 was not really 'stable'; GA2 had problems that were known, the LCEpatchers.org site was the best version to run because at least it had latest patches applied. 6.1 GA3 is out, but I don't know how stable it actually is.

So now 6.2 is out and, once again, the early adopters are going to pay the price.
Jack Bakker
RE: Upgrade from 6.1.1 GA2 CE to 6.2 GA1 CE fails with SQLGrammarException
November 5, 2013 9:11 AM
Answer

Jack Bakker

Rank: Liferay Master

Posts: 883

Join Date: January 3, 2010

Recent Posts

Having used Liferay since v5.2.3, for CE I've noted that at least a GA3 release is needed for anything real (unless you are really good at patches yourself and/or have contacts you are willing to pay to get such). While I think a lot of stuff coming in v6.2 is VERY cool, there is no way I would think about using it for anything real at this point (it is only GA1 currently).

As a developer I am very appreciative of getting early experience with coming software. Unfortunately there are also non-developer marketing folks who think a GA release is a ready release. I keep having to say 'no' not yet, but wow, what's coming still will beat most else out there.

That... is the way it is.
Juan Gonzalez
RE: Upgrade from 6.1.1 GA2 CE to 6.2 GA1 CE fails with SQLGrammarException
November 5, 2013 11:41 PM
Answer

Juan Gonzalez

LIFERAY STAFF

Rank: Liferay Legend

Posts: 2947

Join Date: October 28, 2008

Recent Posts

Guess you're reproducing this issue:

https://issues.liferay.com/browse/LPS-41989
Krzysztof Gołębiowski
RE: Upgrade from 6.1.1 GA2 CE to 6.2 GA1 CE fails with SQLGrammarException
November 6, 2013 12:48 AM
Answer

Krzysztof Gołębiowski

Rank: Liferay Master

Posts: 508

Join Date: June 25, 2011

Recent Posts

I used to fix Liferay 6.0 and 6.1 for similar issues in the past. Fortunately this is my own "sandbox" portal, I realize 6.2 is be unstable and we have to deal with it for some time before it goes into any production environment.

According to upgrade bug, I started debugging it, found a solution (I was hoping for my first pull request to liferay core emoticon ) and then realized it was already fixed two days ago (https://github.com/liferay/liferay-portal/commit/2dae19b1a814fd5a9e5b4e9c1e87f2b3bd37e66a#diff-d4b6c39d7e2aa7bbc65695b3801aec4c).

Juan, it seems that this is the issue. I filed new one already (LPS-42047) and have to close it as duplicate.

Anyway, I will try to make a pull request to lcepatchers at least (althought they don't have branch for 6.2 yet).

Regards,
KG
Juan Gonzalez
RE: Upgrade from 6.1.1 GA2 CE to 6.2 GA1 CE fails with SQLGrammarException
November 6, 2013 1:04 AM
Answer

Juan Gonzalez

LIFERAY STAFF

Rank: Liferay Legend

Posts: 2947

Join Date: October 28, 2008

Recent Posts

Krzysztof Gołębiowski:
I used to fix Liferay 6.0 and 6.1 for similar issues in the past. Fortunately this is my own "sandbox" portal, I realize 6.2 is be unstable and we have to deal with it for some time before it goes into any production environment.


Hi Krzysztof,

yep, it is usually a good practice to upgrade first in a test environment to see what issues you're finding, or if they aren't issues and only a change in portal-ext.properties, etc..

Please if you find some issues post here so we can verify.
Michael Rohleder
RE: Upgrade from 6.1.1 GA2 CE to 6.2 GA1 CE fails with SQLGrammarException
November 8, 2013 9:34 PM
Answer

Michael Rohleder

Rank: New Member

Posts: 19

Join Date: July 30, 2013

Recent Posts

same issue here, upgrade from 6.1.2ga2 to 6.2ga1 with postgres 9.1.9

I think i didnt have that issue some weeks ago with 6.2.rc3 or so. (but others...)

The fixed version in the issue tracker is for 6.2ee, does this mean I cant upgrade the ce version with postgres?


PS and edit:
the fix Krzysztof pointed to (many thanks!!) works:
I compiled the TreePathUtil, changed the class in the ext/portal-service.jar and did the upgrade again -> works ;)
Krzysztof Gołębiowski
RE: Upgrade from 6.1.1 GA2 CE to 6.2 GA1 CE fails with SQLGrammarException
November 9, 2013 7:40 AM
Answer

Krzysztof Gołębiowski

Rank: Liferay Master

Posts: 508

Join Date: June 25, 2011

Recent Posts

Michael you are welcome, I'm glad I could help.

The buggy method has been added 8 days ago (https://github.com/liferay/liferay-portal/commit/f76ed15e799225c161cabe6d98fadceee47bd18f), i think just before GA1 release (and after beta testing emoticon ).
Mario Leggio
RE: Upgrade from 6.1.1 GA2 CE to 6.2 GA1 CE fails with SQLGrammarException
March 6, 2014 3:27 PM
Answer

Mario Leggio

Rank: New Member

Posts: 1

Join Date: March 1, 2014

Recent Posts

Michael Rohleder:
same issue here, upgrade from 6.1.2ga2 to 6.2ga1 with postgres 9.1.9

I think i didnt have that issue some weeks ago with 6.2.rc3 or so. (but others...)

The fixed version in the issue tracker is for 6.2ee, does this mean I cant upgrade the ce version with postgres?


PS and edit:
the fix Krzysztof pointed to (many thanks!!) works:
I compiled the TreePathUtil, changed the class in the ext/portal-service.jar and did the upgrade again -> works ;)



Please, could you attach the updated jar?
Benco Tenisovski
RE: Upgrade from 6.1.1 GA2 CE to 6.2 GA1 CE fails with SQLGrammarException
March 13, 2014 4:14 PM
Answer

Benco Tenisovski

Rank: New Member

Posts: 1

Join Date: March 13, 2014

Recent Posts

Yes if you could atach the jar file that would be great!

________________________________________________________________________________________________________________________________________

Ben 10 Bike Games
mika mika
RE: Upgrade from 6.1.1 GA2 CE to 6.2 GA1 CE fails with SQLGrammarException
March 14, 2014 2:44 AM
Answer

mika mika

Rank: New Member

Posts: 13

Join Date: November 26, 2012

Recent Posts

error "column "/0/" does not exist_" cause by class com.liferay.portal.kernel.util.TreePathUtil in portal-service.jar
if (rootParent) {
sb.append("treePath = \"/0/\" ");
}

you can change to
if (rootParent) {
sb.append("treePath = '/0/' ");
}

and compile this class again