[orientdb] KeywordAnalyzer, no results

2015-02-06 Thread Erik Peterson
Reposting as separate issue Anyone seeing issues with KeywordAnalyzer? Not returning any records with it. Using 2.0RC1. create index geo.lucene.KeywordAnalyzer on geo (location) fulltext engine lucene METADATA {"analyzer":"org.apache.lucene.analysis.core.KeywordAnalyzer"} select location

[orientdb] Dijkstra with dynamic weight

2015-02-06 Thread Georg Göttlich
Hello everyone. I have another newbie question regarding the graph model. Is it somehow possible to have the result of a custom function being the weight parameter in dijkstra()? Cheers Georg -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group.

[orientdb] Re: OTimeoutException: Timeout on acquiring exclusive lock against resource of class:

2015-02-06 Thread alexander anguiano
I have a similar problem. in the latest release 2.0.1 orientdb 2.0.1 java 7 window & linux I use sql and the java api I have a class that i'm updating frequently in multiple threads. This same class is used in a guery to show in a grid. i did find the setting OGlobalConfiguration.STORAGE_

Re: [orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
I think the Luca's update query will be able to use my index, where this one even though it looks cleaner will probably not. It's no long hanging, but i do have a connection that did not make it back to the thread pool. It's stuck in the graph.shutdown(). dw-57 - PUT /api/asset-manager/assets

Re: [orientdb] newbie traverse confusion

2015-02-06 Thread Georg Göttlich
Hi Riccardo. Thank you very much for your offer to help and please excuse the somewhat incomprehensible post late at night. Here is what I'm trying to do. Consider the following setup. create class NodeTypeA extends V create property NodeTypeA.name string create vertex NodeTypeA set name = 'No

Re: [orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread syshex
Yes, you can, but that way you need to know the rid of the records , you cant ( that I know of ) put a subquery on the update , like you want (http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Update.html) You can however address the problem you have at hand, which is : selecting so

Re: [orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread Luca Garulli
Try this: update (select expand(in('Manages')) from asset where guid = '817ea932-4a4a-49a4-8454-37c5098703a2') set lastCommunicationTime=date() With expand the collection becomes the resultset. Lvc@ On 6 February 2015 at 17:40, alexander anguiano wrote: > I didn't realize you can do this. >

Re: [orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
I didn't realize you can do this. The real query that i need is update (select in('Manages') from asset where guid = '817ea932-4a4a-49a4-8454-37c5098703a2') set lastCommunicationTime=date() but it isn't working, it get this java.lang.IllegalArgumentException: Cluster segment #-2 does not ex

Re: [orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread Emanuel
Have you thought to do change in this way: update #13:3 set lastCommunicationTime=date() bye Emanuel On 06/02/15 15:59, syshex wrote: update Agent set lastCommunicationTime=date() where @rid = #13:3 -- --- You received this message because you are subscribed to the Google Groups "Orient

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread syshex
The inner select doesn't seem problematic , but then again I'm not a master of orientdb and am still learning most of the stuff. Still, let me try and give you a hand. More info needed : - what about if you run the inner query by itself ? How long does it take to run ? - how many assets do

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
yes it is faster, but it gets in a weird state. If i remove the inner select and just run this update Agent set lastCommunicationTime=date() where @rid = #13:3 it's taking 2 seconds. On Friday, February 6, 2015 at 9:42:19 AM UTC-6, syshex wrote: > > Hi, > Without the expand it should be faster

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread syshex
Hi, Without the expand it should be faster now. The hanging bit, are you saying that after running update commands like that , after a bit the server starts hanging and/or the queries taking longer to execute ? Anything being printed on the logs ? On Friday, February 6, 2015 at 3:25:26 PM UT

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
Ok, i see what happened if i run this in the sql analyzer it i don't see a rid select in('Manages').@rid from asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf' but if i run this new update Agent set lastCommunicationTime=date() where @rid in (select in('Manages').@rid from asset whe

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
I don't need to expand, how do i get the rid? I tried in("Manages").@rid and it didnt work select in('Manages').@rid from asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf') On Friday, February 6, 2015 at 8:39:12 AM UTC-6, syshex wrote: > > Hi Alexander > > Do you need to Expand ? >

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread syshex
Hi Alexander Do you need to Expand ? select expand(in('Manages')) from asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf') Returns a result set of the complete records, which you don't seem to need, just the rid. select in('Manages') from asset where guid = '19da4856-57c0-4b39-8f

[orientdb] sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
orientdb version 2.0.1 java 7 windows and linux i'm making alot of these calls and eventually they begin to hang update Agent set lastCommunicationTime=date() where @rid in (select @rid from (select expand(in('Manages')) from asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf'))

[orientdb] Re: Select using Index fires warning: "result set with more than 10000 records"

2015-02-06 Thread syshex
Also skip 10 limit 50 order by key DESC in this query gives different results than order by key DESC skip 10 limit 50 on the same query, which was unexpected to me On Friday, February 6, 2015 at 12:21:14 PM UTC, syshex wrote: > > Using a Query like so : > > select > expand(rid) > from ind

Re: [orientdb] Robustness Problem

2015-02-06 Thread Luca Garulli
Hi Chanras, When you killed the process, OrientDB was flushing pages on disk. During this operation you could have portion of your database lost. In this case OrientDB read the WAL (Journal) and rollback any non committed transactions. This is to *apply the ACIDity of transactions*. About indexes

[orientdb] Select using Index fires warning: "result set with more than 10000 records"

2015-02-06 Thread syshex
Using a Query like so : select expand(rid) from index:Papers.publicationDate skip 10 limit 50 order by key DESC makes orientdb fire a warning : 2015-02-06 12:16:33:718 INFO {db=testdb} [TIP] Query 'select expand(rid) from index:Papers.publicationDate skip 10 limit 30 order by key DESC' r

Re: [orientdb] UnsupportedOperationException When Creating in Memory Distributed Database

2015-02-06 Thread Luigi Dell'Aquila
Hi Andy, This is a known issue, you can find all the details here: https://github.com/orientechnologies/orientdb/issues/3203 Luigi 2015-02-05 16:58 GMT+01:00 : > > Hello, > I am unable to create an in MEMORY distributed database due to the > following exception: > java.lang.UnsupportedO

[orientdb] phpOrient and DATE

2015-02-06 Thread Dlpnet
Hello, I have a vertex with 2 DATE properties. When I use phporient to get the data from the vertex the resulting dates are not correct. If I do the same request using Studio the answer is correct. Is there anyway to convert the result from phporient to a proper value ? I tried converting from a D