[Monetdb-developers] COPY, terminating connection

Martin Kersten Martin.Kersten at cwi.nl
Sun Sep 14 13:57:36 CEST 2008

Fabian Groffen wrote:
> On 13-09-2008 07:36:19 +0200, Stefan Manegold wrote:
>>> Is there anything im doing wrong ? I have the feeling there must be too many connections crashing the system .. coz after that i can't use mclient anymore, i have to restart the DB.
>> How many (sequential, not concurrent, right?) connections are we talking
>> about, i.e., how many *.CDR files do you have?
>> How many rows do these *.CDR files hold in total?
>> Are all attributes of the cdrwholesaler table string attributes?
>> ... "too many connections" *might* be the problem (though it should of
>> course not) --- strange, though, that the merovingian log do not give any
>> indication of whether, and if so why the server might have crashed ...
> It can't, because the server didn't crash.  It indicates it is still
> alive.  Most probably the server is confused by the amount of inserts,
If the input data is not valid, such that the number of tuples are not 
correct, then indeed the
server will at some point fail,.e.g waiting for tuples that never appeara.
> I've seen this a few times before.  Somewhere something gets stuck,
> making the mserver refuse to operate.  A restart of the server solves
> it, as the original reporter also indicates.
> Note from the logs that the server "demo" had one crash in the past,
> though.
> -------------------------------------------------------------------------
> 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-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers

More information about the developers-list mailing list