List:Cluster« Previous MessageNext Message »
From:prashant abhang Date:July 18 2012 7:13am
Subject:Mysql Server not starting on datanode
View as plain text  
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