Upgrade error

[8年前 に Daniel Chan によって更新されました。]

Dear Sir/Madam

I am trying to upgrade the liferay from 6.1.1 CE GA2 to 6.2 CE GA6. My database is MySQL Community Edition 5.5
When starting up 6.2, the system prompt error and stop the liferay. Please kindly help

As attached, please kindly find the console for your reference

Regards
Daniel

[8年前 に David H Nebinger によって更新されました。]

Looks like LR is expecting one form of UTF8 but your database was created with another form.

You'll have to change the collation to match.

http://dev.mysql.com/doc/refman/5.5/en/charset-column.html

[8年前 に Daniel Chan によって更新されました。]

David H Nebinger:

Looks like LR is expecting one form of UTF8 but your database was created with another form.

You'll have to change the collation to match.

http://dev.mysql.com/doc/refman/5.5/en/charset-column.html

Dear David,

Please note that the upgrade is automatically by Liferay Process. Also, the table are created automatically by Liferay 6.1.1 CE GA2. How can I change the liferay internal table ? Also, What liferay table are required to change ? Please kindly help

Regards
Daniel

[8年前 に Olaf Kock によって更新されました。]

Daniel Chan:

Please note that the upgrade is automatically by Liferay Process. Also, the table are created automatically by Liferay 6.1.1 CE GA2. How can I change the liferay internal table ? Also, What liferay table are required to change ?

Note that I haven't looked at the log file. If it's an encoding issue, note that the database should have been created (prior to Liferay using it) with a default character set of UTF-8 (as documented) - e.g. through "CREATE DATABASE lportal CHARACTER SET utf8;". If you didn't do this when installing 6.1.1, you should use MySQL's tools to change it - and if you're already working with non-ASCII characters you might even notice one or the other encoding problem in your portal. I don't envy you if you have to change this - it's not fun. Unfortunately Liferay has to rely on the underlying platform to handle encoding in an expected and reproducable manner - thus it's standardizing on UTF-8.

Liferay might have created all the tables automatically all by itself, but doing so it uses the default database encoding - which you did set when creating the database schema.

[8年前 に Daniel Chan によって更新されました。]

Olaf Kock:

Daniel Chan:

Please note that the upgrade is automatically by Liferay Process. Also, the table are created automatically by Liferay 6.1.1 CE GA2. How can I change the liferay internal table ? Also, What liferay table are required to change ?

Note that I haven't looked at the log file. If it's an encoding issue, note that the database should have been created (prior to Liferay using it) with a default character set of UTF-8 (as documented) - e.g. through "CREATE DATABASE lportal CHARACTER SET utf8;". If you didn't do this when installing 6.1.1, you should use MySQL's tools to change it - and if you're already working with non-ASCII characters you might even notice one or the other encoding problem in your portal. I don't envy you if you have to change this - it's not fun. Unfortunately Liferay has to rely on the underlying platform to handle encoding in an expected and reproducable manner - thus it's standardizing on UTF-8.

Liferay might have created all the tables automatically all by itself, but doing so it uses the default database encoding - which you did set when creating the database schema.

Dear Olaf,

Thank you for your information.
I am trying to restore the database with the default UTF-8 option.

Drop database `lportal`;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `lportal` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

However, no improvement with the same error. Do you have any idea ?

In additional, I traced the source. The problem SQL is as follows:

update ResourcePermission resourcePermission1 left outer join ResourcePermission resourcePermission2 on resourcePermission1.companyId = resourcePermission2.companyId and resourcePermission1.name = resourcePermission2.name and resourcePermission1.primKey = resourcePermission2.primKey and resourcePermission1.scope = resourcePermission2.scope and resourcePermission2.roleId = 10165 inner join Layout on resourcePermission1.companyId = Layout.companyId and resourcePermission1.primKey like replace('[$PLID$]_LAYOUT_%', '[$PLID$]', cast_text(Layout.plid)) inner join Group_ on Layout.groupId = Group_.groupId and Layout.type_ = 'portlet' set resourcePermission1.roleId = 10165 where resourcePermission1.scope = 4 and resourcePermission1.primKey like '%_LAYOUT_%' and resourcePermission1.roleId = 10164 and resourcePermission2.roleId is null and (Group_.classNameId = 10005 or Group_.classNameId = 10006)

java.sql.SQLException: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'like'
java.sql.SQLException: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'like'
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'like'
null
HY000

As above, the error occurs in the clause "like replace('[$PLID$]_LAYOUT_%', '[$PLID$]', cast_text(Layout.plid))"

However, I can update in the MySQL console as follows:

mysql> update ResourcePermission resourcePermission1 left outer join ResourcePermission resourcePermission2 on resourceP
ermission1.companyId = resourcePermission2.companyId and resourcePermission1.name = resourcePermission2.name and resourc
ePermission1.primKey = resourcePermission2.primKey and resourcePermission1.scope = resourcePermission2.scope and resourc
ePermission2.roleId = 10165 inner join Layout on resourcePermission1.companyId = Layout.companyId and resourcePermission
1.primKey like replace('[$PLID$]_LAYOUT_%', '[$PLID$]', CAST(Layout.plid AS CHAR)) inner join Group_ on Layout.groupId =
Group_.groupId and Layout.type_ = 'portlet' set resourcePermission1.roleId = 10165 where resourcePermission1.scope = 4
and resourcePermission1.primKey like '%_LAYOUT_%' and resourcePermission1.roleId = 10164 and resourcePermission2.roleId
is null and (Group_.classNameId = 10005 or Group_.classNameId = 10006);
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Please kindly help

Regard for your help
Daniel

[8年前 に David H Nebinger によって更新されました。]

So if you connect to mysql and try the following sql: "show full columns from table;" and run it for the ResourcePermission, Layout and Group tables, what collations do you find there?

[8年前 に Daniel Chan によって更新されました。]

David H Nebinger:

So if you connect to mysql and try the following sql: "show full columns from table;" and run it for the ResourcePermission, Layout and Group tables, what collations do you find there?

Dear David

As follows, please advice

Regards
Daniel

mysql> show full columns from Group_;
+-------------------------+--------------+-----------------+------+-----+---------+-------+-----------------------------
----+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges
| Comment |
+-------------------------+--------------+-----------------+------+-----+---------+-------+-----------------------------
----+---------+
| groupId | bigint(20) | NULL | NO | PRI | NULL | | select,insert,update,referen
ces | |
| companyId | bigint(20) | NULL | YES | MUL | NULL | | select,insert,update,referen
ces | |
| creatorUserId | bigint(20) | NULL | YES | | NULL | | select,insert,update,referen
ces | |
| classNameId | bigint(20) | NULL | YES | | NULL | | select,insert,update,referen
ces | |
| classPK | bigint(20) | NULL | YES | | NULL | | select,insert,update,referen
ces | |
| parentGroupId | bigint(20) | NULL | YES | | NULL | | select,insert,update,referen
ces | |
| liveGroupId | bigint(20) | NULL | YES | MUL | NULL | | select,insert,update,referen
ces | |
| name | varchar(150) | utf8_unicode_ci | YES | | NULL | | select,insert,update,referen
ces | |
| description | longtext | utf8_unicode_ci | YES | | NULL | | select,insert,update,referen
ces | |
| type_ | int(11) | NULL | YES | MUL | NULL | | select,insert,update,referen
ces | |
| typeSettings | longtext | utf8_unicode_ci | YES | | NULL | | select,insert,update,referen
ces | |
| friendlyURL | varchar(255) | utf8_unicode_ci | YES | | NULL | | select,insert,update,referen
ces | |
| site | tinyint(4) | NULL | YES | | NULL | | select,insert,update,referen
ces | |
| active_ | tinyint(4) | NULL | YES | | NULL | | select,insert,update,referen
ces | |
| uuid_ | varchar(75) | utf8_unicode_ci | YES | MUL | NULL | | select,insert,update,referen
ces | |
| treePath | longtext | utf8_unicode_ci | YES | | NULL | | select,insert,update,referen
ces | |
| manualMembership | tinyint(4) | NULL | YES | | NULL | | select,insert,update,referen
ces | |
| membershipRestriction | int(11) | NULL | YES | | NULL | | select,insert,update,referen
ces | |
| remoteStagingGroupCount | int(11) | NULL | YES | | NULL | | select,insert,update,referen
ces | |
+-------------------------+--------------+-----------------+------+-----+---------+-------+-----------------------------
----+---------+
19 rows in set (0.00 sec)

mysql> show full columns from ResourcePermission;
+----------------------+--------------+-----------------+------+-----+---------+-------+--------------------------------
-+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges
| Comment |
+----------------------+--------------+-----------------+------+-----+---------+-------+--------------------------------
-+---------+
| resourcePermissionId | bigint(20) | NULL | NO | PRI | NULL | | select,insert,update,references
| |
| companyId | bigint(20) | NULL | YES | MUL | NULL | | select,insert,update,references
| |
| name | varchar(255) | utf8_unicode_ci | YES | | NULL | | select,insert,update,references
| |
| scope | int(11) | NULL | YES | MUL | NULL | | select,insert,update,references
| |
| primKey | varchar(255) | utf8_unicode_ci | YES | | NULL | | select,insert,update,references
| |
| roleId | bigint(20) | NULL | YES | MUL | NULL | | select,insert,update,references
| |
| ownerId | bigint(20) | NULL | YES | | NULL | | select,insert,update,references
| |
| actionIds | bigint(20) | NULL | YES | | NULL | | select,insert,update,references
| |
+----------------------+--------------+-----------------+------+-----+---------+-------+--------------------------------
-+---------+
8 rows in set (0.04 sec)

mysql> show full columns from Layout;
+----------------------------+--------------+-----------------+------+-----+---------+-------+--------------------------
-------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges
| Comment |
+----------------------------+--------------+-----------------+------+-----+---------+-------+--------------------------
-------+---------+
| uuid_ | varchar(75) | utf8_unicode_ci | YES | MUL | NULL | | select,insert,update,refe
rences | |
| plid | bigint(20) | NULL | NO | PRI | NULL | | select,insert,update,refe
rences | |
| groupId | bigint(20) | NULL | YES | MUL | NULL | | select,insert,update,refe
rences | |
| companyId | bigint(20) | NULL | YES | MUL | NULL | | select,insert,update,refe
rences | |
| createDate | datetime | NULL | YES | | NULL | | select,insert,update,refe
rences | |
| modifiedDate | datetime | NULL | YES | | NULL | | select,insert,update,refe
rences | |
| privateLayout | tinyint(4) | NULL | YES | | NULL | | select,insert,update,refe
rences | |
| layoutId | bigint(20) | NULL | YES | | NULL | | select,insert,update,refe
rences | |
| parentLayoutId | bigint(20) | NULL | YES | | NULL | | select,insert,update,refe
rences | |
| name | longtext | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| title | longtext | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| description | longtext | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| keywords | longtext | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| robots | longtext | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| type_ | varchar(75) | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| typeSettings | longtext | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| hidden_ | tinyint(4) | NULL | YES | | NULL | | select,insert,update,refe
rences | |
| friendlyURL | varchar(255) | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| iconImage | tinyint(4) | NULL | YES | | NULL | | select,insert,update,refe
rences | |
| iconImageId | bigint(20) | NULL | YES | MUL | NULL | | select,insert,update,refe
rences | |
| themeId | varchar(75) | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| colorSchemeId | varchar(75) | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| wapThemeId | varchar(75) | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| wapColorSchemeId | varchar(75) | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| css | longtext | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
| priority | int(11) | NULL | YES | | NULL | | select,insert,update,refe
rences | |
| layoutPrototypeUuid | varchar(75) | utf8_unicode_ci | YES | MUL | NULL | | select,insert,update,refe
rences | |
| layoutPrototypeLinkEnabled | tinyint(4) | NULL | YES | | NULL | | select,insert,update,refe
rences | |
| sourcePrototypeLayoutUuid | varchar(75) | utf8_unicode_ci | YES | MUL | NULL | | select,insert,update,refe
rences | |
| userId | bigint(20) | NULL | YES | | NULL | | select,insert,update,refe
rences | |
| userName | varchar(75) | utf8_unicode_ci | YES | | NULL | | select,insert,update,refe
rences | |
+----------------------------+--------------+-----------------+------+-----+---------+-------+--------------------------
-------+---------+

[8年前 に David H Nebinger によって更新されました。]

So the columns are all using "utf8_unicode_ci" for the collation value.

Can you also run the command "show table status;" and copy in the values from Group_, ResourcePermission and Layout?

[8年前 に Jorge Díaz によって更新されました。]

Your problem is:
- Your database is configured with UTF-8 but with 'unicode' collation: utf8_unicode_ci
- Your JDBC driver is configured with default UTF-8 collation that is: utf8_general_ci

In LPS-54590 there were some database query optimizations. Since that LPS, there are some queries with CAST() function.

That function uses collation_connection for type conversion, so if there is a collation mismatch your error is thrown:

java.sql.SQLException: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation

There are two solutions:
- Change your database configuration to utf8_general_ci
- Change your JDBC connection configuration to utf8_unicode_ci, adding parameter &connectionCollation=utf8_unicode_ci to your JDBC connection configured in portal-ext.properties

[8年前 に Daniel Chan によって更新されました。]

Dear Jorge

Thank you for your help
Please note that the auto database upgrade is worked fine with the following minor issue
1. There is a number of error in liferay regarding the document library

Please kindly help
Regards
Daniel

01:59:19,122 WARN [localhost-startStop-1][VerifyDocumentLibrary:275] Unable to find file version 1.0 for file entry 412
com.liferay.portlet.documentlibrary.NoSuchFileException: D:\java\liferay-portal-6.2-ce-ga6-new\data\document_library\10154\10180\412\1.0
at com.liferay.portlet.documentlibrary.store.FileSystemStore.getFileAsStream(FileSystemStore.java:224)
at com.liferay.portlet.documentlibrary.store.StoreProxyImpl.getFileAsStream(StoreProxyImpl.java:178)
at com.liferay.portlet.documentlibrary.store.SafeFileNameStoreWrapper.getFileAsStream(SafeFileNameStoreWrapper.java:264)
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.getFileAsStream(DLStoreImpl.java:300)
at com.liferay.portlet.documentlibrary.store.DLStoreUtil.getFileAsStream(DLStoreUtil.java:452)
at com.liferay.portlet.documentlibrary.service.impl.DLFileEntryLocalServiceImpl.getFileAsStream(DLFileEntryLocalServiceImpl.java:1101)
at com.liferay.portlet.documentlibrary.service.impl.DLFileEntryLocalServiceImpl.getFileAsStream(DLFileEntryLocalServiceImpl.java:1084)
at sun.reflect.GeneratedMethodAccessor311.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
at com.sun.proxy.$Proxy201.getFileAsStream(Unknown Source)
at com.liferay.portlet.documentlibrary.service.DLFileEntryLocalServiceUtil.getFileAsStream(DLFileEntryLocalServiceUtil.java:613)
at com.liferay.portal.verify.VerifyDocumentLibrary$3.performAction(VerifyDocumentLibrary.java:257)
at com.liferay.portal.kernel.dao.orm.BaseActionableDynamicQuery.performActionsInSingleInterval(BaseActionableDynamicQuery.java:324)
at com.liferay.portal.kernel.dao.orm.BaseActionableDynamicQuery.performActions(BaseActionableDynamicQuery.java:46)
at com.liferay.portal.verify.VerifyDocumentLibrary.checkFileVersionMimeTypes(VerifyDocumentLibrary.java:303)
at com.liferay.portal.verify.VerifyDocumentLibrary.checkMimeTypes(VerifyDocumentLibrary.java:314)
at com.liferay.portal.verify.VerifyDocumentLibrary.doVerify(VerifyDocumentLibrary.java:421)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:68)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:76)
at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:42)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:68)
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:231)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:74)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1246)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:231)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5266)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5554)
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:652)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1912)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.io.FileNotFoundException: D:\java\liferay-portal-6.2-ce-ga6-new\data\document_library\10154\10180\412\1.0 (System cannot find the path)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:146)
at com.liferay.portlet.documentlibrary.store.FileSystemStore.getFileAsStream(FileSystemStore.java:221)
... 50 more


02:01:00,621 ERROR [com.liferay.portal.search.lucene.LuceneHelperImpl-1][LuceneIndexer:142] Error encountered while reindexing
com.liferay.portal.kernel.search.SearchException: com.liferay.portal.NoSuchUserException: No User exists with the key {contactId=19804}
at com.liferay.portal.kernel.search.BaseIndexer.getDocument(BaseIndexer.java:181)
at com.liferay.portlet.usersadmin.util.ContactIndexer$1.performAction(ContactIndexer.java:204)
at com.liferay.portal.kernel.dao.orm.BaseActionableDynamicQuery.performActionsInSingleInterval(BaseActionableDynamicQuery.java:324)
at com.liferay.portal.kernel.dao.orm.BaseActionableDynamicQuery.performActions(BaseActionableDynamicQuery.java:46)
at com.liferay.portlet.usersadmin.util.ContactIndexer.reindexContacts(ContactIndexer.java:216)
at com.liferay.portlet.usersadmin.util.ContactIndexer.doReindex(ContactIndexer.java:186)
at com.liferay.portal.kernel.search.BaseIndexer.reindex(BaseIndexer.java:490)
at com.liferay.portal.search.lucene.LuceneIndexer.reindex(LuceneIndexer.java:161)
at com.liferay.portal.search.lucene.LuceneIndexer.doReIndex(LuceneIndexer.java:131)
at com.liferay.portal.search.lucene.LuceneIndexer.reindex(LuceneIndexer.java:64)
at com.liferay.portal.search.lucene.LuceneIndexer.run(LuceneIndexer.java:73)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:682)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:593)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.liferay.portal.NoSuchUserException: No User exists with the key {contactId=19804}
at com.liferay.portal.service.persistence.UserPersistenceImpl.findByContactId(UserPersistenceImpl.java:1711)
at com.liferay.portal.service.impl.UserLocalServiceImpl.getUserByContactId(UserLocalServiceImpl.java:2662)
at sun.reflect.GeneratedMethodAccessor959.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:51)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
at com.sun.proxy.$Proxy107.getUserByContactId(Unknown Source)
at com.liferay.portal.service.UserLocalServiceUtil.getUserByContactId(UserLocalServiceUtil.java:2093)
at com.liferay.portlet.usersadmin.util.ContactIndexer.doGetDocument(ContactIndexer.java:108)
at com.liferay.portal.kernel.search.BaseIndexer.getDocument(BaseIndexer.java:153)
... 13 more

[8年前 に Jorge Díaz によって更新されました。]

About document library issues, you have some missing files in \data\document_library so there is some inconsistencies between database and filesystem (there are DLFileEntry objects without physical file in disk)

There are some applications in Liferay marketplace that can help you to find the inconsistencies, but as data is missed there are few options:
- Delete document from document library interface to avoid inconsistences
- Create an empty file to avoid errors (for example at \data\document_library\10154\10180\412\1.0 )

Those validations must be done in origin sysmte (6.1) before starting upgrade

[8年前 に Daniel Chan によって更新されました。]

Jorge Díaz:

About document library issues, you have some missing files in \data\document_library so there is some inconsistencies between database and filesystem (there are DLFileEntry objects without physical file in disk)

There are some applications in Liferay marketplace that can help you to find the inconsistencies, but as data is missed there are few options:
- Delete document from document library interface to avoid inconsistences
- Create an empty file to avoid errors (for example at \data\document_library\10154\10180\412\1.0 )

Those validations must be done in origin sysmte (6.1) before starting upgrade

Dear Jorge

Here, I would like to let you know the background as follows:
1. Currently, I am using 6.1.1 CE. There is a number of Web Contents and Portlets. Also, MySQL is as my liferay database
2. Now, I want to upgrade 6.2.
3. I extract new instance of Liferay from Liferay download
4. copy the portal-ext.property into the Liferay 6.2
5. start the instance do database upgrade.

Please comment how I can seamless upgrade.

Also, I want to know something. By design, you put the jpg and web content in system directory. Do you have planned to move them into database since the database is depended on the location directory by design. However, for clustered case, it is not supported by such design

Regards
Daniel

[8年前 に Jorge Díaz によって更新されました。]

Hi Daniel,

You have to copy data\document_library folder from old Liferay 6.1 installation to new 6.2 one.

You have more information about upgrade process in following url: https://dev.liferay.com/discover/deployment/-/knowledge_base/6-2/upgrading-liferay

About your last comment:

Daniel Chan:

Also, I want to know something. By design, you put the jpg and web content in system directory. Do you have planned to move them into database since the database is depended on the location directory by design. However, for clustered case, it is not supported by such design

If you are using a cluster, you have to share that data folder between both nodes, it is explained in following url: https://dev.liferay.com/discover/deployment/-/knowledge_base/6-2/liferay-clustering

Using the File System Store
This is the default store. It’s a simple file storage implementation that uses a local folder to store files. You can use the file system for your clustered configuration, but you’d have to make sure the folder to which you point the store can handle things like concurrent requests and file locking. For this reason, you need to use a Storage Area Network or a clustered file system.

In case you want to use database to store files (I personally don't recomend it) you can configure DBStore as file repository, see: https://dev.liferay.com/discover/portal/-/knowledge_base/6-2/alternative-file-repository-options

Regards,
Jorge Díaz

[7年前 に Daniel Chan によって更新されました。]

Dear all,

noted with thank you

Regards
Daniel