Issues with creating/dropping tables

3 posts / 0 new
Last post
david.bell
david.bell's picture
Offline
Last seen: 1 month 2 weeks ago
Joined: Jul 23 2014
Junior Boarder

Posts: 2

david Garrison
Issues with creating/dropping tables
I have my UM running on machine sql03 with two other PM machines. I'm having a few issues with creating/dropping tables.
sync.syncevents was a table that I created a few weeks ago and had no issues last week, and I can still see it in MySQL Workbench.

root@sql03:~# idbmysql

...
mysql> show databases;
+---------------------+
| Database            |
+---------------------+
| information_schema  |
| calpontsys          |
| infinidb_querystats |
| infinidb_vtable     |
| mysql               |
| sync                |
| test                |
+---------------------+
8 rows in set (0.00 sec)
 
mysql> use sync
Database changed
mysql> drop table syncevents;
ERROR 122 (HY000): CAL0009: Drop table failed due to  IDB-2006: 'sync.syncevents' does not exist in InfiniDB.
 
mysql> create table syncevents(c1 int, c2 int) engine=infinidb;
ERROR 1050 (42S01): Table 'syncevents' already exists
 
mysql> SELECT * FROM calpontsys.systable;
Empty set (0.02 sec)
 
mysql> SELECT * FROM calpontsys.syscolumn;
Empty set (0.02 sec)
 
mysql> create table test(c1 int, c2 int) engine=infinidb;
ERROR 122 (HY000): CAL0009: Error while calling getSysCatDBRoot
 
Any assistance with any of these issues would be appreciated.
radams
radams's picture
Offline
Last seen: 2 days 18 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
Issues with creating/dropping tables

 

 

Hi David,

 

The error "'sync.syncevents' does not exist in InfiniDB" is indicating the table is defined in the mysql front end but it does not

exist in the backend. The "Error while calling getSysCatDBRoot" is also indicating the system catalog does not exit. Check and see if the /usr/local/Calpont/data1 is available on the system. The system catalog would be on data1.

 

Thanks,

 

Robert

 

 

david.bell
david.bell's picture
Offline
Last seen: 1 month 2 weeks ago
Joined: Jul 23 2014
Junior Boarder

Posts: 2

david Garrison
Removing table from mysql frontend

[quote=radams]

 The error "'sync.syncevents' does not exist in InfiniDB" is indicating the table is defined in the mysql front end but it does notexist in the backend. 

[/quote]

 

I've fixed the System Catalog issue, and can now create other tables, but how can I remove this table from the mysql frontend?