Re: Urgent replication problem
I don't know how big your database is but is it possible to backup the
primary and restore it to the secondary. Basically you are starting
over. We do it all the time after a release. We modify so much we
found it better to break replication and then redo the replication
steps that are so well described in the manual. The manual also gives
you a list of which onconfig parameters need to be the same.
The message log is clearly saying that it can't communicate with the
primary anymore.
"Bjorn De Waele" <bjornREMTHIS@pandora.Be> wrote in message news:<qRWUc.218634$AZ1.10654746@phobos.telenet-ops.be>...
> Hello alexey,
>
>
>
> 1. the onstat -g dri gives me on the secondary a last dr ckpt from -1/-1, so
> this is definitely wrong
> 2. the netstat -a shows me a connection on port 4049 with the primary
> 3. onstat -m gives me :
>
> Informix Dynamic Server 2000 Version 9.21.TC3 -- Fast Recovery (Sec) --
> Up 09:08:55 -- 25792 Kbytes
>
> Message Log File: C:\\informix\\ol_cabrita2.log
> 22:06:56 Informix Dynamic Server 2000 Version 9.21.TC3 Software Serial> Number AAC#J968164
> 22:06:57 Informix Dynamic Server 2000 Initialized -- Shared Memory> Initialized.
>
> 22:06:57 DR: Logs will be cleared during logical recovery
> 22:06:57 DR: Trying to connect to primary server ...
> 22:06:58 DR: Secondary server connected
> 22:06:58 DR: Receive error
> 22:06:58 DR: Failure recovery error (2)
> 22:06:59 Physical Recovery Started.
> 22:06:59 DR: Turned off on secondary server
> 22:06:59 Physical Recovery Complete: 0 Pages Restored.
>
> 22:06:59 Dataskip is now OFF for all dbspaces
> 22:06:59 Recovery Mode
> 22:13:04 DR: Secondary server connected
> 22:13:05 DR: Failure recovery from disk in progress ...
> 22:13:05 Logical Recovery Started.
> 22:13:05 10 recovery worker threads will be started.
> 22:13:05 Start Logical Recovery - Start Log 14125, End Log ?
> 22:13:05 Starting Log Position - 14125 0x23b018>
> There are no other messages about hdr.
>
> 4. onstat -l
> Informix Dynamic Server 2000 Version 9.21.TC3 -- Fast Recovery (Sec) --
> Up 01:46:41 -- 33984 Kbytes
>
> Physical Logging
> Buffer bufused bufsize numpages numwrits pages/io
> P-2 0 8 0 0 0.00
> phybegin physize phypos phyused %used
> 300035 10000 2446 0 0.00
>
> Logical Logging
> Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> L-1 0 8 0 0 0 0.0 0.0
> Subsystem numrecs Log Space used
>
> address number flags uniqid begin size used %used
> c8ceb44 7 F------ 0 200035 750 0 0.00
> c8ceb60 8 F------ 0 200323 750 0 0.00
> c8ceb7c 9 F------ 0 200611 750 0 0.00
> c8ceb98 10 F------ 0 2008ff 750 0 0.00
> c8cebb4 11 F------ 0 200bed 750 0 0.00
> c8cebd0 12 F------ 0 200edb 750 0 0.00
> c8cebec 13 F------ 0 2011c9 750 0 0.00
> c8cec08 14 F------ 0 2014b7 750 0 0.00
> c8cec24 15 F------ 0 2017a5 750 0 0.00
> c8cec40 16 F------ 0 201a93 750 0 0.00
> c8cec5c 17 F------ 0 201d81 750 0 0.00
> c8cec78 18 F------ 0 20206f 750 0 0.00
> c8cec94 19 F------ 0 20235d 750 0 0.00
> c8cecb0 20 F------ 0 20264b 750 0 0.00
> c8ceccc 21 F------ 0 202939 750 0 0.00
> c8cece8 22 F------ 0 202c27 750 0 0.00
> c8ced04 23 F------ 0 202f15 750 0 0.00
> c8ced20 24 F------ 0 203203 750 0 0.00
> c8ced3c 25 U---C-L 14125 2034f1 750 572 76.27
> c8ced58 26 F------ 0 2037df 750 0 0.00
> c8ced74 27 F------ 0 203acd 750 0 0.00
> c8ced90 28 F------ 0 203dbb 750 0 0.00
> c8cedac 29 F------ 0 2040a9 750 0 0.00
> c8cedc8 30 F------ 0 204397 750 0 0.00
> c8cede4 31 F------ 0 204685 750 0 0.00
> c8cee00 32 F------ 0 204973 750 0 0.00
> c8cee1c 33 F------ 0 204c61 750 0 0.00
> c8cee38 34 F------ 0 204f4f 750 0 0.00
> c8cee54 35 F------ 0 20523d 750 0 0.00
> c8cee70 36 F------ 0 20552b 750 0 0.00
> c8cee8c 37 F------ 0 205819 750 0 0.00
> c8ceea8 38 F------ 0 205b07 750 0 0.00
> c8ceec4 39 F------ 0 205df5 750 0 0.00
> c8ceee0 40 F------ 0 2060e3 750 0 0.00
> c8ceefc 41 F------ 0 2063d1 750 0 0.00
> c8cef18 42 F------ 0 2066bf 750 0 0.00
> c8cef34 43 F------ 0 2069ad 750 0 0.00
> c8cef50 44 F------ 0 206c9b 750 0 0.00
> c8cef6c 45 F------ 0 206f89 750 0 0.00
> c8cef88 46 F------ 0 207277 750 0 0.00
> c8cefa4 47 F------ 0 207565 750 0 0.00
> c8cefc0 48 F------ 0 207853 750 0 0.00
> c8cefdc 49 F------ 0 207b41 750 0 0.00
> c8ceff8 50 F------ 0 207e2f 750 0 0.00
> c8cf014 51 F------ 0 20811d 750 0 0.00
> c8cf030 52 F------ 0 20840b 750 0 0.00
> c8cf04c 53 F------ 0 2086f9 750 0 0.00
> c8cf068 54 F------ 0 2089e7 750 0 0.00
> c8cf084 55 F------ 0 208cd5 750 0 0.00
> c8cf0a0 56 F------ 0 208fc3 750 0 0.00
> c8cf0bc 57 F------ 0 2092b1 750 0 0.00
> c8cf0d8 58 F------ 0 20959f 750 0 0.00
> c8cf0f4 59 F------ 0 20988d 750 0 0.00
> c8cf110 60 F------ 0 209b7b 750 0 0.00
> c8cf12c 61 F------ 0 209e69 750 0 0.00
> c8cf148 62 F------ 0 20a157 750 0 0.00
> c8cf164 63 F------ 0 20a445 750 0 0.00
> c8cf180 64 F------ 0 20a733 750 0 0.00
> c8cf19c 65 F------ 0 20aa21 750 0 0.00
> c8cf1b8 66 F------ 0 20ad0f 750 0 0.00
> c8cf1d4 67 F------ 0 20affd 750 0 0.00
> c8cf1f0 68 F------ 0 20b2eb 750 0 0.00
> c8cf20c 69 F------ 0 20b5d9