I mention it because I had a segfault (that I sent in another message a few minutes before this thread) that I experienced after a spontaneous reboot on an idle database that had no connections.  The database appears to be unrecoverable:

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fe8592906e0 (LWP 5538)]
0x00007fe8582faa29 in strPut () from /usr/lib/libbat.so.1
(gdb)
(gdb) bt
#0  0x00007fe8582faa29 in strPut () from /usr/lib/libbat.so.1
#1  0x00007fe858259288 in BATappend () from /usr/lib/libbat.so.1
#2  0x00007fe858571e83 in ?? () from /usr/lib/libbat.so.1
#3  0x00007fe8585729e9 in ?? () from /usr/lib/libbat.so.1
#4  0x00007fe858573dc4 in logger_create () from /usr/lib/libbat.so.1
#5  0x00007fe84744f0c5 in ?? () from /usr/lib/MonetDB5/lib/lib_sql.so
#6  0x00007fe847449245 in store_init () from /usr/lib/MonetDB5/lib/lib_sql.so
#7  0x00007fe847415346 in mvc_init () from /usr/lib/MonetDB5/lib/lib_sql.so
#8  0x00007fe8473d6b9b in SQLprelude () from /usr/lib/MonetDB5/lib/lib_sql.so
#9  0x00007fe858d80ef1 in ?? () from /usr/lib/libmonetdb5.so.5
#10 0x00007fe858d8c471 in runMAL () from /usr/lib/libmonetdb5.so.5
#11 0x00007fe858d7aa74 in MALengine () from /usr/lib/libmonetdb5.so.5
#12 0x00007fe858d797b1 in callString () from /usr/lib/libmonetdb5.so.5
#13 0x0000000000402976 in main ()
(gdb) quit


73,
Matthew W. Jones (KI4ZIB)
http://matburt.net


On Tue, Oct 6, 2009 at 11:36 AM, Niels Nes <Niels.Nes@cwi.nl> wrote:
On Tue, Oct 06, 2009 at 11:01:58AM -0400, Matthew Jones wrote:
> Is this option still required to keep the database from corrupting
> itself on shutdown?

Definitely not. The default (full transaction support) is the mode which
we recommand.

Niels
>
> I've also noticed when running in this mode that I see a lot of
> duplicate tables and when attempting to drop a table it doesn't
> disappear from my table list... what gives?
>
> 73,
> Matthew W. Jones (KI4ZIB)
> http://matburt.net

> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
> http://p.sf.net/sfu/devconf
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users


--
Niels Nes, Centre for Mathematics and Computer Science (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room C0.02/M3.46,  phone ++31 20 592-4098, fax ++31 20 592-4312
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes@cwi.nl

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users