如果你遇到了下面的错误信息，例如：
com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: MySQLIntegrityConstraintViolationException: Duplicate entry '1475804-Edit' for key 'cps_unique_type'
上面表示在 XML 的备份文件中恢复的数据库没有正确的权限，通常是因为使用了第三方的插件的原因。这个问题在 Confluence 3.5.2 的后续版本中已经修复了，请参考 CONF-22123 中的说明。如果你的版本已经是新的版本了，你的导出文件可能需要手动进行修改来删除掉重复权限实例，或者整个记录都需要被删除。下面的 SQL 可以被用来找到这个记录。
SELECT
*
FROM
CONTENT_PERM
WHERE
USERNAME
IS
NULL
AND
GROUPNAME
IS
NULL
;
FROM
CONTENT_PERM cp
SELECT
cps1.ID, cps1.CONTENT_ID, cps1.CONT_PERM_TYPE
FROM
CONTENT_PERM_SET cps1, CONTENT_PERM_SET cps2
SELECT
cp.ID, cp.CP_TYPE, cps.CONTENT_ID,
(
SELECT
scps.ID
FROM
CONTENT_PERM_SET scps
WHERE
scps.CONTENT_ID = cps.CONTENT_ID
AND
scps.CONT_PERM_TYPE = cp.CP_TYPE)
AS
suggested_cps_id
FROM
CONTENT_PERM cp, CONTENT_PERM_SET cps
FROM
CONTENT_PERM cp1, CONTENT_PERM_SET cps1, CONTENT_PERM cp2, CONTENT_PERM_SET cps2
WHERE
cp1.CPS_ID = cps1.ID
AND
cp2.CPS_ID = cps2.ID
AND
cp1.CP_TYPE = cp2.CP_TYPE
AND
FROM
CONTENT_PERM cp1, CONTENT_PERM_SET cps1, CONTENT_PERM cp2, CONTENT_PERM_SET cps2
WHERE
cp1.CPS_ID = cps1.ID
AND
cp2.CPS_ID = cps2.ID
AND
cp1.CP_TYPE = cp2.CP_TYPE
AND
SELECT
*
FROM
CONTENT_PERM_SET
WHERE
ID
NOT
IN
(
SELECT
DISTINCT
CPS_ID
FROM
CONTENT_PERM);
|
删除所有找到的记录，然后尝试重新导出。
https://www.cwiki.us/display/CONFLUENCEWIKI/Troubleshooting+XML+backups+that+fail+on+restore
