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

[17 Jul 2004 19:22] Johan Andersson
Description:
Error messages are not written (only error codes are). Error messages should be written for EVERY error that happens. 

How to repeat:
[19 Jul 2004 10:51] Magnus Blåudd
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.
[23 Jul 2004 15:00] Johan Andersson
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)
[28 Jul 2004 1:25] Jonas Oreland
Please write one testcase which produces this error
[4 Nov 2004 20:09] John David Duncan
Error reporting has improved -- can this bug be closed now?  Johan?
[18 Jul 2005 5:36] mon lax
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
[15 Aug 2005 7:21] Magnus Blåudd
Thanks for your comment, will try to reproduce.
[23 Jan 2006 13:41] Laurent NEGRIER
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.
[23 Jan 2006 13:43] Laurent NEGRIER
Sorry I forgot the mysql version ! 5.0.18
[6 Feb 2006 10:55] Jonas Oreland
Duplicate of 14509 ?
[7 Mar 2006 0:00] Bugs System
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".