ERROR: relation "replication_document" does not exist

jamiemc01 · August 25, 2023, 9:06am

Hi,

I keep on getting this message. I think it was after I installed the replication extension. I have tried installing and removing it, but I still get this message.

I’m fairly new at Xwiki, and I am guessing it’s a macro running on every page. Is it possible to manually remove or suppress this message?

I would be very grateful for any advice given.

Many Thanks
Jamie

mleduc · August 25, 2023, 9:09am

Hello @jamiemc01,

Did you restart you instance after installing Replication?

According to the documentation:

XWiki needs to be restarted after the first install of the extension (it’s providing a database table, which currently is only loaded at XWiki startup).

This is not usual to have to restart but this is the case for Replication.

jamiemc01 · August 25, 2023, 9:32am

Hi @mleduc,

Thanks for your reply. On reboot, I am still getting the same error.

mleduc · August 25, 2023, 9:33am

Thanks for trying. In this case I’m out of idea but @tmortagne might know better.

tmortagne · August 25, 2023, 11:11am

ERROR: relation “replication_document” does not exist

This is a bit light, could you past the complete error, especially the stack trace indicating what is trying to use that table.

You indicated in your previous comment that you uninstalled it, have you installed it again before restarting ?

Could you check your startup log for any error once you full installed it and then restarted. It should tell you exactly why it failed to create it.

jamiemc01 · August 25, 2023, 1:12pm

Hi

The full message im getting is this,

Failed to execute template. Cause: [ERROR: relation "replication_document" does not exist   Position: 52]. Click on this message for details.

org.xwiki.rendering.RenderingException: Failed to execute renderer
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:287)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.execute(DefaultBlockAsyncRendererExecutor.java:125)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.execute(InternalTemplateManager.java:928)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.execute(InternalTemplateManager.java:909)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.executeNoException(InternalTemplateManager.java:874)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.executeNoException(DefaultTemplateManager.java:187)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.executeNoException(DefaultTemplateManager.java:181)
 at org.xwiki.contrib.replication.entity.internal.ui.DocumentReplicationConflictUIExtension.execute(DocumentReplicationConflictUIExtension.java:73)
 at jdk.internal.reflect.GeneratedMethodAccessor958.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:704)
 at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:75)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:167)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:492)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.directive.Foreach.renderBlock(Foreach.java:309)
 at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:279)
 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.Template.merge(Template.java:358)
 at org.apache.velocity.Template.merge(Template.java:262)
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:280)
 at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:321)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:95)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:222)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:177)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:138)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)
 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.render(DefaultBlockAsyncRendererExecutor.java:154)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:843)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:805)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:792)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:747)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:739)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:79)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:73)
 at org.xwiki.template.script.TemplateScriptService.render(TemplateScriptService.java:54)
 at jdk.internal.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:492)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:331)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:261)
 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:190)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.Template.merge(Template.java:358)
 at org.apache.velocity.Template.merge(Template.java:262)
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:280)
 at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:321)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:95)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:222)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:177)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:138)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)
 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.render(DefaultBlockAsyncRendererExecutor.java:154)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:843)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:805)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:785)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:771)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:91)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:85)
 at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:2554)
 at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:180)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:650)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:338)
 at com.xpn.xwiki.web.LegacyActionServlet.service(LegacyActionServlet.java:112)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:122)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.xwiki.wysiwyg.filter.ConversionFilter.doFilter(ConversionFilter.java:61)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:132)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
 at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:375)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.xwiki.rendering.RenderingException: Failed to evaluate template with id [jar:file:/var/lib/xwiki/data/extension/repository/org%252Exwiki%252Econtrib%252Ereplication%253Areplication-entity-default/1%252E12%252E3/org%252Exwiki%252Econtrib%252Ereplication%253Areplication-entity-default-1%252E12%252E3.jar!/templates/replication/conflict.vm]
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:224)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:177)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:138)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)
 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)
 ... 133 more
Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with namespace [/skins/flamingo/view.vm]
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:289)
 at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:321)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:95)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:222)
 ... 139 more
Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getConflict' in  class org.xwiki.contrib.replication.entity.script.DocumentReplicationScriptService threw exception org.xwiki.contrib.replication.ReplicationException: Failed to execute the select at /skins/flamingo/view.vm[line 23, column 37]
 at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:308)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:235)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.evaluate(ASTReference.java:676)
 at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:65)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:169)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.Template.merge(Template.java:358)
 at org.apache.velocity.Template.merge(Template.java:262)
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:280)
 ... 142 more
Caused by: org.xwiki.contrib.replication.ReplicationException: Failed to execute the select
 at org.xwiki.contrib.replication.entity.internal.index.ReplicationDocumentStore.get(ReplicationDocumentStore.java:349)
 at org.xwiki.contrib.replication.entity.internal.index.ReplicationDocumentStore.getConflict(ReplicationDocumentStore.java:284)
 at org.xwiki.contrib.replication.entity.internal.DefaultEntityReplication.getConflict(DefaultEntityReplication.java:80)
 at org.xwiki.contrib.replication.entity.script.DocumentReplicationScriptService.getConflict(DocumentReplicationScriptService.java:191)
 at jdk.internal.reflect.GeneratedMethodAccessor960.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)
 ... 150 more
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
 at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:835)
 at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:902)
 at org.xwiki.contrib.replication.entity.internal.index.ReplicationDocumentStore.get(ReplicationDocumentStore.java:335)
 at org.xwiki.contrib.replication.entity.internal.index.ReplicationDocumentStore.get(ReplicationDocumentStore.java:347)
 ... 159 more
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
 at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
 at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1626)
 at org.hibernate.query.internal.AbstractProducedQuery.uniqueResult(AbstractProducedQuery.java:1659)
 at org.xwiki.contrib.replication.entity.internal.index.ReplicationDocumentStore.get(ReplicationDocumentStore.java:178)
 at org.xwiki.contrib.replication.entity.internal.index.ReplicationDocumentStore.lambda$get$5(ReplicationDocumentStore.java:335)
 at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:826)
 ... 162 more
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
 at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103)
 at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
 at org.hibernate.loader.Loader.getResultSet(Loader.java:2322)
 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2075)
 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2037)
 at org.hibernate.loader.Loader.doQuery(Loader.java:956)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:357)
 at org.hibernate.loader.Loader.doList(Loader.java:2868)
 at org.hibernate.loader.Loader.doList(Loader.java:2850)
 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2682)
 at org.hibernate.loader.Loader.list(Loader.java:2677)
 at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:540)
 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
 at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:218)
 at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1459)
 at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649)
 at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617)
 ... 166 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "replication_document" does not exist
  Position: 52
 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)
 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368)
 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)
 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)
 at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
 at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134)
 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
 ... 181 more

jamiemc01 · August 25, 2023, 1:13pm

Just to confirm, I reinstalled and then restarted.

I appreciate your help @tmortagne. Thank you

I will have a look at the other logs as well.

Cheers
Jamie

jamiemc01 · August 25, 2023, 1:20pm

I have found these error in catalina.out

[2023-08-24 15:50:31] [info] 2023-08-24 15:50:31,776 [http-nio-8080-exec-5 - https://wiki.issured.com/xwiki/bin/view/WikiManager/] ERROR .x.i.t.InternalTemplateManager - Error while executing template [replication/conflict.vm]
[2023-08-24 15:50:31] [info] Caused by: org.xwiki.rendering.RenderingException: Failed to evaluate template with id [jar:file:/var/lib/xwiki/data/extension/repository/org%252Exwiki%252Econtrib%252Ereplication%253Areplication-entity-default/1%252E12%252E3/org%252Exwiki%252Econtrib%252Ereplication%253Areplication-entity-default-1%252E12%252E3.jar!/templates/replication/conflict.vm]
[2023-08-24 15:50:31] [info] Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getConflict' in  class org.xwiki.contrib.replication.entity.script.DocumentReplicationScriptService threw exception org.xwiki.contrib.replication.ReplicationException: Failed to execute the select at /skins/flamingo/view.vm[line 23, column 37]
[2023-08-24 15:50:31] [info] Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: HibernateReplicationDocument is not mapped [SELECT conflict FROM HibernateReplicationDocument where docId = :docId]

There are plenty more, but these look, to my untrained eye, the most obvious.

Cheers
jamie

tmortagne · August 25, 2023, 1:45pm

This just indicate that the table does not exist. What you need is the error explaining why it failed to create it, and this is done at startup (the first time you access XWiki after a restart).

jamiemc01 · August 29, 2023, 2:55pm

Hi, I decided to roll back via a backup. Thanks for all your help. Its appreciated

Now I need to work out why my office importer isnt working.

ixul · March 19, 2024, 11:56am

I am piggibacking on this as I have the same error. It does not seem to want to create the table in the database although I restarted Xwiki after the install. What version of postgresql does the extension need ? We are using version 14.

Caused by: org.postgresql.util.PSQLException: ERROR: relation “replication_document” does not exist
Position: 52

Thank you for your help

tmortagne · March 19, 2024, 1:35pm

Nothing special in theory; whatever works with XWiki in general should be fine.

Do you have any error in the application server log related to the table creation that could explain why it failed to create it ?

ixul · March 19, 2024, 1:47pm

The error message also contains the following

Caused by: org.xwiki.rendering.RenderingException: Failed to evaluate template with id [jar:file:/C:/ProgramData/XWikiData/extension/repository/org%252Exwiki%252Econtrib%252Ereplication%253Areplication-entity-default/1%252E12%252E11/org%252Exwiki%252Econtrib%252Ereplication%253Areplication-entity-default-1%252E12%252E11.jar!/templates/replication/conflict.vm]

and

Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method ‘getConflict’ in class org.xwiki.contrib.replication.entity.script.DocumentReplicationScriptService threw exception org.xwiki.contrib.replication.ReplicationException: Failed to execute the select at jar:file:/C:/ProgramData/XWikiData/extension/repository/org%252Exwiki%252Econtrib%252Ereplication%253Areplication-entity-default/1%252E12%252E11/org%252Exwiki%252Econtrib%252Ereplication%253Areplication-entity-default-1%252E12%252E11.jar!/templates/replication/conflict.vm[line 23, column 37]

But that folder (org%252Exwiki%…) does not exist
There are however many that start with

org%2Exwiki%2Econtrib%2Ereplication%3

tmortagne · March 19, 2024, 2:03pm

What’s in the error you pasted is not really a folder, it’s an identifier which is based on a folder but modified a bit. Anyway the error is not saying there is a problem with any folder, you would need to paste the complete error with all the “Caused by” (the interesting one is generally the last one).

In any case that’s something you get when viewing a page, what would be more interesting is the startup log since it’s supposed to have tried to create the replication_document table at startup.

ixul · March 19, 2024, 3:49pm

I uninstalled version 1.12.11 and restarted xwiki… twice. If you only restart it once it does not remove all the dependencies and there is still an error message. I then installed 1.12.0. And… no error. I will not try the other versions in-between. (at least not for now) . I will see to get the log and extract the error.

We use Xwiki 15.10.7 on windows 2022 standard with postgresql 14 and tomcat 9.

ixul · March 19, 2024, 3:56pm

Here are already 2 errors I found that I think is linked to replication

2024-03-19 12:39:10,409 [XWiki initialization] ERROR c.x.x.i.s.h.HibernateStore - Error executing DDL “create table public.replication_document (XWD_ID int8 not null, XWRD_OWNER varchar(768) not null, XWRD_CONFLICT boolean default 0 not null, XWRD_READONLY boolean default 0 not null, primary key (XWD_ID))” via JDBC Statement
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL “create table public.replication_document (XWD_ID int8 not null, XWRD_OWNER varchar(768) not null, XWRD_CONFLICT boolean default 0 not null, XWRD_READONLY boolean default 0 not null, primary key (XWD_ID))” via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:581)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:526)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:293)
at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:74)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:220)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:123)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:94)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:63)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1171)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1038)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1205)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:264)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.hibernateShemaUpdate(HibernateDataMigrationManager.java:214)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:195)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:735)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:657)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:363)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:637)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:614)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:539)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:867)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:576)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1040)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:399)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2196)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2258)
at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1459)
at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1426)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1354)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1291)
at com.xpn.xwiki.XWiki.(XWiki.java:1264)
at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:103)
at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:246)
at org.xwiki.job.AbstractJob.run(AbstractJob.java:223)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: org.postgresql.util.PSQLException: ERROR: column “xwrd_conflict” is of type boolean but default expression is of type integer
Hint: You will need to rewrite or cast the expression.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182)
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)

2024-03-19 12:39:10,409 [XWiki initialization] ERROR .HibernateDataMigrationManager - Failed to migrate database [xwiki]…
com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of wiki [xwiki]
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:199)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:735)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:657)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:363)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:637)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:614)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:539)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:867)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:576)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1040)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:399)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2196)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2258)
at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1459)
at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1426)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1354)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1291)
at com.xpn.xwiki.XWiki.(XWiki.java:1264)
at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:103)
at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:246)
at org.xwiki.job.AbstractJob.run(AbstractJob.java:223)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: org.hibernate.HibernateException: Failed to update the database. See the log for all errors
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1184)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1038)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1205)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:264)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.hibernateShemaUpdate(HibernateDataMigrationManager.java:214)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:195)
… 21 common frames omitted
Caused by: org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL “create table public.replication_document (XWD_ID int8 not null, XWRD_OWNER varchar(768) not null, XWRD_CONFLICT boolean default 0 not null, XWRD_READONLY boolean default 0 not null, primary key (XWD_ID))” via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:581)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:526)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:293)
at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:74)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:220)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:123)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:94)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:63)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1171)
… 26 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: column “xwrd_conflict” is of type boolean but default expression is of type integer
Hint: You will need to rewrite or cast the expression.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182)
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
… 35 common frames omitted

ixul · April 5, 2024, 12:26pm

UPDATE: When I install the latest LTS version 15.10.8, I can also install the latest version of the replication extension (1.12.11), without error message, and all working fine.

tmortagne · April 5, 2024, 12:53pm

OK, it’s strange since the database mapping is on replication extension side (which indeed indicate 0 as default value because unfortunately declaring false was breaking Oracle apparently). There is no reason that upgrading from XWiki 15.10.7 to 15.10.8 help with that. Your new install still use the same postgres setup ?

And sorry I totally missed your previous messages, not sure why.

ixul · May 8, 2024, 8:07am

Yes, I am still using the same postgres setup. I did the production server today: upgraded from 15.10.7 to 15.10.8. However I have to note that I first have to install the extension in version 1.12.1 and then upgrade it as well. If I install the latest straight away, I will have error messages, even after restarting xwiki.

tmortagne · May 13, 2024, 8:27am

That’s because 1.12.1 uses ‘true’ and the default value is not updated when the table already exists.

So that means we have a serious regression in the Replication App when used with postgress. Just created Loading... and will need to find a solution which please both Postgres and Oracle.