[Linux-sunucu] Re: "Got temporary error 899 'Rowid already allocated' from NDBCLUSTER"
Merhaba, MysqlCluster konusunda yeni olduğunuzu tahmin ediyorum. Rolling Restart yapabilirsiniz. Upgrade süreçlerini inceleyebilirsiniz. On 10/11/2016 04:50 PM, Sencer Hamarat wrote: İ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) id=2...@xxx.xxx.xxx.101 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0) id=3...@xxx.xxx.xxx.102 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0, Master) id=4...@xxx.xxx.xxx.103 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 1) id=5...@xxx.xxx.xxx.104 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 1) id=6...@xxx.xxx.xxx.105 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 2) id=7...@xxx.xxx.xxx.106 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 2) [ndb_mgmd(MGM)]2 node(s) id=1...@xxx.xxx.xxx.100 (mysql-5.5.20 ndb-7.2.5) id=8 (not connected, accepting connect from xxx.xxx.xxx.111) [mysqld(API)]94 node(s) id=9...@xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=1...@xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=1...@xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=1...@xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=1...@xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=1...@xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=1...@xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=1...@xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=1...@xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=1...@xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=1...@xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=2...@xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=2...@xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=2...@xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=2...@xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=2...@xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=2...@xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=2...@xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=2...@xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=2...@xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=2...@xxx.xxx.xxx.113 (mysql-5.5.20 ndb-7.2.5) id=3...@xxx.xxx.xxx.107 (mysql-5.5.20 ndb-7.2.5) id=3...@xxx.xxx.xxx.113 (mysql-5.5.20 ndb-7.2.5) id=3...@xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=3...@xxx.xxx.xxx.114 (mysql-5.5.20 ndb-7.2.5) id=3...@xxx.xxx.xxx.114 (mysql-5.5.20 ndb-7.2.5) id=3...@xxx.xxx.xxx.114 (mysql-5.5.20 ndb-7.2.5) id=3...@xxx.xxx.xxx.114 (mysql-5.5.20 ndb-7.2.5) id=3...@xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=3...@xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=3...@xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=4...@xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=4...@xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=4...@xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=4...@xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=4...@xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=4...@xxx.xxx.xxx.113 (mysql-5.5.20 ndb-7.2.5) id=4...@xxx.xxx.xxx.113 (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) id=5...@xxx.xxx.xxx.107 (mysql-5.5.20 ndb-7.2.5) id=5...@xxx.xxx.xxx.107 (mysql-5.5.20 ndb-7.2.5) id=5...@xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=5...@xxx.xxx.xxx.244 (mysql-5.5.20 ndb-7.2.5) id=5...@xxx.xxx.xxx.244 (mysql-5.5.20 ndb-7.2.5) id=5...@xxx.xxx.xxx.244 (mysql-5.5.20 ndb-7.2.5) id=5...@xxx.xxx.xxx.244 (mysql-5.5.20 ndb-7.2.5) id=5...@xxx.xxx.xxx.107 (mysql-5.5.20 ndb-7.2.5) id=5...@xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=5...@xxx.xxx.xxx.116 (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
[Linux-sunucu] Re: "Got temporary error 899 'Rowid already allocated' from NDBCLUSTER"
İ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) id=2 @xxx.xxx.xxx.101 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0) id=3 @xxx.xxx.xxx.102 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0, Master) id=4 @xxx.xxx.xxx.103 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 1) id=5 @xxx.xxx.xxx.104 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 1) id=6 @xxx.xxx.xxx.105 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 2) id=7 @xxx.xxx.xxx.106 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 2) [ndb_mgmd(MGM)] 2 node(s) id=1 @xxx.xxx.xxx.100 (mysql-5.5.20 ndb-7.2.5) id=8 (not connected, accepting connect from xxx.xxx.xxx.111) [mysqld(API)] 94 node(s) id=9 @xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=10 @xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=11 @xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=12 @xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=13 @xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=14 @xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=15 @xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=16 @xxx.xxx.xxx.119 (mysql-5.5.20 ndb-7.2.5) id=17 @xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=18 @xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=19 @xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=20 @xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=21 @xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=22 @xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=23 @xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=24 @xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=25 @xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=26 @xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=27 @xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=28 @xxx.xxx.xxx.109 (mysql-5.5.20 ndb-7.2.5) id=29 @xxx.xxx.xxx.113 (mysql-5.5.20 ndb-7.2.5) id=30 @xxx.xxx.xxx.107 (mysql-5.5.20 ndb-7.2.5) id=31 @xxx.xxx.xxx.113 (mysql-5.5.20 ndb-7.2.5) id=32 @xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=33 @xxx.xxx.xxx.114 (mysql-5.5.20 ndb-7.2.5) id=34 @xxx.xxx.xxx.114 (mysql-5.5.20 ndb-7.2.5) id=35 @xxx.xxx.xxx.114 (mysql-5.5.20 ndb-7.2.5) id=36 @xxx.xxx.xxx.114 (mysql-5.5.20 ndb-7.2.5) id=37 @xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=38 @xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=39 @xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=40 @xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=41 @xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=42 @xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=43 @xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=44 @xxx.xxx.xxx.115 (mysql-5.5.20 ndb-7.2.5) id=45 @xxx.xxx.xxx.113 (mysql-5.5.20 ndb-7.2.5) id=46 @xxx.xxx.xxx.113 (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) id=50 @xxx.xxx.xxx.107 (mysql-5.5.20 ndb-7.2.5) id=51 @xxx.xxx.xxx.107 (mysql-5.5.20 ndb-7.2.5) id=52 @xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=53 @xxx.xxx.xxx.244 (mysql-5.5.20 ndb-7.2.5) id=54 @xxx.xxx.xxx.244 (mysql-5.5.20 ndb-7.2.5) id=55 @xxx.xxx.xxx.244 (mysql-5.5.20 ndb-7.2.5) id=56 @xxx.xxx.xxx.244 (mysql-5.5.20 ndb-7.2.5) id=57 @xxx.xxx.xxx.107 (mysql-5.5.20 ndb-7.2.5) id=58 @xxx.xxx.xxx.116 (mysql-5.5.20 ndb-7.2.5) id=59 @xxx.xxx.xxx.116 (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
[Linux-sunucu] Re: "Got temporary error 899 'Rowid already allocated' from NDBCLUSTER"
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 Linux-sunucu@liste.linux.org.tr 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 ___ Linux-sunucu E-Posta Listesi Linux-sunucu@liste.linux.org.tr 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