Re: [luciddb-users] LucidDB for Spatial OLAP

[Emily G. <eg...@re...>]

The select query results in a Java Out of Memory Error:

0: jdbc:luciddb:rmi://localhost> select count(*) from habc_extraction_schema.master_grid;

Error: java.lang.OutOfMemoryError: Java heap space (state=,code=0)


I can however run counts and extract from other tables/views with fewer records:

0: jdbc:luciddb:rmi://localhost> select count(*) from habc_extraction_schema.lwdpbc;
+---------+
| EXPR$0  |
+---------+
| 19249   |
+---------+
1 row selected (7.179 seconds)

Emily

John V. Sichi wrote:
> Emily Gouge wrote:
>> I set the net.sf.farrago.jdbc.level=FINER in the Trace.properties file 
>> and attached the new logfile.  However I'm not sure it has any more 
>> information that the first one I sent.  I've attached both the new log 
>> file and my Trace.properties file.
> 
> Hmmm...the trace has this in the log just before the crash:
> 
> SEVERE: org.eigenbase.util.EigenbaseException: Failed to access data 
> server for execution
> 
> Usually that means there was some problem when LucidDB calls the foreign 
> server's JDBC driver to prepare and execute the query, but for some 
> reason the underlying exception isn't being traced.
> 
> Instead of the insert statement, can you try just a query:
> 
> select count(*) from habc_extraction_schema.master_grid
> 
> This will attempt to pull back all the rows from the PostgreSQL server 
> and count them.
> 
> JVS