lucene spatial - import 1.7.4 db to 1.7.9 throws error

[Jonathan Rosen]

Here is an error that is thrown when I try to import the 1.7.4 db that has a spatial index to 1.7.9:

- Index 'stores.latlong'...Error on database import happened just before line 0, column 1582755
com.orientechnologies.orient.core.index.OIndexException: Index type: SPATIAL is not supported. Types are [UNIQUE,FULLTEXT,FULLTEXT_HASH_INDEX,DICTIONARY_HASH_INDEX,DICTIONARY,UNIQUE_HASH_INDEX,NOTUNIQUE_HASH_INDEX,SPATIAL,NOTUNIQUE]

This is a weird error, since it says that Spatial is not supported, bu then lists Spatial as an available index option. Any thoughts on how to fix this?

[Enrico Risa]

Hi Jonathan

are you importing from the console right?

Seems that from there you have no access to the Lucene Plugin

Se the rebuild of the index fail.

Can you try to put the lucene plugin under you libs directory of OrientDB

Enrico

--

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

[Jonathan Rosen]

Same result with lucene plugin under libs directory. Are there any workarounds for this?

Generally speaking I have found backup reliability in orientdb to be atrocious, and it makes me scared to run any kind of production environment around it. You never know if your db migration will succeed or fail...

com.orientechnologies.orient.core.index.OIndexException: Index type: SPATIAL is not supported. Types are [UNIQUE,FULLTEXT,FULLTEXT_HASH_INDEX,DICTIONARY_HASH_INDEX,DICTIONARY,UNIQUE_HASH_INDEX,NOTUNIQUE_HASH_INDEX,SPATIAL,NOTUNIQUE]

    at com.orientechnologies.orient.core.index.OIndexes.createIndex(OIndexes.java:153)
    at com.orientechnologies.orient.core.index.OIndexManagerShared.createIndex(OIndexManagerShared.java:143)
    at com.orientechnologies.orient.core.index.OIndexManagerProxy.createIndex(OIndexManagerProxy.java:75)
    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLCreateIndex.execute(OCommandExecutorSQLCreateIndex.java:255)
    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.execute(OCommandExecutorSQLDelegate.java:60)
    at com.orientechnologies.orient.core.storage.OStorageEmbedded.executeCommand(OStorageEmbedded.java:94)
    at com.orientechnologies.orient.core.storage.OStorageEmbedded.command(OStorageEmbedded.java:83)
    at com.orientechnologies.orient.core.command.OCommandRequestTextAbstract.execute(OCommandRequestTextAbstract.java:59)
    at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.command(ONetworkProtocolBinary.java:1181)
    at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.executeRequest(ONetworkProtocolBinary.java:340)
    at com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstract.execute(OBinaryNetworkProtocolAbstract.java:169)
    at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:45)

Error: com.orientechnologies.orient.core.db.tool.ODatabaseExportException: Error on importing database 'ipdb' from file: /Users/xxx/Sites/releases/releases/orientdb-community-1.7.9/backups/174again.export.gz

Error: com.orientechnologies.orient.core.index.OIndexException: Index type: SPATIAL is not supported. Types are [UNIQUE,FULLTEXT,FULLTEXT_HASH_INDEX,DICTIONARY_HASH_INDEX,DICTIONARY,UNIQUE_HASH_INDEX,NOTUNIQUE_HASH_INDEX,SPATIAL,NOTUNIQUE]

[Enrico Risa]

Hi  Jonathan

do you use remote connection or local for the import?

[Jonathan Rosen]

remote. Should I try local?

--

---
You received this message because you are subscribed to a topic in the Google Groups "OrientDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orient-database/Rmepr8bI5MA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.

[Enrico Risa]

Seems strange that doesn't find the lucene plugin in the server.

Do you have the log of the server?

[Jonathan Rosen]

yes. i can email it to you if you want.

[Enrico Risa]

yes thanks :D

[Jonathan Rosen]

nevermind i can just post it. it is pasted below. it says that the plugin definition file (plugin.json) is missing. maybe this is the issue? how do i fix this?

2014-10-21 18:49:57:510 INFO Loading configuration from: /Users/xxx/Sites/releases/releases/orientdb-community-1.7.9/config/orientdb-server-config.xml... [OServerConfigurationLoaderXml]
2014-10-21 18:49:57:640 INFO OrientDB Server v1.7.9 (build 3) is starting up... [OServer]
2014-10-21 18:49:57:644 INFO Databases directory: /Users/xxx/Sites/releases/releases/orientdb-community-1.7.9/databases [OServer]
2014-10-21 18:49:57:673 INFO Listening binary connections on 0.0.0.0:2424 (protocol v.21, socket=default) [OServerNetworkListener]
2014-10-21 18:49:57:674 INFO Listening http connections on 0.0.0.0:2480 (protocol v.10, socket=default) [OServerNetworkListener]
2014-10-21 18:49:57:682 INFO Installing dynamic plugin 'studio-1.7.8.zip'... [OServerPluginManager]
2014-10-21 18:49:57:725 INFO Installing GREMLIN language v.2.5.0 - graph.pool.max=50 [OGraphServerHandler]
2014-10-21 18:49:57:728 INFO Installing Script interpreter. WARN: authenticated clients can execute any kind of code into the server by using the following allowed languages: [sql] [OServerSideScriptInterpreter]
2014-10-21 18:49:57:810 INFO OrientDB Server v1.7.9 is active. [OServer]
2014-10-21 19:12:38:337 INFO Created database 'ipdb' of type 'plocal' [ONetworkProtocolBinary]
2014-10-21 19:17:33:004 INFO Installing dynamic plugin 'orientdb-lucene-1.7.9-SNAPSHOT-dist.jar'... [OServerPluginManager]
2014-10-21 19:17:33:005 SEVE Plugin definition file ('plugin.json') is not found for dynamic plugin 'orientdb-lucene-1.7.9-SNAPSHOT-dist.jar' [OServerPluginManager]Error on installing dynamic plugin 'orientdb-lucene-1.7.9-SNAPSHOT-dist.jar'
Plugin definition file ('plugin.json') is not found for dynamic plugin 'orientdb-lucene-1.7.9-SNAPSHOT-dist.jar'
-> com.orientechnologies.orient.server.plugin.OServerPluginManager.installDynamicPlugin(OServerPluginManager.java:297)
-> com.orientechnologies.orient.server.plugin.OServerPluginManager.updatePlugin(OServerPluginManager.java:185)
-> com.orientechnologies.orient.server.plugin.OServerPluginManager.updatePlugins(OServerPluginManager.java:270)
-> com.orientechnologies.orient.server.plugin.OServerPluginManager.access$000(OServerPluginManager.java:54)
-> com.orientechnologies.orient.server.plugin.OServerPluginManager$1.run(OServerPluginManager.java:87)
-> java.util.TimerThread.mainLoop(Timer.java:555)
-> java.util.TimerThread.run(Timer.java:505)
2014-10-21 19:17:38:004 INFO Installing dynamic plugin 'orientdb-lucene-1.7.9-SNAPSHOT-dist.jar'... [OServerPluginManager]
2014-10-21 19:17:38:016 INFO Lucene index plugin installed and active. Lucene version: LUCENE_47 [OLuceneIndexPlugin]
2014-10-21 19:17:56:011 INFO Received shutdown command from the remote client /192.168.1.10:59198 [ONetworkProtocolBinary]
2014-10-21 19:17:56:011 INFO Remote client /192.168.1.10:59198 authenticated. Starting shutdown of server... [ONetworkProtocolBinary]
2014-10-21 19:17:56:012 INFO OrientDB Server is shutting down... [OServer]
2014-10-21 19:17:56:012 INFO Shutting down listeners: [OServer]
2014-10-21 19:17:56:012 INFO - ONetworkProtocolBinary /0.0.0.0:2424: [OServer]
2014-10-21 19:17:56:012 INFO - ONetworkProtocolHttpDb /0.0.0.0:2480: [OServer]
2014-10-21 19:17:56:012 INFO Shutting down protocols [OServer]
2014-10-21 19:17:56:012 INFO Shutting down plugins: [OServerPluginManager]
2014-10-21 19:17:56:013 INFO - studio [OServerPluginManager]
2014-10-21 19:17:56:013 INFO - automaticBackup [OServerPluginManager]
2014-10-21 19:17:56:013 INFO - script-interpreter [OServerPluginManager]
2014-10-21 19:17:56:013 INFO - jmx [OServerPluginManager]
2014-10-21 19:17:56:042 INFO - graph [OServerPluginManager]
2014-10-21 19:17:56:042 INFO - lucene-index [OServerPluginManager]
2014-10-21 19:17:56:042 INFO Shutting down databases: [OServer]
2014-10-21 19:17:56:043 INFO - storage: ipdb... [Orient]
2014-10-21 19:17:56:063 INFO OrientDB Engine shutdown complete [Orient]
2014-10-21 19:17:56:063 INFO OrientDB Server shutdown complete [OServer]

[Enrico Risa]

Yes 

this is  the issue

have you downloaded the plugin from here ?

https://github.com/orientechnologies/orientdb-lucene/releases/download/1.7.9-SNAPSHOT/orientdb-lucene-1.7.9-SNAPSHOT-dist.jar

Do you still have the plugin also in OrientDB lib directory?

[Jonathan Rosen]

I've gotten it working now. I compiled 2.0M2 plugin from source and it is working on 2.0M2. However, I am seeing some data inconsistency issues on the migrated database. Records that don't have graph edges to them are being pulled using lucene. Not sure what this is about...they appear to be "ghost" records, since they are showing as having an edge connection, but there is no such connection in the actual db (ridbag does not contain the edge shown). Not sure what's going on exactly, since the db on the other system did not do this. Still researching this....