Error message in replication

Hello,
I recently upgraded the replication extension to the latest version and when I want to add a page (with children) to the replication I have the following error:

Failed to execute template. Cause: [ERROR: null value in column “docid” of relation “replication_document” violates not-null constraint Detail: Failing row contains (null, null, null, -3505024300970076781, http://xwikixxx:8080/xwiki, null, f, f).]. Click on this message for details.

xwiki_error3.txt (29.2 KB)

I have attached the full error. We use PostGreSQL 14 and xwiki 15.10.8

Thank you for your assistance.

Hmm that sounds like a lot more columns than this table is supposed to contain.

Which version have you upgraded from ? This might have something to do with the fact that the column names changed in 1.2.1, for example there is no such thing as docid anymore (its name is XWD_ID now).

I guess the quick fix on your side would be to get rid of any column in that table which does not start with XWRD_ or XWD_. You might have similar leftovers in the table replication_entity_instances (columns which don’t start with XWR_ are wrong).

In the meantime it would be great if you could create an issue about that on the bug tracker. Will need to think about a proper way to migrate this table automatically I guess.