Re: [Neo4j] LockClient can't wait on resource RWLock

2016-09-02 Thread 'Michael Hunger' via Neo4j
The reason is: for creating/deleting a relationship both end-nodes are locked and if you have one thread locking a, then trying b while another does b, then tries a, none can proceed and one of the transactions will be killed with a deadlock exception. Update to 3.0.4 recommended is to retry t

Re: [Neo4j] deletion of relationships got stuck

2016-08-30 Thread 'Michael Hunger' via Neo4j
Anything more about the history? Upgrades from previous versions? Since when are you getting these errors? Only now or also before? Which version is it? Michael On Tue, Aug 30, 2016 at 12:39 PM, Ray Chengr wrote: > Hi Michael, > Sorry, I copy-pasted wrong text in my last reply two minutes ag

Re: [Neo4j] deletion of relationships got stuck

2016-08-30 Thread 'Michael Hunger' via Neo4j
Can you tell me more about your use of Neo4j and the history of this store? Were there crashes, out of disk situations or hard kills? Or any other unusual incidents? Perhaps you can even share a compressed copy with us / our engineering so that we can do some forensics? To recover/repair, try my s

Re: [Neo4j] deletion of relationships got stuck

2016-08-28 Thread 'Michael Hunger' via Neo4j
Can you run a consistency check on your store? https://neo4j.com/developer/kb/how-do-i-run-consistency-check-manually/ Thx > Am 29.08.2016 um 00:02 schrieb Ray Chengr : > > On our Neo4j 3.0.3, I tried to delete relations

Re: [Neo4j] Does deleting nodes and relationships immediate cut down Neo4j disk usage size?

2016-08-28 Thread 'Michael Hunger' via Neo4j
> Am 28.08.2016 um 23:50 schrieb Ray Chengr : > > Hi Michael, > > (1) I didn't restart Neo4j 3.0.3 after I deleted about 3,000,000 > relationships last night. > > 'du' showed neostore.propertystore.db and neostore.propertystore.db.arrays > stay the same size after a whole night's Neo4j creati

Re: [Neo4j] Is it possible to merge two or more graph.db folders in Neo4j?

2016-08-28 Thread 'Michael Hunger' via Neo4j
Not out of the box. What you can do is to export the smaller databases, e.g. to Cypher script with the APOC procedure library, using CALL apoc.export.cypher.all("/tmp/export.cypher",{}); Then run the resulting file with neo4j-shell bin/

Re: [Neo4j] Does deleting nodes and relationships immediate cut down Neo4j disk usage size?

2016-08-28 Thread 'Michael Hunger' via Neo4j
If you restart after deletions the freed records will be reused. To compact your store you can use my store-utils tool: https://github.com/jexp/store-utils Cheers, Michael > Am 28.08.2016 um 09:48 schrieb Ray Chengr : > > We continue to add nodes and relat

Re: [Neo4j] Please help me writting query for this example.

2016-08-25 Thread 'Michael Hunger' via Neo4j
simple double match MATCH (p:Professor)<-[:STUDENT_OF]-(s:Student) WITH p, avg(s.grade) as grade MATCH (p:Professor)<-[:STUDENT_OF]-(s:Student) WHERE s.grade > grade RETURN p,collect(s) as students better collect + filter MATCH (p:Professor)<-[:STUDENT_OF]-(s:Student) WITH p, avg(s.grade) as gr

Re: [Neo4j] neo4j 3.0.1 [Full GC (Allocation Failure)

2016-08-25 Thread &#x27;Michael Hunger&#x27; via Neo4j
Sorry, it's a bug we fixed in 3.0.2 I think. Please upgrade to 3.0.4 then all of that should go away and you should be able to run your imports with 1-2G heap. Your page-cahe should be fine around 1-2G you can check your store-file sizes (neostore.*.db) Michael > Am 26.08.2016 um 00:24 schri

Re: [Neo4j] Multiple statements using the Neo4j java driver with the bolt protocol

2016-08-25 Thread &#x27;Michael Hunger&#x27; via Neo4j
Hi Davide, You can open one tx and then run multiple statements in that tx I think bolt packs stuff in the same fram of the open tcp connection Nigel will know more. Good luck with the update Michael Von meinem iPhone gesendet > Am 25.08.2016 um 12:51 schrieb Davide D'Alto : > > Hi, > I

Re: [Neo4j] Re: How to know the structure of node

2016-08-24 Thread &#x27;Michael Hunger&#x27; via Neo4j
, etc). > Also, please let me know, if it is possible to check in the browser. > > On Wednesday, August 24, 2016, 'Michael Hunger' via Neo4j > mailto:neo4j@googlegroups.com>> wrote: > > https://github.com/neo4j/neo4j/blob/2.3/community/kernel/src/main/java/o

Re: [Neo4j] Help in making the query more efficient

2016-08-24 Thread &#x27;Michael Hunger&#x27; via Neo4j
Can you share the current query plan that you get when you prefix your query with PROFILE Also the size and structure of your datastore and the output of :schema to list existing indexes and constraints. > Am 22.08.2016 um 21:28 schrieb Divya Saxena : > > Hi, > Can someone help me in making th

Re: [Neo4j] How to know the structure of node

2016-08-24 Thread &#x27;Michael Hunger&#x27; via Neo4j
https://github.com/neo4j/neo4j/blob/2.3/community/kernel/src/main/java/org/neo4j/kernel/impl/store/NodeStore.java#L183 > Am 24.08.2016 um 20:54 schrieb Sukaant Chaudhary > :

Re: [Neo4j] Why does latency from neo4j increases when Database size is in large ?

2016-08-22 Thread &#x27;Michael Hunger&#x27; via Neo4j
Please share the details of what you are running (workload, statements, query profiles). Michael On 8/22/16, gitanshu.be...@freecharge.com wrote: > My database has around 15 million nodes. > App server is hitting the database with 3000 parallel threads, earlier the > latency from database was in

Re: [Neo4j] Issue regarding different behaviours to two clients

2016-08-22 Thread &#x27;Michael Hunger&#x27; via Neo4j
I think the high concurrency is not helpful. As your servers will be mostly thread-switching. Can you detail more about the statements/workload that you run against Neo4j? Is your networks setup the same too? I.e. latency to server? If you have 30G RAM, you can use 16G for heap and 12G for page-

Re: [Neo4j] Re: Connection time out + Java + Spring rest graph database

2016-08-22 Thread &#x27;Michael Hunger&#x27; via Neo4j
The link I sent is using System properties to configure the SpringRestGraphDatabase. Perhaps there is something wrong with your network configuration? On 8/22/16, Ganesh Selvaraj wrote: > Thanks. > > I am already using 3.0 and Bolt. And the link you sent does not have a > setter, does it work st

Re: [Neo4j] case question

2016-08-22 Thread &#x27;Michael Hunger&#x27; via Neo4j
In general clauses are not supported within CASE only expressions. Fortunately you can rewrite your query USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM "file:///incident.csv" AS line MERGE (incident:Incident { id: TOINT(line.incidentId) }) SET incident.session = line.session, incident.allegati

Re: [Neo4j] Cypher results without repeated sub-paths

2016-08-20 Thread &#x27;Michael Hunger&#x27; via Neo4j
Jaroslav, you could use shortestPath or allShortestPaths right now you do an expand over everything. There is also an expandPath procedure in apoc that could be helpful for you: https://neo4j-contrib.github.io/neo4j-apoc-procedures/#_expand_paths Michael On Mon, Aug 8, 2016 at 12:59 PM, Alan R

Re: [Neo4j] I want a query which returns a subgraph...

2016-08-20 Thread &#x27;Michael Hunger&#x27; via Neo4j
Hey, sorry for the delay. You could use the allShortestPaths option too. And shortest paths actually take predicates into account that follow it in the where clause. I don't know how you got this query to run, because UNWIND is not a function but a clause: match path = shortestPath( (n)-[*]->(

Re: [Neo4j] Issue upgrading from Neo4j 2 to 3 using embedded Java API

2016-08-19 Thread &#x27;Michael Hunger&#x27; via Neo4j
t; Very strange ... > > Howard > > > On 8/19/16 4:13 PM, 'Michael Hunger' via Neo4j wrote: > > You have to iterate inside the or at least a transaction > > Von meinem iPhone gesendet > > Am 19.08.2016 um 20:25 schrieb Howard Lander : > > Hi all >

Re: [Neo4j] Issue upgrading from Neo4j 2 to 3 using embedded Java API

2016-08-19 Thread &#x27;Michael Hunger&#x27; via Neo4j
You have to iterate inside the or at least a transaction Von meinem iPhone gesendet > Am 19.08.2016 um 20:25 schrieb Howard Lander : > > Hi all > Hi all > > Thanks in advance for the attention and any suggestions. I hope my > explanation of the issue is clear enough. > > As noted in the subje

Re: [Neo4j] Connection time out + Java + Spring rest graph database

2016-08-18 Thread &#x27;Michael Hunger&#x27; via Neo4j
Upgrade to 3.0 then that query will be fast. Don't use SpringRestGraphDatabase. Use the offical driver to run cypher queries. You can set some config options for socket and connection timeouts as System properties. https://github.com/spring-projects/spring-data-neo4j/blob/3.4.x/spring-data-neo4j-

Re: [Neo4j] Which is the best way to Connect neo4j with java

2016-08-17 Thread &#x27;Michael Hunger&#x27; via Neo4j
-chaudhary/33/ba8/479> > > On Wed, Aug 17, 2016 at 3:29 PM, 'Michael Hunger' via Neo4j < > neo4j@googlegroups.com> wrote: > >> Not really sure what you mean. You can compose queries at runtime in your >> client and execute them in Neo4j. >> >>

Re: [Neo4j] Which is the best way to Connect neo4j with java

2016-08-17 Thread &#x27;Michael Hunger&#x27; via Neo4j
there any way to form the query at runtime in neo4j > (i.e. can we replace or add or remove nodes and relations at the runtime)? > > -Sukaant Chaudhary > <http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479> > > On Wed, Aug 17, 2016 at 12:36 AM, 'Michael Hunger

Re: [Neo4j] Which is the best way to Connect neo4j with java

2016-08-17 Thread &#x27;Michael Hunger&#x27; via Neo4j
What is your use-case, concurrency, application architecture, do you mostly do crud or complex queries? Von meinem iPhone gesendet > Am 17.08.2016 um 06:03 schrieb Sukaant Chaudhary > : > > Hi, > Please suggest the best way to connect neo4j with java for neo4j 2.3.6 and > 3.0.4 > I'm referrin

Re: [Neo4j] Getting nodes with maximum relationships in Neo4j

2016-08-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
Which Neo4j version do you use? In 2.3.+ you can use: MATCH (n) WITH n, size( (n)--() ) as degree RETURN n ORDER BY degree DESC LIMIT 100 On Wed, Aug 10, 2016 at 8:33 AM, wrote: > Hi all, > We have a graph database with 8 million nodes and 50 million > relationships. We need to find out nodes

Re: [Neo4j] Scale limits when storing properties on relationships

2016-08-14 Thread &#x27;Michael Hunger&#x27; via Neo4j
Hi John, Thanks a lot for the detailed feedback. GH issues is bugtracking on GitHub: https://github.com/neo4j/neo4j/issues Please report the NaN issues (which might be not so easy to resolve). And more importantly the need for disabling the transaction-log (which is actually the write-ahead-log

Re: [Neo4j] Scale limits when storing properties on relationships

2016-08-13 Thread &#x27;Michael Hunger&#x27; via Neo4j
Hi John, thanks a lot for reporting back. Would you mind creating a GH issue (if possible reproducible with a minimal test)? Do you get a clean shutdown (db.shutdown() for your program when creating the data? I haven't seen an error with that kind of property on recovery. Does the recovery erro

Re: [Neo4j] How to design a social database like Instagram

2016-08-09 Thread &#x27;Michael Hunger&#x27; via Neo4j
Yes sorry, I was on vacation so the publication lagged a bit. Let us know how it goes with the testing and if you need any help with the use-case queries. Michael On Tue, Aug 9, 2016 at 2:53 PM, <5785.a...@gmail.com> wrote: > Hi Michael, > thank you for your feedback about this pattern! > Since

Re: [Neo4j] Scale limits when storing properties on relationships

2016-08-09 Thread &#x27;Michael Hunger&#x27; via Neo4j
Oh sorry, I might have misunderstood you. Do you see the performance issue when creating the data or when accessing it? Could you share your graph-creation code? M On Tue, Aug 9, 2016 at 3:51 PM, John Fry wrote: > Hi Michael, thanks... > > some more background info on the queries: > * note I

Re: [Neo4j] How to design a social database like Instagram

2016-08-09 Thread &#x27;Michael Hunger&#x27; via Neo4j
I think your model looks quite good so far. One node per Media is totally fine. In general I presume you want to see in your stream the 20 latest media of users you follow. MATCH (me:User {id:{userid}})-[:FOLLOW]->(u:User)-[:POSTS]->()-[:NEXT*0..20]->(m:Media) RETURN u, collect(m) as medias Make

Re: [Neo4j] Java with Neo4j Error

2016-08-09 Thread &#x27;Michael Hunger&#x27; via Neo4j
You didn't provide auth information. I think the error message should be more informative. (Nigel) You can find more information here in the docs: http://neo4j.com/docs/developer-manual/current/drivers/#driver-driver Driver driver = GraphDatabase.driver( "bolt://localhost", AuthTokens.basic("neo

Re: [Neo4j] How can I export a graph as a PDF or other shareable image?

2016-08-09 Thread &#x27;Michael Hunger&#x27; via Neo4j
There is a little down-arrow on the top-right of the graph visualization which allows you to export as SVG and PNG. On Sat, Aug 6, 2016 at 6:44 PM, leam hall wrote: > Second newbie question of the day. :) > > I'm using the Neo4J browser and would like to send an image to a friend so > he can cr

Re: [Neo4j] why does the neo4j osx app require high performance graphics?

2016-08-09 Thread &#x27;Michael Hunger&#x27; via Neo4j
I think that's just an artifact. It doesn't really need any high-perf-graphics as it is a background-service database. Perhaps a setting that we can change in the installer which might just take the default for java apps which is not needed in our case. Michael On Sat, Aug 6, 2016 at 5:00 AM,

Re: [Neo4j] Newbie''s query fails to show Node properties.

2016-08-09 Thread &#x27;Michael Hunger&#x27; via Neo4j
Leam, did you run that whole statement in one go or in two parts? If you run it in two parts the "variable names" from the first query are no longer bound (as you run a new query). So it creates new nodes for those,e .g. `MarcoD`. If you run the whole statement in one go, the variables will stil

Re: [Neo4j] Scale limits when storing properties on relationships

2016-08-09 Thread &#x27;Michael Hunger&#x27; via Neo4j
Hi John, which kind of "transaction logging did you turn off" ? Would you be able to share the queries you are using? each double property takes 8 bytes of storage in the property-record (which are linked in a chain, each property-record can hold up to 4 4-byte-storage properties). But arrays a

Re: [Neo4j] Re: exception shutting down db after 200M property writes

2016-08-08 Thread &#x27;Michael Hunger&#x27; via Neo4j
Veesion 2.0.3 is very old and out of support Any chance that you could update to a recent version like 3.0.4? Also 2.0.3 doesn't have a page cache, so sth is off. I think this issue was fixed recently. >>> Caused by: java.lang.IllegalStateException: Cannot close the PageCache >>> while file

Re: [Neo4j] Scale limits when storing properties on relationships

2016-08-08 Thread &#x27;Michael Hunger&#x27; via Neo4j
Hi John, Do you have more details on the properties that you add as well as your graph model and queries? Without these details it will be hard to help. It sounds a bit as if your property heavy relationships might be nodes in hiding. Cheers Michael Von meinem iPhone gesendet > Am 08.08.20

Re: [Neo4j] Help with slow query

2016-08-04 Thread &#x27;Michael Hunger&#x27; via Neo4j
It just misses the rel before the colon >> MATCH (n:DataModel:CI__DataModel) WHERE n.name={name} >> OPTIONAL >> MATCH(n)-[rel:PARENT|:DISPLAYATTRIBUTE|:CREATEDBY|:APPLICATIONACCESS|:UPDATEDBY|:APPLICATION]->(related) >> >> WITH n, type(rel) as type, collect(related.__id__) as ids >> RETURN n a

Re: [Neo4j] Do Neo4j Data expires periodically

2016-08-04 Thread &#x27;Michael Hunger&#x27; via Neo4j
No. Perhaps you're looking at the wrong db. Or you had uncommitted transactions? Von meinem iPhone gesendet > Am 01.08.2016 um 08:38 schrieb gitanshu.be...@freecharge.com: > > Yesterday, in my graph db Node Id allocation was upto 5.5 million, and today > it is reduced to 4.8 million. > In my

Re: [Neo4j] Regarding to create user defined procedure on scala

2016-08-04 Thread &#x27;Michael Hunger&#x27; via Neo4j
Perhaps you can share your full code or equivalent example code. As the error message says, a procedure has to be either void or return a Java8 Stream. Michael On Tue, Aug 2, 2016 at 2:57 PM, Anurag Srivastava wrote: > I am using Scala Version "2.11.8" and trying to create user defined > proce

Re: [Neo4j] Aggregation function/cypher

2016-07-29 Thread &#x27;Michael Hunger&#x27; via Neo4j
Return x,count(*) as c Order by c desc Limit 1 Gives you the value of x that has the highest frequency Von meinem iPhone gesendet > Am 29.07.2016 um 21:03 schrieb Marwa Elabri : > > For example i have a vector of variable (00101) and i want to calculate the > mode of this vector > The occure

Re: [Neo4j] Why do neo4j implement a mmap-like file page manage strategy instead of just use mmap?

2016-07-28 Thread &#x27;Michael Hunger&#x27; via Neo4j
Operating systems don't do the best job on mmap as they have no information about page priorities and order of flushing. Also across the different OS esp on Windows the implementation of mmap differs a lot. Our implementation also us sympathetic to our storage structure, takes care of correc

Re: [Neo4j] Help with slow query

2016-07-24 Thread &#x27;Michael Hunger&#x27; via Neo4j
All your optional matches, what cardinality do they have? at most 1 or more? If it is > 1 you should reduce the cardinality in between, e.g. MATCH (n:DataModel:CI__DataModel) WHERE ( n.name='host' ) OPTIONAL MATCH(n)-[:PARENT]->(parentNode) WITH n, collect(DISTINCT parentNode.__id__) as parentIds

Re: [Neo4j] Help with slow query

2016-07-24 Thread &#x27;Michael Hunger&#x27; via Neo4j
Can you run it with PROFILE instead of EXPLAIN ? So that the actual costs are visible not just the estimated ones? Please also share your current indexes/constraints (run "schema") Michael On Fri, Jul 22, 2016 at 1:09 AM, Matias Burak wrote: > Hi all, > > Hi, I need some help with a slow query

Re: [Neo4j] Neo4J configuration having little effect

2016-07-24 Thread &#x27;Michael Hunger&#x27; via Neo4j
Hi Ben, nice machine. Sorry for the delay in answering Usually you don't need such gigantic heaps. 32G to 64G usually do fine. in neo4-wrapper.conf wrapper.java.initmemory=32000 wrapper.java.maxmemory=32000 in neo4j.properties For the pagecache settings (you only need this dbms.pagecache.memo

Re: [Neo4j] Load data fron local to neo4j

2016-07-24 Thread &#x27;Michael Hunger&#x27; via Neo4j
This should work: file:c:/path/to/data.csv The error message you see is unrelated to the URL. See: https://neo4j.com/developer/guide-import-csv/#_load_csv_for_medium_sized_datasets please note that from Neo4j 3.0 there is an import directory configured from which files are loaded (you can change

Re: [Neo4j] Nested maps/collections

2016-07-24 Thread &#x27;Michael Hunger&#x27; via Neo4j
They are supported within Cypher as datastructure / parameters / result types but not yet as storage properties On Tue, Jul 19, 2016 at 12:06 AM, Bryan Haakman wrote: > The reference card here says > that nested maps are supported. > However, in a CREA

Re: [Neo4j] Authentication in neo4j 3.0

2016-07-24 Thread &#x27;Michael Hunger&#x27; via Neo4j
Both is coming with 3.1 There is currently an unsupported way to add users: https://leanjavaengineering.wordpress.com/2015/04/16/neo4j-2-2-authentication-and-adding-extra-users/ On Fri, Jul 22, 2016 at 8:13 PM, Sachin Rodge wrote: > I am using neo4j 3.0 and would like to know > 1. how can I int

Re: [Neo4j] custom stored procedures

2016-07-21 Thread &#x27;Michael Hunger&#x27; via Neo4j
See apoc.periodic.commit in Periodic.java Von meinem iPhone gesendet > Am 20.07.2016 um 16:52 schrieb Clark Richey : > > Hi! When writing your own procedure I understand that the procedure lives in > the calling transaction. However, is there any way to perform periodic > commits in a store pr

Re: [Neo4j] Neo4J hardware - processor, ram

2016-07-16 Thread &#x27;Michael Hunger&#x27; via Neo4j
What's the expected size of your graph and concurrent user requests? Are those 10k writes / s batches or individual requests? For more concurrency more cores make more sense. And depending on your graph size more RAM. On Sat, Jul 16, 2016 at 9:55 AM, Niranjan U wrote: > I am buying my own hard

Re: [Neo4j] Re: Using Neo4j Community edition in commercial applications

2016-07-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
There is also a free startup / personal option for neo4j enterprise: https://neo4j.com/startup-program/ as well as an accomodating license for OSS projects. On Fri, Jul 15, 2016 at 9:38 PM, Dennis O wrote: > Hi Dave, > > *>> What decisions have you made about scalability? * > I started using G

Re: [Neo4j] Neo4j-Spark-Connector Example help

2016-07-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
Yes, sorry the compiled runtime was moved to Neo4j 3.1 so you'll have to remove this prefix: cypher runtime=compiled On Wed, Jul 13, 2016 at 8:32 PM, wrote: > I have been following the example from > https://neo4j.com/blog/neo4j-3-0-apache-spark-connector/ and everything > seemed fine until I tr

Re: [Neo4j] Getting an error when running

2016-07-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
You probably have an version issue, you would have to share your build-settings (e.g. pom.xml and mvn dependency:tree) And the code you use where the error happens. Michael On Thu, Jul 14, 2016 at 6:49 PM, Kevin Pham wrote: > I'm getting this error when I try to run, I'm not sure how to resol

Re: [Neo4j] Re: Installing Neo4J Community in Windows- Failed to Start

2016-07-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
Yes best delete the old directory or select a new one altogether. Adding the upgrade option should also work but then also between 2.x and 3.x all config options changed their names. On Thu, Jul 14, 2016 at 9:02 PM, Dave M wrote: > I'm new to neo4j and ran into this same problem under Windows 1

Re: [Neo4j] REST API

2016-07-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
Glad to hear that. Depends on your use-case If you don't need object graph mapping the java driver works well. Von meinem iPhone gesendet > Am 15.07.2016 um 15:42 schrieb 'Martin Prinz' via Neo4j > : > > Hi Michael, > > I have create a solution now with Cypher and it works really well. > W

Re: [Neo4j] REST API

2016-07-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
It has a cache for nodes and rels but changes should be reflected in it. Do you have a test? But I'd strongly suggest to move to a newer driver :) Von meinem iPhone gesendet > Am 15.07.2016 um 12:27 schrieb 'Martin Prinz' via Neo4j > : > > Hi all, > > I am facing the problem that I get old

Re: [Neo4j] BatchInserter-Intermediate cache to hold reference for domainID-Neoid

2016-07-12 Thread &#x27;Michael Hunger&#x27; via Neo4j
Sure it is part of neo4j, just check out the community/import-tool submodule here on GitHub: It uses some other parts of neo4j internally like the CSV reader and the parallel batch importer API On Tue, Jul 12, 2016 at 10:35 AM, Gane

Re: [Neo4j] Do incoming relationships have index-free adjacency?

2016-07-11 Thread &#x27;Michael Hunger&#x27; via Neo4j
Yes, what Clark said, nodes have index free adjacency for both incoming and outgoing relationships. So they are fast to traverse and even substructured per type and direction. On Sun, Jul 10, 2016 at 10:10 PM, Clark Richey wrote: > It doesn't make a difference which way you make the relationship

Re: [Neo4j] Re: BatchInserter-Intermediate cache to hold reference for domainID-Neoid

2016-07-10 Thread &#x27;Michael Hunger&#x27; via Neo4j
Perhaps you can share your code? I think it is rather the too low pagecache config Von meinem iPhone gesendet > Am 10.07.2016 um 12:32 schrieb Ganesh Selvaraj : > > Update<> - I tried with batchinsertIndexProvider with both lucene and also > mapDB(the same code from here > http://www.program

Re: [Neo4j] Neo4j Isochrones, All Nodes Reachable

2016-07-07 Thread &#x27;Michael Hunger&#x27; via Neo4j
Hi, 1. you should use a label + index or constraint to find your starting node 2. I'd change it to use shortest path perhaps, at least rewrite it a bit 3. do you have only one relationship-type ? // lookup via label + osm_id in index/constraint MATCH (S:Waypoint) WHERE S.osm_id="1683208894" MATC

Re: [Neo4j] Expired SSL at https://m2.neo4j.org/content/repositories/releases/

2016-07-07 Thread &#x27;Michael Hunger&#x27; via Neo4j
Thanks, should be fixed. On Thu, Jul 7, 2016 at 6:42 AM, Matthew Marple wrote: > Expired SSL at https://m2.neo4j.org/content/repositories/releases/ > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiv

Re: [Neo4j] how to connect mater-slave from different VMs

2016-07-06 Thread &#x27;Michael Hunger&#x27; via Neo4j
you need different entries for each of the instances for each of these settings (different port or different server id) dbms.backup.address=0.0.0.0:6362 dbms.connector.bolt.address=0.0.0.0:7687 dbms.connector.http.address=0.0.0.0:7474 dbms.connector.https.address=localhost:7473 ha.server_id=1 ha.h

Re: [Neo4j] LOAD CSV - Wanting to set property name, not value

2016-07-05 Thread &#x27;Michael Hunger&#x27; via Neo4j
Not directly but you can use SET a + {properties} where properties is a map And in 3.0 with procedures you can use APOC to both set named properties as well as create map-keys dynamically. e.g. https://github.com/neo4j-contrib/neo4j-apoc-procedures#map-functions https://github.com/neo4j-contrib/

Re: [Neo4j] Re: How to Integrated with Neo4j in C#

2016-07-05 Thread &#x27;Michael Hunger&#x27; via Neo4j
For visualization questions there is also a dedicated page on neo4j.com/developer/guide-data-visualization Also the example application here features a graph visualization. Or join neo4j.com/slack and ask there for concrete detail.

Re: [Neo4j] Re: How to Integrated with Neo4j in C#

2016-07-03 Thread &#x27;Michael Hunger&#x27; via Neo4j
see http://neo4j.com/developer/dotnet for more detail and check out the official dotnet driver for neo4j On Sat, Jul 2, 2016 at 8:35 AM, Siva Nainar wrote: > Hi Team, > > Any javascript available for Neo4j lable node select time the particular > node details show on like popup window... > > Awai

Re: [Neo4j] Re: Problems to add my unmanaged server extension

2016-07-03 Thread &#x27;Michael Hunger&#x27; via Neo4j
Oh and can you upgrade to 3.0.3 ? On Thu, Jun 30, 2016 at 12:23 PM, luca scipioni wrote: > Yes of course, the jar file is very simple, it is only an example file to > test an unmanaged extension. > > Il giorno giovedì 30 giugno 2016 11:23:19 UTC+2, Michael Hunger ha scritto: >> >> Hmm good ques

Re: [Neo4j] Create DataBase Neo4j with node js

2016-07-03 Thread &#x27;Michael Hunger&#x27; via Neo4j
You have to change your password first and then use that changed password On Thu, Jun 30, 2016 at 4:19 PM, Hamza REZGUI wrote: > up vote > down votefavorite > > > i have a problem to create a db neoj, this my code

Re: [Neo4j] Adding new properties to an existing map

2016-07-03 Thread &#x27;Michael Hunger&#x27; via Neo4j
You can do it with the apoc procedures There is eg apoc.map.setKey Von meinem iPhone gesendet > Am 29.06.2016 um 03:13 schrieb Jason Brumwell : > > I also would love this feature :) > >> On Tuesday, April 7, 2015 at 6:32:52 PM UTC-4, bi...@levelstory.com wrote: >> Yes, I thought about that but

Re: [Neo4j] Importing a large xml file to Neo4j with Py2neo

2016-07-01 Thread &#x27;Michael Hunger&#x27; via Neo4j
I think you should use a streaming parser, otherwise it might be even on the python side that you overflow on memory. Also I recommend doing transactions in Neo4j with batches of 10k to 100k updates per transaction. Don't store "NO " fields, just leave them off it is just a waste of space and

Re: [Neo4j] lucene index corruption

2016-06-30 Thread &#x27;Michael Hunger&#x27; via Neo4j
1. can you raise a GH issue, if possible with your db attached and the messages.log / neo4j.log log files 2. it should not get corrupted, one cause could be a broken file system or out of disk space 3. the schema indexes are implemented using lucene 4. not On Thu, Jun 30, 2016 at 12:43 AM, Vinee

Re: [Neo4j] Simulating Streaming Graph Databases with Neo4j

2016-06-30 Thread &#x27;Michael Hunger&#x27; via Neo4j
I'm not sure where you see that those are slow operations? Do you have an example? On Thu, Jun 30, 2016 at 3:23 AM, Mohammad Hossain Namaki < mhn.na...@gmail.com> wrote: > Hi, > I want to use Neo4j in a streaming graph database which by the time > nodes/edges are inserted/removed. > However, as

Re: [Neo4j] Community edition performance with more than 4 cores

2016-06-30 Thread &#x27;Michael Hunger&#x27; via Neo4j
dition "scales up to 4 cores"? Having more than 4 cores just doesn't help >>> to the community edition or it could actually yield a worse performance? >>> What about available memory? more is always expected to be better? >>> >>> Regards, >>

Re: [Neo4j] Re: Problems to add my unmanaged server extension

2016-06-30 Thread &#x27;Michael Hunger&#x27; via Neo4j
Hmm good question, can you share your jar and the config changes in neo4j.conf ? On Thu, Jun 30, 2016 at 10:29 AM, luca scipioni wrote: > Any suggestions? > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and st

Re: [Neo4j] Neo4j Community Memory Usage

2016-06-27 Thread &#x27;Michael Hunger&#x27; via Neo4j
can you share more about how you insert the data? queries / apis etc? Also your neo4j configuration? On Thu, Jun 23, 2016 at 10:41 PM, Marcus Baffa wrote: > Hi, > > I am working with Neo4j Community and my application is inserting > something like 10 nodes per second. It is working ok but the

Re: [Neo4j] Optimizing ShortestPath query for a better performances

2016-06-25 Thread &#x27;Michael Hunger&#x27; via Neo4j
On Sat, Jun 25, 2016 at 10:23 PM, idor wrote: > Hi Michael, > Thanks for replying. > > scale it out on a scluster. > > > It requiresNeo4j entreprise license isnt it? > It will require neo4j enterprise. Which license depends on your use-case and company. > > Why do you string-concatinate the di

Re: [Neo4j] Optimizing ShortestPath query for a better performances

2016-06-25 Thread &#x27;Michael Hunger&#x27; via Neo4j
Hi, for what you do shortest Path is not the right solution, as you don't wan the path between two nodes but the neighborhood of one node. Also having that many connections when you don't have the CPUs to process it doesn't make sense, scale it out on a scluster. Why do you string-concatinate th

Re: [Neo4j] Re: Data Insertion into Neo4j

2016-06-21 Thread &#x27;Michael Hunger&#x27; via Neo4j
cy of the information supplied through this service. > > Innoplexus Consulting Services Pvt. Ltd. accepts no responsibility or > liability for the contents of any other site, whether linked to this site or > not, or any consequences from your acting upon the contents of another site. > >

Re: [Neo4j] Neo4j 3.0.x not stable

2016-06-21 Thread &#x27;Michael Hunger&#x27; via Neo4j
It would be great if you could share more detail. Please share your machine specs, database, queries, log files, configuration and usage patterns with a more detailed description. Please note that the configuration options changed in 3.0 and if you ran Neo4j before you need to migrate them (there

Re: [Neo4j] Cluster on local machine

2016-06-21 Thread &#x27;Michael Hunger&#x27; via Neo4j
Can you share the config of the 3 servers (note that they need separate ports not just for HA but also for http/https/bolt). And the 3x logs/debug.log and logs/neo4j.log On Mon, Jun 20, 2016 at 1:45 PM, wrote: > Hi All, > > > I'm new to neo4j server, trying to make a cluster on local machine o

Re: [Neo4j] Re: Data Insertion into Neo4j

2016-06-21 Thread &#x27;Michael Hunger&#x27; via Neo4j
More detail please: 0. share your query & code 0. do you use labels 1. do you use real query parameters 2. do you have indexes / constraints for the keys you merge on 3. do you batch transactions On Tue, Jun 21, 2016 at 9:00 AM, Yayati Sule wrote: > Hi Michael, > I am reading records from mong

Re: [Neo4j] Problems to add my unmanaged server extension

2016-06-20 Thread &#x27;Michael Hunger&#x27; via Neo4j
can you check the logs in the logs directory for any error message? Als which instructions did you use for writing and deploying your extension? On Sun, Jun 19, 2016 at 7:14 PM, luca scipioni wrote: > Hi there, i tried to add an unmanaged server extension but when i start > the neo4j community

Re: [Neo4j] Neo4j is pretty slow when trying to create relationships between existing nodes with a large amount of data

2016-06-20 Thread &#x27;Michael Hunger&#x27; via Neo4j
Can you share your queries and the output of ":schema" ? You'd do he tx batching in python. You should also use params You could also do it like this (send in a list of 10k dicts as parameter rows) MERGE (log:Syslog {id:{log_id}) UNWIND {rows} as row CREATE (log)-[:CONTAINS]->(l:Line {logline:

Re: [Neo4j] Data Insertion into Neo4j

2016-06-20 Thread &#x27;Michael Hunger&#x27; via Neo4j
You should share what you have done so far otherwise no one can help you There are docs on the mongodb connector and data import on neo4j.com/developer Most likely you forgot to create some indexes/constraints Von meinem iPhone gesendet > Am 20.06.2016 um 10:10 schrieb yayati.s...@innoplexus.c

Re: [Neo4j] performance when deleting large numbers of nodes

2016-06-18 Thread &#x27;Michael Hunger&#x27; via Neo4j
Shouldn't be slow. Faster disk. Concurrent batches would help. Von meinem iPhone gesendet > Am 18.06.2016 um 22:29 schrieb John Fry : > > > Clark - this works. It is still slow. I guess multithreading may help > some > > > > Transaction tx = db.beginTx(); > > //try ( Tr

Re: [Neo4j] Null id on relationships

2016-06-18 Thread &#x27;Michael Hunger&#x27; via Neo4j
How do you access the ids? With id(r) in cypher or r.getId() in Java ? Von meinem iPhone gesendet > Am 18.06.2016 um 20:25 schrieb John Fry : > > Hello All, > > what could be the cause of having relationships in a *.db with the id set as > null? > > When I crate the relationship, via the batc

Re: [Neo4j] Neo4j and Alteryx Connection

2016-06-17 Thread &#x27;Michael Hunger&#x27; via Neo4j
No idea what Alteryx ist. Von meinem iPhone gesendet > Am 17.06.2016 um 11:11 schrieb Sanjana Senthil : > > Hi, > > I am new to Alteryx. Can we connect neo4j database and alteryx? Is > there any solution? > > Thanks, > Sanjana > -- > You received this message because you are subscribe

Re: [Neo4j] Re: creating multiple properties on a node using batch inserter

2016-06-16 Thread &#x27;Michael Hunger&#x27; via Neo4j
Yes, that's totally doable On Thu, Jun 16, 2016 at 10:03 PM, John Fry wrote: > I see - thanks Michael. > According to the docs i should be able to do this a mix object that are > strings or arrays of strings. Does this seem safe/reasonable? > > String[] aka = new String[nd.akaNames.size()]; > >

Re: [Neo4j] Re: creating multiple properties on a node using batch inserter

2016-06-16 Thread &#x27;Michael Hunger&#x27; via Neo4j
setNodeProperties overrides all properties so the map you use there has to contain all the properties you want to have on your node On Thu, Jun 16, 2016 at 9:21 PM, John Fry wrote: > > here is what cypher returns > > START a=node(4238335) > > > return keys(a); > > +-+ > > | keys(a) | >

Re: [Neo4j] neo4j Github patch

2016-06-16 Thread &#x27;Michael Hunger&#x27; via Neo4j
Please read up on GitHub pull requests and our contribution policy: http://neo4j.com/developer/contributing You have to fork to your own repository first and push the changes there. Then create a Pull Request from your repo. Michael On Thu, Jun 16, 2016 at 7:41 AM, Häkelmeister wrote: > Hi :)

Re: [Neo4j] Community edition performance with more than 4 cores

2016-06-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
than 4 cores just doesn't help to the community edition > or it could actually yield a worse performance? What about available memory? > more is always expected to be better? > > Regards, > > >> On Wed, Jun 15, 2016 at 9:51 PM, 'Michael Hunger' via Neo4j

Re: [Neo4j] Neo4j is pretty slow when trying to create relationships between existing nodes with a large amount of data

2016-06-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
*You have to share more detail of what you're doing.* Make sure to have an index / constraint on the label + property you are matching / merging. it also makes sense if you are import larger amounts to batch updates, into eg. 1k to 10k blocks. On Tue, Jun 14, 2016 at 8:23 PM, Praveen T wrote

Re: [Neo4j] method findNodes in GraphDatabaseService throws MultipleFoundException

2016-06-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
You have to create a lock to make that an exclusive operation. Best with cypher's MERGE and a unique constraint which take care of creating that index lock for you: create constraint on t:Top assert t.id is unique; MERGE (t:Top {id:123}) RETURN t; On Wed, Jun 15, 2016 at 12:27 AM, David Starkw

Re: [Neo4j] Community edition performance with more than 4 cores

2016-06-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
You can provide the number of processors to the import tool. I presume it's mostly your disk performance. The import tool is unrelated to the enterprise core scalability. On Tue, Jun 14, 2016 at 10:38 PM, Santiago Videla wrote: > Hi, > > I'm using Neo 3.0.2 community edition and running the

Re: [Neo4j] Collapse sequential items in cypher

2016-06-15 Thread &#x27;Michael Hunger&#x27; via Neo4j
You're almost there. Match (a:Action) with a.type as type, a order by a.date return type, collect(a)[0..20] as actions On Tue, Jun 14, 2016 at 10:00 PM, S Ben wrote: > So here's the deal, I'm using Neo4J 3.01 and I have a graph with nodes of > type Action which have amongst other links and pr

Re: [Neo4j] Time based data query with Neo4J showing more relations than expected

2016-06-13 Thread &#x27;Michael Hunger&#x27; via Neo4j
But you connected domain6 to domain3 not sure what your question is, the time tree and the domains live all in the same graph MERGE (d:Domain {name:'domain3.com'}) MERGE (z:Domain {name:'domain6.com'}) ... MERGE (d)-[:REFERRED_BY]->(z) On Sat, Jun 11, 2016 at 2:59 PM, 'Dorian C' via Neo4j < neo

Re: [Neo4j] Can't change the database in the Neo4j browser

2016-06-13 Thread &#x27;Michael Hunger&#x27; via Neo4j
If you downloaded the installer, the config file can be found at the options pane. Michael On Thu, Jun 9, 2016 at 11:01 PM, wrote: > Hi, > > I'm very new to Neo4j, just downloaded it today. I downloaded Neo4j 3.0.2 > I have a couple of databases created via the Java APIs. I cant find the > prop

Re: [Neo4j] Potential Bug : Double/Float performance issues

2016-06-08 Thread &#x27;Michael Hunger&#x27; via Neo4j
Can you raise a GitHub issue for this? On Wed, Jun 8, 2016 at 12:23 PM, Kamilos wrote: > Hello, > > I found something which is very strange. > > I have a graph with 100 000 nodes where a node has a property "age". > > If i want to update the property "age" of 50 nodes with the Java API > > Node

Re: [Neo4j] neo4j get Node object

2016-06-07 Thread &#x27;Michael Hunger&#x27; via Neo4j
In a server extension you can, in 3.0 there are also nodes in procedures and the binary protocol drivers. why are you asking? On Wed, Jun 8, 2016 at 12:08 AM, Eric Fulton wrote: > I'm using neo4j 2.3.3 server. Is there anyway to get a Node object? > > -- > You received this message because yo

Re: [Neo4j] Neo4j 3.0 perofrmance question

2016-06-07 Thread &#x27;Michael Hunger&#x27; via Neo4j
Can you share the query plan? by prefixing your query with PROFILE ? Without knowing the domain model and looking at the database it's hard to predict which optimization will help. You have to reduce the cardinality of the work in progress, so something like this. It could also be that you can mat

<    1   2   3   4   5   6   7   >