[orientdb] Re: Restore Database

2017-11-13 Thread Oleksandr Gubchenko
The version that you are using is old, try to run it with the latest 2.2.x and if it doesn't help on the latest version you can also try REPAIR DATABASE command. Il giorno lunedì 13 novembre 2017 12:48:49 UTC+1, Pugazharasan Thirumalai ha scritto: > > Hai, > > We are using Orientdb 2.0.18 vers

[orientdb] Querying on multiple LINKMAP items with SQL

2017-11-13 Thread Eric24
I have a class that contains a LINKMAP field called links. This class is used recursively to create arbitrary hierarchical groupings (something like the time-series example, but not with the fixed year/month/day structure). A query like this: select expand(links['2017'].links['07'].links['15'].

[orientdb] Lightweight Edges not maintained when using SQL DELETE VERTEX

2017-11-13 Thread Eric24
It has been mentioned many times that using lightweight edges is "more difficult" with SQL. Can anyone provide specific examples of when this is true (i.e. what are the SQL issues created by using them)? I ask because just about everything I've tried with lightweight edges works the same way wi

Re: [orientdb] Syntax for ADD operation with collection of maps?

2017-11-13 Thread Eric Lenington
Looks like a bug; report opened: https://github.com/orientechnologies/orientjs/issues/285 On Mon, Nov 13, 2017 at 2:20 AM, Luigi Dell'Aquila < luigi.dellaqu...@gmail.com> wrote: > Hi Eric, > > The correct syntax should be just > > UPDATE x ADD list = {"ddd":444, "dd":44} > > If it doesn't work,

[orientdb] Restore Database

2017-11-13 Thread Pugazharasan Thirumalai
Hai, We are using Orientdb 2.0.18 version Our database has crashed, when we try to restart my database am getting error . Provide proper solution to restore my database. Its very urgent please reply soon, all customers are waiting. 2017-11-13 03:55:23:538 INFO OrientDB auto-config DISKCACHE

Re: [orientdb] Efficiency of delete from manual index using @rid (And possible bug in 2.2.29)

2017-11-13 Thread Luigi Dell'Aquila
Hi Eric, The index is optimized to do lookups by key, not by RID, so I'd say the answer is no, it won't be efficient. About the SELECT, it's not an expected behavior, I'll check it Thanks Luigi 2017-11-13 5:05 GMT+01:00 Eric24 : > While it's easy enough to delete rows from a manual index by

Re: [orientdb] Syntax for ADD operation with collection of maps?

2017-11-13 Thread Luigi Dell'Aquila
Hi Eric, The correct syntax should be just UPDATE x ADD list = {"ddd":444, "dd":44} If it doesn't work, I'd say it's a bug. Could you please report in issue? Thanks Luigi 2017-11-12 19:15 GMT+01:00 Eric24 : > I can't figure out the proper SQL syntax for adding a map to a collection. > For

Re: [orientdb] Re: Concurrency during UPDATE ADD operation

2017-11-13 Thread Luigi Dell'Aquila
Hi Eric, UPDATE ADD is just a normal record change, the record is completely overwritten and the version is increased, so you will have a normal ConcurrentModificationException if two operations happen at the same time. My general advice in these cases is to use a commit/retry strategy. If you are