[orientdb] Re: How to browse through records in in-memoryDB

2015-02-19 Thread Shivanandan Gupta
Can someone please help me on this , as currently I am doing evaluation of orientdb and based on this we will decide to go with orientdb or to analyze another no-sql db. really appreciate your help. Thanks, Shivanandan Gupta -- --- You received this message because you are subscribed to the

Re: [orientdb] Re: OrientDB 2.0.2: COMMIT blocks reads?

2015-02-19 Thread Andrey Lomakin
Hi Markus, Now it is expected behavior but we work on parallel TXs implementation which will be introduced in 2.3 version where we will remove this issue. On Thu, Feb 19, 2015 at 5:39 PM, Markus Menner wrote: > Okay, seems to be related to: > https://github.com/orientechnologies/orientdb/issues

Re: [orientdb] Record deadlock issue in 2.0.2

2015-02-19 Thread Andrey Lomakin
Hi, I do not think that it is deadlock, it is timeout exception could you set storage.record.lockTimeout property to 20 to double check ? On Fri, Feb 20, 2015 at 1:08 AM, Kareem Jabr wrote: > I am facing this exception a lot now, > > in context with path [/aa-sport] threw exception > [com.o

[orientdb] [announcement] Released OrientDB 2.0.3 (hotfix)

2015-02-19 Thread Luca Garulli
Hi guys, We released OrientDB 2.0.3 as hotfix. If you're using OrientDB 2.x, please upgrade to this version (it's 100% compatible). The main focus of this release is on *replication* and *sharding*. If you had any issue with replication and shading, please upgrade and check again if the issue has

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

2015-02-19 Thread Kareem Jabr
I am also having the same issue have you found a solution for it. I am on 2.0.2 On Friday, December 12, 2014 at 4:07:17 PM UTC+4, Adithyan K wrote: > > OrientDB Version : 2.0-M3 > > our software reads from doc db in multi threads while there is another > only one thread creating records...!

[orientdb] Record deadlock issue in 2.0.2

2015-02-19 Thread Kareem Jabr
I am facing this exception a lot now, in context with path [/aa-sport] threw exception [com.orientechnologies.orient.core.exception.ODatabaseException: Error on retrieving record #27:165831 (cluster: event)] with root cause com.orientechnologies.common.concur.OTimeoutException: Can not lock reco

[orientdb] problems with GraphSONReader / GraphSONWriter

2015-02-19 Thread Stephen Tyler
Hi I am having trouble importing and exporting data with GraphSONReader. As a simple test case, I have a class named Person that inherits from V. I have one Person record. When I export the data using GraphSONWriter and then import the data using GraphSONReader, the record is of class V, not

[orientdb] Custom sort order for OIndexNotUnique

2015-02-19 Thread Sébastien Boulet
Hello, I am using the graph api and i have created an index NOT_UNIQUE on a string property. entryVersionType.createProperty('property', OType.STRING).createIndex(INDEX_TYPE.NOTUNIQUE); Now i would like to configure the index sort algorithm. I don't want to use the default sort order (Str

[orientdb] Re: NoClassDefFound (ODatabaseReocrd) problem using Java API to connect to remote database (2.0.2)

2015-02-19 Thread John Firman
I found the problem - I had included the dependencies for com.tinkerpop.blueprints in my pom.xml (blueprints-core and blueprints-orient-graph). These are not necessary with the latest version of OrientDB. Removing those dependencies solved my problem and I am able to connect to the remote datab

[orientdb] How to browse through records in in-memoryDB

2015-02-19 Thread Shivanandan Gupta
Hi All, We wanted to use in-memory DB in orientdb. So i created an in-memoryDB and create a class with 74 properties, then I used jsonETL code to bulk load 1 million vertex to the class. The load was over in 50 seconds and I was very happy to see the quick data load. Now I went to the orientdb

[orientdb] [Orientdb - 2.0.2] - Error on executing distributed request

2015-02-19 Thread Tiago Palma
I'm having the following issue, is it an issue from my configuration files? Thank you. *## DB Information* 1. OrientDb VERSION 2.0.2 - (February, 9th 2015) running on CentOS7 64 Bit 2. Three ODB servers in a cluster (1 instance running in orientdb-01 and 2 instances running in orientdb-02 as men

[orientdb] Re: OrientDB 2.0.2: COMMIT blocks reads?

2015-02-19 Thread Markus Menner
Okay, seems to be related to: https://github.com/orientechnologies/orientdb/issues/3283 -- --- 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-database+unsubs

[orientdb] Object API: generated schema with in/out relations

2015-02-19 Thread Wouter de Vaal
Hi, I'm using Object API and let orient generate a schema for me with the objectDatabaseTx.getMetadata().getSchema().generateSchema() method. If there is a link to another class, it adds it as a property link, but not as an in/out graph relation: public class Login extends BasePersistentObject

[orientdb] OrientDB 2.0.2: COMMIT blocks reads?

2015-02-19 Thread Markus Menner
Hi guys, I asked this question as part of another thread already, but now explicitly due to the fact that the effect I describe is very annoying: I update around 8000 Documents within a transaction. When I commit it seems that reads on the same Document in another thread are blocked until the c

[orientdb] Get available edge types for a vertex - Java API

2015-02-19 Thread stefan
Hi, The Java API has a handy count edges by type function: .countEdges(Direction.IN, Label) Is there a function that allows me to the a list of possible labels? Something like String[] getEdgeTypes(Direction) Regards, -Stefan -- --- You received this message because you are subscribed to

Re: [orientdb] Re: HELP: 2.0.2 write performance in transaction

2015-02-19 Thread Shivanandan Gupta
I am able to do 2 vertex per second but its in inmemory db , Dont know how I can use this inmemory data from the class to the downstream system? when I am doing a select to the class to which the ETL json loaded the data it shows 0 records. + extracted 996,523 rows (20,043 rows/sec) - 996

[orientdb] Re: HELP: 2.0.2 write performance in transaction

2015-02-19 Thread Markus Menner
Hi, I think there is a misunderstanding: My problem occurs in EMBEDDED mode, when I do 8000 UPDATES within a TRANSACTION using the DOCUMENT API. The save()s are performed in a reasonable amount of time (around 2-3 secs.). But when the COMMIT is performed, it takes between 3 and 20 seconds (that'

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-19 Thread Shivanandan Gupta
In current situation , we want to load data in in-memory DB and another application will read data from it. Is there a way I can persist the data inmemory till another application reads it? I used plocal and data can be persisted but the load time is high 2 minutes for the same set of records.

[orientdb] Issue: Files system based DB gets locked when multiple client perform write operations

2015-02-19 Thread Hiren Dutta
I am new to Orient DB. I am having below queries regarding database storage creation and access 1. Simultaneous db operation from Java (plocal) as well as admin console not working. say which running local server if I tried to drop and create db through blueprint java API, its giving file sys

[orientdb] Re: Detect Cycles in a Graph

2015-02-19 Thread Hiren Dutta
Check http://www.geeksforgeeks.org/detect-cycle-in-a-graph/ You have to traverse through DFS to check the same. -- --- 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

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-19 Thread Luigi Dell'Aquila
Hi Shivanandan, the problem here is that ETL is creating an in-memory database, and every in-memory db is completely deleted when the VM goes down (in this case when the ETL terminates). If you want a persistent db you have to use PLocal Regards Luigi 2015-02-19 10:45 GMT+01:00 Shivanandan Gu

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-19 Thread Shivanandan Gupta
Hi Luigi, I used below given json for ETL the data load happened but I am not able to see any vertex in the class. { "source": { "file": { "path": "C:\odb\s_asset.csv" } }, "extractor": { "row": {} }, "transformers": [ { "csv": {} }, { "vertex": { "class": "S_ASSET" } } ], "lo

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-19 Thread Shivanandan Gupta
Thanks Luigi I changed it and it worked. the statics is given below: *RecordsLoaded* *AttributesPerRecords* *DataVolume* *TimeTaken (MS)* *TimeTaken(Seconds)* 1,000,320 75 250 MB 50435ms 50 Sec Thanks Shivanandan Gupta On Thursday, 19 February 2015 14:40:04 UTC+5:30, Luigi

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-19 Thread Luigi Dell'Aquila
Hi Shivanandan, you can just replace this "loader": { "orientdb": { "dbURL": "remote:localhost/databases/indb", "dbUser": "root", "dbPassword": "root", "dbAutoCreate": true, "tx": false, "batchCommit": 1, "dbType": "graph" } } with this "loader": { "orientdb":

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-19 Thread Shivanandan Gupta
Hi Luigi, Thanks for your response ,I am loading the csv file from the same server where orientdb is installed, I tried doing a plocal (create a DB as plocal ? ) can you please help me how to go with it? I am a newbei to orientdb. We are trying to have a data model as DWH like facts and dimen