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".

image.png

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

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 <pedro.ferreira@monetdbsolutions.com> 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;