When using ModeShape, BRMS and MySQL, there's a timing issue when nodes are being checked in, causing an ItemNotFoundException

When using BRMS, ModeShape and a MySQL database, the server doesn't start, with the following exception appearing in the server log:

Caused by: org.drools.repository.RulesRepositoryException: Unable to checkin.
at org.drools.repository.VersionableItem.checkin(VersionableItem.java:591)
at org.drools.repository.RulesRepository.createPackage(RulesRepository.java:860)
at org.drools.repository.RulesRepository.createPackage(RulesRepository.java:813)
at org.drools.repository.RulesRepository.listPackages(RulesRepository.java:1379)
at org.drools.repository.migration.MigrateDroolsPackage.migrate(MigrateDroolsPackage.java:43)
at org.drools.repository.RulesRepository.checkForDataMigration(RulesRepository.java:148)
at org.drools.repository.RulesRepository.<init>(RulesRepository.java:139)
at org.drools.guvnor.server.repository.RepositoryStartupService.create(RepositoryStartupService.java:155)
at org.drools.guvnor.server.repository.RepositoryStartupService.create(RepositoryStartupService.java:94)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
at org.drools.guvnor.server.repository.RepositoryStartupService_$$javassist_1.create(RepositoryStartupService$$_javassist_1.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:138)
at org.jboss.seam.Component.callComponentMethod(Component.java:2171)
at org.jboss.seam.Component.callCreateMethod(Component.java:2094)
at org.jboss.seam.Component.newInstance(Component.java:2054)
... 74 more
Caused by: javax.jcr.ItemNotFoundException: Unable to find "/

{http://www.jcp.org/jcr/1.0}

system/

{http://www.jcp.org/jcr/1.0}

versionStorage/{}49/{}c9/{}09/{}6f/{}02dc-4c69-ba72-41459f67293c/{}2011-08-23T23?03?07.194-05?00"; lowest existing path is "/

{http://www.jcp.org/jcr/1.0}

system/

{http://www.jcp.org/jcr/1.0}

versionStorage/{}49/{}c9/{}09/{}6f/{}02dc-4c69-ba72-41459f67293c"
at org.modeshape.jcr.SessionCache.findJcrNode(SessionCache.java:621)
at org.modeshape.jcr.JcrVersionManager.checkin(JcrVersionManager.java:374)
at org.modeshape.jcr.JcrVersionManager.checkin(JcrVersionManager.java:1722)
at org.drools.repository.VersionableItem.checkin(VersionableItem.java:581)
... 106 more

This works with the default H2 repo and postgres.