1. BTW I am running a non-released revision of Feb13 branch. Could this be the reason for such a crash?
I am doing so coz I need a fix that Niels had made for fixing a concurrency issue that caused duplicate keys.
Also planning to implement group_concat UDF as per the changed semantics of Feb13. I already have a partially running one for Oct12.
2. As the DB crashes each time I try to start it I think its a perfect state to gather more diagnostics. How do I do so?
I really need that a DB never reaches a non-recoverable state.
My setup is such that there would be non-stop Inserts/updates into the DB 24/7.
Thanks and Regards,
Tapomay.
________________________________
From: Tapomay Dey
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 _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list