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:
- CREATE TABLE test (f1 int, f2 float);
- 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:
- 32 bit XP with 3 GB RAM.
- 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.