[opencms-dev] OPENCMS.PK_ONLINE_STRUCTURE violation

[Chris Shimmin-Vincent]

I have an issue on OpenCms version 7.0.4 whereby when I publish a 
resource, it publishes correctly but doesn't replicate to the other 
server. This only happens on a particular resource and other resources 
are unaffected. Can anyone help please?

The error I am getting is:

Replicating files ...
( Replication ) Replicating 
/sites/bath/hr/stayingsafewell/physicalhazards/ ... Error replicating 
VFS resource "/sites/bath/hr/stayingsafewell/physicalhazards/" to 
replication server "Replication"
Exception org.opencms.db.CmsDbSqlException: An SQL error occurred when 
executing the following query: 
oracle.jdbc.driver.T4CPreparedStatement at 14f8f4a.
at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:675)
at org.opencms.ocee.cache.CmsVfsCache.createResource(CmsVfsCache.java:221)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicateFolder(CmsReplicationVfsHandler.java:1304)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicateParent(CmsReplicationVfsHandler.java:1575)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicateFile(CmsReplicationVfsHandler.java:732)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicateVfsResources(CmsReplicationVfsHandler.java:1823)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicate(CmsReplicationVfsHandler.java:302)
at 
org.opencms.ocee.replication.CmsReplicationManager.o000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000super(CmsReplicationManager.java:1446)
at 
org.opencms.ocee.replication.CmsReplicationManager.handleAfterPublishReplication(CmsReplicationManager.java:618)
at 
org.opencms.ocee.replication.CmsReplicationModuleAction.cmsEvent(CmsReplicationModuleAction.java:118)
at 
org.opencms.main.CmsEventManager.fireEventHandler(CmsEventManager.java:203)
at org.opencms.main.CmsEventManager.fireEvent(CmsEventManager.java:126)
at org.opencms.main.OpenCms.fireCmsEvent(OpenCms.java:156)
at 
org.opencms.publish.CmsPublishEngine.publishJobFinished(CmsPublishEngine.java:647)
at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java:222)
Caused by: java.sql.SQLException: ORA-00001: unique constraint 
(OPENCMS.PK_ONLINE_STRUCTURE) violated
at 
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at 
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at 
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at 
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at 
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:598)
... 14 more
( Replication ) Replicating 
/sites/bath/hr/stayingsafewell/physicalhazards/index.html ... Error 
replicating VFS resource 
"/sites/bath/hr/stayingsafewell/physicalhazards/index.html" to 
replication server "Replication"
Exception org.opencms.file.CmsVfsResourceNotFoundException: Unable to 
read parent id of resource "/hr/stayingsafewell/physicalhazards/index.html".
at 
org.opencms.db.generic.CmsVfsDriver.internalReadParentId(CmsVfsDriver.java:3252)
at 
org.opencms.db.generic.CmsVfsDriver.publishResource(CmsVfsDriver.java:1234)
at org.opencms.ocee.cache.CmsVfsCache.publishResource(CmsVfsCache.java:418)
at 
org.opencms.ocee.replication.CmsReplicationProjectDriver.publishFileContent(CmsReplicationProjectDriver.java:395)
at 
org.opencms.ocee.cache.CmsProjectCache.publishFileContent(CmsProjectCache.java:368)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicateFile(CmsReplicationVfsHandler.java:1076)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicateVfsResources(CmsReplicationVfsHandler.java:1823)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicate(CmsReplicationVfsHandler.java:302)
at 
org.opencms.ocee.replication.CmsReplicationManager.o000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000super(CmsReplicationManager.java:1446)
at 
org.opencms.ocee.replication.CmsReplicationManager.handleAfterPublishReplication(CmsReplicationManager.java:618)
at 
org.opencms.ocee.replication.CmsReplicationModuleAction.cmsEvent(CmsReplicationModuleAction.java:118)
at 
org.opencms.main.CmsEventManager.fireEventHandler(CmsEventManager.java:203)
at org.opencms.main.CmsEventManager.fireEvent(CmsEventManager.java:126)
at org.opencms.main.OpenCms.fireCmsEvent(OpenCms.java:156)
at 
org.opencms.publish.CmsPublishEngine.publishJobFinished(CmsPublishEngine.java:647)
at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java:222)
Error during the replication process
Exception org.opencms.ocee.replication.CmsReplicationException: Error 
replicating VFS resource to replication server "Replication"
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicate(CmsReplicationVfsHandler.java:317)
at 
org.opencms.ocee.replication.CmsReplicationManager.o000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000super(CmsReplicationManager.java:1446)
at 
org.opencms.ocee.replication.CmsReplicationManager.handleAfterPublishReplication(CmsReplicationManager.java:618)
at 
org.opencms.ocee.replication.CmsReplicationModuleAction.cmsEvent(CmsReplicationModuleAction.java:118)
at 
org.opencms.main.CmsEventManager.fireEventHandler(CmsEventManager.java:203)
at org.opencms.main.CmsEventManager.fireEvent(CmsEventManager.java:126)
at org.opencms.main.OpenCms.fireCmsEvent(OpenCms.java:156)
at 
org.opencms.publish.CmsPublishEngine.publishJobFinished(CmsPublishEngine.java:647)
at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java:222)
Caused by: org.opencms.ocee.replication.CmsReplicationException: Error 
replicating VFS resource to replication server "Replication"
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicateVfsResources(CmsReplicationVfsHandler.java:1844)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicate(CmsReplicationVfsHandler.java:302)
... 8 more
Caused by: org.opencms.file.CmsVfsResourceNotFoundException: Error 
replicating VFS resource 
"/sites/bath/hr/stayingsafewell/physicalhazards/index.html" to 
replication server "Replication"
at 
org.opencms.file.CmsVfsResourceNotFoundException.createException(CmsVfsResourceNotFoundException.java:79)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicateFile(CmsReplicationVfsHandler.java:1221)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicateVfsResources(CmsReplicationVfsHandler.java:1823)
... 9 more
Caused by: org.opencms.file.CmsVfsResourceNotFoundException: Unable to 
read parent id of resource "/hr/stayingsafewell/physicalhazards/index.html".
at 
org.opencms.db.generic.CmsVfsDriver.internalReadParentId(CmsVfsDriver.java:3252)
at 
org.opencms.db.generic.CmsVfsDriver.publishResource(CmsVfsDriver.java:1234)
at org.opencms.ocee.cache.CmsVfsCache.publishResource(CmsVfsCache.java:418)
at 
org.opencms.ocee.replication.CmsReplicationProjectDriver.publishFileContent(CmsReplicationProjectDriver.java:395)
at 
org.opencms.ocee.cache.CmsProjectCache.publishFileContent(CmsProjectCache.java:368)
at 
org.opencms.ocee.replication.CmsReplicationVfsHandler.replicateFile(CmsReplicationVfsHandler.java:1076)
... 10 more

Vfs replication handler in incremental mode finished!

Regards,

Chris