Opened 6 years ago

Closed 5 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: pbaumann
Complexity:

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 Changed 6 years ago by dmisev

  • Cc pbaumann added
  • Component changed from DEB to rasserver
  • Version set to 8.3

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

comment:2 Changed 5 years ago by dmisev

  • Resolution set to fixed
  • Status changed from new to 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.

Note: See TracTickets for help on using tickets.