The steps are very simple...

1) I have created the MERGE TABLE

CREATE MERGE TABLE cubm_201909 AS (SELECT * FROM cub) WITH NO DATA;

2) I have attached the table:

ALTER TABLE cubm_201909 ADD TABLE cub8_20190901;

3) Wanted to REMOVE the table:

ALTER TABLE cubm_201909 DROP TABLE cub8_20190901;

This new MERGE table has inside 30 tables attached, none of them were removed.

We are using MonetDB v11.31.7 (Aug2018)

Thks Ariel

On Wed, Oct 23, 2019 at 1:32 PM ferreira < pedro.ferreira@monetdbsolutions.com> wrote:

Hello Ariel, this looks like a bug. Can you send the reproducible steps?

Best regards,

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

Hi! Can someone help me? Im trying to REMOVE a table from a merge table, when I run the command, it states "operation successful", but the table is NOT removed. Here you can see an example... I have run it several times, but the table is still there :(

[image: image.png]

---

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

Hi Ariel,

An ALTER TABLE cubm_201909 DROP TABLE cub8_20190901; command does not drop the table cub8_20190901 itself, only removes the partition table from a MERGE TABLE set.

To drop the cub8_20190901 itself use: DROP TABLE cub8_20190901;

See also: https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DataPartitioning

However running multiple "ALTER TABLE cubm_201909 DROP TABLE cub8_20190901;" commands sequentially should definitely give an error from the second one onwards. If not, that is a bug.

Try reproducing the issue in a clean new test schema or test database. If reproducable, log it in Bugzilla. If not reproducable, potentially your current data dictionary / database is corrupted. Make a dump of the database asap and recreate a second database using the dump.

Regards, Martin

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

The steps are very simple...

1. I have created the MERGE TABLE

   CREATE MERGE TABLE cubm_201909 AS (SELECT * FROM cub) WITH NO DATA;

2. I have attached the table:

   ALTER TABLE cubm_201909 ADD TABLE cub8_20190901;

3. Wanted to REMOVE the table:

   ALTER TABLE cubm_201909 DROP TABLE cub8_20190901;

This new MERGE table has inside 30 tables attached, none of them were removed.

We are using MonetDB v11.31.7 (Aug2018)

Thks Ariel

On Wed, Oct 23, 2019 at 1:32 PM ferreira <pedro.ferreira@monetdbsolutions.com mailto:pedro.ferreira@monetdbsolutions.com> wrote:

Hello Ariel, this looks like a bug. Can you send the reproducible steps?

Best regards,

Pedro

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

...

Hi!
Can someone help me?
Im trying to REMOVE a table from a merge table, when I run the
command, it states "operation successful", but the table is NOT
removed.
Here you can see an example... I have run it several times, but
the table is still there :(

image.png






_______________________________________________
users-list mailing list
users-list@monetdb.org  <mailto: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

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