[luciddb-users] Out of memory in ETL process

[Pedro A. <pmg...@gm...>]

Hello again


I'm getting a nasty crash on the server while copying a fact table from a
mysql server to lucid. I'm using 512Mb of ram - it's just my sandbox, and
it's just 350k rows. I was expecting some kind of partial commits, not a
out of memory crash like this. Am I missing some parameter?


Here's the command:

INSERT INTO "METRICS"."f_weblog_personas" SELECT * FROM "METRICS"."f_weblog_personas_link";


and here's the crash:

$ ./lucidDbServer
Server personality:  LucidDB
Loading database...
Starting network...
Server now listening for RMI connections on port 5434; enter !quit to stop
terminate called after throwing an instance of 'fennel::JavaExcn'
  what():  java.lang.OutOfMemoryError: Java heap space

*** CAUGHT SIGNAL 6; BACKTRACE:
/opt/luciddb-0.9.1/luciddb-0.9.1/lib/fennel/libfennel_common.so(fennel::AutoBacktrace::signal_handler(int)+0x3e) [0x203ee]
[0xffffe400]
/lib/libc.so.6(gsignal+0x46) [0xb7dea456]
/lib/libc.so.6(abort+0x188) [0xb7debe08]
/opt/luciddb-0.9.1/luciddb-0.9.1/lib/fennel/libstlport.so.5.1(__gnu_cxx::__verbose_terminate_handler()+0x150) [0x7a800]
/opt/luciddb-0.9.1/luciddb-0.9.1/lib/fennel/libstlport.so.5.1(__cxxabiv1::__terminate(void (*)())+0x15) [0x78235]
/opt/luciddb-0.9.1/luciddb-0.9.1/lib/fennel/libstlport.so.5.1 [0x8ddf5272]
/opt/luciddb-0.9.1/luciddb-0.9.1/lib/fennel/libstlport.so.5.1(__cxa_rethrow+0x5b) [0x7832b]
/opt/luciddb-0.9.1/luciddb-0.9.1/lib/fennel/libfennel_common.so(fennel::TimerThread::run()+0x6ec) [0x554cc]
/opt/luciddb-0.9.1/luciddb-0.9.1/lib/fennel/libfennel_common.so(fennel::Thread::initAndRun()+0x19) [0x52d59]
/opt/luciddb-0.9.1/luciddb-0.9.1/lib/fennel/libfennel_common.so(boost::detail::thread_data<boost::_bi::bind_t<void, boost::_mfi::mf0<void, fennel::Thread>, boost::_bi::list1<boost::_bi::value<fennel::Thread*> > > >::run()+0x30) [0x536d0]
/opt/luciddb-0.9.1/luciddb-0.9.1/lib/fennel/libboost_thread-mt-p.so(thread_proxy+0x6e) [0x8ea0c2ce]
/lib/libpthread.so.0 [0xb7f32310]
/lib/libc.so.6(clone+0x5e) [0xb7ea1bee]
./lucidDbServer: line 9: 22607 Aborted                 ${JAVA_EXEC} ${JAVA_ARGS} com.lucidera.farrago.LucidDbServer


Thanks


-- 
Pedro Alves
pmgalves-at-gmail.com