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: smartzio@… 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 Dimitar Misev, 13 years ago

Cc: Peter Baumann added
Component: DEBrasserver
Version: 8.3

We have the same error reported in #120, it's probably a bug.

comment:2 by Dimitar Misev, 12 years ago

Resolution: fixed
Status: newclosed

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.

Note: See TracTickets for help on using tickets.