[jira] [Resolved] (OAK-8917) Thousands ConflitException on .createRepository()

["Marcel Reutegger (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OAK-8917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Marcel Reutegger resolved OAK-8917.
-----------------------------------
    Resolution: Won't Fix

Thanks for the feedback. Resolving this issue as WONTFIX. I agree it would be better if the implementation points a misconfiguration rather than throwing a strange exception, but this would be an improvement.

> Thousands ConflitException on .createRepository()
> -------------------------------------------------
>
>                 Key: OAK-8917
>                 URL: https://issues.apache.org/jira/browse/OAK-8917
>             Project: Jackrabbit Oak
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.24.0
>            Reporter: Olivier Jolit
>            Priority: Minor
>         Attachments: effective-pom.xml, output
>
>
> I use OAK in my Spring Boot application to store user content (bookmarks). Users will write to OAK via REST calls.
> So I create a repository (in a Spring Bean) on my application startup with:
> {code:java}
> public OakBookmarkService() {
>     RDBDocumentNodeStoreBuilder.newRDBDocumentNodeStoreBuilder()
>         .setRDBConnection(RDBDataSourceFactory.forJdbcUrl("jdbc:postgresql://" + host + ":" + port + "/" + db + "?currentSchema= " + schema, user, password, sqlDriverClassName)).build()
>     SecurityProvider securityProvider = new BookmarksSecurityProvider(rolesProvider);
>     ThreeWayConflictHandler threeWayConflictHandler = new BookmarkConflictHandler();
>     repository = new Jcr(new Oak(store)).with(securityProvider).with(threeWayConflictHandler).createRepository(); 
> ...
> }{code}
> The issue I have is that this creation of the repository throws thousands of ConflitExceptions like:
> {code:java}
> The node 1:/jcr:system already existed in revision
> r170631ac223-0-1 (older than base r17063a941e2-0-1), commit revision: r17063a95314-0-1 {code}
> Which prevent my application from starting.
> Deleting all the tables in my PostgreSQL database between each startup of my server fixes this issue but is obviously not expected. So it seems to me that OAK tries to recreate the default nodes in the database even though they already exist.
> I see in the documentation ([https://jackrabbit.apache.org/oak/docs/construct.html]) that I need to logout and dispose of the node store after each use. Do I have to do this when the server stops ? How to ensure this is done even when the server crashes in this case ?
> Or should I create the node store at the beginning of each REST call and dispose of it at the end every time ? For now I only create a session and close it for each call and am assuming creating the store each time is too expensive.
> Also, my conflict handler (that always returns Resolution.OURS for now) does not seem to be called in this scenario, which surprises me.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)