List:Cluster« Previous MessageNext Message »
From:Sabika Makhdoom Date:July 21 2012 1:04am
Subject:Re: Mysql Server not starting on datanode
View as plain text  
Looks like you are missing some of the default mysql tables. Did you run the installation
script?

Sabika

Life was meant to be mobile

On Jul 18, 2012, at 12:13 AM, prashant abhang <abhang_prashant@stripped> 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
Thread
Mysql Server not starting on datanodeprashant abhang18 Jul
  • Re: Mysql Server not starting on datanodeJohan Andersson18 Jul
  • Re: Mysql Server not starting on datanodeSabika Makhdoom21 Jul
    • Re: Mysql Server not starting on datanodeprashant abhang21 Jul