If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Enterprise Replication

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-31-06, 11:14
mcorreia mcorreia is offline
Registered User
 
Join Date: May 2006
Posts: 1
Unhappy Enterprise Replication

I've been preparing two systems for Primary-Target replication and I've successfully defined the primary the primary database server. However, when I try to define the secondary server I get the following error.

command failed -- *Error* <-1> is not a known Enterprise Replication error (-1)

The command I used to define the primary server is:
cdr define server --init g_development

I've tried several commands for the secondary server:
This command is run from the primary server:
cdr define server --connect=demo_on --init --sync=g_development g_swxtest2
These commands were run from the secondary server:
cdr define server --init g_swxtest2
cdr define server --init --sync=g_development g_swxtest2

In dbaccess on both servers I can successfully access the databases on either server.


Entries in the services file on both servers:
onnet 1526/tcp
idsrep 1530/tcp

Entries in the hosts.equiv file on both servers:
swxtest2 informix
development informix

sqlhosts on swxtest2:
s2_demo onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
#develop101 onipcshm swxtest2 online
#develop101inet onsoctcp swxtest2 onnet
g_development group - - i=101
develop101inet onsoctcp development onnet g=g_development
g_swxtest2 group - - i=102
demo_on onsoctcp swxtest2 idsrep g=g_swxtest2

sqlhosts on development:
#demo_on onipcshm on_hostname on_servername
#demo_se seipcpip se_hostname sqlexec
develop101 onipcshm development online
#develop101inet onsoctcp development onnet
g_development group - - i=101
develop101inet onsoctcp development onnet g=g_development
g_swxtest2 group - - i=102
demo_on onsoctcp swxtest2 idsrep g=g_swxtest2
#develop101inet onsoctcp swxtest2 onnet g=g_swxtest2

onconfig files attached.

Last several lines of the online.log on swxtest2:

15:41:27 Maximum server connections 0
15:41:27 Dropping temporary TBLspace 0x100139, recovering 28 pages.
15:41:27 Checkpoint Completed: duration was 0 seconds.
15:41:27 Checkpoint loguniq 6, logpos 0x8f0c8, timestamp: 87881

15:41:27 Maximum server connections 0
15:41:27 On-Line Mode
15:45:19 Booting Language <spl> from module <>
15:45:19 Loading Module <SPLNULL>
15:45:20 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
15:45:20 CDR Initialization failed (Catalog Initialization Failed).
15:46:57 Checkpoint Completed: duration was 0 seconds.
15:46:57 Checkpoint loguniq 6, logpos 0xf9018, timestamp: 96610

15:46:57 Maximum server connections 1
15:47:15 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
15:47:15 CDR Initialization failed (Catalog Initialization Failed).
15:48:46 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
15:48:46 CDR Initialization failed (Catalog Initialization Failed).
15:50:10 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
15:50:10 CDR Initialization failed (Catalog Initialization Failed).
15:50:11 Logical Log 6 Complete, timestamp:122523.
15:50:11 Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/etc/alarmprogram.sh 2 23 "Logical Log 6 Complete, timestamp:122523." "Logical Log 6 Comp
15:51:57 Checkpoint Completed: duration was 0 seconds.
15:51:57 Checkpoint loguniq 7, logpos 0x40018, timestamp: 122533

15:51:57 Maximum server connections 1
15:56:56 Checkpoint Completed: duration was 0 seconds.
15:56:56 Checkpoint loguniq 7, logpos 0x41018, timestamp: 122538

I believe it may have something to do with the failure to create the syscdr database shown in the log above.

Thanks in advance for your help.

Mark

Go SOCA WARRIORS - World Cup 2006
Attached Files
File Type: txt onconfig on developments.txt (11.4 KB, 68 views)
File Type: txt onconfig on swxtest2.txt (11.4 KB, 174 views)
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On