INSERT not working, error 879 (?)

hi there!

i'm trying to get a 2-node ndb cluster running, without
success so far.

my setup is like this:
2 hosts, raddb1 and 2; both with internal ips.
i intend to run on each one mgm, ndbd, and api node.
basically, i want
to run freeradius with mysql backend fully 2-way redundant.

so far, everything seemed to work. i was able to create a
table with
engine=ndbcluster. ndb_mgm "show" looks fine. but
as soon as i try to
insert any data, i always get this error: Got error 879
'879' from
ndbcluster

perror only has to say this when asked:
NDB error code 879: 879: Permanent error: Application error

and the only relevant source code line i could find:
#define ZATTRIBUTE_ID_ERROR 879

i noticed that someone posted a similar problem recently
here, without a
solution. if anyone has any idea what is going wrong here...
please let
me know.

here is my system info / config:

Server version: 5.0.45-Debian_1+lenny1 Debian etch
distribution

ndb_mgm "show" output:
Connected to Management Server at: raddb1:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=11   10.255.35.55  (Version: 5.0.45, Nodegroup: 0,
Master)
id=12   10.255.35.56  (Version: 5.0.45, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=1    10.255.35.55  (Version: 5.0.45)
id=2    10.255.35.56  (Version: 5.0.45)

[mysqld(API)]   2 node(s)
id=21   10.255.35.55  (Version: 5.0.45)
id=22   10.255.35.56  (Version: 5.0.45)


my.cnf (of raddb1):
==============================================
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking
bind-address            = 10.255.35.55
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 128K
thread_cache_size       = 8
query_cache_limit       = 1M
query_cache_size        = 16M
skip-bdb
character_set_server=utf8
collation_server=utf8_general_ci
ndbcluster
ndb-connectstring=raddb1,raddb2

[mysql_cluster]
ndb-connectstring=raddb1,raddb2

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]

[isamchk]
key_buffer              = 16M
==============================================

ndb_mgmd.cnf (debian name for config.ini):
==============================================
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=200M
IndexMemory=45M
#MaxNoOfTables=256
#MaxNoOfOrderedIndexes=256
#MaxNoOfUniqueHashIndexes=128

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

[NDB_MGMD]
hostname=raddb1
datadir=/var/lib/mysql-cluster

[NDB_MGMD]
hostname=raddb2
datadir=/var/lib/mysql-cluster

[NDBD]
id=11
hostname=raddb1
datadir=/var/lib/mysql-cluster

[NDBD]
id=12
hostname=raddb2
datadir=/var/lib/mysql-cluster

[MYSQLD]
id=21
hostname=raddb1

[MYSQLD]
id=22
hostname=raddb2
==============================================

thanks in advance & regards,
-- 
Markus Rambossek [MXR66-RIPE]
m.rambossekwnt-isp.net
WNT / WNT-ISP / WNT-NEWMEDIA NOC

WNT Telecommunication
Richard-Strauss-Str. 43
A-1230 Vienna
Mobile: +43 650 4126691


-- 
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com
/cluster
To unsubscribe:    http://list
s.mysql.com/cluster?unsub=bondyahoo.com

Hi Markus,

On Dec 17, 2007, at 1:45 , Markus Rambossek wrote:
..
> my setup is like this:
> 2 hosts, raddb1 and 2; both with internal ips.
> i intend to run on each one mgm, ndbd, and api node.
basically, i want
> to run freeradius with mysql backend fully 2-way
redundant.

Although it works we don't recommend such setup: ndbd should
better  
run on separate machines.
I had to nag about it 

> i noticed that someone posted a similar problem
recently here,  
> without a
> solution. if anyone has any idea what is going wrong
here... please  
> let
> me know.

Might be this bug:
  http://bugs.my
sql.com/bug.php?id=31761
5.0.51 was released source only, and the fix for that bug
was pushed  
to 5.0.52.

> Server version: 5.0.45-Debian_1+lenny1 Debian etch
distribution

Tried it using our binaries?
  h
ttp://dev.mysql.com/downloads/mysql/5.0.html#linux

Would be nice if you do test this using the static binaries.
Might be  
problem with combination compiler/source.

Cheers,

Geert

-- 
Geert Vanderkelen, Senior Support Engineer
MySQL GmbH, Germany, www.mysql.com





-- 
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com
/cluster
To unsubscribe:    http://list
s.mysql.com/cluster?unsub=bondyahoo.com