DM setup - config sync not possible

[hagor]

Hey guys!

I am currently testing a DM setup with two nodes. I followed the manual precisely and after the first start it look promisingly.
The Log shows, that history and events are synchronized without problems but the configuration synchronization is never running.

From the logs i can see, the connection is established between the nodes and they are exchanging history, events and auditlog but no configuration. In case of the auditlog the insert in the db is not possible but i think this is because of the missing configuration (user not imported so the audit can not be inserted)

Child (NodeID 2):

  5800:20121211:143144.708 NODE 2: Sending history_sync of node 2 to node 1 datalen 538
  5800:20121211:143144.836 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 170
  5800:20121211:143144.907 NODE 2: Sending events of node 2 to node 1 datalen 6758
  5800:20121211:143144.911 NOT OK
  5800:20121211:143144.919 NODE 2: Sending auditlog of node 2 to node 1 datalen 659
  5800:20121211:143144.924 NOT OK

Master (NodeID 1):

 13320:20121211:143144.711 NODE 1: Received history from node 2 for node 2 datalen 538
 13323:20121211:143144.838 NODE 1: Received history_uint from node 2 for node 2 datalen 170
 13322:20121211:143144.910 NODE 1: Received events from node 2 for node 2 datalen 6758
 13323:20121211:143144.921 NODE 1: Received auditlog from node 2 for node 2 datalen 659
 13323:20121211:143144.923 [Z3005] query failed: [-1] ORA-02291: integrity constraint (BUMONTST.C_AUDITLOG_1) violated - parent key not found
ORA-06512: at line 2 [begin
insert into auditlog (auditid,userid,clock,action,resourcetype,details,ip,resourceid,resourcename) values (200200000000011,200200000000003,1355215791,2,21,'Node [ZABBIX_DRS] id [1]','172.23.16.158',0,'');
insert into auditlog (auditid,userid,clock,action,resourcetype,details,ip,resourceid,resourcename) values (200200000000012,200200000000003,1355215794,2,21,'Node [ZABBIX_DRS] id [1]','172.23.16.158',0,'');
insert into auditlog (auditid,userid,clock,action,resourcetype,details,ip,resourceid,resourcename) values (200200000000013,200200000000003,1355215794,2,21,'Node [ZABBIX_DRS] id [1]','172.23.16.158',0,'');
insert into auditlog (auditid,userid,clock,action,resourcetype,details,ip,resourceid,resourcename) values (200200000000014,200200000000003,1355216275,1,21,'Node [ZABBIX_DRS02] id [2]','172.23.16.158',0,'');
insert into auditlog (auditid,userid,clock,action,resourcetype,details,ip,resourceid,resourcename) values (200200000000015,200200000000003,1355216330,0,21,'Node [ZABBIX_DRS] id [1]','172.23.16.158',0,'');
end;
]

Setup Information:
Two virtual RedHat Machines
Zabbix 2.0.4
Oracle 11

Has someone of you a idea why the configuration is not synced and how i can solve this problem?

Thanks in advance
Harry

[hagor]

I think I can now tell the source of the problem.
In the child log the following Message appears:

19015:20121213:075020.168 [Z3005] query failed: [-1] ORA-00904: "MD5": invalid identifier [insert into node_cksum (nodeid,tablename,recordid,cksumtype,cksum) select 2,'maintenances',maintenanceid,1,md5(name)||','||maintenance_type||','||md5(description)||','||active_since||','||active_till from maintenances where 1=1 and maintenanceid between 200000000000000 and 299999999999999]

It seems, that Oracle does not support the md5 function from scratch and this function is also not provided by the schema.sql of the zabbix installation.

Therefore this function has to be added.
In Issue ZBX-5675 the missing md5 function was already stated.

The problem is not solved yet, but I think with the help of my DBA it should be possible

[hagor]

I think the problem is solved by now.
The problem was the missing md5 function in Oracle and also a Oracle specific failure in the usage of cast.

I created a patch for Oracle and Zabbix 2.0.4.
The files and more information you can find at ZBX-6008 where I have submitted this patch.

Maybe it will be added to zabbix source so future releases.