[OAK-7855] rdbmk: Invalid SplitDocType when run on non-upgraded DB

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8.0
• Fix Version/s: 1.10.0, 1.8.9, 1.9.10
• Component/s: documentmk, rdbmk
• Assignee: Julian Reschke
• Reporter: Marcel Reutegger
• Created: 22/Oct/18 09:42
• Updated: 06/Nov/18 10:28
• Resolved: 31/Oct/18 14:50

Description

After upgrading a repository from 1.8.2 to 1.8.7 on RDB the background update thread started to log warnings that complain about invalid SplitDocType:

java.lang.IllegalArgumentException: Not a valid SplitDocType :0

It is also worth noting that the automatic database schema upgrade fails on that repository with:

org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore Attempted to upgrade NODES to DB level 2 using 'alter table NODES add SDTYPE smallint', but failed - will continue without.
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=Q1D18T05;ALTER TABLE;G031.NODES, DRIVER=4.23.42

and

org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore Attempted to upgrade NODES to DB level 2 using 'create index NODES_SDT on NODES (SDTYPE) exclude null keys', but failed - will continue without.
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-205, SQLSTATE=42703, SQLERRMC=SDTYPE;G031.NODES, DRIVER=4.23.42

It turns out this is unrelated to the update from 1.8.2 to 1.8.7. The issue also occurs with 1.8.0.