On Fri, Oct 17, 2008 at 10:01:26PM +0200, Sjoerd Mullender wrote:
On 2008-10-17 20:06, Richard Wesley wrote:
On 16 Oct 2008, at 07:55, Sjoerd Mullender wrote:
As to your question about6 the generic error, the driver often returns a generic error because a query was not acceptable to the server and the driver doesn't interpret the error messages that come back from the server (they are too varied and unstructured). So the best the driver can do is give a generic error.
I'm getting another strange problem where the ODBC driver issues a command and it fails, but if I then go and issue the same command in the client, it succeeds. I have attached another log file from a run that has this problem. The failure point is not consistent and changes between runs (the tables are dropped before each attempt to build the data).
I see a failure after a COPY 19348821 OFFSET 58046463 RECORDS INTO ... query. Could it be that either the server or the client is using too much memory? It could be that the server uses too much memory and therefore complains, but by the time you try it again, the server has maybe consolidated some tables and can again cope with the next batch.
So one thing to check for is the memory footprint of the server.
Niels, what do you think? The table consists of 7 integers and 2 float(53) and the application inserts batches of nearly 20M rows.
Probably its indeed some form of out of memory which causes the problem. Niels
-- Sjoerd Mullender
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ 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) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl