RE: Urgent replication problem

Bjorn, 1. What is 'onstat -g dri' on both machines? 2. Is there netwotk connection (netstat -a) between machines? 3. Are there HDR-specific messages in 'online.log' on both? 4. Is there activity on primary? 5. What are logical log positions (onstat -l) on both? 6. Are onconfig's identical on both servers? 7. Are there HDR-specific threads (onstat -g ath | grep 'dr_') on both machines? ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: Bjorn De Waele [mailto:bjornREMTHIS@pandora.Be] > > Hello everybody, > > > today we brought our dbase down to finetune our onconfig. After it, it > couldn't get started anymore. So we placed our old onconfig back. > > Everything was fine again except that our secondary stayed in fast > recovery > mode. It was very long so we supposed that our replication was corrupt. > No > problem, we made a new ontape -s and set our replica up again. > But right now we still have the same problem .... Our replica stays in > fast > recovery mode. We're running 9.21 TC3. > After 3 hours, it was still the same, no activity on the server. > > I did some tests with the onstat -p to check disk activity. I resetted > the > activity with onstat -z before the replica thread started (onstat -g ath). > Once the replica started, my pagewrites went step by step to 84000 but > there > it stands.... nothing happens anymore.... > > In onstat -d, I don't see down chunks. > Onstat -g ath gives me a cond wait for drcb_bqe in dr_secrcv > > I think the thread is waiting and waiting ... but I don't know for what ! > > I really hope someone could help me out or hint me cause we're running our > reports on that secondary. > > Thanks in advance ! > > Bjorn sending to informix-list

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 SerialNumber AAC#J968164 22:06:57 Informix Dynamic Server 2000 Initialized -- Shared MemoryInitialized. 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 0.00 c8cf308 78 F------ 0 20d037 750 0 0.00 c8cf324 79 F------ 0 20d325 750 0 0.00 c8cf340 80 F------ 0 20d613 750 0 0.00 c8cf35c 81 F------ 0