Bug #30697 Slave gives bad error message on create table when not connected to cluster
Submitted: 29 Aug 2007 16:24
Reporter: Jonathan Miller Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Replication Severity:S3 (Non-critical)
Version:mysql-5.1-telco-6.2 OS:Linux (64 bit)
Assigned to: Assigned Account CPU Architecture:Any
Tags: 5.1.20-ndb-6.2.4
Triage: Triaged: D4 (Minor) / R6 (Needs Assessment) / E6 (Needs Assessment)

[29 Aug 2007 16:24] Jonathan Miller
Description:
Last_Errno: 1486
                   Last_Error: Error 'For the partitioned engine it is necessary to define all partitions' on query. Default database: 'test'. Query: 'create table t1(c1 INT)engine=ndb'

70829 17:08:15 [ERROR] Slave: Error 'For the partitioned engine it is necessary to define all partitions' on query. Default database: 'test'. Query: 'create table t1(c1 INT)engine=ndb', Error_code: 1486
070829 17:08:15 [Warning] Slave: Ndb might have problems storing the max amount of rows specified Error_code: 1105
070829 17:08:15 [Warning] Slave: For the partitioned engine it is necessary to define all partitions Error_code: 1486
070829 17:08:15 [Warning] Slave: Unknown error Error_code: 1105
070829 17:08:15 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'ndb14-bin.000001' position 106

How to repeat:
Start a MySQLD with the following in the my.cnf that does not point to a real cluster.

ndbcluster                      # run NDB engine
ndb-connectstring=XXXXX:PPPPP  # location of MGM node

NOTE: Replace X's and P's with some real number value

Suggested fix:
Should return a 4009