MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to drop empty tablespace

2726429Apr 18 2016 — edited May 9 2016

I'm not able to drop a tablespace in a mysql cluster 7.4.6.

First step: drop database attached to datafiles;

DROP DATABASE LISUELLA;

-- Show list of datafiles;

SELECT FILE_NAME, FILE_TYPE, TABLESPACE_NAME

FROM INFORMATION_SCHEMA.files

WHERE tablespace_name='TBS_CENAM_LISUELLA' ;

+---------------------------+------------+--------------------+

| FILE_NAME | FILE_TYPE | TABLESPACE_NAME |

+---------------------------+------------+--------------------+

| TBS_CENAM_LISUELLA_01.dat | DATAFILE | TBS_CENAM_LISUELLA |

| TBS_CENAM_LISUELLA_02.dat | DATAFILE | TBS_CENAM_LISUELLA |

| NULL | TABLESPACE | TBS_CENAM_LISUELLA |

+---------------------------+------------+--------------------+

9 rows in set (0.05 sec)

-- drop datafile datafiles;

ALTER TABLESPACE TBS_CENAM_LISUELLA

DROP DATAFILE 'TBS_CENAM_LISUELLA_01.dat'

ENGINE=NDB;

ALTER TABLESPACE TBS_CENAM_LISUELLA

DROP DATAFILE 'TBS_CENAM_LISUELLA_02.dat'

ENGINE=NDB;

-- drop tablespace

DROP TABLESPACE TBS_CENAM_LISUELLA ENGINE NDBCLUSTER;

ERROR 1529 (HY000): Failed to drop TABLESPACE

mysql> show warnings;

+---------+------+-----------------------------------------------------------------+

| Level | Code | Message |

+---------+------+-----------------------------------------------------------------+

| Warning | 1296 | Got error 768 'Cant drop filegroup, filegroup is used' from NDB |

| Error | 1529 | Failed to drop TABLESPACE |

+---------+------+-----------------------------------------------------------------+

2 rows in set (0.00 sec)

How I can drop this tablespace?

Thank you

Bests

Antonio Boi

Added on Apr 18 2016

2 comments

1,172 views