Liferay 6.0 EE SP1 to SP2 upgrade error: ORA-00001

[12年前 に Mathias Lehmann によって更新されました。]

Hello @all,
i tried to upgrade from SP1 to Sp2.

I imported my database scheme (Lieray 6.0 EE SP1 ) form production to testenvironment.
After starting the server in testenvironment i get the following error:

11.11.2011 08:31:06 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8888
11.11.2011 08:31:06 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 825 ms
11.11.2011 08:31:07 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
11.11.2011 08:31:07 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.32
11.11.2011 08:31:07 org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor ROOT.xml
Loading jar:file:/D:/Liferay%20Developer%20Studio/liferay-portal-6.0-ee-sp2/tomcat-6.0.32/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
08:31:18,932 INFO [EasyConf:122] Refreshed the configuration of all components
08:31:19,463 INFO [ConfigurationLoader:56] Properties for jar:file:/D:/Liferay%20Developer%20Studio/liferay-portal-6.0-ee-sp2/tomcat-6.0.32/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal loaded from [file:/D:/Liferay%20Developer%20Studio/liferay-portal-6.0-ee-sp2/tomcat-6.0.32/webapps/ROOT/WEB-INF/classes/portal-developer.properties, file:/D:/Liferay%20Developer%20Studio/liferay-portal-6.0-ee-sp2/portal-ide.properties, file:/D:/Liferay%20Developer%20Studio/liferay-portal-6.0-ee-sp2/portal-ext.properties, jar:file:/D:/Liferay%20Developer%20Studio/liferay-portal-6.0-ee-sp2/tomcat-6.0.32/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties]
Loading jar:file:/D:/Liferay%20Developer%20Studio/liferay-portal-6.0-ee-sp2/tomcat-6.0.32/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
Loading file:/D:/Liferay%20Developer%20Studio/liferay-portal-6.0-ee-sp2/portal-ext.properties
Loading file:/D:/Liferay%20Developer%20Studio/liferay-portal-6.0-ee-sp2/portal-ide.properties
Loading file:/D:/Liferay%20Developer%20Studio/liferay-portal-6.0-ee-sp2/tomcat-6.0.32/webapps/ROOT/WEB-INF/classes/portal-developer.properties
08:31:27,807 INFO [DialectDetector:80] Determine dialect for Oracle 10
08:31:27,885 INFO [DialectDetector:145] Found dialect org.hibernate.dialect.Oracle10gDialect
08:31:34,557 INFO [PortalImpl:295] Global lib directory /D:/Liferay Developer Studio/liferay-portal-6.0-ee-sp2/tomcat-6.0.32/lib/ext/
08:31:34,572 INFO [PortalImpl:315] Portal lib directory /D:/Liferay Developer Studio/liferay-portal-6.0-ee-sp2/tomcat-6.0.32/webapps/ROOT/WEB-INF/lib/
Starting Liferay Portal Enterprise Edition 6.0 EE SP2 (Bunyan / Build 6012 / July 27, 2011)
08:31:53,791 INFO [BaseDB:401] Database supports case sensitive queries
08:31:53,806 INFO [UpgradeProcess:199] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_12
08:31:53,806 INFO [UpgradeProcess:199] Upgrading com.liferay.portal.upgrade.v6_0_12.UpgradeSchema
08:31:54,400 INFO [UpgradeProcess:199] Upgrading com.liferay.portal.upgrade.v6_0_12.UpgradeAsset
08:31:54,525 INFO [UpgradeProcess:199] Upgrading com.liferay.portal.upgrade.v6_0_12.UpgradeBlogs
08:31:54,806 INFO [UpgradeProcess:199] Upgrading com.liferay.portal.upgrade.v6_0_12.UpgradeDocumentLibrary
08:31:54,822 INFO [UpgradeProcess:199] Upgrading com.liferay.portal.upgrade.v6_0_12.UpgradeExpando
08:31:54,822 INFO [UpgradeProcess:199] Upgrading com.liferay.portal.upgrade.v6_0_12.UpgradeLock
08:31:54,838 INFO [UpgradeProcess:199] Upgrading com.liferay.portal.upgrade.v6_0_12.UpgradeMessageBoards
08:32:01,900 INFO [UpgradeProcess:199] Upgrading com.liferay.portal.upgrade.v6_0_12.UpgradePermission
08:32:03,509 ERROR [JDBCExceptionReporter:234] ORA-00001: Unique Constraint violated (PORTAL.SYS_C00114152)

08:32:03,509 ERROR [JDBCExceptionReporter:234] ORA-00001: Unique Constraint violated (PORTAL.SYS_C00114152)

08:32:03,509 ERROR [MainServlet:201] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at com.liferay.portal.events.StartupAction.run(StartupAction.java:57)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1193)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:198)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4420)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4733)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:205)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:99)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:126)
at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:51)
... 29 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:205)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:221)
at com.liferay.portal.upgrade.UpgradeProcess_6_0_12.doUpgrade(UpgradeProcess_6_0_12.java:54)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:202)
... 37 more
Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:190)
at com.liferay.portal.service.persistence.ResourcePermissionPersistenceImpl.updateImpl(ResourcePermissionPersistenceImpl.java:467)
at com.liferay.portal.service.persistence.ResourcePermissionPersistenceImpl.updateImpl(ResourcePermissionPersistenceImpl.java:1)
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:254)
at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.addResourcePermissions(ResourcePermissionLocalServiceImpl.java:186)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:86)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:60)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:60)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:60)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:93)
at $Proxy67.addResourcePermissions(Unknown Source)
at com.liferay.portal.service.ResourcePermissionLocalServiceUtil.addResourcePermissions(ResourcePermissionLocalServiceUtil.java:329)
at com.liferay.portal.upgrade.v6_0_12.UpgradePermission.updatePermissions_6(UpgradePermission.java:101)
at com.liferay.portal.upgrade.v6_0_12.UpgradePermission.updatePermissions(UpgradePermission.java:54)
at com.liferay.portal.upgrade.v6_0_12.UpgradePermission.doUpgrade(UpgradePermission.java:43)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:202)
... 40 more
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:128)
at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.flush(ClassLoaderSession.java:218)
at com.liferay.portal.service.persistence.BatchSessionImpl.update(BatchSessionImpl.java:95)
at com.liferay.portal.service.persistence.BatchSessionUtil.update(BatchSessionUtil.java:49)
at com.liferay.portal.service.persistence.ResourcePermissionPersistenceImpl.updateImpl(ResourcePermissionPersistenceImpl.java:462)
... 59 more
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:125)
... 63 more
Caused by: java.sql.BatchUpdateException: ORA-00001: Unique Constraint (PORTAL.SYS_C00114152) verletzt

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10070)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:213)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 69 more
Stopping the server due to unexpected startup errors

When i start the server for the second time it seems all fine. The upgrade process works without any errors (upgrading and verifying).

What does that mean? What is the index PORTAL.SYS_C00114152? And does the error have any effects on my tables?
Can i run the upgrade process in my production environment or will i get any problems?

As database i use Oracle 10g.

Please help me with that issue.
Thanks in advance.

Best regards,
Mathias

[12年前 に Mathias Lehmann によって更新されました。]

Hello @all,
Any ideas or information about that. It's important to know if i can update the system.

Best regards,
Mathias

[7年前 に Reshmi Singha Chaudhury によって更新されました。]

Hi All,

I am also facing slimier problem during up gradation to 6.1 from Liferay 6.0 and getting the below error during upgrade. Please suggest a way out, how to recover this and complete successful up gradation.

Please follow the below log:
11:46:10,545 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
11:46:12,371 ERROR [localhost-startStop-1][MainServlet:217] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-00001: unique constraint (LIFERAY_GENPORTAL_UPGRADE2.SYS_C0022091) violated

com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-00001: unique constraint (LIFERAY_GENPORTAL_UPGRADE2.SYS_C0022091) violated

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:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

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

Reshmi Singha Chaudhury:

I am also facing slimier problem during up gradation to 6.1 from Liferay 6.0 and getting the below error during upgrade. Please suggest a way out, how to recover this and complete successful up gradation.

Unfortunately a stacktrace is not quite enough to give solid advice. Some things that you should consider

• As you're writing about upgrade to 6.1 in 2016, I hope that this is only one step in your quest to upgrade to a current and still supported version
• If You're doing this on EE, open a ticket and ask for the recommended upgrade path to use. You'll need to give your current exact version. There's a 6.0.0 in the stacktrace and I hope that you're not upgrading from 6.0 CE GA1.
• You might want to run this routine in a debugger and check, when the constraint violation actually happens
• Possible root causes are: Data has been manipulated manually, "Somehow" (tm) the database got inconsistent, Bug in the upgrade routines, Bug in the previous version