Re: [MonetDB-users] mclient - copy into problem

Hi, I did not say It's anybodys' fault, I'm simply evaluating the software, I think the software is amazing. All I was asking was - what would I do if I was going to use it in production and I had to deal with situation like this, that's all. Thanks for hour help. Dariusz. Mark V wrote:

On Sat, Jan 31, 2009 at 6:44 AM, dariuszs wrote:

...

Hi, So this database was never intended for production use? Dariusz.

You've designed your application to do/allow fragile/volatile/experimental things on a production server, a server which hundreds of people depend on - and its MonetDB's fault?

...

Martin Kersten wrote:

...

dariuszs wrote:

...

Hi, Well then how do you stop that process? Terminate server? And if that's a production machine? Log off hundreds of people?

The server does not see when a client ceases until it requests the next statement. The protocol does not include an out of bound message to warn the server. Even if it could, the bulk-processing approach leads to at best stopping between two MAL instructions. Such an instruction can take a lot of time.

The developments aimed at distribution and automatic horizontal. partitioning are the handles to better control 'early escape'

...

Martin Kersten wrote:

...

dariuszs wrote:

...

Hi, Please verify this - when you output a file from the table with 'copy... into...' and terminate that client - the output file is still being created even though the client was terminated. Thanks. Dariusz.

Of course. mclient and server are two independent processes. And MonetDB does not let you abort a query easily. So the back-end happily continous to finish the query.

...

------------------------------------------------------------------------------

This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------

This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users