Alex, how much data are you laoding and one which kind of machines does it work? If your are loadling "lots" of data and the difference between float and real alos inside MonetDB is 64- vs. 32-bit, using 64-bit float iso. 32-bit real might just cause to reach/cross the 32-bit address space limitation and hence memory allocations might fail. Obviously, we should not crash in such case, but we are aware that older versions did, though we spend quite some effort on fixing these problems in the Nov2009-SP1 & Nov2009-SP2 releases. In you are loading "lots" of data, could you also try the Nov2009-SP2 release? Stefan On Thu, Feb 04, 2010 at 09:48:58AM +0100, Sjoerd Mullender wrote:
On 2010-02-03 16:53, Alex Bo. wrote:
Hi,
I am encountering something very strange. (Windows - NovSP1 from CVS)
On some machines I encountered crashes in Monet when doing a copy into on tables with a float column. After trying to investigate, I narrowed it down to this:
Run: 1. CREATE TABLE test (f1 int, f2 float); 2. COPY INTO test from 'filename.txt' using delimiters ',','\n','"' null as '';
the text file contains: 1,1 2,2
This sequence exactly caused a server crash (without any message) on some machines, while on others it didn't. The machines it happened on were: 1. 32 bit XP with 3 GB RAM. 2. 32 bit Vista with 4 GB RAM.
In both cases, changing the column type from float to real worked.
Could it be that float, being a 64 bit floating point, might cause crashes on 32 bit machines?
Is there anything I can to help you get a clearer picture of this?
Thanks.
I have not (yet?) been able to reproduce this. I have tried the official Nof2009-SP1 installer, and also some recent build I made.
Since you're using your own build, you can perhaps try this: start the server, then attach the Visual Studio debugger. Then try the sequence of queries that resulted in the crash. Hopefully you can then see in the debugger where it crashed, and perhaps even why.
In the meantime I'll try some more builds, once I've made them.
I am trying this on a 32 bit XP Pro with 2 GB RAM, formerly the system on which I created the official builds.
-- Sjoerd Mullender
------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |