I cannot drop a table:
SQL Error [1815] [HY000]: Internal error: CAL0009: Drop table failed due to IDB-2006: 'chargify_tickets.flow_tickets' does not exist in Columnstore.
MariaDB [chargify_tickets]> show tables;
----------------------------
| Tables_in_chargify_tickets |
----------------------------
| flow_tickets |
----------------------------
1 row in set (0.001 sec)
I can see some difference between the information_schema Columstore table and the calpontsys.
MariaDB [(none)]> select count
from calpontsys.systable where tablename like 'flow%';
----------
| count |
----------
| 3 |
----------
1 row in set (0.011 sec)
MariaDB [(none)]> select count from information_schema.tables where `TABLE_NAME` like 'flow%';
----------
| count |
----------
| 1 |
----------
1 row in set (0.001 sec)
I need some help because it seems that this problem is blocking all MCS API work. I cannot write anything using the API anymore, even using other tables and databases.