Hi Brandon, In v. 1.7 there are still problems with indexes, this is why I asked you about a migration. Unfortunately the only solution is to avoid hard shutdown and to rebuild indexes periodically. Could you please post the exceptions you get with 2.0? I'll see if we can do something about that
Thanks Luigi 2015-08-28 19:38 GMT+02:00 Brandon Dennis <[email protected]>: > So I rebuilt all the indexes and it appears that we are getting all the > results we expect from this query. I'm assuming that Orient is using the > indexes to short circuit some traversing if it thinks it is not needed? > > My question now is how do the indexes get out of date like that and is > there anything I can do to make sure they stay current without having to > just rebuild them periodically? > > On Thursday, August 27, 2015 at 3:29:04 AM UTC-4, Luigi Dell'Aquila wrote: >> >> Hi guys, >> yes, having just a few lines of result will help a lot, I'm just trying >> to figure out the exact "physical" structure of your records to see if >> there is something I'm missing. >> >> Could you please also try this and let me know if you get the expected >> results? >> >> select expand(in("CompetitionEntry__competition").out(" >> CompetitionEntry__roster").in("plays_for")) from #{@competition.id} >> LIMIT -1 >> >> >> Thanks >> >> Luigi >> >> >> >> 2015-08-26 16:53 GMT+02:00 Brandon Dennis <[email protected]>: >> >>> CompetitionEntry__competition is a lightweight edge. >>> CompetitionEntry__roster and plays_for are both document backed edges. >>> >>> Running the last query gives me CompetitionEntry, the middle query gives >>> me Rosters, and the first query gives me the plays_for edges. >>> >>> We're still on 1.7 because we're using this from a jruby application, >>> that has a gem that wraps the java jars, and another gem that modeled after >>> an old Neo4j gem version to access Orient. My predecessors wrote both gems, >>> and there are a lot of exceptions that get thrown when I try to run it with >>> 2.x version of orient. >>> >>> >>> On Tuesday, August 25, 2015 at 2:05:08 PM UTC-4, Brandon Dennis wrote: >>>> >>>> For reference I'm using 1.7.9 in jruby (but I stole the studio.zip from >>>> 2.1 and put it in the plugins directory, hence the graph editor). Also I >>>> didn't write this query (or codebase) I inherited it. >>>> >>>> I have a query that should start at a Competition, traverse to all >>>> CompetitionEntries via the CompetitionEntry__competition, then to the >>>> Rosters via the CompetitionEntry__roster and finally get all the >>>> 'plays_for' edges. Here is the query: >>>> >>>> "select from (select expand(inE('plays_for')) from (traverse >>>> out_CompetitionEntry__roster from (traverse >>>> in_CompetitionEntry__competition from #{@competition.id})))" >>>> >>>> Below is a screenshot of the graph editor showing the relationships. >>>> There are a lot more than this, but this was mainly for reference. >>>> >>>> >>>> <https://lh3.googleusercontent.com/-uf2aek6jakg/VdynV2qMOcI/AAAAAAAAAJg/wlJiJtiJ7uU/s1600/Screen%2BShot%2B2015-08-25%2Bat%2B1.26.03%2BPM.png> >>>> >>>> This query returns a lot of data, but it doesn't return everything I >>>> expect it to. It actually wont return any of the 'plays_for' edges shown >>>> above. I'm not sure what I'm missing. Is there a reason the above query's >>>> response wouldn't include the data shown in the screenshot? >>>> >>>> -- >>> >>> --- >>> 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 [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > > --- > 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
