graphiti icon indicating copy to clipboard operation
graphiti copied to clipboard

Received notification from DBMS server

Open pxz2016 opened this issue 8 months ago • 4 comments

2025-03-10 22:25:59 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: content)} {position: line: 4, column: 18, offset: 143} for query: '\n MATCH (e:Episodic) WHERE e.valid_at <= $reference_time \n AND ($group_ids IS NULL) OR e.group_id in $group_ids\n RETURN e.content AS content,\n e.created_at AS created_at,\n e.valid_at AS valid_at,\n e.uuid AS uuid,\n e.group_id AS group_id,\n e.name AS name,\n e.source_description AS source_description,\n e.source AS source\n ORDER BY e.created_at DESC\n LIMIT $num_episodes\n ' 2025-03-10 22:25:59 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: source_description)} {position: line: 10, column: 15, offset: 345} for query: '\n MATCH (e:Episodic) WHERE e.valid_at <= $reference_time \n AND ($group_ids IS NULL) OR e.group_id in $group_ids\n RETURN e.content AS content,\n e.created_at AS created_at,\n e.valid_at AS valid_at,\n e.uuid AS uuid,\n e.group_id AS group_id,\n e.name AS name,\n e.source_description AS source_description,\n e.source AS source\n ORDER BY e.created_at DESC\n LIMIT $num_episodes\n ' 2025-03-10 22:25:59 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: source)} {position: line: 11, column: 15, offset: 401} for query: '\n MATCH (e:Episodic) WHERE e.valid_at <= $reference_time \n AND ($group_ids IS NULL) OR e.group_id in $group_ids\n RETURN e.content AS content,\n e.created_at AS created_at,\n e.valid_at AS valid_at,\n e.uuid AS uuid,\n e.group_id AS group_id,\n e.name AS name,\n e.source_description AS source_description,\n e.source AS source\n ORDER BY e.created_at DESC\n LIMIT $num_episodes\n ' 2025-03-10 22:26:00 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: content)} {position: line: 3, column: 22, offset: 63} for query: '\n MATCH (e:Episodic {uuid: $uuid})\n RETURN e.content AS content,\n e.created_at AS created_at,\n e.valid_at AS valid_at,\n e.uuid AS uuid,\n e.name AS name,\n e.group_id AS group_id,\n e.source_description AS source_description,\n e.source AS source,\n e.entity_edges AS entity_edges\n ' 2025-03-10 22:26:00 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: source_description)} {position: line: 9, column: 15, offset: 265} for query: '\n MATCH (e:Episodic {uuid: $uuid})\n RETURN e.content AS content,\n e.created_at AS created_at,\n e.valid_at AS valid_at,\n e.uuid AS uuid,\n e.name AS name,\n e.group_id AS group_id,\n e.source_description AS source_description,\n e.source AS source,\n e.entity_edges AS entity_edges\n ' 2025-03-10 22:26:00 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: source)} {position: line: 10, column: 15, offset: 321} for query: '\n MATCH (e:Episodic {uuid: $uuid})\n RETURN e.content AS content,\n e.created_at AS created_at,\n e.valid_at AS valid_at,\n e.uuid AS uuid,\n e.name AS name,\n e.group_id AS group_id,\n e.source_description AS source_description,\n e.source AS source,\n e.entity_edges AS entity_edges\n ' 2025-03-10 22:26:00 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: entity_edges)} {position: line: 11, column: 15, offset: 353} for query: '\n MATCH (e:Episodic {uuid: $uuid})\n RETURN e.content AS content,\n e.created_at AS created_at,\n e.valid_at AS valid_at,\n e.uuid AS uuid,\n e.name AS name,\n e.group_id AS group_id,\n e.source_description AS source_description,\n e.source AS source,\n e.entity_edges AS entity_edges\n ' 2025-03-10 22:26:01 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: fact_embedding)} {position: line: 4, column: 45, offset: 280} for query: '\n MATCH (n:Entity)-[r:RELATES_TO]->(m:Entity)\n WHERE r.group_id IN $group_ids\nWITH DISTINCT r, vector.similarity.cosine(r.fact_embedding, $search_vector) AS score\n WHERE score > $min_score\n RETURN\n r.uuid AS uuid,\n r.group_id AS group_id,\n startNode(r).uuid AS source_node_uuid,\n endNode(r).uuid AS target_node_uuid,\n r.created_at AS created_at,\n r.name AS name,\n r.fact AS fact,\n r.fact_embedding AS fact_embedding,\n r.episodes AS episodes,\n r.expired_at AS expired_at,\n r.valid_at AS valid_at,\n r.invalid_at AS invalid_at\n ORDER BY score DESC\n LIMIT $limit\n ' 2025-03-10 22:26:01 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: fact_embedding)} {position: line: 14, column: 23, offset: 723} for query: '\n MATCH (n:Entity)-[r:RELATES_TO]->(m:Entity)\n WHERE r.group_id IN $group_ids\nWITH DISTINCT r, vector.similarity.cosine(r.fact_embedding, $search_vector) AS score\n WHERE score > $min_score\n RETURN\n r.uuid AS uuid,\n r.group_id AS group_id,\n startNode(r).uuid AS source_node_uuid,\n endNode(r).uuid AS target_node_uuid,\n r.created_at AS created_at,\n r.name AS name,\n r.fact AS fact,\n r.fact_embedding AS fact_embedding,\n r.episodes AS episodes,\n r.expired_at AS expired_at,\n r.valid_at AS valid_at,\n r.invalid_at AS invalid_at\n ORDER BY score DESC\n LIMIT $limit\n ' 2025-03-10 22:26:01 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: episodes)} {position: line: 15, column: 23, offset: 779} for query: '\n MATCH (n:Entity)-[r:RELATES_TO]->(m:Entity)\n WHERE r.group_id IN $group_ids\nWITH DISTINCT r, vector.similarity.cosine(r.fact_embedding, $search_vector) AS score\n WHERE score > $min_score\n RETURN\n r.uuid AS uuid,\n r.group_id AS group_id,\n startNode(r).uuid AS source_node_uuid,\n endNode(r).uuid AS target_node_uuid,\n r.created_at AS created_at,\n r.name AS name,\n r.fact AS fact,\n r.fact_embedding AS fact_embedding,\n r.episodes AS episodes,\n r.expired_at AS expired_at,\n r.valid_at AS valid_at,\n r.invalid_at AS invalid_at\n ORDER BY score DESC\n LIMIT $limit\n ' 2025-03-10 22:26:02 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: fact_embedding)} {position: line: 15, column: 24, offset: 651} for query: '\n CALL db.index.fulltext.queryRelationships("edge_name_and_fact", $query, {limit: $limit}) \n YIELD relationship AS rel, score\n MATCH (:Entity)-[r:RELATES_TO]->(:Entity)\n WHERE r.group_id IN $group_ids\nWITH r, score, startNode(r) AS n, endNode(r) AS m\n RETURN\n r.uuid AS uuid,\n r.group_id AS group_id,\n n.uuid AS source_node_uuid,\n m.uuid AS target_node_uuid,\n r.created_at AS created_at,\n r.name AS name,\n r.fact AS fact,\n r.fact_embedding AS fact_embedding,\n r.episodes AS episodes,\n r.expired_at AS expired_at,\n r.valid_at AS valid_at,\n r.invalid_at AS invalid_at\n ORDER BY score DESC LIMIT $limit\n ' 2025-03-10 22:26:02 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: episodes)} {position: line: 16, column: 24, offset: 708} for query: '\n CALL db.index.fulltext.queryRelationships("edge_name_and_fact", $query, {limit: $limit}) \n YIELD relationship AS rel, score\n MATCH (:Entity)-[r:RELATES_TO]->(:Entity)\n WHERE r.group_id IN $group_ids\nWITH r, score, startNode(r) AS n, endNode(r) AS m\n RETURN\n r.uuid AS uuid,\n r.group_id AS group_id,\n n.uuid AS source_node_uuid,\n m.uuid AS target_node_uuid,\n r.created_at AS created_at,\n r.name AS name,\n r.fact AS fact,\n r.fact_embedding AS fact_embedding,\n r.episodes AS episodes,\n r.expired_at AS expired_at,\n r.valid_at AS valid_at,\n r.invalid_at AS invalid_at\n ORDER BY score DESC LIMIT $limit\n ' 2025-03-10 22:26:07 INFO: 127.0.0.1:57278 - "GET /healthcheck HTTP/1.1" 200 OK 2025-03-10 22:26:18 INFO: 127.0.0.1:34758 - "GET /healthcheck HTTP/1.1" 200 OK 2025-03-10 22:26:29 INFO: 127.0.0.1:41300 - "GET /healthcheck HTTP/1.1" 200 OK 2025-03-10 22:26:39 INFO: 172.19.0.5:60144 - "POST /messages HTTP/1.1" 202 Accepted 2025-03-10 22:26:39 INFO: 127.0.0.1:38496 - "GET /healthcheck HTTP/1.1" 200 OK 2025-03-10 22:26:40 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: fact_embedding)} {position: line: 4, column: 45, offset: 280} for query: '\n MATCH (n:Entity)-[r:RELATES_TO]->(m:Entity)\n WHERE r.group_id IN $group_ids\nWITH DISTINCT r, vector.similarity.cosine(r.fact_embedding, $search_vector) AS score\n WHERE score > $min_score\n RETURN\n r.uuid AS uuid,\n r.group_id AS group_id,\n startNode(r).uuid AS source_node_uuid,\n endNode(r).uuid AS target_node_uuid,\n r.created_at AS created_at,\n r.name AS name,\n r.fact AS fact,\n r.fact_embedding AS fact_embedding,\n r.episodes AS episodes,\n r.expired_at AS expired_at,\n r.valid_at AS valid_at,\n r.invalid_at AS invalid_at\n ORDER BY score DESC\n LIMIT $limit\n ' 2025-03-10 22:26:40 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: fact_embedding)} {position: line: 14, column: 23, offset: 723} for query: '\n MATCH (n:Entity)-[r:RELATES_TO]->(m:Entity)\n WHERE r.group_id IN $group_ids\nWITH DISTINCT r, vector.similarity.cosine(r.fact_embedding, $search_vector) AS score\n WHERE score > $min_score\n RETURN\n r.uuid AS uuid,\n r.group_id AS group_id,\n startNode(r).uuid AS source_node_uuid,\n endNode(r).uuid AS target_node_uuid,\n r.created_at AS created_at,\n r.name AS name,\n r.fact AS fact,\n r.fact_embedding AS fact_embedding,\n r.episodes AS episodes,\n r.expired_at AS expired_at,\n r.valid_at AS valid_at,\n r.invalid_at AS invalid_at\n ORDER BY score DESC\n LIMIT $limit\n ' 2025-03-10 22:26:40 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: episodes)} {position: line: 15, column: 23, offset: 779} for query: '\n MATCH (n:Entity)-[r:RELATES_TO]->(m:Entity)\n WHERE r.group_id IN $group_ids\nWITH DISTINCT r, vector.similarity.cosine(r.fact_embedding, $search_vector) AS score\n WHERE score > $min_score\n RETURN\n r.uuid AS uuid,\n r.group_id AS group_id,\n startNode(r).uuid AS source_node_uuid,\n endNode(r).uuid AS target_node_uuid,\n r.created_at AS created_at,\n r.name AS name,\n r.fact AS fact,\n r.fact_embedding AS fact_embedding,\n r.episodes AS episodes,\n r.expired_at AS expired_at,\n r.valid_at AS valid_at,\n r.invalid_at AS invalid_at\n ORDER BY score DESC\n LIMIT $limit\n ' 2025-03-10 22:26:40 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: fact_embedding)} {position: line: 15, column: 24, offset: 651} for query: '\n CALL db.index.fulltext.queryRelationships("edge_name_and_fact", $query, {limit: $limit}) \n YIELD relationship AS rel, score\n MATCH (:Entity)-[r:RELATES_TO]->(:Entity)\n WHERE r.group_id IN $group_ids\nWITH r, score, startNode(r) AS n, endNode(r) AS m\n RETURN\n r.uuid AS uuid,\n r.group_id AS group_id,\n n.uuid AS source_node_uuid,\n m.uuid AS target_node_uuid,\n r.created_at AS created_at,\n r.name AS name,\n r.fact AS fact,\n r.fact_embedding AS fact_embedding,\n r.episodes AS episodes,\n r.expired_at AS expired_at,\n r.valid_at AS valid_at,\n r.invalid_at AS invalid_at\n ORDER BY score DESC LIMIT $limit\n ' 2025-03-10 22:26:40 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: episodes)} {position: line: 16, column: 24, offset: 708} for query: '\n CALL db.index.fulltext.queryRelationships("edge_name_and_fact", $query, {limit: $limit}) \n YIELD relationship AS rel, score\n MATCH (:Entity)-[r:RELATES_TO]->(:Entity)\n WHERE r.group_id IN $group_ids\nWITH r, score, startNode(r) AS n, endNode(r) AS m\n RETURN\n r.uuid AS uuid,\n r.group_id AS group_id,\n n.uuid AS source_node_uuid,\n m.uuid AS target_node_uuid,\n r.created_at AS created_at,\n r.name AS name,\n r.fact AS fact,\n r.fact_embedding AS fact_embedding,\n r.episodes AS episodes,\n r.expired_at AS expired_at,\n r.valid_at AS valid_at,\n r.invalid_at AS invalid_at\n ORDER BY score DESC LIMIT $limit\n

pxz2016 avatar Mar 10 '25 14:03 pxz2016

Hey, were you able to run the graphiti.build_indices_and_constraints() method before running any code? What were you trying to run when you got this error, and what version of Graphiti are you on?

prasmussen15 avatar Mar 11 '25 17:03 prasmussen15

@prasmussen15 I have the same set of warnings, while graphiti.build_indices_and_constraints() runs fine. Here is the setup, using version neo4j:5.26.

LoopKarma avatar Mar 26 '25 09:03 LoopKarma

Same, here's the full output from instantiating docker compose containers freshly and giving it an episode "I prefer typescript and nextjs", and having tested the OPENAI_API_KEY to work:

output
WARN[0000] The "OPENAI_BASE_URL" variable is not set. Defaulting to a blank string. 
[+] Running 2/0
 ✔ Container mcp_server-graphiti-mcp-1  Created                                                                                                                    0.0s 
 ✔ Container mcp_server-neo4j-1         Recreated                                                                                                                  0.0s 
Attaching to graphiti-mcp-1, neo4j-1
neo4j-1         | Changed password for user 'neo4j'. IMPORTANT: this change will only take effect if performed before the database is started for the first time.
neo4j-1         | 2025-04-02 18:46:01.691+0000 INFO  Logging config in use: File '/var/lib/neo4j/conf/user-logs.xml'
neo4j-1         | 2025-04-02 18:46:01.699+0000 INFO  Starting...
neo4j-1         | 2025-04-02 18:46:02.118+0000 INFO  This instance is ServerId{faf6e0df} (faf6e0df-05cb-44b9-a147-9bc0e85fee9f)
neo4j-1         | 2025-04-02 18:46:02.558+0000 INFO  ======== Neo4j 5.26.0 ========
neo4j-1         | 2025-04-02 18:46:03.379+0000 INFO  Anonymous Usage Data is being sent to Neo4j, see https://neo4j.com/docs/usage-data/
neo4j-1         | 2025-04-02 18:46:03.476+0000 INFO  Bolt enabled on 0.0.0.0:7687.
neo4j-1         | 2025-04-02 18:46:03.755+0000 INFO  HTTP enabled on 0.0.0.0:7474.
neo4j-1         | 2025-04-02 18:46:03.755+0000 INFO  Remote interface available at http://localhost:7474/
neo4j-1         | 2025-04-02 18:46:03.756+0000 INFO  id: F1DAA5D97B49B732B0C86AF6905FFA99B1CA62BDC5B4609A1F896F4D27CE6409
neo4j-1         | 2025-04-02 18:46:03.757+0000 INFO  name: system
neo4j-1         | 2025-04-02 18:46:03.757+0000 INFO  creationDate: 2025-04-01T22:49:12.147Z
neo4j-1         | 2025-04-02 18:46:03.757+0000 INFO  Started.
graphiti-mcp-1  | 2025-04-02 18:46:05,451 - __main__ - INFO - Generated random group_id: graph_a86e653a
graphiti-mcp-1  | 2025-04-02 18:46:05,451 - __main__ - INFO - Entity extraction disabled (no custom entities will be used)
graphiti-mcp-1  | 2025-04-02 18:46:06,064 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX relation_uuid IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.uuid)` has no effect.} {description: `RANGE INDEX relation_uuid FOR ()-[e:RELATES_TO]-() ON (e.uuid)` already exists.} {position: None} for query: 'CREATE INDEX relation_uuid IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.uuid)'
graphiti-mcp-1  | 2025-04-02 18:46:06,064 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX created_at_edge_index IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.created_at)` has no effect.} {description: `RANGE INDEX created_at_edge_index FOR ()-[e:RELATES_TO]-() ON (e.created_at)` already exists.} {position: None} for query: 'CREATE INDEX created_at_edge_index IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.created_at)'
graphiti-mcp-1  | 2025-04-02 18:46:06,065 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE FULLTEXT INDEX node_name_and_summary IF NOT EXISTS FOR (e:Entity) ON EACH [e.name, e.summary, e.group_id]` has no effect.} {description: `FULLTEXT INDEX node_name_and_summary FOR (e:Entity) ON EACH [e.name, e.summary, e.group_id]` already exists.} {position: None} for query: 'CREATE FULLTEXT INDEX node_name_and_summary IF NOT EXISTS \n        FOR (n:Entity) ON EACH [n.name, n.summary, n.group_id]'
graphiti-mcp-1  | 2025-04-02 18:46:06,065 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX valid_at_episodic_index IF NOT EXISTS FOR (e:Episodic) ON (e.valid_at)` has no effect.} {description: `RANGE INDEX valid_at_episodic_index FOR (e:Episodic) ON (e.valid_at)` already exists.} {position: None} for query: 'CREATE INDEX valid_at_episodic_index IF NOT EXISTS FOR (n:Episodic) ON (n.valid_at)'
graphiti-mcp-1  | 2025-04-02 18:46:06,065 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX mention_uuid IF NOT EXISTS FOR ()-[e:MENTIONS]-() ON (e.uuid)` has no effect.} {description: `RANGE INDEX mention_uuid FOR ()-[e:MENTIONS]-() ON (e.uuid)` already exists.} {position: None} for query: 'CREATE INDEX mention_uuid IF NOT EXISTS FOR ()-[e:MENTIONS]-() ON (e.uuid)'
graphiti-mcp-1  | 2025-04-02 18:46:06,066 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX invalid_at_edge_index IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.invalid_at)` has no effect.} {description: `RANGE INDEX invalid_at_edge_index FOR ()-[e:RELATES_TO]-() ON (e.invalid_at)` already exists.} {position: None} for query: 'CREATE INDEX invalid_at_edge_index IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.invalid_at)'
graphiti-mcp-1  | 2025-04-02 18:46:06,067 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX episode_uuid IF NOT EXISTS FOR (e:Episodic) ON (e.uuid)` has no effect.} {description: `RANGE INDEX episode_uuid FOR (e:Episodic) ON (e.uuid)` already exists.} {position: None} for query: 'CREATE INDEX episode_uuid IF NOT EXISTS FOR (n:Episodic) ON (n.uuid)'
graphiti-mcp-1  | 2025-04-02 18:46:06,067 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX created_at_episodic_index IF NOT EXISTS FOR (e:Episodic) ON (e.created_at)` has no effect.} {description: `RANGE INDEX created_at_episodic_index FOR (e:Episodic) ON (e.created_at)` already exists.} {position: None} for query: 'CREATE INDEX created_at_episodic_index IF NOT EXISTS FOR (n:Episodic) ON (n.created_at)'
graphiti-mcp-1  | 2025-04-02 18:46:06,067 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX expired_at_edge_index IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.expired_at)` has no effect.} {description: `RANGE INDEX expired_at_edge_index FOR ()-[e:RELATES_TO]-() ON (e.expired_at)` already exists.} {position: None} for query: 'CREATE INDEX expired_at_edge_index IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.expired_at)'
graphiti-mcp-1  | 2025-04-02 18:46:06,067 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX entity_uuid IF NOT EXISTS FOR (e:Entity) ON (e.uuid)` has no effect.} {description: `RANGE INDEX entity_uuid FOR (e:Entity) ON (e.uuid)` already exists.} {position: None} for query: 'CREATE INDEX entity_uuid IF NOT EXISTS FOR (n:Entity) ON (n.uuid)'
graphiti-mcp-1  | 2025-04-02 18:46:06,067 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX community_uuid IF NOT EXISTS FOR (e:Community) ON (e.uuid)` has no effect.} {description: `RANGE INDEX community_uuid FOR (e:Community) ON (e.uuid)` already exists.} {position: None} for query: 'CREATE INDEX community_uuid IF NOT EXISTS FOR (n:Community) ON (n.uuid)'
graphiti-mcp-1  | 2025-04-02 18:46:06,067 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX entity_group_id IF NOT EXISTS FOR (e:Entity) ON (e.group_id)` has no effect.} {description: `RANGE INDEX entity_group_id FOR (e:Entity) ON (e.group_id)` already exists.} {position: None} for query: 'CREATE INDEX entity_group_id IF NOT EXISTS FOR (n:Entity) ON (n.group_id)'
graphiti-mcp-1  | 2025-04-02 18:46:06,067 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX episode_group_id IF NOT EXISTS FOR (e:Episodic) ON (e.group_id)` has no effect.} {description: `RANGE INDEX episode_group_id FOR (e:Episodic) ON (e.group_id)` already exists.} {position: None} for query: 'CREATE INDEX episode_group_id IF NOT EXISTS FOR (n:Episodic) ON (n.group_id)'
graphiti-mcp-1  | 2025-04-02 18:46:06,067 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX name_entity_index IF NOT EXISTS FOR (e:Entity) ON (e.name)` has no effect.} {description: `RANGE INDEX name_entity_index FOR (e:Entity) ON (e.name)` already exists.} {position: None} for query: 'CREATE INDEX name_entity_index IF NOT EXISTS FOR (n:Entity) ON (n.name)'
graphiti-mcp-1  | 2025-04-02 18:46:06,068 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX name_edge_index IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.name)` has no effect.} {description: `RANGE INDEX name_edge_index FOR ()-[e:RELATES_TO]-() ON (e.name)` already exists.} {position: None} for query: 'CREATE INDEX name_edge_index IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.name)'
graphiti-mcp-1  | 2025-04-02 18:46:06,068 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX relation_group_id IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.group_id)` has no effect.} {description: `RANGE INDEX relation_group_id FOR ()-[e:RELATES_TO]-() ON (e.group_id)` already exists.} {position: None} for query: 'CREATE INDEX relation_group_id IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.group_id)'
graphiti-mcp-1  | 2025-04-02 18:46:06,068 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX valid_at_edge_index IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.valid_at)` has no effect.} {description: `RANGE INDEX valid_at_edge_index FOR ()-[e:RELATES_TO]-() ON (e.valid_at)` already exists.} {position: None} for query: 'CREATE INDEX valid_at_edge_index IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON (e.valid_at)'
graphiti-mcp-1  | 2025-04-02 18:46:06,068 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX has_member_uuid IF NOT EXISTS FOR ()-[e:HAS_MEMBER]-() ON (e.uuid)` has no effect.} {description: `RANGE INDEX has_member_uuid FOR ()-[e:HAS_MEMBER]-() ON (e.uuid)` already exists.} {position: None} for query: 'CREATE INDEX has_member_uuid IF NOT EXISTS FOR ()-[e:HAS_MEMBER]-() ON (e.uuid)'
graphiti-mcp-1  | 2025-04-02 18:46:06,069 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX mention_group_id IF NOT EXISTS FOR ()-[e:MENTIONS]-() ON (e.group_id)` has no effect.} {description: `RANGE INDEX mention_group_id FOR ()-[e:MENTIONS]-() ON (e.group_id)` already exists.} {position: None} for query: 'CREATE INDEX mention_group_id IF NOT EXISTS FOR ()-[e:MENTIONS]-() ON (e.group_id)'
graphiti-mcp-1  | 2025-04-02 18:46:06,070 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE RANGE INDEX created_at_entity_index IF NOT EXISTS FOR (e:Entity) ON (e.created_at)` has no effect.} {description: `RANGE INDEX created_at_entity_index FOR (e:Entity) ON (e.created_at)` already exists.} {position: None} for query: 'CREATE INDEX created_at_entity_index IF NOT EXISTS FOR (n:Entity) ON (n.created_at)'
graphiti-mcp-1  | 2025-04-02 18:46:06,093 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE FULLTEXT INDEX edge_name_and_fact IF NOT EXISTS FOR ()-[e:RELATES_TO]-() ON EACH [e.name, e.fact, e.group_id]` has no effect.} {description: `FULLTEXT INDEX edge_name_and_fact FOR ()-[e:RELATES_TO]-() ON EACH [e.name, e.fact, e.group_id]` already exists.} {position: None} for query: 'CREATE FULLTEXT INDEX edge_name_and_fact IF NOT EXISTS \n        FOR ()-[e:RELATES_TO]-() ON EACH [e.name, e.fact, e.group_id]'
graphiti-mcp-1  | 2025-04-02 18:46:06,093 - neo4j.notifications - INFO - Received notification from DBMS server: {severity: INFORMATION} {code: Neo.ClientNotification.Schema.IndexOrConstraintAlreadyExists} {category: SCHEMA} {title: `CREATE FULLTEXT INDEX community_name IF NOT EXISTS FOR (e:Community) ON EACH [e.name, e.group_id]` has no effect.} {description: `FULLTEXT INDEX community_name FOR (e:Community) ON EACH [e.name, e.group_id]` already exists.} {position: None} for query: 'CREATE FULLTEXT INDEX community_name IF NOT EXISTS \n        FOR (n:Community) ON EACH [n.name, n.group_id]'
graphiti-mcp-1  | 2025-04-02 18:46:06,094 - __main__ - INFO - Graphiti client initialized successfully
graphiti-mcp-1  | 2025-04-02 18:46:06,094 - __main__ - INFO - Starting MCP server with transport: sse
graphiti-mcp-1  | 2025-04-02 18:46:06,094 - __main__ - INFO - Running MCP server with SSE transport on 0.0.0.0:8000
graphiti-mcp-1  | INFO:     Started server process [9]
graphiti-mcp-1  | INFO:     Waiting for application startup.
graphiti-mcp-1  | INFO:     Application startup complete.
graphiti-mcp-1  | INFO:     Uvicorn running on http://0.0.0.0:8000 (Press CTRL+C to quit)
graphiti-mcp-1  | INFO:     172.21.0.1:60814 - "GET /sse HTTP/1.1" 200 OK
graphiti-mcp-1  | INFO:     172.21.0.1:60824 - "GET /sse HTTP/1.1" 200 OK
graphiti-mcp-1  | INFO:     172.21.0.1:60838 - "GET /sse HTTP/1.1" 200 OK
graphiti-mcp-1  | INFO:     172.21.0.1:60840 - "GET /sse HTTP/1.1" 200 OK
graphiti-mcp-1  | INFO:     172.21.0.1:60842 - "GET /sse HTTP/1.1" 200 OK
graphiti-mcp-1  | INFO:     172.21.0.1:59734 - "GET /sse HTTP/1.1" 200 OK
graphiti-mcp-1  | INFO:     172.21.0.1:59744 - "POST /messages/?session_id=0b32a36e813a4ccab7e3d9279bb478ef HTTP/1.1" 202 Accepted
graphiti-mcp-1  | INFO:     172.21.0.1:59752 - "POST /messages/?session_id=0b32a36e813a4ccab7e3d9279bb478ef HTTP/1.1" 202 Accepted
graphiti-mcp-1  | INFO:     172.21.0.1:59760 - "POST /messages/?session_id=0b32a36e813a4ccab7e3d9279bb478ef HTTP/1.1" 202 Accepted
graphiti-mcp-1  | 2025-04-02 18:46:34,704 - mcp.server.lowlevel.server - INFO - Processing request of type ListToolsRequest
graphiti-mcp-1  | INFO:     172.21.0.1:59762 - "POST /messages/?session_id=0b32a36e813a4ccab7e3d9279bb478ef HTTP/1.1" 202 Accepted
graphiti-mcp-1  | 2025-04-02 18:46:34,712 - mcp.server.lowlevel.server - INFO - Processing request of type ListResourcesRequest
graphiti-mcp-1  | INFO:     172.21.0.1:59764 - "POST /messages/?session_id=0b32a36e813a4ccab7e3d9279bb478ef HTTP/1.1" 202 Accepted
graphiti-mcp-1  | 2025-04-02 18:46:34,718 - mcp.server.lowlevel.server - INFO - Processing request of type ListResourceTemplatesRequest
graphiti-mcp-1  | INFO:     172.21.0.1:56942 - "POST /messages/?session_id=0b32a36e813a4ccab7e3d9279bb478ef HTTP/1.1" 202 Accepted
graphiti-mcp-1  | 2025-04-02 18:47:03,745 - mcp.server.lowlevel.server - INFO - Processing request of type CallToolRequest
graphiti-mcp-1  | 2025-04-02 18:47:03,746 - __main__ - INFO - Starting episode queue worker for group_id: graph_a86e653a
graphiti-mcp-1  | 2025-04-02 18:47:03,746 - __main__ - INFO - Processing queued episode 'User Technology Preference' for group_id: graph_a86e653a
graphiti-mcp-1  | 2025-04-02 18:47:04,261 - neo4j.notifications - WARNING - 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: content)} {position: line: 4, column: 18, offset: 143} for query: '\n        MATCH (e:Episodic) WHERE e.valid_at <= $reference_time \n        AND ($group_ids IS NULL) OR e.group_id in $group_ids\n        RETURN e.content AS content,\n            e.created_at AS created_at,\n            e.valid_at AS valid_at,\n            e.uuid AS uuid,\n            e.group_id AS group_id,\n            e.name AS name,\n            e.source_description AS source_description,\n            e.source AS source\n        ORDER BY e.created_at DESC\n        LIMIT $num_episodes\n        '
graphiti-mcp-1  | 2025-04-02 18:47:04,261 - neo4j.notifications - WARNING - 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: source_description)} {position: line: 10, column: 15, offset: 345} for query: '\n        MATCH (e:Episodic) WHERE e.valid_at <= $reference_time \n        AND ($group_ids IS NULL) OR e.group_id in $group_ids\n        RETURN e.content AS content,\n            e.created_at AS created_at,\n            e.valid_at AS valid_at,\n            e.uuid AS uuid,\n            e.group_id AS group_id,\n            e.name AS name,\n            e.source_description AS source_description,\n            e.source AS source\n        ORDER BY e.created_at DESC\n        LIMIT $num_episodes\n        '
graphiti-mcp-1  | 2025-04-02 18:47:04,261 - neo4j.notifications - WARNING - 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: source)} {position: line: 11, column: 15, offset: 401} for query: '\n        MATCH (e:Episodic) WHERE e.valid_at <= $reference_time \n        AND ($group_ids IS NULL) OR e.group_id in $group_ids\n        RETURN e.content AS content,\n            e.created_at AS created_at,\n            e.valid_at AS valid_at,\n            e.uuid AS uuid,\n            e.group_id AS group_id,\n            e.name AS name,\n            e.source_description AS source_description,\n            e.source AS source\n        ORDER BY e.created_at DESC\n        LIMIT $num_episodes\n        '
graphiti-mcp-1  | 2025-04-02 18:47:04,269 - openai._base_client - INFO - Retrying request to /chat/completions in 0.440350 seconds
graphiti-mcp-1  | 2025-04-02 18:47:04,712 - openai._base_client - INFO - Retrying request to /chat/completions in 0.965049 seconds
graphiti-mcp-1  | 2025-04-02 18:47:05,681 - graphiti_core.llm_client.openai_client - ERROR - Error in generating LLM response: Connection error.
graphiti-mcp-1  | 2025-04-02 18:47:05,681 - __main__ - ERROR - Error processing episode 'User Technology Preference' for group_id graph_a86e653a: Connection error.

I don't see the missing properties content, source_description or source in the initial schema creation...

Morriz avatar Apr 02 '25 18:04 Morriz

when running the mcp-server container just with the cmd env I see the OPENAI_API_KEY correctly set to the one tested. Strange that it still gives

graphiti_core.llm_client.openai_client - ERROR - Error in generating LLM response: Connection error.

Morriz avatar Apr 02 '25 19:04 Morriz

I see this as well (the warnings), on the very first episode ingest only. build_indices_and_constraints completes fine.

The missing properties are: name_embedding, fact_embedding, episodes. Things seem to be ingested fine though, and the warnings don't appear on future episode additions.

Note that I don't know cypher well at all, but is this perhaps happening because setRelationshipVectorProperty has not been called yet on any node/edge, but it's being used in a query as part of ingest?

vvuk avatar Jul 14 '25 17:07 vvuk

Same issue here with basic setup:

  • Create a new neo4j locally (Docker Neo4j 2025.06.2 )
  • run in python:
# python -m asyincio
from graphiti_core import Graphiti
from graphiti_core.utils.datetime_utils import utc_now

....
graphiti_client =  Graphiti(
        os.getenv("NEO4J_URI", "bolt://...:7687"),
        os.getenv("NEO4J_USERNAME", "neo4j"),
        os.getenv("NEO4J_PASSWORD", "docker"),
        llm_client=llm_client,
        embedder=embedder,
        cross_encoder=reranker,
    )
await graphiti_client.build_indices_and_constraints()
await graphiti_client.add_episode(
    name="MyFirst EP",
    episode_body="Somebody",
    source_description=f"Any desc",
    reference_time=utc_now(),
)

Happen with name_embedding, entity_edges, episodes

Gwydce avatar Aug 03 '25 19:08 Gwydce

I'm having the same issue (missing fact_embedding) using the docker-compose. When I insert episodes via the MCP server, it appears to me that the episode is recorded, but no facts are created, this error appears in the logs, and I cannot recall anything. I suspect this is not the expected behavior of the project.

lukebarton avatar Aug 03 '25 19:08 lukebarton

These warnings are harmless as they will only appear before anything is saved to the DB. It is a quirk of Neo4j and won't effect outputs. Please open a new issue if you are having other errors or missing data

prasmussen15 avatar Aug 18 '25 15:08 prasmussen15