[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