Re: [orientdb] Re: Support for Lucene 6 3D (nD) Spatial Indexes

2016-06-08 Thread Roberto Franchini
On Thu, Jun 9, 2016 at 7:26 AM, 'scott molinari' via OrientDB < orient-database@googlegroups.com> wrote: > If I read the code/ config in the Lucene index section of ODB, it looks > like it is using 4.7.0, which is disappointing, considering the Lucene team > is working on version 7. > > > https://

[orientdb] Re: Support for Lucene 6 3D (nD) Spatial Indexes

2016-06-08 Thread 'scott molinari' via OrientDB
If I read the code/ config in the Lucene index section of ODB, it looks like it is using 4.7.0, which is disappointing, considering the Lucene team is working on version 7. https://github.com/orientechnologies/orientdb/blob/5d4ff9438db9eacd18c2502615747648602b49ed/lucene/pom.xml#L39 Scott --

[orientdb] Re: Pagination bug

2016-06-08 Thread Stuart Reynolds
I found a mistake in my example. Should have been as follows (but still fails): var resultset = db.query[OResultSet[ODocument]](query) while (!resultset.isEmpty()) { resultset.toArray.foreach(println) resultset = db.query(query) println("-") } I

[orientdb] Pagination bug

2016-06-08 Thread Stuart Reynolds
I'm trying to follow the doc's recommendations to implement pagination - I think there's a bug here: http://orientdb.com/docs/last/Pagination.html. This method gives me duplicate records and iterates for ever. Here's my example in Scala: // Create a new memory DB. val db: ODatabaseDocume

[orientdb] Support for Lucene 6 3D (nD) Spatial Indexes

2016-06-08 Thread Eric24
What version of Lucene is currently supported in OrientDB 2.2.0? If less than 6.0, what would be required to support 6.0/6.0.1 (and/or if and when is this on the road map)? If 6.0 or later, are 3D/nD spatial indexes supported? For example, there is no enforced limit on the number of elements th

[orientdb] orientdb 2.2.0: is command cache working?

2016-06-08 Thread pabloa
Hello I cannot say if command cache works in orientdb 2.2.0 community. I added this line in server.sh on a remote orientdb 2.2.0 ORIENTDB_SETTINGS="-Dprofiler.enabled=true -Dcommand.cache.enabled=true -Dcommand.cache.evictStrategy=INVALIDATE_ALL -Dcommand.cache.minExecutionTime=5 -Dcommand.ca

[orientdb] select from MyClass fetchplan *:-1; is SLOW (around 1000 docs/sec)

2016-06-08 Thread pabloa
Hello I have a class *UserTrace* with a property *trace* of type *LinkedList*. Property *trace* is a list of other classes. I have several thousand documents stored in that class on a remote server. When we send from Java a query like: *select from UserTrace fetchplan *:-1* We get the list b

Re: [orientdb] OrientDb 2.1.19: File databases/temp_1465328268_pzfv6nn3/internal.cpm' is locked by other process

2016-06-08 Thread pabloa
Thank you both Andrey and Luca for you answers. I believe this issue perhaps was triggered by the open files leaking described in https://github.com/orientechnologies/orientdb/issues/6269 I will wait for the hot fix. I will report if I find it again. P On Wednesday, June 8, 2016 at 3:18:33 AM

Re: [orientdb] OrientDb 2.1.19: possible open file leaking? (more than 129235 open files)

2016-06-08 Thread pabloa
thanks. On Tuesday, June 7, 2016 at 9:20:29 PM UTC-7, Andrey Lomakin wrote: > > Hi, > I have created an issue which will be fixed in 2.1.x version > https://github.com/orientechnologies/orientdb/issues/6269 . > > On Tue, Jun 7, 2016 at 11:46 PM pabloa > > wrote: > >> Hello >> >> Log files have t

[orientdb] Order BY @RID DESC stops working in 2.2

2016-06-08 Thread hartmut bischoff
Hi altogether I am in the process of adapting ActiveOrient (https://github.com/topofocus/active-orient) to Version 2.2. And found that DatabaseClass#Last returns the first instead of the last record. The following query is transmitted by the test-suite: select from industry order by @rid d

[orientdb] AWS performance question

2016-06-08 Thread Curt Kohler
I've been asked to kick the tires on OrientDB as a possible graph DB solution for an upcoming project at my company. In order to do so, I've spun up an EC2 instance using the OrientDB marketplace AMI on a m4.xlarge box with an EBS drive (picked as a general purpose box since I couldn't find any

Re: [orientdb] Re: OrientDB Storage Overhead

2016-06-08 Thread Andrey Lomakin
Depends on ID value, typically 1-2 bytes. On Wed, Jun 8, 2016 at 4:47 PM Eric Lenington wrote: > OK. So the space used is just the ID itself? How many bytes is the ID? > > > On Wed, Jun 8, 2016 at 1:23 AM, Andrey Lomakin > wrote: > >> Hi, >> >The second part is new--whether there is a differenc

Re: [orientdb] Re: OrientDB Storage Overhead

2016-06-08 Thread Eric Lenington
OK. So the space used is just the ID itself? How many bytes is the ID? On Wed, Jun 8, 2016 at 1:23 AM, Andrey Lomakin wrote: > Hi, > >The second part is new--whether there is a difference between not adding > a property and setting it to NULL > Yes, there is the difference. In last case name of

[orientdb] Serious Unique index violation - ORecordDuplicatedException: Cannot index record found duplicate

2016-06-08 Thread 'Simon White' via OrientDB
Affecting 2.1.19 We have quite a large database - about a million entries for a particular vertex. Recently I noticed by chance a duplicate, but surely this is impossible when there is a unique index? I attempted to rebuild the index but unsurprisingly it fails with an ORecordDuplicatedExcepti

Re: [orientdb] OrientDb 2.1.19: File databases/temp_1465328268_pzfv6nn3/internal.cpm' is locked by other process

2016-06-08 Thread Luca Garulli
For more information about how to set settings look at: http://orientdb.com/docs/last/Configuration.html Best Regards, Luca Garulli Founder & CEO OrientDB On 8 June 2016 at 06:22, Andrey Lomakin wrote: > Hi, > Some Java versions have the bug with interprocess file lock.

Re: [orientdb] What does "You cannot access outside the file size (30 bytes). You have requested portion ..." mean?

2016-06-08 Thread Luca Garulli
Hi, v2.2 is better ;-) Best Regards, Luca Garulli Founder & CEO OrientDB On 8 June 2016 at 09:02, Andrey Lomakin wrote: > Hi, > We do not support 2.0 version any more could you try on 2.1 and provide > feedback whether issue is fixed. > > On Wed, Jun 8, 2016 at 9:17 AM

Re: [orientdb] OrientDB Live Query Use Cases

2016-06-08 Thread Luigi Dell'Aquila
Hi Vijay, Live queries are mainly designed to be used in reactive architectures, where your application expects a push notification when something changes instead of querying the db periodically. For your needs, I suggest you to take a look at OrientDB hooks http://orientdb.com/docs/last/Hook.html

Re: [orientdb] What does "You cannot access outside the file size (30 bytes). You have requested portion ..." mean?

2016-06-08 Thread Andrey Lomakin
Hi, We do not support 2.0 version any more could you try on 2.1 and provide feedback whether issue is fixed. On Wed, Jun 8, 2016 at 9:17 AM Udit Mittal wrote: > Hello , > I am having Same Issue > with 2.0.10 v in OrientDB > > Query is --> delete vertex sitedata where siteid='334_776' and > local