Exceptions while upgrading 5.2.2 to 5.2.3

[Ilya Zverev, modifié il y a 14 années.]

I've removed old "ROOT" and "tunnel-web" folders and unpacked ones from new 5.2.3 archive, also I've replaced jars in tomcat/common/lib/ext.

Tomcat prints a lot of following exceptions:

17:34:57,690 ERROR [PortletPreferencesImpl:213] java.lang.NullPointerException
java.lang.NullPointerException
        at com.liferay.portal.service.impl.PortletPreferencesLocalServiceImpl.getDefaultPreferences(PortletPreferencesLocalServiceImpl.java:141)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy52.getDefaultPreferences(Unknown Source)
        at com.liferay.portal.service.PortletPreferencesLocalServiceUtil.getDefaultPreferences(PortletPreferencesLocalServiceUtil.java:138)
        at com.liferay.portlet.PortletPreferencesImpl.reset(PortletPreferencesImpl.java:208)
        at com.liferay.portal.upgrade.v5_2_3.UpgradeDocumentLibrary.upgradePreferences(UpgradeDocumentLibrary.java:249)
        at com.liferay.portal.upgrade.v5_2_3.UpgradeDocumentLibrary.updatePortletPreferences(UpgradeDocumentLibrary.java:196)
        at com.liferay.portal.upgrade.v5_2_3.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:131)
        at com.liferay.portal.upgrade.v5_2_3.UpgradeDocumentLibrary.upgrade(UpgradeDocumentLibrary.java:62)
        at com.liferay.portal.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:99)
        at com.liferay.portal.upgrade.UpgradeProcess_5_2_3.upgrade(UpgradeProcess_5_2_3.java:63)
        at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:127)
        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:55)
        at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:126)
        at com.liferay.portal.events.StartupAction.run(StartupAction.java:66)
        at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:161)

After that, there's next exception:

...
Caused by: com.liferay.portal.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: value is too long for type character varying(75)
        at com.liferay.portal.upgrade.v5_2_3.UpgradeUser.upgrade(UpgradeUser.java:53)
        at com.liferay.portal.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:99)
        at com.liferay.portal.upgrade.UpgradeProcess_5_2_3.upgrade(UpgradeProcess_5_2_3.java:73)
        at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:127)
        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:55)
        at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:126)
        at com.liferay.portal.events.StartupAction.run(StartupAction.java:66)
        ... 28 more
Caused by: org.postgresql.util.PSQLException: ERROR: value is too long for type character varying(75)

        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at com.liferay.portal.upgrade.v5_2_3.UpgradeUser.doUpgrade(UpgradeUser.java:116)
        at com.liferay.portal.upgrade.v5_2_3.UpgradeUser.upgrade(UpgradeUser.java:50)
        ... 34 more

Then a thousand lines about some problems with dtd, didn't catch (see the last line of this post).

Then a really awful lot of:

17:51:44,737 ERROR [PluginPackageUtil:502] Error reindexing liferay/sun-showtime-portlet/5.2.0.1/war
java.lang.NullPointerException
        at com.liferay.portal.kernel.messaging.MessageBusUtil._sendMessage(MessageBusUtil.java:178)
        at com.liferay.portal.kernel.messaging.MessageBusUtil._sendMessage(MessageBusUtil.java:186)
        at com.liferay.portal.kernel.messaging.MessageBusUtil.sendMessage(MessageBusUtil.java:92)
        at com.liferay.portal.search.IndexWriterImpl.updateDocument(IndexWriterImpl.java:80)
        at com.liferay.portal.kernel.search.SearchEngineUtil.updateDocument(SearchEngineUtil.java:171)
        at com.liferay.portal.plugin.PluginPackageIndexer.updatePluginPackage(PluginPackageIndexer.java:166)
        at com.liferay.portal.plugin.PluginPackageUtil._indexPluginPackage(PluginPackageUtil.java:490)
        at com.liferay.portal.plugin.PluginPackageUtil._parseRepositoryXml(PluginPackageUtil.java:786)
        at com.liferay.portal.plugin.PluginPackageUtil._loadRepository(PluginPackageUtil.java:686)
        at com.liferay.portal.plugin.PluginPackageUtil._reloadRepositories(PluginPackageUtil.java:1164)
        at com.liferay.portal.plugin.PluginPackageUtil.reloadRepositories(PluginPackageUtil.java:218)
        at com.liferay.portlet.admin.job.CheckRemoteRepositoriesJob.execute(CheckRemoteRepositoriesJob.java:43)
        at com.liferay.portal.job.JobWrapper.execute(JobWrapper.java:69)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

(for every war on liferay site)

Then tons of deploy exceptions caused by

Caused by: java.lang.NullPointerException
        at com.liferay.portal.kernel.messaging.MessageBusUtil._sendMessage(MessageBusUtil.java:178)
        at com.liferay.portal.kernel.messaging.MessageBusUtil._sendMessage(MessageBusUtil.java:186)
        at com.liferay.portal.kernel.messaging.MessageBusUtil.sendMessage(MessageBusUtil.java:92)
        at com.liferay.portal.search.IndexWriterImpl.deleteDocument(IndexWriterImpl.java:57)
        at com.liferay.portal.kernel.search.SearchEngineUtil.deleteDocument(SearchEngineUtil.java:59)
        at com.liferay.portal.plugin.PluginPackageIndexer.removePluginPackage(PluginPackageIndexer.java:149)
        at com.liferay.portal.plugin.LocalPluginPackageRepository.removePluginPackage(LocalPluginPackageRepository.java:128)
        at com.liferay.portal.plugin.PluginPackageUtil._unregisterInstalledPluginPackage(PluginPackageUtil.java:1291)
        at com.liferay.portal.plugin.PluginPackageUtil.unregisterInstalledPluginPackage(PluginPackageUtil.java:245)
        at com.liferay.portal.deploy.hot.PluginPackageHotDeployListener.doInvokeUndeploy(PluginPackageHotDeployListener.java:249)
        at com.liferay.portal.deploy.hot.PluginPackageHotDeployListener.invokeUndeploy(PluginPackageHotDeployListener.java:176)
        ... 28 more

I've restarted the server and there was second upgrade attempt, obviously failed:

17:58:57,971 INFO  [DBUtil:498] Database supports case sensitive queries
17:58:57,987 INFO  [UpgradeProcess_5_2_3:58] Upgrading
17:58:58,018 WARN  [DBUtil:474] ERROR: column "groupid" for table "bookmarksentry" already exists: alter table BookmarksEntry add groupId LONG;
...and so on...

Then there was error message about varchar(75), deploy-undeploy exceptions caused by com.liferay.portal.kernel.messaging.MessageBusUtil._sendMessage(MessageBusUtil.java:178) and shortly after, tons of indexing exceptions.

AND STILL NO LOGGING TO FILE IN DEFAULT PACKAGE!!!

[Ilya Zverev, modifié il y a 14 années.]

Problem (75) cause: jobtitle column in contact_ is varchar(100), but jobtitle in user_ is varchar(75). I've fixed this with pgAdmin.
Problem "MessageBusUtil" cause: http://www.liferay.com/web/guest/community/forums/-/message_boards/message/1419187

liferay started with no exceptions. Thanks for watching