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
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:
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
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
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
----- 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
participants (3)
-
Gaetano Mele
-
Martin Kersten
-
Stefan Manegold