将 NOM 持久化数据库迁移到 5.x
如果要迁移 **Neo4j Ops Manager 作为持久化存储使用过的** 4.4 数据库到 5.x 数据库,请按照文档中概述的 Neo4j 迁移正常步骤操作。
在遵循迁移过程之前或之后,请在持久化数据库上执行以下查询。您可以通过 Cypher-Shell 或 Neo4j 浏览器连接到它。如果不运行此查询,Neo4j Ops Manager 服务器可能无法启动。
仅当您将 Neo4j 4.4 版本的现有持久化数据库迁移到 Neo4j 5.x 时,才运行以下查询。 不要更改此查询,因为它可能会对 Ops Manager 产生负面影响,例如无法启动。 除了运行此查询之外,不要进一步修改持久化数据库的内容。 |
查询
OPTIONAL MATCH (n:`__Neo4jMigration`{version:"056"})
MATCH (m:`__Neo4jMigration`{version:"057"})
FOREACH (ignoreMe in CASE WHEN n IS NULL THEN [1] ELSE [] END |
CREATE (a:`__Neo4jMigration`{version:"056", checksum: "3451352755",description: "DropQueryLogIndexOn5", repeatable: false, source: "V056__DropQueryLogIndexOn5.cypher
", type: "CYPHER"})
CREATE (a)-[r:MIGRATED_TO{ at: datetime(), by: "root", connectedAs: "Ops Manager manual migration script", in: duration({seconds: 1}) }]->(m)
)
WITH 1 as one
MATCH (n:`__Neo4jMigration`{version:"054"}), (d:`__Neo4jMigration`{version:"055"}), (m:`__Neo4jMigration`{version:"056"})
OPTIONAL MATCH (n)-[r:MIGRATED_TO]->(m)
FOREACH (ignoreMe in CASE WHEN r IS NULL THEN [1] ELSE [] END |
DETACH DELETE d
CREATE (n)-[r:MIGRATED_TO{ at: datetime(), by: "root", connectedAs: "Ops Manager manual migration script", in: duration({seconds: 1}) }]->(m)
)
WITH 1 as one
MATCH (n:`__Neo4jMigration`{version:"057"}),(d:`__Neo4jMigration`{version:"058"}), (m:`__Neo4jMigration`{version:"059"})
OPTIONAL MATCH (n)-[r:MIGRATED_TO]->(m)
FOREACH (ignoreMe in CASE WHEN r IS NULL THEN [1] ELSE [] END |
DETACH DELETE d
CREATE (n)-[r:MIGRATED_TO{ at: datetime(), by: "root", connectedAs: "Ops Manager manual migration script", in: duration({seconds: 1}) }]->(m)
)
WITH 1 as one
MATCH (n:`__Neo4jMigration`{version:"062"}), (d:`__Neo4jMigration`{version:"063"}), (m:`__Neo4jMigration`{version:"064"})
OPTIONAL MATCH (n)-[r:MIGRATED_TO]->(m)
FOREACH (ignoreMe in CASE WHEN r IS NULL THEN [1] ELSE [] END |
DETACH DELETE d
CREATE (n)-[r:MIGRATED_TO{ at: datetime(), by: "root", connectedAs: "Ops Manager manual migration script", in: duration({seconds: 1}) }]->(m)
)
WITH 1 as one
MATCH (n:`__Neo4jMigration`{version:"066"}), (d:`__Neo4jMigration`{version:"067"}), (m:`__Neo4jMigration`{version:"068"})
OPTIONAL MATCH (n)-[r:MIGRATED_TO]->(m)
FOREACH (ignoreMe in CASE WHEN r IS NULL THEN [1] ELSE [] END |
DETACH DELETE d
CREATE (n)-[r:MIGRATED_TO{ at: datetime(), by: "root", connectedAs: "Ops Manager manual migration script", in: duration({seconds: 1}) }]->(m)
)
WITH 1 as one
MATCH (n:`__Neo4jMigration`{version:"090"}), (d:`__Neo4jMigration`{version:"091"}), (m:`__Neo4jMigration`{version:"092"})
OPTIONAL MATCH (n)-[r:MIGRATED_TO]->(m)
FOREACH (ignoreMe in CASE WHEN r IS NULL THEN [1] ELSE [] END |
DETACH DELETE d
CREATE (n)-[r:MIGRATED_TO{ at: datetime(), by: "root", connectedAs: "Ops Manager manual migration script", in: duration({seconds: 1}) }]->(m)
);