Opened 13 years ago
Closed 12 years ago
#137 closed defect (fixed)
created collection odd behaviour (different answer for the same query and error in drop collection)
Reported by: | Owned by: | ||
---|---|---|---|
Priority: | major | Milestone: | 8.4 |
Component: | rasserver | Version: | 8.3 |
Keywords: | Cc: | Peter Baumann | |
Complexity: | Medium |
Description
Hello,
I've created a collection and run a rasql query twice (3-4 seconds apart) and the answer was different each time:
antleb@ubuntu:~/stefania$ rasql -q "select sdom(electronDensityTestSet)[3].hi from electronDensityTestSet" —out string
rasql: rasdaman query tool v1.0, rasdaman v8 — generated on 01.03.2012 17:37:14.
opening database RASBASE at localhost:7001...ok
Executing retrieval query…ok
Query result collection has 1 element(s):
Result element 1: 1660944384
rasql done.
antleb@ubuntu:~/stefania$ rasql -q "select sdom(electronDensityTestSet)[3].hi from electronDensityTestSet" —out string
rasql: rasdaman query tool v1.0, rasdaman v8 — generated on 01.03.2012 17:37:14.
opening database RASBASE at localhost:7001...ok
Executing retrieval query…ok
Query result collection has 1 element(s):
Result element 1: 149
rasql done.
(the second answer is the correct one)
Any ideas?
Also when i'm trying to drop the collection i get this error:
antleb@ubuntu:~/stefania$ rasql -q "drop collection electronDensityTestSet" —user rasadmin —passwd rasadmin
rasql: rasdaman query tool v1.0, rasdaman v8 — generated on 01.03.2012 17:37:14.
opening database RASBASE at localhost:7001...ok
Executing update query…ok
rasdaman error 206: Serialisable exception r_Ebase_dbms: error in base DBMS.
aborting transaction…ok
rasql done.
the same happens also when i'm trying to delete from the collection:
antleb@ubuntu:~/stefania$ rasql -q "delete from electronDensityTestSet as a where all_cells(a≥0)" —user rasadmin —passwd rasadmin
rasql: rasdaman query tool v1.0, rasdaman v8 — generated on 01.03.2012 17:37:14.
opening database RASBASE at localhost:7001...ok
Executing update query…ok
rasdaman error 206: Serialisable exception r_Ebase_dbms: error in base DBMS.
aborting transaction…ok
rasql done.
Any ideas why i can't delete the collection?
Stefania
Change History (2)
comment:1 by , 13 years ago
Cc: | added |
---|---|
Component: | DEB → rasserver |
Version: | → 8.3 |
comment:2 by , 12 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
For the delete error a patch has been provided.
For the other error there was probably some uninitialized variable, but unless you can provide steps to reproduce it we can't do much, so I'd close the ticket.
We have the same error reported in #120, it's probably a bug.