I tried to do it a couple of times.
Eventhough the message in module loaded.. the truth is that the database is NOT starting anymore. As per somebody else information I would need to dump and restore the entire database which for us is a very painful process.
The worst thing, is that we had the chance to upgrade a couple of versions (now we are on 11.31.13) and we are still having the same problem for removing a partition from a Merged Table. So, my doubt/concern is I will do the whole dump and restore, on the new version... and I will have to cross my fingers to see if the problem is still there....
Thks
Ariel
> On 24 Oct 2019, at 13:54, Ariel Abadi <aabadi@starbi.com> 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".
>
> <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
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 <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;
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list