Thanks a lot.
But since the time I asked the question the DB has gone into a state where it keeps logging
2013-02-11 04:12:40 ERR merovingian[15380]: client error: database 'msearch_stats_db' has crashed after starting, manual intervention needed, check monetdbd's logfile for details

in merovingian.log.

Health is 1%.

What can I do at this stage?

Thanks and Regards,
Tapomay.


From: Fabian Groffen <fabian@monetdb.org>
To: users-list@monetdb.org
Sent: Sunday, February 10, 2013 11:33 PM
Subject: Re: monetdb status health

On 10-02-2013 09:44:09 -0800, Tapomay Dey wrote:
> My questions are simple: 
>
> what causes crashes?

The mserver5 (monetdb database) terminates in such a way that it can
not be considered a clean shutdown, this is usually the case when the
program gets terminated due to a condition that makes further execution
impossible, e.g. memory faults.  These are almost always program errors.

> what is health?

Health is the percentage of start-stop sequences compared to the number
of times the database was actually started.  E.g. how many times a start
was followed by a clean shutdown (hence no crash).

> how do we stop health from degrading?

You can't, a database that crashes, and keeps on doing so will cause the
health of the database to degrade.

> Following is the status of my db-
>   start count: 140
>   stop count: 1
>   crash count: 138

So, essentially, every time you start your database, it never reaches a
point where you stop it cleanly, but instead your database crashes all
the time.


--
Fabian Groffen                              fabian@monetdb.org
column-store pioneer              http://www.monetdb.org/Home
_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list