[prev in list] [next in list] [prev in thread] [next in thread]
List: monetdb-users
Subject: Re: [MonetDB-users] server crash/sql prompt
From: dariuszs <dariuszs () svnp ! com>
Date: 2009-01-28 16:26:41
Message-ID: 49808741.3020101 () svnp ! com
[Download RAW message or body]
Hi,
Yes I will try to reproduce the error, my question is what do I need to
set in order to capture that problem? Right now I don't see any logs or
activity anywhere. Thanks. Dariusz.
Stefan Manegold wrote:
> Hi,
>
> the most interesting question for us for now is what is your machine and/or
> mserver5 doing after the restart while the client cannot connect? Is
> mserver5 / the machine idle (no CPU load no I/O) or is there any
> (significant) activity (CPU load, I/O)?
>
> ... repeating the process on a virgin machine to see whether it is a
> reproducible problem would also provide us with valuable input ...
>
> Stefan
>
> On Wed, Jan 28, 2009 at 09:44:52AM -0500, dariuszs wrote:
>
>> 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
>>>>
>>>>
>>>>
>>>
>>>
>>
>> ------------------------------------------------------------------------------
>> 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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic