[Neo4j] HTTP Status Codes and Errors

2014-06-17 Thread Hadi Hariri
Hi, When using the transactional endpoint, when an error occurs, such as for instance a unique constraint violation, the status code returned is still 200. Is this by design? Is the preferred method to always have to examine errors property in body to make sure it's empty to guarantee success?

Re: [Neo4j] HTTP Status Codes and Errors

2014-06-17 Thread Michael Hunger
Yes it is, as the results are streamed, the headers are already sent out immediately before query execution happens. Also as you can send many queries, the error contains more information on which (the last) query it happened. There is an error field in the response. Not sure how much effort

Re: [Neo4j] Re: dijkstra bidirectional

2014-06-17 Thread Mattias Persson
Sorry for not replying but time is a scarse resource :( I don't expect my getting time for this the closest months. Perhaps there are others willing to help out! Take care Best, Mattias Den 10 jun 2014 12:06 skrev Antonio Grimaldi antonio.grimaldim...@gmail.com: Is*

[Neo4j] Re: Neo4j database ALWAYS shuts down incorrectly if start/stop as a service from a list of windows services

2014-06-17 Thread Denys Hryvastov
Here is a stack trace that I get when I try to do upgrade from 1.9.5 to 2.0: 2014-06-17 09:48:27.319+ INFO [API] Setting startup timeout to: 12ms based on -1 Detected incorrectly shut down database, performing recovery.. 2014-06-17 09:48:28.108+ DEBUG [API]

[Neo4j] Upgrading neo4j 1.9.3 to 2.0.3 fails with Invalid log format version found, expected 3 but was 2

2014-06-17 Thread Mamta Thakur
Hi, I have been trying to upgrade neo4j from 1.9.3 to 2.0.3. SDN from 2.3.1.RELEASE to 3.1.0.RELEASE. Followed the steps listed @ http://docs.neo4j.org/chunked/stable/deployment-upgrading.html#explicit-upgrade I try bringing up the server with the upgrade configuration.There are a few new

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-17 Thread Michael Hunger
if they don't have a value for city id, do they then have empty columns there still? like user-id,, You probably want to filter these rows? LOAD CSV WITH HEADERS FROM file:/Users/pauld/Documents/LOCATED_IN.csv AS c WHERE coalesce(c.CitiId,) ... Am 17.06.2014 um 11:23 schrieb Paul Damian

Re: [Neo4j] Hierarchical facets

2014-06-17 Thread Tom Zeppenfeldt
Hi Michael, have you been able to look at the profiling info that I sent you ? Perhaps we can have a chat on it tomorrow in Amsterdam .. Best, Tom Met vriendelijke groet / With kind regards Ir. T. Zeppenfeldt van der Waalsstraat 30 6706 JR Wageningen The Netherlands Mobile: +31 6 23 28

Re: [Neo4j] 'Using Periodic Commit' throws a invalid syntax exception

2014-06-17 Thread ducky
oh, that was a really useful command when updating large datasets. +1 for this feature please. On Tuesday, 17 June 2014 14:08:08 UTC+1, Michael Hunger wrote: Sorry, that feature was removed between M06 and 2.1.0 :( So what you have to do is to run this repeatedly: MATCH (a) LIMIT 1

Re: [Neo4j] Upgrading neo4j 1.9.3 to 2.0.3 fails with Invalid log format version found, expected 3 but was 2

2014-06-17 Thread Michael Hunger
Btw. just got the info that it is fixed and will be part of 2.0.4 https://github.com/neo4j/neo4j/commit/37371aa (Thanks Jake!) Michael Am 17.06.2014 um 14:55 schrieb Michael Hunger michael.hun...@neotechnology.com: This is a know issue which is currently worked on, can you delete the

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-17 Thread Paul Damian
in the file I only have 2 columns, one for client id, which is always not null and CityId, which may be sometimes null. Should I export the records from SQL database leaving out the columns that contain null values? marți, 17 iunie 2014, 15:39:14 UTC+3, Michael Hunger a scris: if they don't

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-17 Thread Michael Hunger
No you can just filter out the lines with no cityid Did you run my suggested commands? LOAD CSV WITH HEADERS FROM file:/Users/pauld/Documents/LOCATED_IN.csv AS c MATCH (client: Client { Id: toInt(c.Id)}) RETURN count(*) LOAD CSV WITH HEADERS FROM file:/Users/pauld/Documents/LOCATED_IN.csv

Re: [Neo4j] Upgrading neo4j 1.9.3 to 2.0.3 fails with Invalid log format version found, expected 3 but was 2

2014-06-17 Thread Mamta Thakur
Hi Michael, Does that mean I will loose the existing index as well? How would any of my queries work? I fixed some of the @RelationshipEntity that did not have an @GraphId required with 2.0.3. Now I don't get this error on start up rather I get this error when shutting down the server.

Re: [Neo4j] Upgrading neo4j 1.9.3 to 2.0.3 fails with Invalid log format version found, expected 3 but was 2

2014-06-17 Thread Michael Hunger
No, as you have a clean shutdown all the data is in the store. Sent from mobile device Am 17.06.2014 um 16:55 schrieb Mamta Thakur ghazal.ma...@gmail.com: Hi Michael, Does that mean I will loose the existing index as well? How would any of my queries work? I fixed some of the

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-17 Thread Paul Damian
The first query returns 96 which is the number of rows in the file and the second one returns Neo.DatabaseError.Statement.ExecutionFailure probably because of the null values. But then I run the following command: LOAD CSV WITH HEADERS FROM file:/Users/pauld/Documents/LOCATED_IN.csv AS c

[Neo4j] Large scale network analysis - best strategy?

2014-06-17 Thread Shongololo
I am preparing a Neo4j database on which I would like to do some network analysis. It is a representation of a weakly connected and static physical system, and will have in the region of 50 million nodes where, lets say, about 50 nodes will connect to a parent node, which in turn is linked

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-17 Thread Michael Hunger
Ok, cool and you have the indexes for both :City(Id) and :Client(Id) ? Michael Am 17.06.2014 um 18:15 schrieb Paul Damian pauldamia...@gmail.com: The first query returns 96 which is the number of rows in the file and the second one returns Neo.DatabaseError.Statement.ExecutionFailure

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-17 Thread Paul Damian
Yes, I do. I keep getting Java heap space error now. I'm using 100 commit size. marți, 17 iunie 2014, 19:28:05 UTC+3, Michael Hunger a scris: Ok, cool and you have the indexes for both :City(Id) and :Client(Id) ? Michael Am 17.06.2014 um 18:15 schrieb Paul Damian paulda...@gmail.com

[Neo4j] Re: Neo4j database ALWAYS shuts down incorrectly if start/stop as a service from a list of windows services

2014-06-17 Thread Jim Salmons
Hi Denys, I think you're experience is a variation of mine as related here https://groups.google.com/d/msg/neo4j/Qp2azbKy2_8/u4jDbiBLlesJ. Seems to be a long-standing issue that hasn't bitten too many but is problematic for the 2.1 database migration. There are some tips/insight on the link.

Re: [Neo4j] Large scale network analysis - best strategy?

2014-06-17 Thread Nigel Small
Hi Gareth As you identify, there are certainly some differences in terms of performance and feature set that you get when working with Neo4j under different programming languages. Depending on your background, constraints and integration needs, you could consider a hybrid approach whereby you

[Neo4j] Re: Upgrading neo4j 1.9.3 to 2.0.3 fails with Invalid log format version found, expected 3 but was 2

2014-06-17 Thread sunyulovetech
I also encountered this problem.My solution is that: 1.put the data import single neo4j.(one instance) 2.update some data(any one can) 3.start the ha cluster. Note: First startup the neo4j instance that import the data 在 2014年6月17日星期二UTC+8下午3时59分32秒,Mamta Thakur写道: Hi, I have been