List:Cluster« Previous MessageNext Message »
From:Johan Andersson Date:July 18 2012 11:38am
Subject:Re: Mysql Server not starting on datanode
View as plain text  
Hi,

Did you run mysql_install_db?

Johan
Severalnines AB


On Wed, Jul 18, 2012 at 9: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