MySQL Forums
Forum List  »  NDB clusters

Mysqld Start failed. * 22: Error * The process has wrong type. Expected a DB process.: Permanent error: Application error
Posted by: Timothy Lee
Date: December 09, 2014 08:53PM

Hi I can't seem to start the SQLD (API). However I can log into the mysql of this node. Can anyone help?

######### used this command to start sqld node 61
[root@SQL1 ~]# /usr/bin/mysqld_safe --defaults-file=/opt/SQL/61/my.cnf --user=mysql --explicit_defaults_for_timestamp &
[2] 2572
[root@SQL1 ~]# 141210 10:50:26 mysqld_safe Logging to '/opt/SQL/61/mysqld.61.err'.
141210 10:50:26 mysqld_safe A mysqld process already exists

[2]+ Exit 1 /usr/bin/mysqld_safe --defaults-file=/opt/SQL/61/my.cnf --user=mysql --explicit_defaults_for_timestamp

######### check if its started
[root@SQL1 ~]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @192.168.168.179 (mysql-5.6.15 ndb-7.3.4, Nodegroup: 0, *)
id=2 @192.168.168.185 (mysql-5.6.15 ndb-7.3.4, Nodegroup: 0, *)

[ndb_mgmd(MGM)] 1 node(s)
id=51 @192.168.168.187 (mysql-5.6.15 ndb-7.3.4)

[mysqld(API)] 3 node(s)
id=61 (not connected, accepting connect from 192.168.168.187)
id=63 (not connected, accepting connect from 192.168.168.174)
id=65 (not connected, accepting connect from any host)

ndb_mgm> 61 start
Start failed.
* 22: Error
* The process has wrong type. Expected a DB process.: Permanent error: Application error

ndb_mgm>
[root@SQL1 ~]# ^C
[root@SQL1 ~]# mysql -u root -p -S /opt/SQL/61/mysql.socket
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.15-ndb-7.3.4-cluster-commercial-advanced MySQL Cluster Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.