Inserting GeoTIFF image fails

[mase@…]

I'm trying to start loading some of our own data into Rasdaman.

I'm starting with a TIFF as that is the closest to the data we used in the course in Munich.

I have a Landsat image and associated world file for geographic projection information.

The gdalinfo output is:

Driver: GTiff/GeoTIFF
Files: Landsat_ETM_321_11Sep2002.tif
       Landsat_ETM_321_11Sep2002.tfw
Size is 9130, 8372
Coordinate System is:
PROJCS["unnamed",
    GEOGCS[,
        DATUM["unknown",
            SPHEROID["unretrievable - using WGS84",6378137,298.257223563]],
        PRIMEM["Greenwich",0],
        UNIT["degree",0.0174532925199433]],
    UNIT["metre",1,
        AUTHORITY["EPSG","9001"]],
    AUTHORITY["EPSG","27700"]]
Origin = (314158.774125767638907,632963.644179778289981)
Pixel Size = (28.500000000000000,-28.500000000000000)
Metadata:
  AREA_OR_POINT=Area
Image Structure Metadata:
  INTERLEAVE=PIXEL
Corner Coordinates:
Upper Left  (  314158.774,  632963.644) 
Lower Left  (  314158.774,  394361.644) 
Upper Right (  574363.774,  632963.644) 
Lower Right (  574363.774,  394361.644) 
Center      (  444261.274,  513662.644) 
Band 1 Block=9130x1 Type=Byte, ColorInterp=Red
Band 2 Block=9130x1 Type=Byte, ColorInterp=Green
Band 3 Block=9130x1 Type=Byte, ColorInterp=Blue

Leaving aside the projection information to start with I thought I'd just try to insert the image.

I created a collection with:

create collection bgs_rs RGBSet

I then tried loading the file with:

rasql -q 'insert into bgs_rs values inv_tiff($1)' —out string —user rasadmin —passwd rasadmin —file Landsat_ETM_321_11Sep2002.tif

but got the output:

/usr/local/rasdaman/bin/rasql: rasdaman query tool v1.0, rasdaman v8 -- generated on 25.08.2011 22:40:37.
opening database RASBASE at localhost:7001...ok
fetching type information for GreyString from database, using readonly transaction...ok
reading file Landsat_ETM_321_11Sep2002.tif...ok
  constant 1: GMarray
  Oid...................: 
  Type Structure........: 
  Type Schema...........: marray< char >
  Domain................: [0:229443568]
  Base Type Schema......: char
  Base Type Length......: 1
  Data format.......... : Array
  Data size (bytes).... : 229443569
Executing update query...rasdaman error 0: Exception: Transfer Failed
aborting transaction...ok

[Dimitar Misev]

Strange that this has failed, Marcus Sen can you please attach the image you're trying to insert here?

[Dimitar Misev]

As can be seen from the log it's a memory problem, so the solution would be to either increase memory or split the files so that you can insert the image into smaller chunks.