Bug #17013 2 data, 2 api nodes, 2nd API to come up complains about missing frm
Submitted: 1 Feb 2006 16:14 Modified: 1 Feb 2006 16:54
Reporter: Arne Hüggenberg Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.1-new OS:Linux (Gentoo Linux AMD64)
Assigned to: Assigned Account CPU Architecture:Any

[1 Feb 2006 16:14] Arne Hüggenberg
Description:
2 nodes, each running 1 API and 1 NDB

config.ini:
[NDBD DEFAULT]
NoOfReplicas=2
MaxNoOfConcurrentOperations=200000
DataMemory=3000M
IndexMemory=256M
TimeBetweenWatchDogCheck=3000
TransactionDeadlockDetectionTimeout=500
MaxNoOfOrderedIndexes=2048
MaxNoOfUniqueHashIndexes=2048
MaxNoOfAttributes=10000
MaxNoOfTables=2500
NoOfDiskPagesToDiskAfterRestartTUP=125
NoOfDiskPagesToDiskAfterRestartACC=23
NoOfFragmentLogFiles=32
TimeBetweenLocalCheckpoints=20
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD]
HostName=xxx.xxx.xxx.xxx
[NDBD]
HostName=xxx.xxx.xxx.xxx            # the IP of the FIRST SERVER
DataDir= /var/lib/mysql-cluster
[NDBD]
HostName=xxx.xxx.xxx.xxx            # the IP of the SECOND SERVER
DataDir=/var/lib/mysql-cluster
# 2 MySQL Clients
# I personally leave this blank to allow rapid changes of the mysql clients;
# you can enter the hostnames of the above two servers here. I suggest you dont.
[MYSQLD]
[MYSQLD]

ndbd --initial on both nodes
start 1st API node
start 2nd API node
check 2nd API node mysqld.err
060201 16:43:55 [Note] /usr/sbin/mysqld-501: ready for connections.
Version: '5.1.6-alpha'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gento
o Linux mysql-5.1.6_alpha-r30
060201 16:43:55 [Note] NDB: missing frm for cluster_replication.apply_status, di
scovering...
060201 16:43:55 [Note] NDB: missing frm for cluster_replication.schema, discover
ing...

the NDB notices repeat every second, the logfile grows

Workaround: connect to api, select on affected tables, missing frm automagically appears

How to repeat:
start cluster, check logfile of 2nd API to come up
[1 Feb 2006 16:16] Arne Hüggenberg
category cluster not available when initially reporting
[1 Feb 2006 16:47] Jonas Oreland
This looks like http://bugs.mysql.com/bug.php?id=16851
Which has been fixed.
[1 Feb 2006 16:54] Arne Hüggenberg
agreed