PyOrient SQL Query MemoryError
0
I have to read from a OrientDB. To test that everything works I tried to read from the Database with the SELECT Statement.
like this:
import pyorient
client = pyorient.OrientDB("adress", 2424)
session_id = client.connect("root", "password")
client.db_open("table","root","password")
print str(client.db_size())
client.query("SELECT * FROM L1_Req",1)
The Connection works fine and also the print str(client.db_size()) line.
But at client.query("SELECT * FROM L1_Req",1) it returns the following Error Message:
Traceback (most recent call last):
File "testpy.py", line 9, in <module>
client.query("SELECT * FROM L1_Req",1)
File "C:apptoolspython27libsite-packagespyorientorient.py", line 470, i
n query
.prepare(( QUERY_SYNC, ) + args).send().fetch_response()
File "C:apptoolspython27libsite-packagespyorientmessagescommands.py",
line 144, in fetch_response
super( CommandMessage, self ).fetch_response()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
265, in fetch_response
self._decode_all()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
249, in _decode_all
self._decode_header()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
176, in _decode_header
serialized_exception = self._decode_field( FIELD_STRING )
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
366, in _decode_field
_decoded_string = self._orientSocket.read( _len )
File "C:apptoolspython27libsite-packagespyorientorient.py", line 164, i
n read
buf = bytearray(_len_to_read)
MemoryError
I also tried some ohter SQL Statements like:
client.query("SELECT subSystem FROM L1_Req",1)
I cant't get why this happends. Can you guys help me ?
python sql select orientdb pyorient
asked Nov 13 '18 at 7:40
Loois95Loois95
629
add a comment |
0
I have to read from a OrientDB. To test that everything works I tried to read from the Database with the SELECT Statement.
like this:
import pyorient
client = pyorient.OrientDB("adress", 2424)
session_id = client.connect("root", "password")
client.db_open("table","root","password")
print str(client.db_size())
client.query("SELECT * FROM L1_Req",1)
The Connection works fine and also the print str(client.db_size()) line.
But at client.query("SELECT * FROM L1_Req",1) it returns the following Error Message:
Traceback (most recent call last):
File "testpy.py", line 9, in <module>
client.query("SELECT * FROM L1_Req",1)
File "C:apptoolspython27libsite-packagespyorientorient.py", line 470, i
n query
.prepare(( QUERY_SYNC, ) + args).send().fetch_response()
File "C:apptoolspython27libsite-packagespyorientmessagescommands.py",
line 144, in fetch_response
super( CommandMessage, self ).fetch_response()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
265, in fetch_response
self._decode_all()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
249, in _decode_all
self._decode_header()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
176, in _decode_header
serialized_exception = self._decode_field( FIELD_STRING )
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
366, in _decode_field
_decoded_string = self._orientSocket.read( _len )
File "C:apptoolspython27libsite-packagespyorientorient.py", line 164, i
n read
buf = bytearray(_len_to_read)
MemoryError
I also tried some ohter SQL Statements like:
client.query("SELECT subSystem FROM L1_Req",1)
I cant't get why this happends. Can you guys help me ?
python sql select orientdb pyorient
asked Nov 13 '18 at 7:40
Loois95Loois95
629
Which version of orientdb are you using? Thanks
– dgiannotti
Nov 30 '18 at 2:32
@dgiannotti 2.1.5
– Loois95
Dec 10 '18 at 12:18
add a comment |
0
0
0
I have to read from a OrientDB. To test that everything works I tried to read from the Database with the SELECT Statement.
like this:
import pyorient
client = pyorient.OrientDB("adress", 2424)
session_id = client.connect("root", "password")
client.db_open("table","root","password")
print str(client.db_size())
client.query("SELECT * FROM L1_Req",1)
The Connection works fine and also the print str(client.db_size()) line.
But at client.query("SELECT * FROM L1_Req",1) it returns the following Error Message:
Traceback (most recent call last):
File "testpy.py", line 9, in <module>
client.query("SELECT * FROM L1_Req",1)
File "C:apptoolspython27libsite-packagespyorientorient.py", line 470, i
n query
.prepare(( QUERY_SYNC, ) + args).send().fetch_response()
File "C:apptoolspython27libsite-packagespyorientmessagescommands.py",
line 144, in fetch_response
super( CommandMessage, self ).fetch_response()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
265, in fetch_response
self._decode_all()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
249, in _decode_all
self._decode_header()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
176, in _decode_header
serialized_exception = self._decode_field( FIELD_STRING )
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
366, in _decode_field
_decoded_string = self._orientSocket.read( _len )
File "C:apptoolspython27libsite-packagespyorientorient.py", line 164, i
n read
buf = bytearray(_len_to_read)
MemoryError
I also tried some ohter SQL Statements like:
client.query("SELECT subSystem FROM L1_Req",1)
I cant't get why this happends. Can you guys help me ?
python sql select orientdb pyorient
asked Nov 13 '18 at 7:40
Loois95Loois95
629
I have to read from a OrientDB. To test that everything works I tried to read from the Database with the SELECT Statement.
like this:
import pyorient
client = pyorient.OrientDB("adress", 2424)
session_id = client.connect("root", "password")
client.db_open("table","root","password")
print str(client.db_size())
client.query("SELECT * FROM L1_Req",1)
The Connection works fine and also the print str(client.db_size()) line.
But at client.query("SELECT * FROM L1_Req",1) it returns the following Error Message:
Traceback (most recent call last):
File "testpy.py", line 9, in <module>
client.query("SELECT * FROM L1_Req",1)
File "C:apptoolspython27libsite-packagespyorientorient.py", line 470, i
n query
.prepare(( QUERY_SYNC, ) + args).send().fetch_response()
File "C:apptoolspython27libsite-packagespyorientmessagescommands.py",
line 144, in fetch_response
super( CommandMessage, self ).fetch_response()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
265, in fetch_response
self._decode_all()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
249, in _decode_all
self._decode_header()
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
176, in _decode_header
serialized_exception = self._decode_field( FIELD_STRING )
File "C:apptoolspython27libsite-packagespyorientmessagesbase.py", line
366, in _decode_field
_decoded_string = self._orientSocket.read( _len )
File "C:apptoolspython27libsite-packagespyorientorient.py", line 164, i
n read
buf = bytearray(_len_to_read)
MemoryError
I also tried some ohter SQL Statements like:
client.query("SELECT subSystem FROM L1_Req",1)
I cant't get why this happends. Can you guys help me ?
python sql select orientdb pyorient
python sql select orientdb pyorient
asked Nov 13 '18 at 7:40
Loois95Loois95
629
asked Nov 13 '18 at 7:40
Loois95Loois95
629
asked Nov 13 '18 at 7:40
Loois95Loois95
629
asked Nov 13 '18 at 7:40
Loois95Loois95
629
asked Nov 13 '18 at 7:40
Loois95Loois95
629
629
Which version of orientdb are you using? Thanks
– dgiannotti
Nov 30 '18 at 2:32
@dgiannotti 2.1.5
– Loois95
Dec 10 '18 at 12:18
add a comment |
Which version of orientdb are you using? Thanks
– dgiannotti
Nov 30 '18 at 2:32
@dgiannotti 2.1.5
– Loois95
Dec 10 '18 at 12:18
Which version of orientdb are you using? Thanks
– dgiannotti
Nov 30 '18 at 2:32
Which version of orientdb are you using? Thanks
– dgiannotti
Nov 30 '18 at 2:32
@dgiannotti 2.1.5
– Loois95
Dec 10 '18 at 12:18
@dgiannotti 2.1.5
– Loois95
Dec 10 '18 at 12:18
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53276065%2fpyorient-sql-query-memoryerror%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53276065%2fpyorient-sql-query-memoryerror%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Which version of orientdb are you using? Thanks
– dgiannotti
Nov 30 '18 at 2:32
@dgiannotti 2.1.5
– Loois95
Dec 10 '18 at 12:18