ERROR 1005 (HY000) at line 4092: Can't create table './bm4/DBPatches.frm' (errno: 4242)
Hello,
I am trying to restore MySQL database on cluster for third day already ;) I was able to find solutions for all previouse errors, but not for this one:
[root@sql root]# /usr/local/mysql/bin/mysql bm4< /root/bm4.sql
ERROR 1005 (HY000) at line 4092: Can't create table './bm4/DBPatches.frm' (errno: 4242)
I didn't find desription for this error:
[root@sql root]# /usr/local/mysql/bin/perror 4242
Illegal error code: 4242
Problem table structure:
CREATE TABLE DBPatches (
ID int(11) NOT NULL auto_increment,
Tag varchar(80) NOT NULL default '',
Patch varchar(255) NOT NULL default '',
Time datetime NOT NULL default '0000-00-00 00:00:00',
Result int(11) NOT NULL default '0',
PRIMARY KEY (ID),
UNIQUE KEY Tag (Tag,Patch)
) ENGINE=NDBCLUSTER;
MySQL Cluster structure:
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.63.213.100 (Version: 4.1.12, Nodegroup: 0, Master)
id=3 @10.63.213.101 (Version: 4.1.12, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.63.213.102 (Version: 4.1.12)
[mysqld(API)] 1 node(s)
id=4 @10.63.213.103 (Version: 4.1.12)
ndb_mgm>
Config.ini:
[NDBD DEFAULT]
NoOfReplicas= 2
DataMemory= 80M
IndexMemory= 52M
MaxNoOfAttributes = 10000
MaxNoOfOrderedIndexes=500
MaxNoOfUniqueHashIndexes=500
MaxNoOfTables=250
[NDB_MGMD]
HostName= 10.63.213.102
DataDir= /var/lib/mysql-cluster
[NDBD]
HostName= 10.63.213.100
DataDir= /usr/local/mysql/data
[NDBD]
HostName= 10.63.213.101
DataDir= /usr/local/mysql/data
[MYSQLD]
HostName= 10.63.213.103
Please advise ;)
Subject
Views
Written By
Posted
ERROR 1005 (HY000) at line 4092: Can't create table './bm4/DBPatches.frm' (errno: 4242)
6004
May 26, 2005 09:39PM
2910
May 26, 2005 10:32PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.