İstediğiniz bilgileri aşağıya ekledim.
Mysql ve Clsuter sürümleri bu şekilde; mysql-5.5.20 ndb-7.2.5
Muhtemelen eski sürümdeki bug'a denk geldim o zaman.
Bu durumda ne yapmam lazım tüm cluster'ı yeniden başlatamama. Yarım
günlük zaman kaybına sebep olur.
ndb_mgm> 1 status
Node 1: connected (Version 7.2.5)
ndb_mgm> 2 status
Node 2: started (mysql-5.5.20 ndb-7.2.5)
ndb_mgm> 3 status
Node 3: started (mysql-5.5.20 ndb-7.2.5)
ndb_mgm> 4 status
Node 4: started (mysql-5.5.20 ndb-7.2.5)
ndb_mgm> 5 status
Node 5: started (mysql-5.5.20 ndb-7.2.5)
ndb_mgm> 6 status
Node 6: started (mysql-5.5.20 ndb-7.2.5)
ndb_mgm> 7 status
Node 7: started (mysql-5.5.20 ndb-7.2.5)
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]6 node(s)
[email protected] (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0)
[email protected] (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0, Master)
[email protected] (mysql-5.5.20 ndb-7.2.5, Nodegroup: 1)
[email protected] (mysql-5.5.20 ndb-7.2.5, Nodegroup: 1)
[email protected] (mysql-5.5.20 ndb-7.2.5, Nodegroup: 2)
[email protected] (mysql-5.5.20 ndb-7.2.5, Nodegroup: 2)
[ndb_mgmd(MGM)]2 node(s)
[email protected] (mysql-5.5.20 ndb-7.2.5)
id=8 (not connected, accepting connect from xxx.xxx.xxx.111)
[mysqld(API)]94 node(s)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
id=47 (not connected, accepting connect from any host)
id=48 (not connected, accepting connect from any host)
id=49 (not connected, accepting connect from any host)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
[email protected] (mysql-5.5.20 ndb-7.2.5)
id=60 (not connected, accepting connect from any host)
id=61 (not connected, accepting connect from any host)
id=62 (not connected, accepting connect from any host)
id=63 (not connected, accepting connect from any host)
id=64 (not connected, accepting connect from any host)
id=65 (not connected, accepting connect from any host)
id=66 (not connected, accepting connect from any host)
id=67 (not connected, accepting connect from any host)
id=68 (not connected, accepting connect from any host)
id=69 (not connected, accepting connect from any host)
id=70 (not connected, accepting connect from any host)
id=71 (not connected, accepting connect from any host)
id=72 (not connected, accepting connect from any host)
id=73 (not connected, accepting connect from any host)
id=74 (not connected, accepting connect from any host)
id=75 (not connected, accepting connect from any host)
id=76 (not connected, accepting connect from any host)
id=77 (not connected, accepting connect from any host)
id=78 (not connected, accepting connect from any host)
id=79 (not connected, accepting connect from any host)
id=80 (not connected, accepting connect from any host)
id=81 (not connected, accepting connect from any host)
id=82 (not connected, accepting connect from any host)
id=83 (not connected, accepting connect from any host)
id=84 (not connected, accepting connect from any host)
id=85 (not connected, accepting connect from any host)
id=86 (not connected, accepting connect from any host)
id=87 (not connected, accepting connect from any host)
id=88 (not connected, accepting connect from any host)
id=89 (not connected, accepting connect from any host)
id=90 (not connected, accepting connect from any host)
id=91 (not connected, accepting connect from any host)
id=92 (not connected, accepting connect from any host)
id=93 (not connected, accepting connect from any host)
id=94 (not connected, accepting connect from any host)
id=95 (not connected, accepting connect from any host)
id=96 (not connected, accepting connect from any host)
id=97 (not connected, accepting connect from any host)
id=98 (not connected, accepting connect from any host)
id=99 (not connected, accepting connect from any host)
id=100 (not connected, accepting connect from any host)
id=101 (not connected, accepting connect from any host)
id=102 (not connected, accepting connect from any host)
Saygılarımla,
Sencer HAMARAT
2016-10-11 12:55 GMT+03:00 Onur Yalazı <[email protected]
<mailto:[email protected]>>:
Merhaba,
Bu hatayı alıyorsanız, sisteminizin tam olarak çalıştığından emin olmanız
da fayda var.
Tüm cluster'ın up olduğundan emin misiniz? Node Recovery durumunda olan
nodeunuz olabilir.
Bir de cluster detaylarını vermeniz ve hatta, management nodedan status
komutu sonucunu vermeniz faydalı olabilir.
- Error code 899 is considered a TEMPORARY error, clients should retry
(potentially after a small delay) on encountering it (like with all temp errors)
- Error code 899 may be returned on INSERT operations during node recovery.
- Error code 899 may be returned on INSERT operations on DD tables in 6.3
- All other known causes of error 899 are fixed, but may still be present
in older versions
- There may be currently unknown causes of error 899.
On 11/10/2016 12:18, Sencer Hamarat wrote:
Merhabalar,
MySQL cluster durduk yerde bu hatayı vermeye başladı. Internette
araştırdım ancak kesin bir çözüm bulamadım.
Bu hatanın neden kaynaklandığını bulmama yardım edebilecek kimse
ya da sorunu nasıl ekarte edeceğimi bilen kimse var mı?
Saygılarımla,
Sencer HAMARAT
_______________________________________________
Linux-sunucu E-Posta Listesi
[email protected]
<mailto:[email protected]>
Liste kurallarınıhttp://liste.linux.org.tr/kurallar.php
<http://liste.linux.org.tr/kurallar.php> bağlantısından okuyabilirsiniz;
Bu Listede neden bulunduğunuzu bilmiyorsanız veya artık bu listeden gelen
e-postaları almak istemiyorsanız aşağıdaki bağlantı adresini kullanarak 1
dakika içinde üyeliğinizi sonlandırabilirsiniz.
https://liste.linux.org.tr/mailman/listinfo/linux-sunucu
<https://liste.linux.org.tr/mailman/listinfo/linux-sunucu>
_______________________________________________ Linux-sunucu
E-Posta Listesi [email protected]
<mailto:[email protected]> Liste kurallarını
http://liste.linux.org.tr/kurallar.php
<http://liste.linux.org.tr/kurallar.php> bağlantısından
okuyabilirsiniz; Bu Listede neden bulunduğunuzu bilmiyorsanız veya
artık bu listeden gelen e-postaları almak istemiyorsanız aşağıdaki
bağlantı adresini kullanarak 1 dakika içinde üyeliğinizi
sonlandırabilirsiniz.
https://liste.linux.org.tr/mailman/listinfo/linux-sunucu
<https://liste.linux.org.tr/mailman/listinfo/linux-sunucu>
_______________________________________________
Linux-sunucu E-Posta Listesi
[email protected]
Liste kurallarını http://liste.linux.org.tr/kurallar.php bağlantısından
okuyabilirsiniz;
Bu Listede neden bulunduğunuzu bilmiyorsanız veya artık bu listeden gelen
e-postaları almak istemiyorsanız aşağıdaki bağlantı adresini kullanarak 1
dakika içinde üyeliğinizi sonlandırabilirsiniz.
https://liste.linux.org.tr/mailman/listinfo/linux-sunucu
