Vinod Holani created OAK-9096:
---------------------------------
Summary: RDBDocumentStore: Update error code for MSSQL 2019
Key: OAK-9096
URL: https://issues.apache.org/jira/browse/OAK-9096
Project: Jackrabbit Oak
Issue Type: Improvement
Components: rdbmk
Affects Versions: 1.30.0, 1.22.3, 1.26.0
Reporter: Vinod Holani
Assignee: Vinod Holani
Getting below exception on RDBMK setup with MSSQL 2019 using jdbc version 8.2.2
Caused by: org.apache.jackrabbit.oak.api.CommitFailedException: OakOak0001:
Update for path failedCaused by:
org.apache.jackrabbit.oak.api.CommitFailedException: OakOak0001: Update for
path failed at
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStoreBranch.mergeFailed(DocumentNodeStoreBranch.java:334)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStoreBranch.access$600(DocumentNodeStoreBranch.java:55)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStoreBranch$InMemory.merge(DocumentNodeStoreBranch.java:539)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStoreBranch.merge0(DocumentNodeStoreBranch.java:194)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStoreBranch.merge(DocumentNodeStoreBranch.java:119)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.DocumentRootBuilder.merge(DocumentRootBuilder.java:170)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore.merge(DocumentNodeStore.java:1869)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.core.MutableRoot.commit(MutableRoot.java:250)
[org.apache.jackrabbit.oak-core:1.10.8] at
org.apache.jackrabbit.oak.jcr.delegate.SessionDelegate.commit(SessionDelegate.java:346)
[org.apache.jackrabbit.oak-jcr:1.10.8] at
org.apache.jackrabbit.oak.jcr.delegate.SessionDelegate.save(SessionDelegate.java:493)
[org.apache.jackrabbit.oak-jcr:1.10.8] ... 14 common frames omittedCaused by:
org.apache.jackrabbit.oak.plugins.document.DocumentStoreException: Update for
path failed at
org.apache.jackrabbit.oak.plugins.document.rdb.RDBJDBCTools.asDocumentStoreException(RDBJDBCTools.java:434)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.handleException(RDBDocumentStore.java:2377)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.handleException(RDBDocumentStore.java:2382)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.updateDocument(RDBDocumentStore.java:2108)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.internalUpdate(RDBDocumentStore.java:1670)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.internalCreateOrUpdate(RDBDocumentStore.java:1637)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.findAndUpdate(RDBDocumentStore.java:603)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.util.LeaseCheckDocumentStoreWrapper.findAndUpdate(LeaseCheckDocumentStoreWrapper.java:141)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore.updateCommitRoot(DocumentNodeStore.java:1540)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.Commit.conditionalCommit(Commit.java:440)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.Commit.applyToDocumentStore(Commit.java:329)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.Commit.applyToDocumentStore(Commit.java:252)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.Commit.applyInternal(Commit.java:220)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.Commit.apply(Commit.java:208)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStoreBranch.persist(DocumentNodeStoreBranch.java:310)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStoreBranch.persist(DocumentNodeStoreBranch.java:275)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStoreBranch.access$500(DocumentNodeStoreBranch.java:55)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStoreBranch$InMemory.merge(DocumentNodeStoreBranch.java:531)
[org.apache.jackrabbit.oak-store-document:1.10.8] ... 21 common frames
omittedCaused by: com.microsoft.sqlserver.jdbc.SQLServerException: String or
binary data would be truncated in table 'NODES', column 'DATA'. Truncated
value:
'\{"_deleted":{"r171a9e9bdfa-0-1":"false"},"jcr:created":{"r171a9e9bdfa-0-1":"\"dat:2020-04-24T02:00:0'.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
[com.microsoft.sqlserver.mssql-jdbc:8.2.2] at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632)
[com.microsoft.sqlserver.mssql-jdbc:8.2.2] at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:600)
[com.microsoft.sqlserver.mssql-jdbc:8.2.2] at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
[com.microsoft.sqlserver.mssql-jdbc:8.2.2] at
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7225)
[com.microsoft.sqlserver.mssql-jdbc:8.2.2] at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3053)
[com.microsoft.sqlserver.mssql-jdbc:8.2.2] at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:247)
[com.microsoft.sqlserver.mssql-jdbc:8.2.2] at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:222)
[com.microsoft.sqlserver.mssql-jdbc:8.2.2] at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:471)
[com.microsoft.sqlserver.mssql-jdbc:8.2.2] at
sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498) at
org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:212)
[org.apache.sling.datasource:1.0.4] at
com.sun.proxy.$Proxy19.executeUpdate(Unknown Source) at
sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498) at
org.apache.tomcat.jdbc.pool.interceptor.StatementDecoratorInterceptor$StatementProxy.invoke(StatementDecoratorInterceptor.java:237)
[org.apache.sling.datasource:1.0.4] at
com.sun.proxy.$Proxy19.executeUpdate(Unknown Source) at
sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498) at
org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
[org.apache.sling.datasource:1.0.4] at
com.sun.proxy.$Proxy19.executeUpdate(Unknown Source) at
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStoreJDBC.appendingUpdate(RDBDocumentStoreJDBC.java:132)
[org.apache.jackrabbit.oak-store-document:1.10.8] at
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.updateDocument(RDBDocumentStore.java:2074)
[org.apache.jackrabbit.oak-store-document:1.10.8] ... 35 common frames omitted
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
