janusgraph-users@lists.lfaidata.foundation | how can i remove the index

Home Messages Hashtags Subgroups Calendar

Date Date 1 - 4 of 4

how can i remove the index

李平 <lipin...@...>

public class GraphTest {

    public static void main(String[] args) throws Exception {

        BaseConfiguration baseConfiguration = new BaseConfiguration();
        baseConfiguration.setProperty("storage.backend", "hbase");
        baseConfiguration.setProperty("storage.hostname", "192.168.1.108");
        baseConfiguration.setProperty("gremlin.graph", "org.janusgraph.core.JanusGraphFactory");
        JanusGraph janusGraph = JanusGraphFactory.open(baseConfiguration);
        GraphTraversalSource g = janusGraph.traversal();
        g.tx().rollback();
        JanusGraphManagement janusGraphManagement = janusGraph.openManagement();
        JanusGraphIndex phoneIndex = janusGraphManagement.getGraphIndex("phoneIndex");
        janusGraphManagement.updateIndex(phoneIndex, SchemaAction.DISABLE_INDEX).get();
        janusGraphManagement.commit();
        g.tx().commit();
        ManagementSystem.awaitGraphIndexStatus(janusGraph,"phoneIndex")
                .status(SchemaStatus.DISABLED)
                .timeout(10, ChronoUnit.MINUTES)
                .call();
        janusGraphManagement.updateIndex(phoneIndex, SchemaAction.REMOVE_INDEX).get();
        janusGraphManagement.commit();
        janusGraph.tx().commit();
        System.out.println("---------------------remove index sucess...");

the log is :Some key(s) on index phoneIndex do not currently have status DISABLED: phone=INSTALLED

David Pitera <piter...@...>

#460

Your propertyKey `phone` on your index `phoneIndex` is in the `INSTALLED` state, so you need to `REGISTER` it and wait for it to become registered before you can attempt to `enable` it. After it is enabled, you can disable and then remove it.

Some code that should help cause it goes through the whole installed/registered/enabled phase is:

https://github.com/dpitera/janusgraph/blob/ef4591e3524b7df87935de1cc86fbb7a139f32e6/janusgraph-core/src/main/java/org/janusgraph/graphdb/management/ConfigurationManagementGraph.java#L261-L289

Show quoted text

On Thu, Jul 20, 2017 at 11:43 PM, 李平 <lipin...@...> wrote:

public class GraphTest {

    public static void main(String[] args) throws Exception {

        BaseConfiguration baseConfiguration = new BaseConfiguration();
        baseConfiguration.setProperty("storage.backend", "hbase");
        baseConfiguration.setProperty("storage.hostname", "192.168.1.108");
        baseConfiguration.setProperty("gremlin.graph", "org.janusgraph.core.JanusGraphFactory");
        JanusGraph janusGraph = JanusGraphFactory.open(baseConfiguration);
        GraphTraversalSource g = janusGraph.traversal();
        g.tx().rollback();
        JanusGraphManagement janusGraphManagement = janusGraph.openManagement();
        JanusGraphIndex phoneIndex = janusGraphManagement.getGraphIndex("phoneIndex");
        janusGraphManagement.updateIndex(phoneIndex, SchemaAction.DISABLE_INDEX).get();
        janusGraphManagement.commit();
        g.tx().commit();
        ManagementSystem.awaitGraphIndexStatus(janusGraph,"phoneIndex")
                .status(SchemaStatus.DISABLED)
                .timeout(10, ChronoUnit.MINUTES)
                .call();
        janusGraphManagement.updateIndex(phoneIndex, SchemaAction.REMOVE_INDEX).get();
        janusGraphManagement.commit();
        janusGraph.tx().commit();
        System.out.println("---------------------remove index sucess...");

the log is :Some key(s) on index phoneIndex do not currently have status DISABLED: phone=INSTALLED

--
You received this message because you are subscribed to the Google Groups "JanusGraph users list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgraph-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Chin Huang <chinhu...@...>

#459

We were in the same situation. The problem is the index cannot be manually moved out the "INSTALLED" state. We have to recreate in the index and make sure no open transactions during mgmt.commit()

Please also check this thread, with similar issue of having index stuck in the "INSTALLED" state.

https://mail.google.com/mail/u/0/#search/installed/15c7ee77373b6ea8

Show quoted text

On Fri, Jul 21, 2017 at 9:15 AM, David Pitera <piter...@...> wrote:

Your propertyKey `phone` on your index `phoneIndex` is in the `INSTALLED` state, so you need to `REGISTER` it and wait for it to become registered before you can attempt to `enable` it. After it is enabled, you can disable and then remove it.

Some code that should help cause it goes through the whole installed/registered/enabled phase is:

https://github.com/dpitera/janusgraph/blob/ef4591e3524b7df87935de1cc86fbb7a139f32e6/janusgraph-core/src/main/java/org/janusgraph/graphdb/management/ConfigurationManagementGraph.java#L261-L289
On Thu, Jul 20, 2017 at 11:43 PM, 李平 <lipin...@...> wrote:
public class GraphTest {

    public static void main(String[] args) throws Exception {

        BaseConfiguration baseConfiguration = new BaseConfiguration();
        baseConfiguration.setProperty("storage.backend", "hbase");
        baseConfiguration.setProperty("storage.hostname", "192.168.1.108");
        baseConfiguration.setProperty("gremlin.graph", "org.janusgraph.core.JanusGraphFactory");
        JanusGraph janusGraph = JanusGraphFactory.open(baseConfiguration);
        GraphTraversalSource g = janusGraph.traversal();
        g.tx().rollback();
        JanusGraphManagement janusGraphManagement = janusGraph.openManagement();
        JanusGraphIndex phoneIndex = janusGraphManagement.getGraphIndex("phoneIndex");
        janusGraphManagement.updateIndex(phoneIndex, SchemaAction.DISABLE_INDEX).get();
        janusGraphManagement.commit();
        g.tx().commit();
        ManagementSystem.awaitGraphIndexStatus(janusGraph,"phoneIndex")
                .status(SchemaStatus.DISABLED)
                .timeout(10, ChronoUnit.MINUTES)
                .call();
        janusGraphManagement.updateIndex(phoneIndex, SchemaAction.REMOVE_INDEX).get();
        janusGraphManagement.commit();
        janusGraph.tx().commit();
        System.out.println("---------------------remove index sucess...");
the log is :Some key(s) on index phoneIndex do not currently have status DISABLED: phone=INSTALLED
--
You received this message because you are subscribed to the Google Groups "JanusGraph users list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgraph-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "JanusGraph users list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgraph-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

李平 <lipin...@...>

#464

BaseConfiguration baseConfiguration = new BaseConfiguration();
baseConfiguration.setProperty("storage.backend", "hbase");
baseConfiguration.setProperty("storage.hostname", "192.168.1.108");
baseConfiguration.setProperty("gremlin.graph", "org.janusgraph.core.JanusGraphFactory");
JanusGraph janusGraph = JanusGraphFactory.open(baseConfiguration);
JanusGraphManagement janusGraphManagement = janusGraph.openManagement();
JanusGraphIndex phoneIndex = janusGraphManagement.getGraphIndex("phoneIndex");
PropertyKey phone = janusGraphManagement.getPropertyKey("phone");
SchemaStatus indexStatus = phoneIndex.getIndexStatus(phone);
System.out.println(indexStatus);
if (indexStatus == INSTALLED) {
    ManagementSystem.awaitGraphIndexStatus(janusGraph,"phoneIndex").call();
    janusGraphManagement.updateIndex(phoneIndex, SchemaAction.REGISTER_INDEX).get();
}
janusGraphManagement.commit();
janusGraph.tx().commit();

it can not turn to register status,exception is  timeout

10:54:19.148 [main] DEBUG org.janusgraph.graphdb.database.management.GraphIndexStatusWatcher - Key phone has status INSTALLED
10:54:19.148 [main] INFO org.janusgraph.graphdb.database.management.GraphIndexStatusWatcher - Some key(s) on index phoneIndex do not currently have status REGISTERED: phone=INSTALLED
10:54:19.148 [main] INFO org.janusgraph.graphdb.database.management.GraphIndexStatusWatcher - Timed out (PT1M) while waiting for index phoneIndex to converge on status REGISTERED

在 2017年7月22日星期六 UTC+8上午12:15:20，David Pitera写道：

Show quoted text

Your propertyKey `phone` on your index `phoneIndex` is in the `INSTALLED` state, so you need to `REGISTER` it and wait for it to become registered before you can attempt to `enable` it. After it is enabled, you can disable and then remove it.

Some code that should help cause it goes through the whole installed/registered/enabled phase is:

https://github.com/dpitera/janusgraph/blob/ef4591e3524b7df87935de1cc86fbb7a139f32e6/janusgraph-core/src/main/java/org/janusgraph/graphdb/management/ConfigurationManagementGraph.java#L261-L289
On Thu, Jul 20, 2017 at 11:43 PM, 李平 <li...@...> wrote:
public class GraphTest {

    public static void main(String[] args) throws Exception {

        BaseConfiguration baseConfiguration = new BaseConfiguration();
        baseConfiguration.setProperty("storage.backend", "hbase");
        baseConfiguration.setProperty("storage.hostname", "192.168.1.108");
        baseConfiguration.setProperty("gremlin.graph", "org.janusgraph.core.JanusGraphFactory");
        JanusGraph janusGraph = JanusGraphFactory.open(baseConfiguration);
        GraphTraversalSource g = janusGraph.traversal();
        g.tx().rollback();
        JanusGraphManagement janusGraphManagement = janusGraph.openManagement();
        JanusGraphIndex phoneIndex = janusGraphManagement.getGraphIndex("phoneIndex");
        janusGraphManagement.updateIndex(phoneIndex, SchemaAction.DISABLE_INDEX).get();
        janusGraphManagement.commit();
        g.tx().commit();
        ManagementSystem.awaitGraphIndexStatus(janusGraph,"phoneIndex")
                .status(SchemaStatus.DISABLED)
                .timeout(10, ChronoUnit.MINUTES)
                .call();
        janusGraphManagement.updateIndex(phoneIndex, SchemaAction.REMOVE_INDEX).get();
        janusGraphManagement.commit();
        janusGraph.tx().commit();
        System.out.println("---------------------remove index sucess...");
the log is :Some key(s) on index phoneIndex do not currently have status DISABLED: phone=INSTALLED
--
You received this message because you are subscribed to the Google Groups "JanusGraph users list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgraph-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

1 - 4 of 4

Previous Topic Next Topic

Home Hashtags Subgroups Calendar Terms