Different row counts on replicas on mysql cluster

[Kenan Ozturk]

hi all,

we have a cluster system that consists of one management server and two data nodes.

when we run "select coun(*) from table_name" on both replicas, we get different row counts!

so what causes this problem? how can we solve it?

I will be grateful if someone helps us!

Regards,

Kenan

Here is our config.ini file
#####################
[NDBD DEFAULT] # Options affecting ndbd processes on all storage nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=52M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.

[TCP DEFAULT] # TCP/IP options:
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead

[NDB_MGMD]
# Management process options:
hostname=10.34.35.21 # Hostname or IP address of MGM node
datadir=/space/mysql/mysql-cluster # Directory for MGM node logfiles

[NDBD]
# Options for storage node "A":
# (one [NDBD] section per storage node)
hostname=10.34.35.22 # Hostname or IP address
datadir=/space/mysql/mysql/data # Directory for this storage node's datafiles

[NDBD]
# Options for storage node "B":
hostname=10.34.35.23 # Hostname or IP address
datadir=/space/mysql/mysql/data # Directory for this storage node's datafiles

[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]