Bug #31714 No usefull feedback when trying to create tablespace with nonexistant log group
Submitted: 19 Oct 2007 11:35 Modified: 26 Oct 2007 17:00
Reporter: Hartmut Holzgraefe Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Disk Data Severity:S3 (Non-critical)
Version:mysql-5.1 OS:Linux
Assigned to: CPU Architecture:Any
Tags: 5.1.22

[19 Oct 2007 11:35] Hartmut Holzgraefe
Description:
Try to create a table space with nonexistant log group or wrong log group name and the only error message that comes back is "Failed to create TABLESPACE" without any hint *why* it actually failed.

How to repeat:
on a fresh installation try:

> CREATE TABLESPACE ts_1
       ADD DATAFILE 'ts_1.dat'
       USE LOGFILE GROUP no_such_log_group
       INITIAL_SIZE 256M
       EXTENT_SIZE 128M
       ENGINE NDB;
ERROR 1525 (HY000): Failed to create TABLESPACE

> show warnings;
+-------+------+-----------------------------+
| Level | Code | Message                     |
+-------+------+-----------------------------+
| Error | 1525 | Failed to create TABLESPACE |
+-------+------+-----------------------------+
1 row in set (0.00 sec)

Suggested fix:
Add at least a warning about the nonexistant log group