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: 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;