From: Johan Andersson Date: July 18 2012 11:38am Subject: Re: Mysql Server not starting on datanode List-Archive: http://lists.mysql.com/cluster/8377 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Hi, Did you run mysql_install_db? Johan Severalnines AB On Wed, Jul 18, 2012 at 9:13 AM, prashant abhang wrote: > Hi, > This is mysql-datanode error logs. I am not finding any solution. What could be the problem? > 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 /usr/local/mysql/data > 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 /usr/local/mysql/data/datanode2-mysqlcluster.pid ended