Re: Bug with remote tables in transactions

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 https://github.com/monetdb/monetdb/issues - Jennie

On 30 Mar 2021, at 15:22, Ioannis Foufoulas 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 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