MySQL Bugs: #4588: Error 4336 returned when creating table

Bug #4588	Error 4336 returned when creating table
Submitted:	17 Jul 2004 19:22	Modified:	6 Mar 2006 10:55
Reporter:	Johan Andersson	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	mysql-4.1.12	OS:
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
Error messages are not written (only error codes are). Error messages should be written for EVERY error that happens. 

How to repeat:

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Error code 830    -  no error message printed.
Error code 4335 -  no error message printed (it is about autoincrement)
Error code 4336 -  no error message printed (it is about autoincrement)

Please write one testcase which produces this error

Error reporting has improved -- can this bug be closed now?  Johan?

I am encountering it 4.1.12 stable. two cases where it occured are:

Case 1:

I am trying to execute the following query on a cluster with 2 NDB and 2 API nodes and one API also being a mgmt node:

CREATE TABLE `companies` (

`company_id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`company_module` INT( 10 ) NOT NULL default 0,
`company_name` varchar( 100 ) default '',
`company_phone1` varchar( 30 ) default '',
`company_phone2` varchar( 30 ) default '',
`company_fax` varchar( 30 ) default '',
`company_address1` varchar( 50 ) default '',
`company_address2` varchar( 50 ) default '',
`company_city` varchar( 30 ) default '',
`company_state` varchar( 30 ) default '',
`company_zip` varchar( 11 ) default '',
`company_primary_url` varchar( 255 ) default '',
`company_owner` int( 11 ) NOT NULL default '0',
`company_description` text NOT NULL default '',
`company_type` int( 3 ) NOT NULL DEFAULT '0',
`company_email` varchar( 255 ) ,
`company_custom` LONGTEXT,
PRIMARY KEY ( `company_id` ) ,
KEY `idx_cpy1` ( `company_owner` )
)

The error is:
#1005 - Can't create table './dotproject/companies.frm' (errno: 4336) 

Case 2:

CREATE TABLE `forum_watch` (

`watch_user` int( 10 ) unsigned NOT NULL default '0',
`watch_forum` int( 10 ) unsigned default NULL ,
`watch_topic` int( 10 ) unsigned default NULL ,
KEY `idx_fw1` ( `watch_user` , `watch_forum` ) ,
KEY `idx_fw2` ( `watch_user` , `watch_topic` ) 
) COMMENT = 'Links users to the forums/messages they are watching' 

The error is:

#1005 - Can't create table './dotproject/forum_watch.frm' (errno: 4336).

Regards,
Mon

Thanks for your comment, will try to reproduce.

I have the bug too.
using cluster with 2 nbd et 1 api
I import same db shema with 21 tables. but not the same data.
after 29 databases insert, on the 30th database the 6th tables get the error. it crach the api too (it is running but the socket is not accessible and I cant connect).
(the primary key is auto_increment)

I hope it will help you.

Sorry I forgot the mysql version ! 5.0.18

Duplicate of 14509 ?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".