Confluence 6 针对 key \"cp_\" 或 \"cps_\" 的 \"Duplicate Entry\" 问题解决

如果你遇到了下面的错误信息,例如:

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;
 
SELECT <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ghd9Kl3KS7y5wls8LVqGpzYD8SFF-MPVaAZljaZrg5g/" rel="nofollow" title="cp.ID,">cp.ID,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60gQNSpgKZ9Ps6yY4pgcrY645gvM8Wnhow5nGvEDCwjyw/" rel="nofollow" title="cp.CP_TYPE,">cp.CP_TYPE,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ZZLipuzH0IRSCkDTKZAsHBHNZ6yaT-lvgq7s3VLcoWw/" rel="nofollow" title="cp.USERNAME,">cp.USERNAME,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61wPjTq7TCuhaINKLjgN5Y1BX5pvsrIyPL0hvBTAmehSA/" rel="nofollow" title="cp.GROUPNAME,">cp.GROUPNAME,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60gQNSpgKZ9Ps6yY4pgcrY6hZdjStXsnV_73IPaFjC2VQ/" rel="nofollow" title="cp.CPS_ID,">cp.CPS_ID,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60gQNSpgKZ9Ps6yY4pgcrY68b-5EFnDJ5xMUmo-Vn56Jw/" rel="nofollow" title="cp.CREATOR,">cp.CREATOR,</a>
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60gQNSpgKZ9Ps6yY4pgcrY6OJCkwEwQuYGZmveOoFJkWg/" rel="nofollow" title="cp.CREATIONDATE,">cp.CREATIONDATE,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61n6AJstxlyB1byGP1G__b4FShr-4MojMFiLuy2Oqhnog/" rel="nofollow" title="cp.LASTMODIFIER,">cp.LASTMODIFIER,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61n6AJstxlyB1byGP1G__b4sQT2rnLnufl7cZEjN-D6qA/" rel="nofollow" title="cp.LASTMODDATE">cp.LASTMODDATE</a>
FROM CONTENT_PERM cp
WHERE <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ZZLipuzH0IRSCkDTKZAsHFq984hRcPyvOn8I4aQGSBg/" rel="nofollow" title="cp.USERNAME">cp.USERNAME</a> IS NOT NULL AND <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61wPjTq7TCuhaINKLjgN5Y1Ks_OfkAbJ3oQ2ee5d0SSVw/" rel="nofollow" title="cp.GROUPNAME">cp.GROUPNAME</a> IS NOT NULL;
 
SELECT <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSZS5T9ubAf77e88o2DJnCgQ/" rel="nofollow" title="cps1.ID,">cps1.ID,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSbkVMaizKitVMp02FOgfQnQ/" rel="nofollow" title="cps1.CONTENT_ID,">cps1.CONTENT_ID,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSXqzU0DraVgryY1lXKQQegw/" rel="nofollow" title="cps1.CONT_PERM_TYPE">cps1.CONT_PERM_TYPE</a> FROM CONTENT_PERM_SET cps1, CONTENT_PERM_SET cps2
WHERE <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSALcjqWQTQjnOsOg6LVQjwQ/" rel="nofollow" title="cps1.ID">cps1.ID</a> <> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60Ghb4hL5o1kzDsVRb7R2EOALcjqWQTQjnOsOg6LVQjwQ/" rel="nofollow" title="cps2.ID">cps2.ID</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSPe0Bumm8D9EeMZzMq8PcRA/" rel="nofollow" title="cps1.CONTENT_ID">cps1.CONTENT_ID</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60Ghb4hL5o1kzDsVRb7R2EOPe0Bumm8D9EeMZzMq8PcRA/" rel="nofollow" title="cps2.CONTENT_ID">cps2.CONTENT_ID</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSXqzU0DraVgryY1lXKQQegw/" rel="nofollow" title="cps1.CONT_PERM_TYPE">cps1.CONT_PERM_TYPE</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60Ghb4hL5o1kzDsVRb7R2EOXqzU0DraVgryY1lXKQQegw/" rel="nofollow" title="cps2.CONT_PERM_TYPE">cps2.CONT_PERM_TYPE</a>
ORDER BY <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSbkVMaizKitVMp02FOgfQnQ/" rel="nofollow" title="cps1.CONTENT_ID,">cps1.CONTENT_ID,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQS4hGTy2EUnAPWPSwKSLgxDZWgUQBW8ceXAdzjtURQlwY/" rel="nofollow" title="cps1.CONT_PERM_TYPE,">cps1.CONT_PERM_TYPE,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSbsABgx0POdjlqLZlzPu-XQ/" rel="nofollow" title="cps1.CREATIONDATE">cps1.CREATIONDATE</a> ASC;
 
SELECT <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ghd9Kl3KS7y5wls8LVqGpzYD8SFF-MPVaAZljaZrg5g/" rel="nofollow" title="cp.ID,">cp.ID,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60gQNSpgKZ9Ps6yY4pgcrY645gvM8Wnhow5nGvEDCwjyw/" rel="nofollow" title="cp.CP_TYPE,">cp.CP_TYPE,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD636sZSOACFZsy2PzeKhmPoCsHIIKs_jIh1gClwVvjQqmg/" rel="nofollow" title="cps.CONTENT_ID,">cps.CONTENT_ID,</a>
(SELECT <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63QHgoiFy_WpHW89zi_7VbpALcjqWQTQjnOsOg6LVQjwQ/" rel="nofollow" title="scps.ID">scps.ID</a> FROM CONTENT_PERM_SET scps WHERE <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63QHgoiFy_WpHW89zi_7VbpPe0Bumm8D9EeMZzMq8PcRA/" rel="nofollow" title="scps.CONTENT_ID">scps.CONTENT_ID</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD636sZSOACFZsy2PzeKhmPoCDOEXxv9pVH5FK-O33iU9nw/" rel="nofollow" title="cps.CONTENT_ID">cps.CONTENT_ID</a> AND <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63QHgoiFy_WpHW89zi_7VbpXqzU0DraVgryY1lXKQQegw/" rel="nofollow" title="scps.CONT_PERM_TYPE">scps.CONT_PERM_TYPE</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60gQNSpgKZ9Ps6yY4pgcrY6MV6PT1PEhSTl0TGX2TsFvA/" rel="nofollow" title="cp.CP_TYPE)">cp.CP_TYPE)</a> AS suggested_cps_id
FROM CONTENT_PERM cp, CONTENT_PERM_SET cps
WHERE <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60gQNSpgKZ9Ps6yY4pgcrY6c5vplgGWkubojs0qIJQ0yQ/" rel="nofollow" title="cp.CPS_ID">cp.CPS_ID</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD636sZSOACFZsy2PzeKhmPoCMVSLX_4EDLYlUVusTaCu0A/" rel="nofollow" title="cps.ID">cps.ID</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60gQNSpgKZ9Ps6yY4pgcrY6z5vCvIIDkVaOSMxRGumpZw/" rel="nofollow" title="cp.CP_TYPE">cp.CP_TYPE</a> <> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD636sZSOACFZsy2PzeKhmPoC_QTJ4ogAyyzlEkLxQ_OsbQ/" rel="nofollow" title="cps.CONT_PERM_TYPE;">cps.CONT_PERM_TYPE;</a>
 
SELECT DISTINCT <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2ovEGSWnRcFMXzVDK-6-JuA/" rel="nofollow" title="cp1.ID,">cp1.ID,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2I9Ha1LMSGB-_DbG7u4JfeQ/" rel="nofollow" title="cp1.CP_TYPE,">cp1.CP_TYPE,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2n2Wdd-joJ018LSZ0AMd80w/" rel="nofollow" title="cp1.USERNAME,">cp1.USERNAME,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2_ADws85-u4WNN0tAjSWItg/" rel="nofollow" title="cp1.GROUPNAME,">cp1.GROUPNAME,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2zHMdHYQXr-XhNI9RBKNa_w/" rel="nofollow" title="cp1.CPS_ID,">cp1.CPS_ID,</a>
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l23Fx8zpgkfMeVKDvQZlHsdA/" rel="nofollow" title="cp1.CREATOR,">cp1.CREATOR,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2CFNvlfDLGBuSsxDd4WR6QQ/" rel="nofollow" title="cp1.CREATIONDATE,">cp1.CREATIONDATE,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2khftCaO7omU6yqYBi0qvhQ/" rel="nofollow" title="cp1.LASTMODIFIER,">cp1.LASTMODIFIER,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l24Hi-34JlAf6nbwwZWq_5HA/" rel="nofollow" title="cp1.LASTMODDATE">cp1.LASTMODDATE</a>
FROM CONTENT_PERM cp1, CONTENT_PERM_SET cps1, CONTENT_PERM cp2, CONTENT_PERM_SET cps2
WHERE
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2zmSKMJwPS7iET6B4cBrSMw/" rel="nofollow" title="cp1.CPS_ID">cp1.CPS_ID</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSALcjqWQTQjnOsOg6LVQjwQ/" rel="nofollow" title="cps1.ID">cps1.ID</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60cVbs9sEaqH4yHZFDeznPFzmSKMJwPS7iET6B4cBrSMw/" rel="nofollow" title="cp2.CPS_ID">cp2.CPS_ID</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60Ghb4hL5o1kzDsVRb7R2EOALcjqWQTQjnOsOg6LVQjwQ/" rel="nofollow" title="cps2.ID">cps2.ID</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2MVSLX_4EDLYlUVusTaCu0A/" rel="nofollow" title="cp1.ID">cp1.ID</a> <> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60cVbs9sEaqH4yHZFDeznPFMVSLX_4EDLYlUVusTaCu0A/" rel="nofollow" title="cp2.ID">cp2.ID</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSPe0Bumm8D9EeMZzMq8PcRA/" rel="nofollow" title="cps1.CONTENT_ID">cps1.CONTENT_ID</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60Ghb4hL5o1kzDsVRb7R2EOPe0Bumm8D9EeMZzMq8PcRA/" rel="nofollow" title="cps2.CONTENT_ID">cps2.CONTENT_ID</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2oyXi0qkLYHcw080WH_Ryww/" rel="nofollow" title="cp1.CP_TYPE">cp1.CP_TYPE</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60cVbs9sEaqH4yHZFDeznPFoyXi0qkLYHcw080WH_Ryww/" rel="nofollow" title="cp2.CP_TYPE">cp2.CP_TYPE</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2Nkq2enbXOuCc5YZb5belKg/" rel="nofollow" title="cp1.USERNAME">cp1.USERNAME</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60cVbs9sEaqH4yHZFDeznPFNkq2enbXOuCc5YZb5belKg/" rel="nofollow" title="cp2.USERNAME">cp2.USERNAME</a>
ORDER BY <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2zHMdHYQXr-XhNI9RBKNa_w/" rel="nofollow" title="cp1.CPS_ID,">cp1.CPS_ID,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2I9Ha1LMSGB-_DbG7u4JfeQ/" rel="nofollow" title="cp1.CP_TYPE,">cp1.CP_TYPE,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2n2Wdd-joJ018LSZ0AMd80w/" rel="nofollow" title="cp1.USERNAME,">cp1.USERNAME,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2YCe3naI2jjaMpsDJeNAx0w/" rel="nofollow" title="cp1.CREATIONDATE;">cp1.CREATIONDATE;</a>
 
SELECT DISTINCT <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2ovEGSWnRcFMXzVDK-6-JuA/" rel="nofollow" title="cp1.ID,">cp1.ID,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2I9Ha1LMSGB-_DbG7u4JfeQ/" rel="nofollow" title="cp1.CP_TYPE,">cp1.CP_TYPE,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2n2Wdd-joJ018LSZ0AMd80w/" rel="nofollow" title="cp1.USERNAME,">cp1.USERNAME,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2_ADws85-u4WNN0tAjSWItg/" rel="nofollow" title="cp1.GROUPNAME,">cp1.GROUPNAME,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2zHMdHYQXr-XhNI9RBKNa_w/" rel="nofollow" title="cp1.CPS_ID,">cp1.CPS_ID,</a>
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l23Fx8zpgkfMeVKDvQZlHsdA/" rel="nofollow" title="cp1.CREATOR,">cp1.CREATOR,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2CFNvlfDLGBuSsxDd4WR6QQ/" rel="nofollow" title="cp1.CREATIONDATE,">cp1.CREATIONDATE,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2khftCaO7omU6yqYBi0qvhQ/" rel="nofollow" title="cp1.LASTMODIFIER,">cp1.LASTMODIFIER,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l24Hi-34JlAf6nbwwZWq_5HA/" rel="nofollow" title="cp1.LASTMODDATE">cp1.LASTMODDATE</a>
FROM CONTENT_PERM cp1, CONTENT_PERM_SET cps1, CONTENT_PERM cp2, CONTENT_PERM_SET cps2
WHERE
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2zmSKMJwPS7iET6B4cBrSMw/" rel="nofollow" title="cp1.CPS_ID">cp1.CPS_ID</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSALcjqWQTQjnOsOg6LVQjwQ/" rel="nofollow" title="cps1.ID">cps1.ID</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60cVbs9sEaqH4yHZFDeznPFzmSKMJwPS7iET6B4cBrSMw/" rel="nofollow" title="cp2.CPS_ID">cp2.CPS_ID</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60Ghb4hL5o1kzDsVRb7R2EOALcjqWQTQjnOsOg6LVQjwQ/" rel="nofollow" title="cps2.ID">cps2.ID</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2MVSLX_4EDLYlUVusTaCu0A/" rel="nofollow" title="cp1.ID">cp1.ID</a> <> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60cVbs9sEaqH4yHZFDeznPFMVSLX_4EDLYlUVusTaCu0A/" rel="nofollow" title="cp2.ID">cp2.ID</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD61ifsyVohS1seOpLIGnnoQSPe0Bumm8D9EeMZzMq8PcRA/" rel="nofollow" title="cps1.CONTENT_ID">cps1.CONTENT_ID</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60Ghb4hL5o1kzDsVRb7R2EOPe0Bumm8D9EeMZzMq8PcRA/" rel="nofollow" title="cps2.CONTENT_ID">cps2.CONTENT_ID</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2oyXi0qkLYHcw080WH_Ryww/" rel="nofollow" title="cp1.CP_TYPE">cp1.CP_TYPE</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60cVbs9sEaqH4yHZFDeznPFoyXi0qkLYHcw080WH_Ryww/" rel="nofollow" title="cp2.CP_TYPE">cp2.CP_TYPE</a> AND
<a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l27_rYOlKoFZsPYE6geRnfyQ/" rel="nofollow" title="cp1.GROUPNAME">cp1.GROUPNAME</a> = <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD60cVbs9sEaqH4yHZFDeznPF7_rYOlKoFZsPYE6geRnfyQ/" rel="nofollow" title="cp2.GROUPNAME">cp2.GROUPNAME</a>
ORDER BY <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2zHMdHYQXr-XhNI9RBKNa_w/" rel="nofollow" title="cp1.CPS_ID,">cp1.CPS_ID,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2I9Ha1LMSGB-_DbG7u4JfeQ/" rel="nofollow" title="cp1.CP_TYPE,">cp1.CP_TYPE,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2_ADws85-u4WNN0tAjSWItg/" rel="nofollow" title="cp1.GROUPNAME,">cp1.GROUPNAME,</a> <a target="_blank" href="https://www.ancii.com/link/v1/aWNkkFZ_ySKXq8H4-S6bJz9fTk0H0KrGGyVAICrkD63Y5-cKpavLYdbjVNF0u6l2YCe3naI2jjaMpsDJeNAx0w/" rel="nofollow" title="cp1.CREATIONDATE;">cp1.CREATIONDATE;</a>
 
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