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

Upgrading from 6.1.1ga2 to 6.2: Warnings + Errors: Unknown column 'versionUserId' in 'field list'; Error encountered while reindexing

    Details

      Description

      Upgrading from our 6.1.1ga2 database to 6.2B1 (tomcat bundle) throws a few exceptions, and have a number of warnings but no adverse effects are seen. This is low priority but upgrading does produce a higher level of log watching and anxiety in the client

      Hope out catalina.out log helps (attached).

      Here are the exceptions:
      This one seems to always follow a warning:
      12:01:27,767 WARN [localhost-startStop-1][BaseUpgradeAttachments:110] Unable to add file entry 4401
      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'versionUserId' in 'field list'

      and the second error:

      12:07:27,742 ERROR [com.liferay.portal.search.lucene.LuceneHelperImpl-1][LuceneIndexer:136] Error encountered while reindexing
      com.liferay.portal.kernel.search.SearchException: com.liferay.portlet.documentlibrary.NoSuchFileEntryException: No DLFileEntry exists with the primary key 28509
      Caused by: com.liferay.portlet.documentlibrary.NoSuchFileEntryException: No DLFileEntry exists with the primary key 28509
      at com.liferay.portlet.documentlibrary.service.persistence.DLFileEntryPersistenceImpl.findByPrimaryKey(DLFileEntryPersistenceImpl.java:10544)

      Warnings:

      12:01:17,418 WARN [localhost-startStop-1][BaseDB:455] Can't DROP 'IX_8DB864A9'; check that column/key exists: drop index IX_8DB864A9 on ResourcePermission;
      12:01:27,767 WARN [localhost-startStop-1][BaseUpgradeAttachments:110] Unable to add file entry 4401
      12:01:27,809 WARN [localhost-startStop-1][BaseUpgradeAttachments:110] Unable to add file entry 4402
      12:01:27,828 WARN [localhost-startStop-1][BaseUpgradeAttachments:110] Unable to add file entry 4403
      12:01:49,738 WARN [localhost-startStop-1][BaseDB:106] BLOB/TEXT column 'templateKey' used in key specification without a key length: create unique index IX_E6DFAB84 on DDMTemplate (groupId, classNameId, templateKey);
      12:01:49,794 WARN [localhost-startStop-1][BaseDB:106] BLOB/TEXT column 'templateKey' used in key specification without a key length: create index IX_CAE41A28 on DDMTemplate (templateKey);
      12:02:00,636 WARN [localhost-startStop-1][BaseDB:106] Duplicate entry '19219-226586' for key 'IX_33781904': create unique index IX_33781904 on MBThreadFlag (userId, threadId);
      12:02:09,304 WARN [localhost-startStop-1][BaseDB:106] Duplicate entry '10154-49-4-254138_LAYOUT_49-10163' for key 'IX_8D83D0CE': create unique index IX_8D83D0CE on ResourcePermission (companyId, name, scope, primKey, roleId);
      12:04:30,776 WARN [localhost-startStop-1][VerifyDocumentLibrary:464] Unable to update asset for folder 276318: No Group exists with the primary key 14555
      12:04:30,781 WARN [localhost-startStop-1][VerifyDocumentLibrary:464] Unable to update asset for folder 276319: No Group exists with the primary key 14555
      12:04:30,788 WARN [localhost-startStop-1][VerifyDocumentLibrary:464] Unable to update asset for folder 276320: No Group exists with the primary key 14555
      12:05:43,572 WARN [localhost-startStop-1][BaseDB:106] BLOB/TEXT column 'templateKey' used in key specification without a key length: create unique index IX_E6DFAB84 on DDMTemplate (groupId, classNameId, templateKey);
      12:05:43,575 WARN [localhost-startStop-1][BaseDB:106] BLOB/TEXT column 'templateKey' used in key specification without a key length: create index IX_CAE41A28 on DDMTemplate (templateKey);
      12:05:43,601 WARN [localhost-startStop-1][BaseDB:106] Duplicate entry '12075-12148' for key 'IX_33781904': create unique index IX_33781904 on MBThreadFlag (userId, threadId);
      12:05:49,822 WARN [localhost-startStop-1][BaseDB:106] Duplicate entry '10154-49-4-254138_LAYOUT_49-10163' for key 'IX_8D83D0CE': create unique index IX_8D83D0CE on ResourcePermission (companyId, name, scope, primKey, roleId);

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  7 years ago

                  Packages

                  Version Package
                  6.2.0 CE B2