Load file MonetDB Client
Hello i'm an italian student. I am loading a file .sql with MonetDB Client. But, during the file's loading, happens that the Client suddenly stops working. Why does this happen? Thanks
Start loading your file in smaller steps to find the culprit On 06/12/13 16:19, Gaetano Mele wrote:
Hello i'm an italian student. I am loading a file .sql with MonetDB Client. But, during the file's loading, happens that the Client suddenly stops working. Why does this happen? Thanks
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Thanks a lot, i did what you suggested me but, unfortunately, the problem subsists.
Date: Fri, 6 Dec 2013 16:21:44 +0100 From: martin@monetdb.org To: users-list@monetdb.org Subject: Re: Load file MonetDB Client
Start loading your file in smaller steps to find the culprit
On 06/12/13 16:19, Gaetano Mele wrote:
Hello i'm an italian student. I am loading a file .sql with MonetDB Client. But, during the file's loading, happens that the Client suddenly stops working. Why does this happen? Thanks
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
What does "stops working" mean? No CPU activity, but does not terminate? Terminates with error message (which)? Terminates without message? In either case of termination, what's the exit code? Stefan ----- Original Message -----
Thanks a lot, i did what you suggested me but, unfortunately, the problem subsists.
Date: Fri, 6 Dec 2013 16:21:44 +0100 From: martin@monetdb.org To: users-list@monetdb.org Subject: Re: Load file MonetDB Client
Start loading your file in smaller steps to find the culprit
On 06/12/13 16:19, Gaetano Mele wrote:
Hello i'm an italian student. I am loading a file .sql with MonetDB Client. But, during the file's loading, happens that the Client suddenly stops working. Why does this happen? Thanks
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
After that i digited this command:<C:/foodmart.sqlthe MonetDB Client remains open but there is no way to insert any command.It is blocked and there isn't any message. I hope to be explained. Gaetano
Date: Fri, 6 Dec 2013 17:46:48 +0100 From: Stefan.Manegold@cwi.nl To: users-list@monetdb.org Subject: Re: Load file MonetDB Client
What does "stops working" mean?
No CPU activity, but does not terminate? Terminates with error message (which)? Terminates without message?
In either case of termination, what's the exit code?
Stefan
----- Original Message -----
Thanks a lot, i did what you suggested me but, unfortunately, the problem subsists.
Date: Fri, 6 Dec 2013 16:21:44 +0100 From: martin@monetdb.org To: users-list@monetdb.org Subject: Re: Load file MonetDB Client
Start loading your file in smaller steps to find the culprit
On 06/12/13 16:19, Gaetano Mele wrote:
Hello i'm an italian student. I am loading a file .sql with MonetDB Client. But, during the file's loading, happens that the Client suddenly stops working. Why does this happen? Thanks
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
The prompt will only return once the server has finished execution of all statements in your SQL script, and the client has output all results. S. Gaetano Mele <iker90@hotmail.it> wrote:
Date: Fri, 6 Dec 2013 17:46:48 +0100 From: Stefan.Manegold@cwi.nl To: users-list@monetdb.org Subject: Re: Load file MonetDB Client
What does "stops working" mean?
No CPU activity, but does not terminate? Terminates with error message (which)? Terminates without message?
In either case of termination, what's the exit code?
Stefan
----- Original Message -----
Thanks a lot, i did what you suggested me but, unfortunately, the
After that i digited this command:<C:/foodmart.sqlthe MonetDB Client remains open but there is no way to insert any command.It is blocked and there isn't any message. I hope to be explained. Gaetano problem
subsists.
Date: Fri, 6 Dec 2013 16:21:44 +0100 From: martin@monetdb.org To: users-list@monetdb.org Subject: Re: Load file MonetDB Client
Start loading your file in smaller steps to find the culprit
On 06/12/13 16:19, Gaetano Mele wrote:
Hello i'm an italian student. I am loading a file .sql with MonetDB Client. But, during the file's loading, happens that the Client suddenly stops working. Why does this happen? Thanks
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
------------------------------------------------------------------------
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sent from my Android phone with K-9 Mail. Please excuse my brevity.
Do I assume correctly that you verified that the server runs uninterruptedly and does not produce any error messages? Further, you might want to consider using mclient with options -i and -e to executed your SQL script statement by statement and echo each statement before execution. Then you see which statement triggers the "stop". S. Stefan Manegold <Stefan.Manegold@cwi.nl> wrote:
What does "stops working" mean?
No CPU activity, but does not terminate? Terminates with error message (which)? Terminates without message?
In either case of termination, what's the exit code?
Stefan
Thanks a lot, i did what you suggested me but, unfortunately, the
----- Original Message ----- problem
subsists.
Date: Fri, 6 Dec 2013 16:21:44 +0100 From: martin@monetdb.org To: users-list@monetdb.org Subject: Re: Load file MonetDB Client
Start loading your file in smaller steps to find the culprit
On 06/12/13 16:19, Gaetano Mele wrote:
Hello i'm an italian student. I am loading a file .sql with MonetDB Client. But, during the file's loading, happens that the Client suddenly stops working. Why does this happen? Thanks
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sent from my Android phone with K-9 Mail. Please excuse my brevity.
participants (3)
-
Gaetano Mele -
Martin Kersten -
Stefan Manegold