Fórum

Upgrade from 6.06 to 6.1/6.2

Don McGregor, modificado 9 Anos atrás.

Upgrade from 6.06 to 6.1/6.2

New Member Postagens: 5 Data de Entrada: 19/11/10 Postagens Recentes
Trying to upgrade from 6.06 CE to a more recent release. Running on MySQL/CentOS, using the -6.1.2-ce-ga3
version with the bundled tomcat. The upgrade runs for a time, then looks like it fails on the ImageGallery table
with a duplicate key. Any advice on how to fix this?

I've modified the portal.ext file. The old version was running the FilesystemHook. Properties added to the portal.ext
file:

image.hook.impl=com.liferay.portal.image.FileSystemHook
users.last.name.required=false
layout.types=portlet,panel,embedded,url,link_to_layout
editor.wysiwyg.portal-web.docroot.html.portlet.message_boards.edit_message.bb_code.jsp=ckeditor_bbcode
setup.wizard.enabled=true discussion.subscribe.by.default=true
message.boards.subscribe.by.default=true

Traceback when the upgrade fails, from catalina.out:

21:15:45,484 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery
21:15:45,527 ERROR [localhost-startStop-1][MainServlet:217] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '85001' for key 'PRIMARY'
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '85001' for key 'PRIMARY'
at com.liferay.portal.events.StartupAction.run(StartupAction.java:56)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1300)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
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:5123)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5407)
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:657)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1636)
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: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '85001' for key 'PRIMARY'
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:113)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:66)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:138)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:61)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:143)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:119)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:50)
... 19 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '85001' for key 'PRIMARY'
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:195)
at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:68)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 27 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '85001' for key 'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.addIGImageDLFileEntryType(UpgradeImageGallery.java:318)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.addIGImageDLFileEntryType(UpgradeImageGallery.java:277)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.doUpgrade(UpgradeImageGallery.java:451)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
thumbnail
Liferay S, modificado 9 Anos atrás.

RE: Upgrade from 6.06 to 6.1/6.2

Junior Member Postagens: 53 Data de Entrada: 12/04/12 Postagens Recentes
Can you please upload your portal-ext.properties file.
Please let me know if there are some changes in the default configurations of liferay.

Thanks
Don McGregor, modificado 9 Anos atrás.

RE: Upgrade from 6.06 to 6.1/6.2

New Member Postagens: 5 Data de Entrada: 19/11/10 Postagens Recentes
portal.ext for the new (6.1.2) version is below. I don't believe I've changed any of the default install options.

[root@localhost liferay-portal-6.1.2-ce-ga3]# cat portal-ext.properties
# MySQL Settings
jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal606?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false&emulateLocators=false
jdbc.default.username=xxxx
jdbc.default.password=xxxxxx
web.server.http.port=80
web.server.https.port=443
live.users.enabled=false
redirect.url.security.mode=ip
redirect.url.domains.allowed
redirect.url.ips.allowed=127.0.0.1,xxxx.yyyy.zzzz.aaaa

image.hook.impl=com.liferay.portal.image.DLHook
users.last.name.required=false
layout.types=portlet,panel,embedded,url,link_to_layout
editor.wysiwyg.portal-web.docroot.html.portlet.message_boards.edit_message.bb_code.jsp=ckeditor_bbcode
setup.wizard.enabled=true discussion.subscribe.by.default=true
message.boards.subscribe.by.default=true



# this is to set up the page you land on after login
#auth.forward.by.last.path=true
#default.landing.page.path=/home


# Set the Terms of Use Web Content to use instead of the default
#terms.of.use.journal.article.id=25540
#terms.of.use.journal.article.group.id=10156
### above commented out because it wasn't working and we deployed our own terms_of_use.jsp file.

# Set the email properties for announcemnts
announcements.email.from.name=xxxxxx
announcements.email.from.address=no-reply@xxxxxx
announcements.email.to.address=no-reply@xxxxxx
admin.email.from.address=no-reply@xxxxx
admin.email.from.name=xxxxxx
blogs.email.from.address=no-reply@xxxxxx
blogs.email.from=xxxxxx
blogs.ping.google.enabled=false
calendar.email.from.address=no-reply@xxxxxx
calendar.email.from=xxxxxxx

# Up the file size limits
com.liferay.portal.upload.UploadServletRequestImpl.max.size=5000000000

# Effectively disable the session timeout.

session.timeout.auto.extend=true


users.update.last.login=true

#editor.wysiwyg.default=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.blogs.edit_entry.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.calendar.edit_configuration.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.enterprise_admin.view.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.invitation.edit_configuration.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.journal.edit_article_content.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.journal.edit_article_content_xsd_el.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.journal.edit_configuration.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.login.configuration.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.mail.edit.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.mail.edit_message.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.message_boards.edit_configuration.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.shopping.edit_configuration.jsp=fckeditor
#editor.wysiwyg.portal-web.docroot.html.portlet.wiki.edit.html.jsp=fckeditor

editor.wysiwyg.default=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.blogs.edit_entry.jsp=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.calendar.edit_configuration.jsp=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.enterprise_admin.view.jsp=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.invitation.edit_configuration.jsp=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.journal.edit_article_content.jsp=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.journal.edit_article_content_xsd_el.ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.journal.edit_configuration.jsp=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.login.configuration.jsp=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.mail.edit.jsp=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.mail.edit_message.jsp=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.message_boards.edit_configuration.jsp=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.shopping.edit_configuration.jsp=ckeditor
editor.wysiwyg.portal-web.docroot.html.portlet.wiki.edit.html.jsp=ckeditor
thumbnail
Alberto Chaparro, modificado 9 Anos atrás.

RE: Upgrade from 6.06 to 6.1/6.2

Liferay Master Postagens: 549 Data de Entrada: 25/04/11 Postagens Recentes
Hi Don,

First of all you have to add the following property to your 6.1/6.2 property-ext file before doing the upgrade:
image.hook.file.system.root.dir=${liferay.home}/data/images

Pointing out to the folder where you stored images in your portal 6.0.6. The portal will use this property to know where the images were stored before merging them into DLFiles.

Besides this and in relation to your issue, could you execute the following query in the database result after upgrading:
Select * from DLFileEntryType;

It seems that, for one reason, the portal is trying to insert a record for images from images gallery with the same primary key than other record. Do you use sharding?

Cheers.
Don McGregor, modificado 9 Anos atrás.

RE: Upgrade from 6.06 to 6.1/6.2

New Member Postagens: 5 Data de Entrada: 19/11/10 Postagens Recentes
...And, back from a well-earned vacation.

I switched to using the 6.2 GA release. Same general problem. I'm not sharding; it's all on one database. I added the indicated property above.

mysql> select * from DLFileEntryType;
+--------------------------------------+-----------------+---------+-----------+--------+----------+---------------------+---------------------+---------------------+---------------------+
| uuid_ | fileEntryTypeId | groupId | companyId | userId | userName | createDate | modifiedDate | name | description |
+--------------------------------------+-----------------+---------+-----------+--------+----------+---------------------+---------------------+---------------------+---------------------+
| ceaa553d-0ee3-4e8f-bbca-1c0e7547d554 | 85602 | 10164 | 10131 | 10134 | | 2014-07-08 18:46:38 | 2014-07-08 18:46:38 | Image Gallery Image | Image Gallery Image |
+--------------------------------------+-----------------+---------+-----------+--------+----------+---------------------+---------------------+---------------------+---------------------+

The catalina.out contents after starting the embedded tomcat with

su tomcat catalina.sh start

It complains about there being no image present at document_library/0/0/14835.png/1.0 (and there is no image there). There is no
file named 14835.png on the original 6.06 installation. The entire contents of the old 6.06 data directory were moved to the 6.2
data directory.

The document library looks like this, post-failed upgrade:

0 10131

Where in the original there was only the 10131 directory.

[root@localhost logs]# cat catalina.out
Jul 08, 2014 7:25:58 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
Jul 08, 2014 7:25:58 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Jul 08, 2014 7:25:58 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Jul 08, 2014 7:25:58 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1259 ms
Jul 08, 2014 7:25:58 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Jul 08, 2014 7:25:58 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.42
Jul 08, 2014 7:25:59 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor /usr/java/liferay-portal-6.2-ce-ga2/tomcat-7.0.42/conf/Catalina/localhost/ROOT.xml
Loading jar:file:/usr/java/liferay-portal-6.2-ce-ga2/tomcat-7.0.42/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
Loading jar:file:/usr/java/liferay-portal-6.2-ce-ga2/tomcat-7.0.42/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
Loading jar:file:/usr/java/liferay-portal-6.2-ce-ga2/tomcat-7.0.42/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
Loading file:/usr/java/liferay-portal-6.2-ce-ga2/portal-ext.properties
Jul 08, 2014 7:26:15 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
19:26:22,591 INFO [localhost-startStop-1][DialectDetector:71] Determine dialect for MySQL 5
19:26:22,701 INFO [localhost-startStop-1][DialectDetector:136] Found dialect org.hibernate.dialect.MySQLDialect
Starting Liferay Portal Community Edition 6.2 CE GA2 (Newton / Build 6201 / March 20, 2014)
19:27:24,154 INFO [localhost-startStop-1][BaseDB:484] Database does not support case sensitive queries
19:27:24,508 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
19:27:24,513 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
19:27:32,563 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName
19:27:32,708 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
19:27:32,989 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeBlogs
19:27:33,003 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCamelCasePortletPreferences
19:27:36,206 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCountry
19:27:36,251 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
19:27:37,096 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeExpando
19:27:37,102 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeGroup
19:27:37,231 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery
19:27:45,529 WARN [localhost-startStop-1][UpgradeImageGallery:619] Ignoring exception for image 14835
com.liferay.portlet.documentlibrary.NoSuchFileException: /usr/java/liferay-portal-6.2-ce-ga2/data/document_library/0/0/14835.png/1.0
at com.liferay.portlet.documentlibrary.store.FileSystemStore.getFileAsStream(FileSystemStore.java:215)
at com.liferay.portlet.documentlibrary.store.BaseStore.getFileAsStream(BaseStore.java:373)
at com.liferay.portlet.documentlibrary.store.StoreProxyImpl.getFileAsStream(StoreProxyImpl.java:167)
at com.liferay.portlet.documentlibrary.store.SafeFileNameStoreWrapper.getFileAsStream(SafeFileNameStoreWrapper.java:246)
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.getFileAsStream(DLStoreImpl.java:288)
at com.liferay.portlet.documentlibrary.store.DLStoreUtil.getFileAsStream(DLStoreUtil.java:425)
at com.liferay.portal.image.DLHook.getImageAsStream(DLHook.java:75)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateFile(UpgradeImageGallery.java:568)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateImage(UpgradeImageGallery.java:615)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateImageFiles(UpgradeImageGallery.java:724)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.doUpgrade(UpgradeImageGallery.java:398)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:195)
at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:68)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:162)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:114)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:94)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:138)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:61)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:143)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:160)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:68)
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.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: /usr/java/liferay-portal-6.2-ce-ga2/data/document_library/0/0/14835.png/1.0 (No such file or directory)
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:212)
... 41 more
19:27:45,543 WARN [localhost-startStop-1][UpgradeImageGallery:668] Ignoring exception for image 14834
com.liferay.portlet.documentlibrary.NoSuchFileException: /usr/java/liferay-portal-6.2-ce-ga2/data/document_library/0/0/14834.png/1.0
at com.liferay.portlet.documentlibrary.store.FileSystemStore.getFileAsStream(FileSystemStore.java:215)
at com.liferay.portlet.documentlibrary.store.BaseStore.getFileAsStream(BaseStore.java:373)
at com.liferay.portlet.documentlibrary.store.StoreProxyImpl.getFileAsStream(StoreProxyImpl.java:167)
at com.liferay.portlet.documentlibrary.store.SafeFileNameStoreWrapper.getFileAsStream(SafeFileNameStoreWrapper.java:246)
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.getFileAsStream(DLStoreImpl.java:288)
at com.liferay.portlet.documentlibrary.store.DLStoreUtil.getFileAsStream(DLStoreUtil.java:425)
at com.liferay.portal.image.DLHook.getImageAsStream(DLHook.java:75)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateImage(UpgradeImageGallery.java:647)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateImageFiles(UpgradeImageGallery.java:724)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.doUpgrade(UpgradeImageGallery.java:398)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:195)
at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:68)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:162)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:114)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:94)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:138)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:61)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:143)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:160)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:68)
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.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: /usr/java/liferay-portal-6.2-ce-ga2/data/document_library/0/0/14834.png/1.0 (No such file or directory)
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:212)
... 40 more
19:27:45,548 ERROR [localhost-startStop-1][MainServlet:209] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.NoSuchImageException: com.liferay.portlet.documentlibrary.NoSuchFileException: /usr/java/liferay-portal-6.2-ce-ga2/data/document_library/0/0/14835.png
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.NoSuchImageException: com.liferay.portlet.documentlibrary.NoSuchFileException: /usr/java/liferay-portal-6.2-ce-ga2/data/document_library/0/0/14835.png
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.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: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.NoSuchImageException: com.liferay.portlet.documentlibrary.NoSuchFileException: /usr/java/liferay-portal-6.2-ce-ga2/data/document_library/0/0/14835.png
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:162)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:114)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:94)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:138)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:61)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:143)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:160)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:68)
... 19 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.NoSuchImageException: com.liferay.portlet.documentlibrary.NoSuchFileException: /usr/java/liferay-portal-6.2-ce-ga2/data/document_library/0/0/14835.png
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:195)
at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:68)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 27 more
Caused by: com.liferay.portal.NoSuchImageException: com.liferay.portlet.documentlibrary.NoSuchFileException: /usr/java/liferay-portal-6.2-ce-ga2/data/document_library/0/0/14835.png
at com.liferay.portal.image.DLHook.deleteImage(DLHook.java:44)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateImage(UpgradeImageGallery.java:678)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateImageFiles(UpgradeImageGallery.java:724)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.doUpgrade(UpgradeImageGallery.java:398)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 30 more
Caused by: com.liferay.portlet.documentlibrary.NoSuchFileException: /usr/java/liferay-portal-6.2-ce-ga2/data/document_library/0/0/14835.png
at com.liferay.portlet.documentlibrary.store.FileSystemStore.deleteFile(FileSystemStore.java:146)
at com.liferay.portlet.documentlibrary.store.StoreProxyImpl.deleteFile(StoreProxyImpl.java:104)
at com.liferay.portlet.documentlibrary.store.SafeFileNameStoreWrapper.deleteFile(SafeFileNameStoreWrapper.java:142)
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.deleteFile(DLStoreImpl.java:225)
at com.liferay.portlet.documentlibrary.store.DLStoreUtil.deleteFile(DLStoreUtil.java:275)
at com.liferay.portal.image.DLHook.deleteImage(DLHook.java:41)
... 34 more
Stopping the server due to unexpected startup errors
thumbnail
Alberto Chaparro, modificado 9 Anos atrás.

RE: Upgrade from 6.06 to 6.1/6.2

Liferay Master Postagens: 549 Data de Entrada: 25/04/11 Postagens Recentes
Hi Don,

Don McGregor:

It complains about there being no image present at document_library/0/0/14835.png/1.0 (and there is no image there). There is no
file named 14835.png on the original 6.06 installation. The entire contents of the old 6.06 data directory were moved to the 6.2
data directory.

You have to be sure that you have copied the old data in the following directory for your 6.2 server before doing the upgrade:
dl.store.file.system.root.dir=${liferay.home}/data/document_library

If you want to copy it in another folder, please modify the property dl.store.file.system.root.dir.

If this is ok, the exception om.liferay.portlet.documentlibrary.NoSuchFileException: /usr/java/liferay-portal-6.2-ce-ga2/data/document_library/0/0/14835.png/1.0 usually occurs when you have a document in your database but not in the filesystem. So please, restore your backup, startup you portal 6.0 and remove the document from the UI. To know which document is you can do a select in DLFileEntry where companyId = 0 and folderId = 0 (document_library/0/0/14835.png)

You can also generate an script in groovy to know if there are more documents whitout any reference in filesystem.

Once this is done you can repeat the upgrade.

Cheers.
Oliver Bayer, modificado 9 Anos atrás.

RE: Upgrade from 6.06 to 6.1/6.2

Liferay Master Postagens: 894 Data de Entrada: 18/02/09 Postagens Recentes
Hi Don,

as stated by Alberto you first have to cleanup you database especially the document_library table. You can -of course- start the upgrade process, save the exception, lookup the file from db. But this can be a very very very very nasty task to do if you have more than 10 missing (filesystem) files emoticon. Because every time you have to restore the database and rerun the upgrade process.

Or you can try the following code snippet:

List<dlfileentry> allFileEntries = DLFileEntryLocalServiceUtil.getDLFileEntries(-1,-1);
Iterator<dlfileentry> fileEntryItr = allFileEntries.iterator();

while (fileEntryItr.hasNext())
{
	DLFileEntry currDLFileEntry = fileEntryItr.next();
	
	try
	{
		String filePath = "../" + currDLFileEntry.getFolderId() + "/" + currDLFileEntry.getName();
		DLLocalServiceUtil.getFileAsStream(currDLFileEntry.getCompanyId(), 0, filePath, currDLFileEntry.getVersion());
	}
	catch (PortalException pe)
	{
		if (pe instanceof NoSuchFileException)
		{
			DLFileEntryLocalServiceUtil.deleteDLFileEntry(currDLFileEntry);
		}
	}
	...
}</dlfileentry></dlfileentry>

Tested for Liferay v5.2.3 - so you maybe have to change some method calls but the overall approach should be the same.

HTH Oli