[Monetdb-developers] Segmentation Fault upon sql.start()

Stefan de Konink skinkie at xs4all.nl
Mon Oct 22 22:15:40 CEST 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

After loading in a bunch of data the monetdb server was Killed due to
memory starvation. With swap MonetDB performed the huge amount of one
insert in 10 seconds, so that wasn't an option too.

I restarted it, and tried to 'load the data again'. Backtrace:

gdb ./mserver5
GNU gdb 6.7
Copyright (C) 2007 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later
<http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-pc-linux-gnu"...
Using host libthread_db library "/lib/libthread_db.so.1".
(gdb) run
Starting program: /opt/monetdb/bin/mserver5
warning: no loadable sections found in added symbol-file system-supplied
DSO at 0x7fff275fe000
[Thread debugging using libthread_db enabled]
[New Thread 0x2afd85f0f2a0 (LWP 23929)]
# MonetDB Server v5.0.0
# Copyright (c) 1993-2007 CWI, all rights reserved
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs
dynamically linked
# dbname:osm
# Visit http://monetdb.cwi.nl/ for further information
#warning: please don't forget to set your vault key!
#(see /opt/monetdb/etc/monetdb5.conf)
[New Thread 0x40800950 (LWP 23932)]
>include sql;
>sql.start();

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x2afd85f0f2a0 (LWP 23929)]
0x00002aaaaab40a8f in load_column ()
   from /opt/monetdb/lib/MonetDB5/lib/lib_sql.so
(gdb) bt
#0  0x00002aaaaab40a8f in load_column ()
   from /opt/monetdb/lib/MonetDB5/lib/lib_sql.so
#1  0x00002aaaaab41a71 in load_table ()
   from /opt/monetdb/lib/MonetDB5/lib/lib_sql.so
#2  0x00002aaaaab433cc in load_trans ()
   from /opt/monetdb/lib/MonetDB5/lib/lib_sql.so
#3  0x00002aaaaab46e15 in store_init ()
   from /opt/monetdb/lib/MonetDB5/lib/lib_sql.so
#4  0x00002aaaaab1b95b in mvc_init ()
   from /opt/monetdb/lib/MonetDB5/lib/lib_sql.so
#5  0x00002aaaaaad0b50 in SQLinit ()
   from /opt/monetdb/lib/MonetDB5/lib/lib_sql.so
#6  0x00002afd8389f476 in initScenario () from /opt/monetdb/lib/libmal.so.0
#7  0x00002aaaaaad0ac8 in SQLsession ()
   from /opt/monetdb/lib/MonetDB5/lib/lib_sql.so
#8  0x00002afd8387842d in runMALsequence () from
/opt/monetdb/lib/libmal.so.0
#9  0x00002afd83879dfd in runMAL () from /opt/monetdb/lib/libmal.so.0
#10 0x00002afd83871dc8 in MALengine () from /opt/monetdb/lib/libmal.so.0
#11 0x00002afd8389f082 in runScenarioBody () from
/opt/monetdb/lib/libmal.so.0
#12 0x00002afd8389f0d2 in runScenario () from /opt/monetdb/lib/libmal.so.0
#13 0x00002afd838719e0 in MSserveClient () from /opt/monetdb/lib/libmal.so.0
#14 0x0000000000402c14 in main ()
(gdb)


It work doesn't anymore... I can conclude, inserting a lot of data start
to become a huge waste of time. If required I can recompile with the -g
option and a lower amount of optimization.


Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHHQTsYH1+F2Rqwn0RCjWKAJ9u/OEu8Sk6HTSY+v431bLjmylrCwCffsNN
Rpf0Fs4XjrakYkdyEwkknWQ=
=0UHS
-----END PGP SIGNATURE-----




More information about the developers-list mailing list