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: | |
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
[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".