Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Running a GAP background job does not return a result #583

Open
vfxcode opened this issue Feb 18, 2025 · 0 comments
Open

Running a GAP background job does not return a result #583

vfxcode opened this issue Feb 18, 2025 · 0 comments

Comments

@vfxcode
Copy link

vfxcode commented Feb 18, 2025

When we run a Map Analysis from two Standards we get the following error in the logs:

INFO:application.database.db:looking for gap analysis with cache key: Standard1 >> Standard2
INFO:application.database.db:found gap analysis with cache key: Standard1 >> Standard2
ERROR:application.web.web_main:Finished job does not have a result object, this is a bug!

The worker seems to print the following:

# FLASK_APP=`pwd`/cre.py python cre.py --start_worker
INFO:application.worker:Worker Starting
/code/application/__init__.py:50: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
  cache.init_app(app)
INFO:rq.worker:Worker rq:worker:957c08098c984eb393cc42a2b9b1b067 started with PID 572, version 2.1.0
INFO:rq.worker:Subscribing to channel rq:pubsub:957c08098c984eb393cc42a2b9b1b067
INFO:rq.worker:*** Listening on high, default, low...
INFO:rq.worker:Cleaning registries for queue: high
INFO:rq.worker:Cleaning registries for queue: default
INFO:rq.worker:Cleaning registries for queue: low
INFO:rq.worker:default: application.database.db.gap_analysis(cache_key='Standard1 >> Standard2', neo_db=<application.database.db.NEO_DB object at 0x7fbd34d5af50>, node_names=['Standard1', 'Standard2']) (2114c31a-5360-4329-8059-bd5a3866fe1f)
INFO:application.database.db:Performing GraphDB queries for gap analysis Standard1>>Standard2
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownLabelWarning} {category: UNRECOGNIZED} {title: The provided label is not in the database.} {description: One of the labels in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing label name is: NeoStandard)} {position: line: 2, column: 30, offset: 30} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL (n in NODES(p) where (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist) \n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownPropertyKeyWarning} {category: UNRECOGNIZED} {title: The provided property key is not in the database} {description: One of the property names in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing property name is: name)} {position: line: 3, column: 46, offset: 103} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL (n in NODES(p) where (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist) \n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownLabelWarning} {category: UNRECOGNIZED} {title: The provided label is not in the database.} {description: One of the labels in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing label name is: NeoCRE)} {position: line: 6, column: 62, offset: 273} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL (n in NODES(p) where (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist) \n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownPropertyKeyWarning} {category: UNRECOGNIZED} {title: The provided property key is not in the database} {description: One of the property names in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing property name is: name)} {position: line: 6, column: 123, offset: 334} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL (n in NODES(p) where (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist) \n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownPropertyKeyWarning} {category: UNRECOGNIZED} {title: The provided property key is not in the database} {description: One of the property names in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing property name is: name)} {position: line: 2, column: 43, offset: 43} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL (n in NODES(p) where (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist) \n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownLabelWarning} {category: UNRECOGNIZED} {title: The provided label is not in the database.} {description: One of the labels in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing label name is: NeoStandard)} {position: line: 3, column: 33, offset: 90} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL (n in NODES(p) where (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist) \n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownPropertyKeyWarning} {category: UNRECOGNIZED} {title: The provided property key is not in the database} {description: One of the property names in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing property name is: name)} {position: line: 6, column: 122, offset: 378} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[:(LINKED_TO|AUTOMATICALLY_LINKED_TO|CONTAINS)*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL(n in NODES(p) WHERE (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist)\n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownLabelWarning} {category: UNRECOGNIZED} {title: The provided label is not in the database.} {description: One of the labels in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing label name is: NeoStandard)} {position: line: 2, column: 30, offset: 30} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[:(LINKED_TO|AUTOMATICALLY_LINKED_TO|CONTAINS)*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL(n in NODES(p) WHERE (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist)\n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownRelationshipTypeWarning} {category: UNRECOGNIZED} {title: The provided relationship type is not in the database.} {description: One of the relationship types in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing relationship type is: AUTOMATICALLY_LINKED_TO)} {position: line: 4, column: 65, offset: 182} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[:(LINKED_TO|AUTOMATICALLY_LINKED_TO|CONTAINS)*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL(n in NODES(p) WHERE (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist)\n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownPropertyKeyWarning} {category: UNRECOGNIZED} {title: The provided property key is not in the database} {description: One of the property names in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing property name is: name)} {position: line: 3, column: 46, offset: 103} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[:(LINKED_TO|AUTOMATICALLY_LINKED_TO|CONTAINS)*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL(n in NODES(p) WHERE (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist)\n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownRelationshipTypeWarning} {category: UNRECOGNIZED} {title: The provided relationship type is not in the database.} {description: One of the relationship types in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing relationship type is: LINKED_TO)} {position: line: 4, column: 55, offset: 172} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[:(LINKED_TO|AUTOMATICALLY_LINKED_TO|CONTAINS)*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL(n in NODES(p) WHERE (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist)\n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownPropertyKeyWarning} {category: UNRECOGNIZED} {title: The provided property key is not in the database} {description: One of the property names in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing property name is: name)} {position: line: 2, column: 43, offset: 43} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[:(LINKED_TO|AUTOMATICALLY_LINKED_TO|CONTAINS)*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL(n in NODES(p) WHERE (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist)\n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownLabelWarning} {category: UNRECOGNIZED} {title: The provided label is not in the database.} {description: One of the labels in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing label name is: NeoStandard)} {position: line: 3, column: 33, offset: 90} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[:(LINKED_TO|AUTOMATICALLY_LINKED_TO|CONTAINS)*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL(n in NODES(p) WHERE (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist)\n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownLabelWarning} {category: UNRECOGNIZED} {title: The provided label is not in the database.} {description: One of the labels in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing label name is: NeoCRE)} {position: line: 6, column: 61, offset: 317} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[:(LINKED_TO|AUTOMATICALLY_LINKED_TO|CONTAINS)*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL(n in NODES(p) WHERE (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist)\n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownRelationshipTypeWarning} {category: UNRECOGNIZED} {title: The provided relationship type is not in the database.} {description: One of the relationship types in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing relationship type is: CONTAINS)} {position: line: 4, column: 89, offset: 206} for query: '\n         MATCH (BaseStandard:NeoStandard {name: $name1})\n         MATCH (CompareStandard:NeoStandard {name: $name2})\n         MATCH p = allShortestPaths((BaseStandard)-[:(LINKED_TO|AUTOMATICALLY_LINKED_TO|CONTAINS)*..20]-(CompareStandard))\n         WITH p\n         WHERE length(p) > 1 AND ALL(n in NODES(p) WHERE (n:NeoCRE or n = BaseStandard or n = CompareStandard) AND NOT n.name in $denylist)\n         RETURN p\n            '
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownLabelWarning} {category: UNRECOGNIZED} {title: The provided label is not in the database.} {description: One of the labels in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing label name is: NeoStandard)} {position: line: 1, column: 21, offset: 20} for query: ' MATCH (neostandard:NeoStandard) WHERE neostandard.name = $neostandard_name_1 RETURN neostandard'
WARNING:neo4j.notifications:Received notification from DBMS server: {severity: WARNING} {code: Neo.ClientNotification.Statement.UnknownPropertyKeyWarning} {category: UNRECOGNIZED} {title: The provided property key is not in the database} {description: One of the property names in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing property name is: name)} {position: line: 1, column: 52, offset: 51} for query: ' MATCH (neostandard:NeoStandard) WHERE neostandard.name = $neostandard_name_1 RETURN neostandard'
INFO:application.database.db:got db gap analysis for Standard1>>>Standard2, calculating paths
INFO:application.database.db:got gap analysis paths for Standard1>>>Standard2, storing result
INFO:application.database.db:adding gap analysis result with cache key: Standard1 >> Standard2
INFO:application.database.db:stored gapa analysis for Standard1>>>Standard2, successfully
INFO:rq.worker:Successfully completed application.database.db.gap_analysis(cache_key='Standard1 >> Standard2', neo_db=<application.database.db.NEO_DB object at 0x7fbd34d5af50>, node_names=['Standard1', 'Standard2']) job in 0:00:06.651509s on worker 957c08098c984eb393cc42a2b9b1b067
INFO:rq.worker:default: Job OK (2114c31a-5360-4329-8059-bd5a3866fe1f)
INFO:rq.worker:Result is kept for 500 seconds
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant