Re: Urgent replication problem
Bjorn De Waele wrote:
> 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 750 0 0.00
> c8cf228 70 F------ 0 20b8c7 750 0 0.00
> c8cf244 71 F------ 0 20bbb5 750 0 0.00
> c8cf260 72 F------ 0 20bea3 750 0 0.00
> c8cf27c 73 F------ 0 20c191 750 0 0.00
> c8cf298 74 F------ 0 20c47f 750 0 0.00
> c8cf2b4 75 F------ 0 20c76d 750 0 0.00
> c8cf2d0 76 F------ 0 20ca5b 750 0 0.00
> c8cf2ec 77 F------ 0 20cd49 750 0