由 MySQLIntegrityConstraintViolationException 引起的 Alfresco 异常：重复条目...等

发布于 2024-11-30 08:01:44 字数 2176 浏览 1 评论 0原文

我有一个 glassfish 3.1.1 Web 服务器，我在上面创建了 2 个实例，我部署了 Alfresco Explorer 3.4e，在一个实例中一切进展顺利，但是当我尝试启动另一个实例时，出现错误并且 alfresco该实例不工作。

我的设置和环境规格是：

使用 glassfish 创建的JDK 1.7
Glassfish 3.1.1
集群环境 （有 2 个实例同一台机器）
MySQL：Ver 14.14 Distrib 5.1.52，适用于 Win64
Alfresco Explorer 3.4e（我从 webapps 文件夹中获取了 war 文件 tomcat捆绑版）
Windows 7 64位！

例外是：

glassfish3.1.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=1;_ThreadName=Thread-2;|14:07:26,077  ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 07150002 Failed to write property deltas: 

.
.
.

Caused by: org.springframework.dao.DuplicateKeyException: SqlMapClient operation; SQL ;   
--- The error occurred in alfresco/ibatis/#resource.dialect#/node-common-SqlMap.xml. 
--- The error occurred while applying a parameter map. 
--- Check the alfresco.node.parameter_NodeProperty. 
--- Check the statement (update failed). 
--- Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '542-69--1-2' for key 'PRIMARY'; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

我的配置参考：

注意： 此异常记录在第二个由于此异常而无法运行的实例，但第一个实例正在工作，如果我关闭第一个实例并重新启动第二个实例，则不会发生异常，并且实例将正常运行。

您可以查看我的问题的完整详细信息&我的配置在这里：http://forums.alfresco.com/en/viewtopic.php?f=9&t=40252&p=118012#p118012

原文

I have a glassfish 3.1.1 web server, and I create 2 instances on it, I deploy Alfresco Explorer 3.4e and everything was going well in one instance, but when I try to start the other instance, I got error and the alfresco in that instance not working.

My settings & Specs of Env. are :

JDK 1.7
Glassfish 3.1.1
Cluster Environment created with glassfish (have 2 instance on
the same machine)
MySQL : Ver 14.14 Distrib 5.1.52, for Win64
Alfresco Explorer 3.4e (I got war file from webapps folder of
tomcat bundled version)
Windows 7 64bit !!

The exception is:

glassfish3.1.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=1;_ThreadName=Thread-2;|14:07:26,077  ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 07150002 Failed to write property deltas: 

.
.
.

Caused by: org.springframework.dao.DuplicateKeyException: SqlMapClient operation; SQL ;   
--- The error occurred in alfresco/ibatis/#resource.dialect#/node-common-SqlMap.xml. 
--- The error occurred while applying a parameter map. 
--- Check the alfresco.node.parameter_NodeProperty. 
--- Check the statement (update failed). 
--- Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '542-69--1-2' for key 'PRIMARY'; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

My reference of configurations:

Note: This exception logged in the second instance that unable to run because this exception, but the first instance is working, if I shutdown the first and restart the second, the exception will not happen and the instance will run without problems.

You can see full details of my problem & my Configuration here: http://forums.alfresco.com/en/viewtopic.php?f=9&t=40252&p=118012#p118012

分享到QQ

分享到微博