Re: [Neo4j] Unable to upgrade 2.1.6 database to 2.2.0-RC1

2015-03-12 Thread Bill Scheidel
Thanks! I haven't been able to do any real testing against 2.2 yet due to the couple of issues I've hit. Any way I could get a new build prior to the GA release? Sent from my iPhone On Mar 12, 2015, at 7:09 AM, Mattias Persson mailto:matt...@neotechnology.com>> wrote: Hi, I've found and fixed

[Neo4j] Getting incorrect results with Neo4j 2.1.5 regex matching using Cypher

2014-10-26 Thread Bill Scheidel
I'm trying to use the Neo4j 2.1.5 regex matching in Cypher and running into problems. I need to implement a full text search on specific fields that a user has access to. The access requirement is key and is what prevents me from just dumping everything into a Lucene instance and querying that

Re: [Neo4j] Re: Using Neo4j 2.1.2 database with Neo4j 2.1.3 fails to start

2014-08-07 Thread Bill Scheidel
t;> More info is in the online docs here: >> >> http://docs.neo4j.org/chunked/stable/deployment-upgrading.html >> >> Hope this helps >> dave fauth >> >> On Wednesday, August 6, 2014 9:11:03 PM UTC-4, Bill Scheidel wrote: >>> >>> Hi Mic

Re: [Neo4j] Re: Using Neo4j 2.1.2 database with Neo4j 2.1.3 fails to start

2014-08-06 Thread Bill Scheidel
Bill, > > could you share your full messages.log file? And please keep the db around. > Can you work around by using 2.1.2 on your server while we look at the > issue? > > Thanks so much. > > > On Wed, Aug 6, 2014 at 9:27 PM, Bill Scheidel > wrote: > >> Just n

[Neo4j] Re: Using Neo4j 2.1.2 database with Neo4j 2.1.3 fails to start

2014-08-06 Thread Bill Scheidel
is version 'NeoStore v0.A.3'. 2014-08-06 19:13:13.104+ INFO [o.n.k.EmbeddedGraphDatabase]: Shutdown started On Wednesday, August 6, 2014 11:23:23 AM UTC-7, Bill Scheidel wrote: > > I'm trying to copy over a database that I've been using with Neo4j 2.1.2 > to a

[Neo4j] Using Neo4j 2.1.2 database with Neo4j 2.1.3 fails to start

2014-08-06 Thread Bill Scheidel
I'm trying to copy over a database that I've been using with Neo4j 2.1.2 to a new machine that is running Neo4j 2.1.3. I shut down my 2.1.2 server and made sure it was a clean shutdown. I then copied over the graph.db directory to my new server and chown'd the files to the neo4j user. However

[Neo4j] Re: Neo4j 2.1.2: Cannot match on a pattern containing only bound identifiers

2014-06-26 Thread Bill Scheidel
Looks like you just need to remove the MATCH statement now. WHERE can immediately follow WITH. On Thursday, June 26, 2014 5:11:43 PM UTC-7, Bill Scheidel wrote: > > I recently upgraded from Neo4j 2.0.1 and immediately hit this new error: > > > {Code:"Neo.ClientError.Sta

[Neo4j] Re: Cannot run simple query on graph. Any help?

2014-06-26 Thread Bill Scheidel
match (c: Client)-[WORKS_FOR]->(co: Company) return c, co limit 10 This query is doing a full graph lookup and capturing 100's of millions of results and then only returning 10 of them. This will never return with Neo4j. You need to pick a starting point in your graph and start executing quer

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

2014-06-26 Thread Bill Scheidel
I ran into this same problem trying to upgrade from 2.0.1 to 2.1.2. On Tuesday, June 24, 2014 1:52:46 AM UTC-7, Denys Hryvastov wrote: > > Ok, > > After having an email thread with neo4j support team (thanks them for > quick and full responses for all my questions) I have decided to use > neo4

[Neo4j] Neo4j 2.1.2: Cannot match on a pattern containing only bound identifiers

2014-06-26 Thread Bill Scheidel
I recently upgraded from Neo4j 2.0.1 and immediately hit this new error: {Code:"Neo.ClientError.Statement.InvalidSyntax", Message:"Cannot match on a pattern containing only already bound identifiers (line 26, column 3)\n\" MATCH (m)\"\n ^"}, I didn't see this new incompatibility in the rel

[Neo4j] Optimizing queries with lots of optional matches

2014-05-18 Thread Bill Scheidel
I've set up a Graph gist at http://gist.neo4j.org/?9494429e3cbbbeda2b11 which is one example of the types of queries I'm trying to do. I have lots of queries where I want to collect information from related nodes, where the relationships are optional. Even with small databases (10's of thousan

Re: [Neo4j] Re: Slow create performance running Neo4j 2.0.0 inside a VM

2014-01-16 Thread Bill Scheidel
t; >> https://github.com/jexp/neo4j-in-memory-server >> >> Cheers >> >> Michael >> >> Am 17.01.2014 um 02:52 schrieb Michael Hunger < >> michael...@neopersistence.com >: >> >> Good question, not sure about that. >> >> Indexi

Re: [Neo4j] Re: Slow create performance running Neo4j 2.0.0 inside a VM

2014-01-16 Thread Bill Scheidel
So during your tx whenever things are changed / created that correspond to > the configured auto-indexing properties they are written to the index. > > Michael > > Am 17.01.2014 um 02:35 schrieb Bill Scheidel > >: > > Hmm... turning off node_auto_indexing drops it from 150m

Re: [Neo4j] Re: Slow create performance running Neo4j 2.0.0 inside a VM

2014-01-16 Thread Bill Scheidel
Hmm... turning off node_auto_indexing drops it from 150ms to 40ms. Why would auto indexing block a request? On Thursday, January 16, 2014 5:07:48 PM UTC-8, Bill Scheidel wrote: > > My hdparm results are 118 MB/sec which isn't horrible, but it seems like > disk latency is the o

Re: [Neo4j] Re: Slow create performance running Neo4j 2.0.0 inside a VM

2014-01-16 Thread Bill Scheidel
RAM, using Neo4j stock settings. > > Wes > > On Thu, Jan 16, 2014 at 7:08 PM, Bill Scheidel > > wrote: > >> Yeah, definitely not great. Odd though since I never had a problem when >> working with Postgres or Mongo and they force things to disk as well. >> N

Re: [Neo4j] Re: Slow create performance running Neo4j 2.0.0 inside a VM

2014-01-16 Thread Bill Scheidel
t; 11 requests completed in 10.2 s, 32.1 k iops, 125.3 mb/s > min/avg/max/mdev = 21 us / 31 us / 50 us / 7 us > > w ab > 29 requests completed in 29.0 s, 33.1 k iops, 129.3 mb/s > min/avg/max/mdev = 20 us / 30 us / 109 us / 17 us > > Am 17.01.2014 um 00:54 schrieb Bill Sc

[Neo4j] Re: Slow create performance running Neo4j 2.0.0 inside a VM

2014-01-16 Thread Bill Scheidel
And this is ioping without the ab test running: 31 requests completed in 30.5 s, 3.2 k iops, 12.5 mb/s min/avg/max/mdev = 190 us / 312 us / 477 us / 63 us On Thursday, January 16, 2014 3:51:32 PM UTC-8, Bill Scheidel wrote: > > I ran vmstat while running the ab test: > > procs -

[Neo4j] Re: Slow create performance running Neo4j 2.0.0 inside a VM

2014-01-16 Thread Bill Scheidel
I ran vmstat while running the ab test: procs ---memory-- ---swap-- -io -system-- cpu r b swpd free buff cache si sobibo in cs us sy id wa 0 1 0 2429284 161572 2133284002275 98 354 9 8 80 2 I also ran ioping

[Neo4j] Slow create performance running Neo4j 2.0.0 inside a VM

2014-01-15 Thread Bill Scheidel
I posted this on StackOverflow but thought I would put here as well in case anybody has any ideas. Creating 2 nodes and one relationship in an empty database is taking 150ms to 170ms. This is making it really hard to run unit tests efficiently so I'm looking for any suggestions to speed things