py2neo query problem

[Alex]

Hi guys,

i do this query :

START me=node(1) MATCH (me)-[r:dailyActivity]-(x) WHERE r.valueOf > 2
RETURN me,r,x,x.id_node,x.name

work great in neo4j console

and when query work without errors with py2neo library i cannot
iterate on result set,
i get only the last one.

i have another query with exact same structure in "for row in
data" .. and work correctly, the only difference is that i have in
that query only one type of variable in return statement (b) :

"START me=node("+startNode+") MATCH me-[:followedBy]->b RETURN
b,b.id_node,b.name"



values = { "returncode" : 0,
}

nodes = { }

for row in data:
row_count += 1
nodes[row[0]._id] =
[row[1]._id,row[2]._id,row[3],row[4]]
values['nodes'] = nodes

values["total"] = row_count


any idea ?

ps.

sometimes query get me this error :
maybe i need some adj on OS resources :)


Exception AttributeError: "'HTTPClient' object has no attribute
'_closed'" in <bound method HTTPClient.__del__ of
<tornado.httpclient.HTTPClient object at 0x1085840c>> ignored
ERROR:./AEPrestServer.py:MASTER ./AEPrestServer.py [ by 15809292]
['Traceback (most recent call last):\n', ' File "./AEPrestServer.py",
line 1623, in render_GET\n q.execQuery()\n', ' File "./
AEPrestServer.py", line 251, in execQuery\n d, c =
cypher.execute(self.query, self.cgdb)\n', ' File "/usr/local/lib/
python2.7/dist-packages/py2neo-1.2.1-py2.7.egg/py2neo/cypher.py", line
205, in execute\n row_handler=row_handler,
metadata_handler=metadata_handler, **kwargs\n', ' File "/usr/local/
lib/python2.7/dist-packages/py2neo-1.2.1-py2.7.egg/py2neo/cypher.py",
line 55, in execute\n return [map(_resolve, row) for row in rows],
Query.Metadata(columns)\n', ' File "/usr/local/lib/python2.7/dist-
packages/py2neo-1.2.1-py2.7.egg/py2neo/cypher.py", line 184, in
_resolve\n node = neo4j.Node(uri)\n', ' File "/usr/local/lib/
python2.7/dist-packages/py2neo-1.2.1-py2.7.egg/py2neo/neo4j.py", line
483, in __init__\n index_uri=index_uri, index=index, **kwargs)\n',
' File "/usr/local/lib/python2.7/dist-packages/py2neo-1.2.1-py2.7.egg/
py2neo/neo4j.py", line 375, in __init__\n
rest.Resource.__init__(self, uri, index=index, **kwargs)\n', ' File "/
usr/local/lib/python2.7/dist-packages/py2neo-1.2.1-py2.7.egg/py2neo/
rest.py", line 54, in __init__\n self._http = http or
httpclient.HTTPClient(curl_httpclient.CurlAsyncHTTPClient)\n', ' File
"/usr/local/lib/python2.7/dist-packages/tornado-2.2.1-py2.7.egg/
tornado/httpclient.py", line 58, in __init__\n self._io_loop =
IOLoop()\n', ' File "/usr/local/lib/python2.7/dist-packages/
tornado-2.2.1-py2.7.egg/tornado/ioloop.py", line 123, in __init__\n
self._waker = Waker()\n', ' File "/usr/local/lib/python2.7/dist-
packages/tornado-2.2.1-py2.7.egg/tornado/platform/posix.py", line 35,
in __init__\n r, w = os.pipe()\n', 'OSError: [Errno 24] Too many
open files\n']
Exception AttributeError: "'HTTPClient' object has no attribute
'_closed'" in <bound method HTTPClient.__del__ of
<tornado.httpclient.HTTPClient object at 0x10f56a0c>> ignored


Thank you

[Nigel Small]

Hi Alessio

It's hard to tell what might be going wrong for you there. Is the full source code available anywhere? If you like, email it across to me (py2...@nigelsmall.net) and I'll see if I can spot anything.

Incidentally, are you running asynchronous? If so, have you tried executing the query and analysing the results afterwards?

Nige