Hi, Thank you for fast response. Here is what happed: I started the server, then he client, then created 3 tables with 300 fields all variable character with the record lenght 700 bytes - and that was done sequentially. Ran couple of queries, everything worked fine. Started creating another table with data from csv file. Started another client at the same time and submitted a query. The query was taking lots of time, so I've termianted the job.Started another client and all I saw was the blinking prompt. Terminated all the clients. Restarted the server - no problem. Restarted the client - blinking prompt, waited 6 hours to get the sql prompt with no luck. What I've noticed is that during the creation of the first table from csv file memory usage went up to 46GB, after It was complete the server did not release the memory. Is there any way to track what happened? How do I read the log files? I mean I can repeat the process. Thanks so much for the help. Dariusz. Stefan Manegold wrote:
Hi,
64-bit Windows (and a 64-bit MonetDB, I assume?) with 48 GB of memory does not sound too bad --- well, it depends on how large your tables are --- 100 millions rows long ans 300 fields wide, but how wide are the fields, i.e., what type are they?
I you successfully manages to load all the data, I see no obvious reasons why simple `select count(*) from table;` queries should not work as well ...
Could please be a bit more elaborate with discribing your problem?
Could you please recap in detail all the steps since installing MonetDB that eventually led to the current problems?
In particular, we'd need to know of any errors or other message that the server and/or client showed and of any cases where you killed either server or client in any way.
Do I understand you correctly, that you now manage to start the MonetDB/SQL server without problems getting a server console, and that then starting the MonetDB/SQL client (both started the default way, i.e., via the respective entries in the start menu?) yields no a window with a blinking prompt? Can you type on that prompt? If so, can you run a trivial query such as `select 1;`? Do you get an answer for that?
We'd at least need to know all this to get a vague idea what might be wrong --- better still, it would be great if you could give as a clear recipe how we could try to reproduce your problem ...
Stefan
On Tue, Jan 27, 2009 at 04:25:30PM -0500, dariuszs wrote:
Hi, Maybe I need a bigger box for what I'm doing. Right now it's 64 bit windows machine with lots of SAS storage and 48GB of memory. I've setup few tables with over 100 million records and about 300 fields in each table, and I'm running counts on those tables at the same time. Could you advise. Thanks. Dariusz.
Stefan Manegold wrote:
On Tue, Jan 27, 2009 at 03:50:02PM -0500, dariuszs wrote:
Hi, Can somebody help me with this one. I was running a very long query, decided to terminate that job. Now when I try to get the client all I see is blinking prompt. How do I get back the sql prompt? Thanks. Dariusz.
- did you terminate only the client or also the server? - is your server still running? if not, you need to restart it. if it is, is it idle or busy? in any case quitting the server and restarting it might be a good idea. note though, that starting the server might take some time, in case it need to reply the write-ahead logs.
(do I recall correctly, that you are using the Nov2008 version of MonetDB (or Nov2008-SP1 or Nov2008-SP2?) on Win32?
Stefan
------------------------------------------------------------------------------ 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