'<' expected but 'n' found during Cypher query

[klauern]

I am on Koan 8 and am having some weirdness running the @test shouldFindEpisodesWhereTennantAndRoseBattleTheDaleks. I've tried this both in Eclipse as well as running a neo4j-community-1.4.2 shell. I have a Mac OX 10.6:

klauer@klauer-imac ~/Programming/Java
$ ./neo4j-community-1.4.2/bin/neo4j-shell -path /var/folders/J6/J67--MxKGjejtyI966Nft++++TI/-Tmp-/neo4j-koans1097860323379298061dir
NOTE: Local Neo4j graph database service at '/var/folders/J6/J67--MxKGjejtyI966Nft++++TI/-Tmp-/neo4j-koans1097860323379298061dir'
Welcome to the Neo4j Shell! Enter 'help' for a list of commands

Welcome to the Neo4j Shell! Enter 'help' for a list of commands

neo4j-sh (0)$ start daleks = node:Species( species = 'Daleks'), rose = node:Character(character = 'Rose Tyler'), tennant = node:actors(actor = 'David Tennant') match (daleks)-[:APPEARED_IN]->(ep), (rose)-[:APPEARED_IN]->(ep), (tennant)-[:APPEARED_IN]->(ep) return ep 
org.neo4j.cypher.SyntaxException: `<' expected but `n' found

[peterneubauer]

HI there,
you need to run this against the latest 1.5-SNAPSHOT, as the cypher
syntax has changed since 1.4.2. Could you try with that, downloading
it from neo4j.org/download?

/peter

On Mon, Oct 31, 2011 at 8:30 PM, Nick Klauer
reply@reply.github.com
wrote:

I am on Koan 8 and am having some weirdness running the @test shouldFindEpisodesWhereTennantAndRoseBattleTheDaleks.  I've tried this both in Eclipse as well as running a neo4j-community-1.4.2 shell.  I have a Mac OX 10.6:

klauer@klauer-imac ~/Programming/Java
$ ./neo4j-community-1.4.2/bin/neo4j-shell -path /var/folders/J6/J67--MxKGjejtyI966Nft++++TI/-Tmp-/neo4j-koans1097860323379298061dir
NOTE: Local Neo4j graph database service at '/var/folders/J6/J67--MxKGjejtyI966Nft++++TI/-Tmp-/neo4j-koans1097860323379298061dir'
Welcome to the Neo4j Shell! Enter 'help' for a list of commands

Welcome to the Neo4j Shell! Enter 'help' for a list of commands

neo4j-sh (0)$ start daleks = node:Species( species = 'Daleks'), rose = node:Character(character = 'Rose Tyler'), tennant = node:actors(actor = 'David Tennant') match (daleks)-[:APPEARED_IN]->(ep), (rose)-[:APPEARED_IN]->(ep), (tennant)-[:APPEARED_IN]->(ep) return ep
org.neo4j.cypher.SyntaxException: `<' expected but `n' found

Reply to this email directly or view it on GitHub:
#10

[klauern]

Okay, so it took a bit of finagling around, but I did get it to work. I got this initially when running it:

klauer@klauer-imac ~/Programming/Java
$ ./neo4j-community-1.5.M02/bin/neo4j-shell -path /var/folders/J6/J67--MxKGjejtyI966Nft++++TI/-Tmp-/neo4j-koans1097860323379298061dir -v
ERROR (-v for expanded information):
    Could not create data source [nioneodb], see nested exception for cause of error
org.neo4j.graphdb.TransactionFailureException: Could not create data source [nioneodb], see nested exception for cause of error
    at org.neo4j.kernel.impl.transaction.TxModule.registerDataSource(TxModule.java:153)
    at org.neo4j.kernel.GraphDbInstance.start(GraphDbInstance.java:112)
    at org.neo4j.kernel.EmbeddedGraphDbImpl.<init>(EmbeddedGraphDbImpl.java:190)
    at org.neo4j.kernel.EmbeddedGraphDatabase.<init>(EmbeddedGraphDatabase.java:80)
    at org.neo4j.shell.kernel.GraphDatabaseShellServer.instantiateGraphDb(GraphDatabaseShellServer.java:85)
    at org.neo4j.shell.kernel.GraphDatabaseShellServer.<init>(GraphDatabaseShellServer.java:57)
    at org.neo4j.shell.StartClient.tryStartLocalServerAndClient(StartClient.java:285)
    at org.neo4j.shell.StartClient.startLocal(StartClient.java:218)
    at org.neo4j.shell.StartClient.start(StartClient.java:158)
    at org.neo4j.shell.StartClient.main(StartClient.java:107)
Caused by: org.neo4j.kernel.impl.storemigration.UpgradeNotAllowedByConfigurationException: To enable automatic upgrade, please set configuration parameter "allow_store_upgrade=true"
    at org.neo4j.kernel.impl.storemigration.ConfigMapUpgradeConfiguration.checkConfigurationAllowsAutomaticUpgrade(ConfigMapUpgradeConfiguration.java:41)
    at org.neo4j.kernel.impl.storemigration.StoreUpgrader.attemptUpgrade(StoreUpgrader.java:50)
    at org.neo4j.kernel.impl.nioneo.store.NeoStore.tryToUpgradeStores(NeoStore.java:131)
    at org.neo4j.kernel.impl.nioneo.store.NeoStore.checkVersion(NeoStore.java:98)
    at org.neo4j.kernel.impl.nioneo.store.CommonAbstractStore.<init>(CommonAbstractStore.java:103)
    at org.neo4j.kernel.impl.nioneo.store.AbstractStore.<init>(AbstractStore.java:120)
    at org.neo4j.kernel.impl.nioneo.store.NeoStore.<init>(NeoStore.java:72)
    at org.neo4j.kernel.impl.nioneo.xa.NeoStoreXaDataSource.<init>(NeoStoreXaDataSource.java:137)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at org.neo4j.kernel.impl.transaction.XaDataSourceManager.create(XaDataSourceManager.java:75)
    at org.neo4j.kernel.impl.transaction.TxModule.registerDataSource(TxModule.java:147)
    ... 9 more

Then created a simple neo4j.config file with allow_store_upgrade=true in it. Then re-ran it:

klauer@klauer-imac ~/Programming/Java
$ ./neo4j-community-1.5.M02/bin/neo4j-shell -path /var/folders/J6/J67--MxKGjejtyI966Nft++++TI/-Tmp-/neo4j-koans1097860323379298061dir -config ./neo4j.config 
Starting upgrade of database store files
Oct 31, 2011 10:45:42 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor started
INFO: Starting upgrade of database store files
..........Oct 31, 2011 10:45:42 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 10% complete
..........Oct 31, 2011 10:45:42 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 20% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 30% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 40% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 50% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 60% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 70% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 80% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 90% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 100% complete

Finished upgrade of database store files
Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor finished
INFO: Finished upgrade of database store files
NOTE: Local Neo4j graph database service at '/var/folders/J6/J67--MxKGjejtyI966Nft++++TI/-Tmp-/neo4j-koans1097860323379298061dir'
Welcome to the Neo4j Shell! Enter 'help' for a list of commands

Welcome to the Neo4j Shell! Enter 'help' for a list of commands

neo4j-sh (0)$ start daleks = node:Species(species = 'Dalek') match (daleks)-[:APPEARED_IN]->(ep) return ep
+-------------------------------------------------------------+
| ep                                                          |
+-------------------------------------------------------------+
| Node[900]{episode->212,title->"The Pandorica Opens"}        |
| Node[888]{episode->206,title->"Victory of the Daleks"}      |
| Node[878]{episode->198,title->"Journey's End"}              |
| Node[877]{episode->198,title->"The Stolen Earth"}           |
| Node[851]{episode->182,title->"Evolution of the Daleks"}    |
| Node[850]{episode->182,title->"Daleks in Manhattan"}        |
| Node[843]{episode->177,title->"Doomsday"}                   |
| Node[842]{episode->177,title->"Army of Ghosts"}             |
| Node[825]{episode->166,title->"The Parting of the Ways"}    |
| Node[824]{episode->166,title->"Bad Wolf"}                   |
| Node[817]{episode->161,title->"Dalek"}                      |
| Node[800]{episode->148,title->"Remembrance of the Daleks"}  |
| Node[788]{episode->142,title->"Revelation of the Daleks"}   |
| Node[775]{title->"Resurrection of the Daleks",episode->133} |
| Node[768]{episode->129,title->"The Five Doctors"}           |
| Node[731]{episode->104,title->"Destiny of the Daleks"}      |
| Node[686]{episode->78,title->"Genesis of the Daleks"}       |
| Node[679]{episode->72,title->"Death to the Daleks"}         |
| Node[674]{episode->68,title->"Planet of the Daleks"}        |
| Node[673]{episode->67,title->"Frontier in Space"}           |
| Node[665]{episode->60,title->"Day of the Daleks"}           |
| Node[653]{episode->50,title->"The War Games"}               |
| Node[634]{episode->36,title->"The Evil of the Daleks"}      |
| Node[626]{episode->30,title->"The Power of the Daleks"}     |
| Node[615]{episode->21,title->"The Daleks' Master Plan"}     |
| Node[609]{episode->16,title->"The Chase"}                   |
| Node[608]{episode->15,title->"The Space Museum"}            |
| Node[603]{title->"The Dalek Invasion of Earth",episode->10} |
| Node[590]{episode->2,title->"The Daleks"}                   |
+-------------------------------------------------------------+
29 rows, 381 ms
neo4j-sh (0)$ 

---

I'm guessing this repo is in-between the 1.5 and 1.4 versions? Otherwise it would have generated a 1.5 compatible db?

[peterneubauer]

Yes,
correct. YOu created the db with 1.4.2, then upgraded and ran it again
against 1.5. If you do a clean build with 1.5.M02, things should be
running smoothly?

/peter

On Mon, Oct 31, 2011 at 8:48 PM, Nick Klauer
reply@reply.github.com
wrote:

Okay, so it took a bit of finagling around, but I did get it to work.  I got this initially when running it:

klauer@klauer-imac ~/Programming/Java
$ ./neo4j-community-1.5.M02/bin/neo4j-shell -path /var/folders/J6/J67--MxKGjejtyI966Nft++++TI/-Tmp-/neo4j-koans1097860323379298061dir -v
ERROR (-v for expanded information):
       Could not create data source [nioneodb], see nested exception for cause of error
org.neo4j.graphdb.TransactionFailureException: Could not create data source [nioneodb], see nested exception for cause of error
       at org.neo4j.kernel.impl.transaction.TxModule.registerDataSource(TxModule.java:153)
       at org.neo4j.kernel.GraphDbInstance.start(GraphDbInstance.java:112)
       at org.neo4j.kernel.EmbeddedGraphDbImpl.<init>(EmbeddedGraphDbImpl.java:190)
       at org.neo4j.kernel.EmbeddedGraphDatabase.<init>(EmbeddedGraphDatabase.java:80)
       at org.neo4j.shell.kernel.GraphDatabaseShellServer.instantiateGraphDb(GraphDatabaseShellServer.java:85)
       at org.neo4j.shell.kernel.GraphDatabaseShellServer.<init>(GraphDatabaseShellServer.java:57)
       at org.neo4j.shell.StartClient.tryStartLocalServerAndClient(StartClient.java:285)
       at org.neo4j.shell.StartClient.startLocal(StartClient.java:218)
       at org.neo4j.shell.StartClient.start(StartClient.java:158)
       at org.neo4j.shell.StartClient.main(StartClient.java:107)
Caused by: org.neo4j.kernel.impl.storemigration.UpgradeNotAllowedByConfigurationException: To enable automatic upgrade, please set configuration parameter "allow_store_upgrade=true"
       at org.neo4j.kernel.impl.storemigration.ConfigMapUpgradeConfiguration.checkConfigurationAllowsAutomaticUpgrade(ConfigMapUpgradeConfiguration.java:41)
       at org.neo4j.kernel.impl.storemigration.StoreUpgrader.attemptUpgrade(StoreUpgrader.java:50)
       at org.neo4j.kernel.impl.nioneo.store.NeoStore.tryToUpgradeStores(NeoStore.java:131)
       at org.neo4j.kernel.impl.nioneo.store.NeoStore.checkVersion(NeoStore.java:98)
       at org.neo4j.kernel.impl.nioneo.store.CommonAbstractStore.<init>(CommonAbstractStore.java:103)
       at org.neo4j.kernel.impl.nioneo.store.AbstractStore.<init>(AbstractStore.java:120)
       at org.neo4j.kernel.impl.nioneo.store.NeoStore.<init>(NeoStore.java:72)
       at org.neo4j.kernel.impl.nioneo.xa.NeoStoreXaDataSource.<init>(NeoStoreXaDataSource.java:137)
       at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
       at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
       at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
       at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
       at org.neo4j.kernel.impl.transaction.XaDataSourceManager.create(XaDataSourceManager.java:75)
       at org.neo4j.kernel.impl.transaction.TxModule.registerDataSource(TxModule.java:147)
       ... 9 more

Then created a simple neo4j.config file with allow_store_upgrade=true in it.  Then re-ran it:

klauer@klauer-imac ~/Programming/Java
$ ./neo4j-community-1.5.M02/bin/neo4j-shell -path /var/folders/J6/J67--MxKGjejtyI966Nft++++TI/-Tmp-/neo4j-koans1097860323379298061dir -config ./neo4j.config
Starting upgrade of database store files
Oct 31, 2011 10:45:42 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor started
INFO: Starting upgrade of database store files
..........Oct 31, 2011 10:45:42 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 10% complete
..........Oct 31, 2011 10:45:42 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 20% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 30% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 40% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 50% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 60% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 70% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 80% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 90% complete
..........Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor percentComplete
INFO: Store upgrade 100% complete

Finished upgrade of database store files
Oct 31, 2011 10:45:43 PM org.neo4j.kernel.impl.storemigration.monitoring.VisibleMigrationProgressMonitor finished
INFO: Finished upgrade of database store files
NOTE: Local Neo4j graph database service at '/var/folders/J6/J67--MxKGjejtyI966Nft++++TI/-Tmp-/neo4j-koans1097860323379298061dir'
Welcome to the Neo4j Shell! Enter 'help' for a list of commands

Welcome to the Neo4j Shell! Enter 'help' for a list of commands

neo4j-sh (0)$ start daleks = node:Species(species = 'Dalek') match (daleks)-[:APPEARED_IN]->(ep) return ep
+-------------------------------------------------------------+
| ep                                                          |
+-------------------------------------------------------------+
| Node[900]{episode->212,title->"The Pandorica Opens"}        |
| Node[888]{episode->206,title->"Victory of the Daleks"}      |
| Node[878]{episode->198,title->"Journey's End"}              |
| Node[877]{episode->198,title->"The Stolen Earth"}           |
| Node[851]{episode->182,title->"Evolution of the Daleks"}    |
| Node[850]{episode->182,title->"Daleks in Manhattan"}        |
| Node[843]{episode->177,title->"Doomsday"}                   |
| Node[842]{episode->177,title->"Army of Ghosts"}             |
| Node[825]{episode->166,title->"The Parting of the Ways"}    |
| Node[824]{episode->166,title->"Bad Wolf"}                   |
| Node[817]{episode->161,title->"Dalek"}                      |
| Node[800]{episode->148,title->"Remembrance of the Daleks"}  |
| Node[788]{episode->142,title->"Revelation of the Daleks"}   |
| Node[775]{title->"Resurrection of the Daleks",episode->133} |
| Node[768]{episode->129,title->"The Five Doctors"}           |
| Node[731]{episode->104,title->"Destiny of the Daleks"}      |
| Node[686]{episode->78,title->"Genesis of the Daleks"}       |
| Node[679]{episode->72,title->"Death to the Daleks"}         |
| Node[674]{episode->68,title->"Planet of the Daleks"}        |
| Node[673]{episode->67,title->"Frontier in Space"}           |
| Node[665]{episode->60,title->"Day of the Daleks"}           |
| Node[653]{episode->50,title->"The War Games"}               |
| Node[634]{episode->36,title->"The Evil of the Daleks"}      |
| Node[626]{episode->30,title->"The Power of the Daleks"}     |
| Node[615]{episode->21,title->"The Daleks' Master Plan"}     |
| Node[609]{episode->16,title->"The Chase"}                   |
| Node[608]{episode->15,title->"The Space Museum"}            |
| Node[603]{title->"The Dalek Invasion of Earth",episode->10} |
| Node[590]{episode->2,title->"The Daleks"}                   |
+-------------------------------------------------------------+
29 rows, 381 ms
neo4j-sh (0)$

I'm guessing this repo is in-between the 1.5 and 1.4 versions?  Otherwise it would have generated a 1.5 compatible db?

Reply to this email directly or view it on GitHub:
#10 (comment)

[klauern]

ok, this works. Thanks for the help.