Hi Jennie,
Any idea when Jul2015 is going to be released?
Regards,
Ashish
From: users-list on behalf of Ashish Singh
Reply-To: "users-list@monetdb.orgmailto:users-list@monetdb.org"
Date: Thursday, 9 July 2015 2:08 pm
To: "users-list@monetdb.orgmailto:users-list@monetdb.org"
Subject: Re: possible monetdb catalogue corruption and how to recover from it?
Hi Jennie,
Thanks for reply!
Drop table is a single statement transaction. Problem is not reproducible though easily. We encountered it after 150 iterations of drop and create table each happening in 1 hour interval but our ETL tool.
We did a restart and after this problem was resolved. I think database was able to do a cleanup.
What will be a recommended way of doing a health check on database catalogue when such problem happens as practically problem does happen right?
Thanks for the heads up on upcoming release we shall plan to upgrade to it.
Regards,
Ashish
From: users-list on behalf of Ying Zhang
Reply-To: "users-list@monetdb.orgmailto:users-list@monetdb.org"
Date: Thursday, 9 July 2015 1:27 pm
To: "users-list@monetdb.orgmailto:users-list@monetdb.org"
Subject: Re: possible monetdb catalogue corruption and how to recover from it?
Hai Ashish,
Do you happen to have any more detailed info of the crash? Such as was the drop table a single statement transaction, or part of a multi statement transaction? Is the problem reproducible?
Can you please try to restart the server to see if it helps cleaning up?
Jan2014 is a pretty old version. I'd highly recommend you to upgrade. Jul2015 will be released later this month.
Regards,
Jennie
On 08 Jul 2015, at 12:37, Ashish Kumar Singh