Re: MERGE TABLE - CANNOT DROP PARTITION

On 24 Oct 2019, at 13:54, Ariel Abadi wrote:

Hi ! I tried to upgrade from 11.31.7 to the latest version. In order to do that (as I learned in the past, I did it step by step), this means that I have upgraded from one version to another.

11.31.7 -> 11.31.11 OK! 11.31.11 -> 11.31.13 OK!

11.31.13 -> 11.33.3 --> ERROR! The database never started, I run the monetdbd xxx, and started with no problem. BUT when I tried to start the DB (monetdb start -a) ... it never started (it kept thinking for a long time). Even Though I saw it was running .... seems to be "hanged".

After a while I killed it via kill -9 xxxx ... And when I started again I found the following error which made my DB unusable. 2019-10-24 07:22:25 ERR cli_mx[4277]: #main thread:!ERROR:ParseException:SQLparser:42000!DROP PROCEDURE: no such procedure 'querylog_enable' (smallint(16)) 2019-10-24 07:22:25 ERR cli_mx[4277]: !ParseException:SQLparser:42000!DROP PROCEDURE: no such procedure 'querylog_enable' (smallint(16)) 2019-10-24 07:22:25 MSG cli_mx[4277]: # MonetDB/SQL module loaded

Hai Ariel, Are you still having problem upgrading your database (please don’t forget to make backups beforehand)? The error messages look like your previous upgrade was unfinished, but it might have partial effect on your database. So, when you start it again, the upgrade code is trying to do its work again. The errors don’t look critical to me, since it tried to remove something that not there any more. Since the log said at the end that "MonetDB/SQL module loaded”, it seems to have finished. What’s the status of your database now? Regards, Jennie

Is something Im doing wrong ?

I need to upgrade this DB, cause is too big to start doing dump & restore. Any help will be appreciated.

Thks Ariel

On Wed, Oct 23, 2019 at 1:54 PM ferreira wrote: Ok, Aug2018 is an old version, can you upgrade to Apr2019?

On 10/23/19 6:42 PM, Ariel Abadi wrote:

...

ALTER TABLE cubm_201909 DROP TABLE cub8_20190901;

---

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list