Skip to content

Instantly share code, notes, and snippets.

@felipebn

felipebn/debug.log

Created November 6, 2018 11:20
Show Gist options
  • Save felipebn/88ccd551781252efa15720fea589e700 to your computer and use it in GitHub Desktop.
Save felipebn/88ccd551781252efa15720fea589e700 to your computer and use it in GitHub Desktop.
Download ZIP
Neo4j Error - Issue #12058
Raw
debug.log
2018-11-06 11:17:38.336 [http-nio-8080-exec-2] T:DEFAULT_TENANT INFO o.n.o.d.bolt.request.BoltRequest - Request: MATCH subJobFamilyPath=(subJobFamily:SubJobFamily)-[toDescriptions:GJC_CATEGORY_TO_DESCRIPTION]->(subDescription:DescriptionElement)-[subToPayload]->(subPayload:JobCatalogLocalizedPayload) WHERE subJobFamily.uuid IN {subJobFamilyIds} AND subToPayload.language IN {languages} AND ALL( rel IN [toDescriptions, subToPayload] WHERE rel.min - {revision} <= 0 AND rel.max - {revision} > 0 )OPTIONAL MATCH subFamToDetail=(subJobFamily)-[toDetails:GJC_CATEGORY_TO_DETAIL]->(detail:JobCategoryDetail)-[detailToDefinition:GJC_DETAIL_TO_DEFINITION]->(detailDefinition:JobCategoryDetailDefinition)-[detailDefinitionToPayload:GJC_DETAIL_DEFINITION]->(detailDefinitionPayload:JobCatalogLocalizedPayload) WHERE detailDefinitionToPayload.language IN (COALESCE({languages},[]) + detailDefinition.defaultLanguage) AND ALL( rel IN [toDetails] WHERE rel.min - {revision} <= 0 AND rel.max - {revision} > 0 )OPTIONAL MATCH detailToLevels=(detail)-[toLevels:GJC_DETAIL_TO_LEVEL]->(level:JobCategoryDetailLevel)-[levelToPayload:GJC_DETAIL_LEVEL]->(levelPayload:JobCatalogLocalizedPayload) WHERE levelToPayload.language IN (COALESCE({languages},[]) + detailDefinition.defaultLanguage) AND ALL( rel IN [toLevels] WHERE rel.min - {revision} <= 0 AND rel.max - {revision} > 0 )OPTIONAL MATCH levelToItems=(level)-[:GJC_LEVEL_TO_ITEM]->()-[:GJC_LEVEL_ITEM]->() OPTIONAL MATCH (detailDefinition)<-[detailDefinitionGroupToDetail:GJC_DEFINITION_GROUP_TO_DEFINITION]-(detailDefinitionGroup:JobCategoryDetailDefinitionGroup)-[detailDefinitionGroupToPayload:GJC_DETAIL_DEFINITION_GROUP]->(detailDefinitionGroupPayload:JobCatalogLocalizedPayload) WHERE detailDefinitionGroupToPayload.language IN (COALESCE({languages},[]) + detailDefinition.defaultLanguage) OPTIONAL MATCH groupLevels=(detailDefinitionGroup)-[toGroupLevel:GJC_DEFINITION_GROUP_TO_LEVEL]->(groupLevel:JobCategoryDetailLevel)-[groupLevelToPayload:GJC_DETAIL_LEVEL]->(groupLevelPayload:JobCatalogLocalizedPayload) WHERE toGroupLevel.language IN (COALESCE({languages},[]) + detailDefinition.defaultLanguage) OPTIONAL MATCH groupLevelToItems=(groupLevel)-[:GJC_LEVEL_TO_ITEM]->()-[:GJC_LEVEL_ITEM]->() OPTIONAL MATCH jobFamilyPath=(subJobFamily)<-[toJobFamily]-(jobFamily:JobFamily)-[:GJC_CATEGORY_TO_DESCRIPTION{main:true}]->(famDescription:DescriptionElement)-[famToPayload]->(famPayload:JobCatalogLocalizedPayload) WHERE famToPayload.language IN {languages} AND ALL( rel IN [toJobFamily , famToPayload] WHERE rel.min - {revision} <= 0 AND rel.max - {revision} > 0 ) OPTIONAL MATCH famToDetails=(jobFamily)-[famDetails:GJC_CATEGORY_TO_DETAIL]->(famDetail:JobCategoryDetail)-[:GJC_DETAIL_TO_DEFINITION]->(famDetailDefinition:JobCategoryDetailDefinition)-[famDetailDefinitionToPayload:GJC_DETAIL_DEFINITION]->(:JobCatalogLocalizedPayload) WHERE famDetailDefinitionToPayload.language IN (COALESCE({languages},[]) + famDetailDefinition.defaultLanguage) AND ALL( rel IN [famDetails] WHERE rel.min - {revision} <= 0 AND rel.max - {revision} > 0 ) OPTIONAL MATCH famDetailToLevels=(famDetail)-[famDetailtoLevels:GJC_DETAIL_TO_LEVEL]->(famDetailLevel:JobCategoryDetailLevel)-[famDetailLevelToPayload:GJC_DETAIL_LEVEL]->(famDetailLevelPayload:JobCatalogLocalizedPayload) WHERE famDetailLevelToPayload.language IN (COALESCE({languages},[]) + famDetailDefinition.defaultLanguage) AND ALL( rel IN [famDetailtoLevels] WHERE rel.min - {revision} <= 0 AND rel.max - {revision} > 0 )OPTIONAL MATCH famLevelToItems=(famDetailLevel)-[:GJC_LEVEL_TO_ITEM]->()-[:GJC_LEVEL_ITEM]->() OPTIONAL MATCH (famDetailDefinition)<-[famDetailDefinitionGroupToDetail:GJC_DEFINITION_GROUP_TO_DEFINITION]-(famDetailDefinitionGroup:JobCategoryDetailDefinitionGroup) OPTIONAL MATCH famGroupLevels=(famDetailDefinitionGroup)-[famDetailtoGroupLevel:GJC_DEFINITION_GROUP_TO_LEVEL]->(famGroupLevel:JobCategoryDetailLevel)-[famGroupLevelToPayload:GJC_DETAIL_LEVEL]->(famGroupLevelPayload:JobCatalogLocalizedPayload) WHERE famDetailtoGroupLevel.language IN (COALESCE({languages},[]) + famDetailDefinition.defaultLanguage) OPTIONAL MATCH famGroupLevelToItems=(famGroupLevel)-[:GJC_LEVEL_TO_ITEM]->()-[:GJC_LEVEL_ITEM]->() OPTIONAL MATCH jobCatalogPath=(jobFamily)<-[toJobCatalog]-(jobCatalog:JobCatalog) WHERE toJobCatalog.min - {revision} <= 0 AND toJobCatalog.max - {revision} > 0 AND ({catalogIds} IS NOT NULL AND jobCatalog.uuid IN {catalogIds})OPTIONAL MATCH (jobCatalog)-[catalogToConfig:GJC_CATALOG_TO_CONFIG]->(configFields) OPTIONAL MATCH (configFields)-[configFieldsToComposition:GJC_CONFIG_TO_COMPOSITION]->(composition:JobCategoryDetailDefinitionGroup)-[compositionToPayload:GJC_DETAIL_DEFINITION_GROUP]->(compositionPayload:JobCatalogLocalizedPayload) WHERE configFieldsToComposition.min - {revision} <= 0 AND configFieldsToComposition.max - {revision} > 0 RETURN * with params {languages=[en], subJobFamilyIds=[9b63295e-fb71-418b-acbd-47dbce0b46ff], catalogIds=[0c18a5db-e88f-4c3e-8c81-58ddaca2dd9b], revision=6}
2018-11-06 11:17:38.344 [http-nio-8080-exec-2] T:DEFAULT_TENANT WARN RequestCycleExtra - ********************************
2018-11-06 11:17:38.344 [http-nio-8080-exec-2] T:DEFAULT_TENANT WARN RequestCycleExtra - Handling the following exception
org.neo4j.driver.v1.exceptions.DatabaseException: ( rel@2650,RefSlot(0,true,Any)) (of class scala.Tuple2)
at org.neo4j.driver.internal.net.SocketResponseHandler.handleFailureMessage(SocketResponseHandler.java:83)
at org.neo4j.driver.internal.messaging.PackStreamMessageFormatV1$Reader.unpackFailureMessage(PackStreamMessageFormatV1.java:470)
at org.neo4j.driver.internal.messaging.PackStreamMessageFormatV1$Reader.read(PackStreamMessageFormatV1.java:431)
at org.neo4j.driver.internal.net.SocketClient.receiveOne(SocketClient.java:196)
at org.neo4j.driver.internal.net.SocketConnection.receiveOne(SocketConnection.java:217)
at org.neo4j.driver.internal.net.ConcurrencyGuardingConnection.receiveOne(ConcurrencyGuardingConnection.java:165)
at org.neo4j.driver.internal.net.pooling.PooledSocketConnection.receiveOne(PooledSocketConnection.java:183)
at org.neo4j.driver.internal.InternalStatementResult.receiveOne(InternalStatementResult.java:335)
at org.neo4j.driver.internal.InternalStatementResult.tryFetchNext(InternalStatementResult.java:325)
at org.neo4j.driver.internal.InternalStatementResult.hasNext(InternalStatementResult.java:193)
at org.neo4j.ogm.drivers.bolt.response.GraphModelResponse.fetchNext(GraphModelResponse.java:36)
at org.neo4j.ogm.drivers.bolt.response.GraphModelResponse.fetchNext(GraphModelResponse.java:26)
at org.neo4j.ogm.drivers.bolt.response.BoltResponse.next(BoltResponse.java:45)
at org.neo4j.ogm.context.GraphEntityMapper.map(GraphEntityMapper.java:95)
at org.neo4j.ogm.session.delegates.ExecuteQueriesDelegate.lambda$executeAndMap$1(ExecuteQueriesDelegate.java:123)
at org.neo4j.ogm.session.Neo4jSession.doInTransaction(Neo4jSession.java:528)
at org.neo4j.ogm.session.delegates.ExecuteQueriesDelegate.executeAndMap(ExecuteQueriesDelegate.java:119)
at org.neo4j.ogm.session.delegates.ExecuteQueriesDelegate.query(ExecuteQueriesDelegate.java:90)
at org.neo4j.ogm.session.Neo4jSession.query(Neo4jSession.java:409)
at jdk.internal.reflect.GeneratedMethodAccessor407.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.springframework.data.neo4j.transaction.SharedSessionCreator$SharedSessionInvocationHandler.invoke(SharedSessionCreator.java:131)
at com.sun.proxy.$Proxy258.query(Unknown Source)
at org.springframework.data.neo4j.repository.query.GraphQueryExecution$CollectionExecution.execute(GraphQueryExecution.java:107)
at org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.doExecute(GraphRepositoryQuery.java:77)
at org.springframework.data.neo4j.repository.query.AbstractGraphRepositoryQuery.execute(AbstractGraphRepositoryQuery.java:51)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:590)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:578)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
Raw
query_with_error.cypher
MATCH subJobFamilyPath=(subJobFamily:SubJobFamily)-[toDescriptions:GJC_CATEGORY_TO_DESCRIPTION]->(subDescription:DescriptionElement)-[subToPayload]->(subPayload:JobCatalogLocalizedPayload) WHERE subJobFamily.uuid IN ["9b63295e-fb71-418b-acbd-47dbce0b46ff"] AND subToPayload.language IN ["en"] AND ALL( rel IN [toDescriptions, subToPayload] WHERE rel.min - 6 <= 0 AND rel.max - 6 > 0 )
OPTIONAL MATCH subFamToDetail=(subJobFamily)-[toDetails:GJC_CATEGORY_TO_DETAIL]->(detail:JobCategoryDetail)-[detailToDefinition:GJC_DETAIL_TO_DEFINITION]->(detailDefinition:JobCategoryDetailDefinition)-[detailDefinitionToPayload:GJC_DETAIL_DEFINITION]->(detailDefinitionPayload:JobCatalogLocalizedPayload) WHERE detailDefinitionToPayload.language IN (COALESCE(["en"],[]) + detailDefinition.defaultLanguage) AND ALL( rel IN [toDetails] WHERE rel.min - 6 <= 0 AND rel.max - 6 > 0 )
OPTIONAL MATCH detailToLevels=(detail)-[toLevels:GJC_DETAIL_TO_LEVEL]->(level:JobCategoryDetailLevel)-[levelToPayload:GJC_DETAIL_LEVEL]->(levelPayload:JobCatalogLocalizedPayload) WHERE levelToPayload.language IN (COALESCE(["en"],[]) + detailDefinition.defaultLanguage) AND ALL( rel IN [toLevels] WHERE rel.min - 6 <= 0 AND rel.max - 6 > 0 )
OPTIONAL MATCH levelToItems=(level)-[:GJC_LEVEL_TO_ITEM]->()-[:GJC_LEVEL_ITEM]->()
OPTIONAL MATCH (detailDefinition)<-[detailDefinitionGroupToDetail:GJC_DEFINITION_GROUP_TO_DEFINITION]-(detailDefinitionGroup:JobCategoryDetailDefinitionGroup)-[detailDefinitionGroupToPayload:GJC_DETAIL_DEFINITION_GROUP]->(detailDefinitionGroupPayload:JobCatalogLocalizedPayload) WHERE detailDefinitionGroupToPayload.language IN (COALESCE(["en"],[]) + detailDefinition.defaultLanguage)
OPTIONAL MATCH groupLevels=(detailDefinitionGroup)-[toGroupLevel:GJC_DEFINITION_GROUP_TO_LEVEL]->(groupLevel:JobCategoryDetailLevel)-[groupLevelToPayload:GJC_DETAIL_LEVEL]->(groupLevelPayload:JobCatalogLocalizedPayload) WHERE toGroupLevel.language IN (COALESCE(["en"],[]) + detailDefinition.defaultLanguage)
OPTIONAL MATCH groupLevelToItems=(groupLevel)-[:GJC_LEVEL_TO_ITEM]->()-[:GJC_LEVEL_ITEM]->()
OPTIONAL MATCH jobFamilyPath=(subJobFamily)<-[toJobFamily]-(jobFamily:JobFamily)-[:GJC_CATEGORY_TO_DESCRIPTION{main:true}]->(famDescription:DescriptionElement)-[famToPayload]->(famPayload:JobCatalogLocalizedPayload) WHERE famToPayload.language IN ["en"] AND ALL( rel IN [toJobFamily , famToPayload] WHERE rel.min - 6 <= 0 AND rel.max - 6 > 0 )
OPTIONAL MATCH famToDetails=(jobFamily)-[famDetails:GJC_CATEGORY_TO_DETAIL]->(famDetail:JobCategoryDetail)-[:GJC_DETAIL_TO_DEFINITION]->(famDetailDefinition:JobCategoryDetailDefinition)-[famDetailDefinitionToPayload:GJC_DETAIL_DEFINITION]->(:JobCatalogLocalizedPayload) WHERE famDetailDefinitionToPayload.language IN (COALESCE(["en"],[]) + famDetailDefinition.defaultLanguage) AND ALL( rel IN [famDetails] WHERE rel.min - 6 <= 0 AND rel.max - 6 > 0 )
OPTIONAL MATCH famDetailToLevels=(famDetail)-[famDetailtoLevels:GJC_DETAIL_TO_LEVEL]->(famDetailLevel:JobCategoryDetailLevel)-[famDetailLevelToPayload:GJC_DETAIL_LEVEL]->(famDetailLevelPayload:JobCatalogLocalizedPayload) WHERE famDetailLevelToPayload.language IN (COALESCE(["en"],[]) + famDetailDefinition.defaultLanguage) AND ALL( rel IN [famDetailtoLevels] WHERE rel.min - 6 <= 0 AND rel.max - 6 > 0 )
OPTIONAL MATCH famLevelToItems=(famDetailLevel)-[:GJC_LEVEL_TO_ITEM]->()-[:GJC_LEVEL_ITEM]->()
OPTIONAL MATCH (famDetailDefinition)<-[famDetailDefinitionGroupToDetail:GJC_DEFINITION_GROUP_TO_DEFINITION]-(famDetailDefinitionGroup:JobCategoryDetailDefinitionGroup)
OPTIONAL MATCH famGroupLevels=(famDetailDefinitionGroup)-[famDetailtoGroupLevel:GJC_DEFINITION_GROUP_TO_LEVEL]->(famGroupLevel:JobCategoryDetailLevel)-[famGroupLevelToPayload:GJC_DETAIL_LEVEL]->(famGroupLevelPayload:JobCatalogLocalizedPayload) WHERE famDetailtoGroupLevel.language IN (COALESCE(["en"],[]) + famDetailDefinition.defaultLanguage)
OPTIONAL MATCH famGroupLevelToItems=(famGroupLevel)-[:GJC_LEVEL_TO_ITEM]->()-[:GJC_LEVEL_ITEM]->()
OPTIONAL MATCH jobCatalogPath=(jobFamily)<-[toJobCatalog]-(jobCatalog:JobCatalog) WHERE toJobCatalog.min - 6 <= 0 AND toJobCatalog.max - 6 > 0 AND (["0c18a5db-e88f-4c3e-8c81-58ddaca2dd9b"] IS NOT NULL AND jobCatalog.uuid IN ["0c18a5db-e88f-4c3e-8c81-58ddaca2dd9b"])
OPTIONAL MATCH (jobCatalog)-[catalogToConfig:GJC_CATALOG_TO_CONFIG]->(configFields)
OPTIONAL MATCH (configFields)-[configFieldsToComposition:GJC_CONFIG_TO_COMPOSITION]->(composition:JobCategoryDetailDefinitionGroup)-[compositionToPayload:GJC_DETAIL_DEFINITION_GROUP]->(compositionPayload:JobCatalogLocalizedPayload) WHERE configFieldsToComposition.min - 6 <= 0 AND configFieldsToComposition.max - 6 > 0
RETURN *
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment