Yes. That was the problem. Thanks
From: Sabika Makhdoom <sabika.makhdoom@stripped>
To: prashant abhang <abhang_prashant@stripped>
Cc: "cluster@stripped" <cluster@stripped>
Sent: Saturday, 21 July 2012 6:34 AM
Subject: Re: Mysql Server not starting on datanode
Looks like you are missing some of the default mysql tables. Did you run the installation
Life was meant to be mobile
On Jul 18, 2012, at 12:13 AM, prashant abhang <abhang_prashant@stripped> wrote:
> This is mysql-datanode error logs. I am not finding any solution. What could be the
> Basically I started ndbd process,then I went to start mysql.server , But it
gave error as "MYSQL server pid could not be found!"
> 120718 12:23:28 mysqld_safe Starting mysqld daemon with databases from
> 120718 12:23:28 [Note] Plugin 'FEDERATED' is disabled.
> /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
> 120718 12:23:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade
to create it.
> 120718 12:23:28 InnoDB: The InnoDB memory heap is disabled
> 120718 12:23:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 120718 12:23:28 InnoDB: Compressed tables use zlib 1.2.3
> 120718 12:23:28 InnoDB: Using Linux native AIO
> 120718 12:23:28 InnoDB: Initializing buffer pool, size = 128.0M
> 120718 12:23:28 InnoDB: Completed initialization of buffer pool
> 120718 12:23:28 InnoDB: highest supported file format is Barracuda.
> InnoDB: The log sequence number in ibdata files does not match
> InnoDB: the log sequence number in the ib_logfiles!
> 120718 12:23:28 InnoDB: Database was not shut down normally!
> InnoDB: Starting crash recovery.
> InnoDB: Reading tablespace information from the .ibd files...
> InnoDB: Restoring possible half-written data pages from the doublewrite
> InnoDB: buffer...
> 120718 12:23:29 InnoDB: Waiting for the background threads to start
> 120718 12:23:30 InnoDB: 1.1.8 started; log sequence number 1595675
> 120718 12:24:05 [Warning] NDB: server id set to zero - changes logged to bin log with
server id zero will be logged with another server id by slave mysqlds
> 120718 12:24:05 [Note] Starting Cluster Binlog Thread
> 120718 12:24:05 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist
> 120718 12:24:05 mysqld_safe mysqld from pid file
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com/cluster
To unsubscribe: http://lists.mysql.com/cluster