I can reproduce this error with Oct2020-SP3:

sql>CREATE REMOTE TABLE rmt_tbl (id int, name varchar(20)) ON 'mapi:monetdb://remote.host.url:50000/dbname/scm1/l_tbl';
operation successful
sql>BEGIN TRANSACTION;
auto commit mode: off
sql>DROP TABLE  rmt_tbl;
operation successful
sql>ROLLBACK;
auto commit mode: on
sql>DROP TABLE if exists rmt_tbl;
#2021-03-30 16:25:03: client149: createExceptionInternal: !ERROR: MALException:deleteRemoteTableCredentials:no such table: 'sys.rmt_tbl'
no such table: 'sys.rmt_tbl'
sql>select * from tables where name ilike '%rmt%';
+------+---------+-----------+--------------------------------------------------------+------+--------+---------------+--------+-----------+
| id   | name    | schema_id | query                                                  | type | system | commit_action | access | temporary |
+======+=========+===========+========================================================+======+========+===============+========+===========+
| 8682 | rmt_tbl |      2000 | mapi:monetdb://remote.host.url:50000/dbname/scm1/l_tbl |    5 | false  |             0 |      0 |         0 |
+------+---------+-----------+--------------------------------------------------------+------+--------+---------------+--------+-----------+
1 tuple

Please file a bug repot at https://github.com/monetdb/monetdb/issues

- Jennie


On 30 Mar 2021, at 15:22, Ioannis Foufoulas <johnfouf@di.uoa.gr> wrote:

Hi, 

We encounter a bug with remote tables as part of transactions:

sql>CREATE REMOTE TABLE rmt_tbl (id int, name varchar(20)) ON ‘mapi:monetdb://remote.host.url:50000/dbname/scm1/l_tbl’;
operation successful
sql>BEGIN TRANSACTION;
auto commit mode: off
sql>DROP TABLE  rmt_tbl;
operation successful
sql>ROLLBACK;
auto commit mode: on
sql>DROP TABLE if exists rmt_tbl;
no such table: ‘sys.rmt_tbl’
sql>

It seems that after rollback the table exists in the catalogue but it does not actually exists so that drop table fails even if we have ‘if exists’
This happens only with remote tables. 

Best,
Yannis



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