Mysqld Start failed. * 22: Error * The process has wrong type. Expected a DB process.: Permanent error: Application error
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>
Subject
Views
Written By
Posted
Mysqld Start failed. * 22: Error * The process has wrong type. Expected a DB process.: Permanent error: Application error
4132
December 09, 2014 08:53PM
1226
December 10, 2014 05:49AM
1534
December 10, 2014 08:51PM
972
December 10, 2014 08:53PM
1080
December 11, 2014 04:09AM
931
December 11, 2014 04:49AM
1219
December 11, 2014 09:04PM
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.