Re: [luciddb-users] LucidDB for Spatial OLAP

[John V. S. <js...@gm...>]

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