MySQL Forums
Forum List  »  NDB clusters

ndb_select_all not working ( No free node id found for mysqld(API) )
Posted by: Odis Yuck
Date: February 03, 2016 06:12AM

Hello. I'm trying to use ndb_select_all.

First of all, I have simple table

# mysql --skip-column-names -e "show create table test.replication"
+-------------+--------------------------------------------------------------------------------------------------+
| replication | CREATE TABLE `replication` (
`i` int(11) DEFAULT NULL
) ENGINE=ndbcluster DEFAULT CHARSET=utf8 |
+-------------+--------------------------------------------------------------------------------------------------+

And I have free API slots in ndb_mgm:

# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @192.168.108.7 (mysql-5.6.23 ndb-7.4.5, Nodegroup: 0, *)
id=2 @192.168.108.8 (mysql-5.6.23 ndb-7.4.5, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=49 @192.168.108.5 (mysql-5.6.23 ndb-7.4.5)
id=50 @192.168.108.6 (mysql-5.6.23 ndb-7.4.5)

[mysqld(API)] 10 node(s)
id=53 @192.168.108.5 (mysql-5.6.23 ndb-7.4.5)
id=54 @192.168.108.6 (mysql-5.6.23 ndb-7.4.5)
id=55 @192.168.108.6 (mysql-5.6.23 ndb-7.4.5)
id=56 @192.168.108.6 (mysql-5.6.23 ndb-7.4.5)
id=57 @192.168.108.6 (mysql-5.6.23 ndb-7.4.5)
id=58 @192.168.108.5 (mysql-5.6.23 ndb-7.4.5)
id=59 @192.168.108.5 (mysql-5.6.23 ndb-7.4.5)
id=60 @192.168.108.5 (mysql-5.6.23 ndb-7.4.5)
id=61 (not connected, accepting connect from any host)
id=62 (not connected, accepting connect from any host)


But when I'm trying to use ndb_select_all nothing happen. I have tried to start it with strace:


# strace ndb_select_all -c localhost -d test replication
execve("/usr/bin/ndb_select_all", ["ndb_select_all", "-c", "localhost", "-d", "test", "replication"], [/* 22 vars */]) = 0
brk(0) = 0x1743000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc74000
access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=29862, ...}) = 0
mmap(NULL, 29862, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f540dc6c000
close(3) = 0
open("/lib64/libpthread.so.0", O_RDONLY|O_CLOEXEC) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240l\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=141616, ...}) = 0
mmap(NULL, 2208864, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f540d839000
mprotect(0x7f540d84f000, 2097152, PROT_NONE) = 0
mmap(0x7f540da4f000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x16000) = 0x7f540da4f000
mmap(0x7f540da51000, 13408, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f540da51000
close(3) = 0
open("/lib64/libstdc++.so.6", O_RDONLY|O_CLOEXEC) = 3
read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\265\5\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=991744, ...}) = 0
mmap(NULL, 3171360, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f540d532000
mprotect(0x7f540d61b000, 2093056, PROT_NONE) = 0
mmap(0x7f540d81a000, 40960, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xe8000) = 0x7f540d81a000
mmap(0x7f540d824000, 82976, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f540d824000
close(3) = 0
open("/lib64/libm.so.6", O_RDONLY|O_CLOEXEC) = 3
read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260T\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=1141552, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc6b000
mmap(NULL, 3150168, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f540d230000
mprotect(0x7f540d331000, 2093056, PROT_NONE) = 0
mmap(0x7f540d530000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x100000) = 0x7f540d530000
close(3) = 0
open("/lib64/libgcc_s.so.1", O_RDONLY|O_CLOEXEC) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360*\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=88720, ...}) = 0
mmap(NULL, 2184192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f540d01a000
mprotect(0x7f540d02f000, 2093056, PROT_NONE) = 0
mmap(0x7f540d22e000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14000) = 0x7f540d22e000
close(3) = 0
open("/lib64/libc.so.6", O_RDONLY|O_CLOEXEC) = 3
read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\34\2\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=2107768, ...}) = 0
mmap(NULL, 3932736, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f540cc59000
mprotect(0x7f540ce0f000, 2097152, PROT_NONE) = 0
mmap(0x7f540d00f000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1b6000) = 0x7f540d00f000
mmap(0x7f540d015000, 16960, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f540d015000
close(3) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc6a000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc69000
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc67000
arch_prctl(ARCH_SET_FS, 0x7f540dc67740) = 0
mprotect(0x7f540d00f000, 16384, PROT_READ) = 0
mprotect(0x7f540d22e000, 4096, PROT_READ) = 0
mprotect(0x7f540d530000, 4096, PROT_READ) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc66000
mprotect(0x7f540d81a000, 32768, PROT_READ) = 0
mprotect(0x7f540da4f000, 4096, PROT_READ) = 0
mprotect(0x960000, 65536, PROT_READ) = 0
mprotect(0x7f540dc75000, 4096, PROT_READ) = 0
munmap(0x7f540dc6c000, 29862) = 0
set_tid_address(0x7f540dc67a10) = 30351
set_robust_list(0x7f540dc67a20, 24) = 0
rt_sigaction(SIGRTMIN, {0x7f540d83f780, [], SA_RESTORER|SA_SIGINFO, 0x7f540d848130}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x7f540d83f810, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x7f540d848130}, NULL, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM64_INFINITY}) = 0
brk(0) = 0x1743000
brk(0x1764000) = 0x1764000
brk(0) = 0x1764000
brk(0) = 0x1764000
brk(0x1785000) = 0x1785000
brk(0) = 0x1785000
brk(0x17a6000) = 0x17a6000
brk(0) = 0x17a6000
brk(0x17c7000) = 0x17c7000
openat(AT_FDCWD, "/sys/devices/system/cpu", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 3
getdents(3, /* 18 entries */, 32768) = 528
getdents(3, /* 0 entries */, 32768) = 0
close(3) = 0
open("/etc/localtime", O_RDONLY|O_CLOEXEC) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=118, ...}) = 0
fstat(3, {st_mode=S_IFREG|0644, st_size=118, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc73000
read(3, "TZif2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\1\0\0\0\1\0\0\0\0"..., 4096) = 118
lseek(3, -62, SEEK_CUR) = 56
read(3, "TZif2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\1\0\0\0\1\0\0\0\0"..., 4096) = 62
close(3) = 0
munmap(0x7f540dc73000, 4096) = 0
gettid() = 30351
stat("/etc/my.cnf", 0x7fff3397d250) = -1 ENOENT (No such file or directory)
stat("/etc/mysql/my.cnf", {st_mode=S_IFREG|0644, st_size=2162, ...}) = 0
open("/etc/mysql/my.cnf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=2162, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc73000
read(3, "# Configuration file for MyClust"..., 4096) = 2162
read(3, "", 4096) = 0
close(3) = 0
munmap(0x7f540dc73000, 4096) = 0
stat("/usr/etc/my.cnf", 0x7fff3397d250) = -1 ENOENT (No such file or directory)
stat("/root/.my.cnf", {st_mode=S_IFREG|0600, st_size=90, ...}) = 0
open("/root/.my.cnf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0600, st_size=90, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc73000
read(3, "[client]\nuser=root\nhost=localhos"..., 4096) = 90
read(3, "", 4096) = 0
read(3, "", 4096) = 0
close(3) = 0
munmap(0x7f540dc73000, 4096) = 0
stat("/root/.mylogin.cnf", 0x7fff3397d250) = -1 ENOENT (No such file or directory)
open("./Ndb.cfg", O_RDONLY) = -1 ENOENT (No such file or directory)
open("Ndb.cfg", O_RDONLY) = -1 ENOENT (No such file or directory)
rt_sigaction(SIGPIPE, {SIG_IGN, [PIPE], SA_RESTORER|SA_RESTART, 0x7f540cc8ea00}, {SIG_DFL, [], 0}, 8) = 0
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 3
open("/etc/resolv.conf", O_RDONLY|O_CLOEXEC) = 4
fstat(4, {st_mode=S_IFREG|0644, st_size=74, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc73000
read(4, "# Generated by NetworkManager\nse"..., 4096) = 74
read(4, "", 4096) = 0
close(4) = 0
munmap(0x7f540dc73000, 4096) = 0
socket(PF_LOCAL, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 4
connect(4, {sa_family=AF_LOCAL, sun_path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
close(4) = 0
socket(PF_LOCAL, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 4
connect(4, {sa_family=AF_LOCAL, sun_path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
close(4) = 0
open("/etc/nsswitch.conf", O_RDONLY|O_CLOEXEC) = 4
fstat(4, {st_mode=S_IFREG|0644, st_size=1728, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc73000
read(4, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1728
read(4, "", 4096) = 0
close(4) = 0
munmap(0x7f540dc73000, 4096) = 0
open("/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 4
fstat(4, {st_mode=S_IFREG|0644, st_size=29862, ...}) = 0
mmap(NULL, 29862, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7f540dc6c000
close(4) = 0
open("/lib64/libnss_files.so.2", O_RDONLY|O_CLOEXEC) = 4
read(4, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0@\"\0\0\0\0\0\0"..., 832) = 832
fstat(4, {st_mode=S_IFREG|0755, st_size=58288, ...}) = 0
mmap(NULL, 2144360, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 4, 0) = 0x7f540ca4d000
mprotect(0x7f540ca58000, 2093056, PROT_NONE) = 0
mmap(0x7f540cc57000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 4, 0xa000) = 0x7f540cc57000
close(4) = 0
mprotect(0x7f540cc57000, 4096, PROT_READ) = 0
munmap(0x7f540dc6c000, 29862) = 0
open("/etc/host.conf", O_RDONLY|O_CLOEXEC) = 4
fstat(4, {st_mode=S_IFREG|0644, st_size=9, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc73000
read(4, "multi on\n", 4096) = 9
read(4, "", 4096) = 0
close(4) = 0
munmap(0x7f540dc73000, 4096) = 0
futex(0x7f540d017a70, FUTEX_WAKE_PRIVATE, 2147483647) = 0
open("/etc/hosts", O_RDONLY|O_CLOEXEC) = 4
fstat(4, {st_mode=S_IFREG|0644, st_size=158, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f540dc73000
read(4, "127.0.0.1 localhost localhost."..., 4096) = 158
read(4, "", 4096) = 0
close(4) = 0
munmap(0x7f540dc73000, 4096) = 0
open("/etc/gai.conf", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
futex(0x7f540d016460, FUTEX_WAKE_PRIVATE, 2147483647) = 0
socket(PF_NETLINK, SOCK_RAW, 0) = 4
bind(4, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 0
getsockname(4, {sa_family=AF_NETLINK, pid=30351, groups=00000000}, [12]) = 0
sendto(4, "\24\0\0\0\26\0\1\3\230\351\261V\0\0\0\0\0\0\0\0", 20, 0, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 20
recvmsg(4, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"L\0\0\0\24\0\2\0\230\351\261V\217v\0\0\2\10\200\376\1\0\0\0\10\0\1\0\177\0\0\1"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 244
recvmsg(4, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"H\0\0\0\24\0\2\0\230\351\261V\217v\0\0\n\200\200\376\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 144
recvmsg(4, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"\24\0\0\0\3\0\2\0\230\351\261V\217v\0\0\0\0\0\0", 4096}], msg_controllen=0, msg_flags=0}, 0) = 20
close(4) = 0
socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 4
connect(4, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
getsockname(4, {sa_family=AF_INET, sin_port=htons(49449), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
close(4) = 0
fcntl(3, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(3, {sa_family=AF_INET, sin_port=htons(1186), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 EINPROGRESS (Operation now in progress)
poll([{fd=3, events=POLLIN|POLLPRI|POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
getsockopt(3, SOL_SOCKET, SO_ERROR, [0], [4]) = 0
fcntl(3, F_GETFL) = 0x802 (flags O_RDWR|O_NONBLOCK)
fcntl(3, F_SETFL, O_RDWR) = 0
getsockname(3, {sa_family=AF_INET, sin_port=htons(46135), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
poll([{fd=3, events=POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "get nodeid\n", 11, 0, NULL, 0) = 11
poll([{fd=3, events=POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "version: 459781\n", 16, 0, NULL, 0) = 16
poll([{fd=3, events=POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "nodetype: 1\n", 12, 0, NULL, 0) = 12
poll([{fd=3, events=POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "nodeid: 0\n", 10, 0, NULL, 0) = 10
poll([{fd=3, events=POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "user: mysqld\n", 13, 0, NULL, 0) = 13
poll([{fd=3, events=POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "password: mysqld\n", 17, 0, NULL, 0) = 17
poll([{fd=3, events=POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "public key: a public key\n", 25, 0, NULL, 0) = 25
poll([{fd=3, events=POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "endian: little\n", 15, 0, NULL, 0) = 15
poll([{fd=3, events=POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "name: ndb_select_all\n", 21, 0, NULL, 0) = 21
poll([{fd=3, events=POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "log_event: 0\n", 13, 0, NULL, 0) = 13
poll([{fd=3, events=POLLOUT}], 1, 30000) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, "\n", 1, 0, NULL, 0) = 1
poll([{fd=3, events=POLLIN}], 1, 30000) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "get nodeid reply\nresult: No free"..., 512, MSG_PEEK, NULL, NULL) = 82
recvfrom(3, "get nodeid reply\n", 17, 0, NULL, NULL) = 17
poll([{fd=3, events=POLLIN}], 1, 30000) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "result: No free node id found fo"..., 512, MSG_PEEK, NULL, NULL) = 65
recvfrom(3, "result: No free node id found fo"..., 47, 0, NULL, NULL) = 47
poll([{fd=3, events=POLLIN}], 1, 30000) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "error_code: 1101\n\n", 512, MSG_PEEK, NULL, NULL) = 18
recvfrom(3, "error_code: 1101\n", 17, 0, NULL, NULL) = 17
poll([{fd=3, events=POLLIN}], 1, 30000) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\n", 512, MSG_PEEK, NULL, NULL) = 1
recvfrom(3, "\n", 1, 0, NULL, NULL) = 1
select(0, NULL, NULL, NULL, {5, 0}^CProcess 30351 detached
<detached ...

After this program constantly receive same error, that's why I have killed it.

Thanks for help.

Options: ReplyQuote


Subject
Views
Written By
Posted
ndb_select_all not working ( No free node id found for mysqld(API) )
2286
February 03, 2016 06:12AM


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.