search

jadell / neo4jphp

PHP wrapper of the Neo4j REST interface
Other
533 stars 137 forks source link

Neo4jphp fails when run with cypher query: START n = node(*) #67

Closed divyanshu-das closed 11 years ago

divyanshu-das commented 12 years ago

I am using neo4j version 1.8 and using neo4jphp Evreyman library.

When I run queries by specifying a particular node Id, like node(123), it gives results,

but when tried with node(*), it fails after executing for 10-15 minutes- and gives error like this:-

Uncaught exception 'Everyman\Neo4j\Exception' with message 'Unable to execute query [100]: Headers: Array ( ) Body: Array ( ) ' in /var/www/new-ui/app/libs/Everyman/Neo4j/Command.php:117 Stack trace: #0 /var/www/new-ui/app/libs/Everyman/Neo4j/Command/ExecuteCypherQuery.php(85): Everyman\Neo4j\Command->throwException('Unable to execu...', 100, Array, Array) #1 /var/www/new-ui/app/libs/Everyman/Neo4j/Command.php(70): Everyman\Neo4j\Command\ExecuteCypherQuery->handleResult(100, Array, Array) #2 /var/www/new-ui/app/libs/Everyman/Neo4j/Client.php(602): Everyman\Neo4j\Command->execute() #3 /var/www/new-ui/app/libs/Everyman/Neo4j/Client.php(164): Everyman\Neo4j\Client->runCommand(Object(Everyman\Neo4j\Command\ExecuteCypherQuery)) #4 /var/www/new-ui/app/libs/Everyman/Neo4j/Cypher/Query.php(65): Everyman\Neo4j\Client->executeCypherQuery(Object(Everyman\Neo4j\Cypher\Query)) #5 /var/www/new-ui/app/services/users_service.php(106): Everyman\Neo4j\Cypher\Query->getResultSet() #6 /var/www/new-ui/app/controllers/users_contro in /var/www/new-ui/app/libs/Everyman/Neo4j/Command.php on line 117

jadell commented 12 years ago

How many nodes do you expect that query to return?

divyanshu-das commented 12 years ago

around 6 million.

jadell commented 11 years ago

Either the server is timing out generating the response, or PHP is failing to get the entire response because it is so large. Streaming should fix this problem when it is implemented. #92