Re: Define replication server problem
Posted in 2003
Topics: Networking & sqlhosts Configuration
Madison, you are a REAL genius. I have seen many posts in the past for ER. You had been able to advise promptly for those and they fixed as well. Well done. Hari "Madison Pruet" <mpruet@comcast.net> wrote in message news:<Hppjb.566308$Oz4.532858@rwcrnsc54>... > Fantastic! - I was hoping that I would get a response from you. Now I can > go to bed and get some sleep! > > > > "Vadim Yezhakov" <yezhakov@mail.ru> wrote in message > news:2d8b1865.0310152014.15b79c56@posting.google.com... > > Hi, Madison. > > I synchronize time on both servers and... > > It's incredible!!! All work!!! > > Thank you very much. > > > > "Madison Pruet" <mpruet@comcast.net> wrote in message > news:<%Bcjb.137864$%h1.138485@sccrnsc02>... > > > The clocks need to be set closer to each other, but the actual problem > is - > > > > XTF_CDR_NIF XTF_DEBUG nif/nifismgr.c 945 5356 19:01:52 15 0 > > > > 531 3a699528 3a676048 341 nifiRecvDharma status 0x50, rc: 0 > > > > XTF_CDR_GCC XTF_PASS globcat/gcext.c 1357 5356 19:01:52 16 0 > > > > 531 3a699528 3a676048 341 servname2id: srv <g_almwhr> notfound > > > > > > For some reason g_whrhouse is not able to see the g_almwhr entry in the > > > sqlhost file. > > > > > > There was an issue in the early 9.3 releases that we would not reread > the > > > sqlhost file. So if the entry was not there when the server was > started, > > > then it would not recognize the entry. You might only need to bounce > the > > > server. > > > > > > You need to recheck to ensure that the server is really using the > sqlhosts > > > file entry that you think that it is. Is there a case open for this > > > problem? > > > > > > > > > "Vadim Yezhakov" <yezhakov@mail.ru> wrote in message > > > news:2d8b1865.0310150425.2c877a31@posting.google.com... > > > > I have done all steps from your instructions. > > > > > > > > Commands executed on primary server 'whrhouse': > > > > informix@whrhouse $xtrace size 50000 > > > > informix@whrhouse $xtrace heavy -c XTF_CDR_GCC > > > > informix@whrhouse $xtrace heavy -c XTF_CDR_NIF > > > > informix@whrhouse $xtrace heavy -c XTF_CDRIF_NIF > > > > informix@whrhouse $xtrace on > > > > > > > > informix@whrhouse $cdr define serv -I g_whrhouse > > > > informix@whrhouse $cdr define serv -c almwhr -I -S g_whrhouse g_almwhr > > > > command failed -- unable to connect to server specified (5) > > > > > > > > informix@whrhouse $xtrace off > > > > informix@whrhouse $xtrace fview > whrhouse.trace > > > > > > > > > > > > > > > > Commands executed on target server 'almwhr': > > > > informix@whrhouse $xtrace size 50000 > > > > informix@whrhouse $xtrace heavy -c XTF_CDR_GCC > > > > informix@whrhouse $xtrace heavy -c XTF_CDR_NIF > > > > informix@whrhouse $xtrace heavy -c XTF_CDRIF_NIF > > > > informix@whrhouse $xtrace on > > > > > > > > informix@whrhouse $xtrace off > > > > informix@whrhouse $xtrace fview > almwhr.trace > > > > > > > > --------- whrhouse.trace content ----------- > > > > Component Feature File Line Pid Time Stamp csvr thrd > > > > trans rstcb session MESSAGE > > > > XTF_CDR_GCC XTF_PASS globcat/dacRepl.c 2167 5356 19:01:20 1 0 > > > > 526 3a6a1b48 3a679108 342 dac_define_serv server g_whrhouse > > > > sflags 0x120 > > > > XTF_CDR_GCC XTF_DEBUG globcat/dacRepl.c 2229 5356 19:01:20 2 0 > > > > 526 3a6a1b48 3a679108 342 myid = 21 islocal=1 > > > > XTF_CDR_NIF XTF_CALL nif/nifext.c 58 5356 19:01:22 3 0 > > > > 526 3a6a1b48 3a679108 342 nifiInit entry > > > > XTF_CDR_NIF XTF_CALL nif/nifext.c 121 5356 19:01:22 4 0 > > > > 526 3a6a1b48 3a679108 342 nifInit return anchor:c00000003b5f8600. > > > > XTF_CDR_GCC XTF_PASS globcat/gcServdef.c 83 5356 19:01:22 5 > > > > 0 526 3a6a1b48 3a679108 342 gc_define_serv server g_whrhouse > > > > id 21 > > > > XTF_CDR_NIF XTF_CDR_SES nif/nifasf.c 759 5358 19:01:52 6 0 > > > > 531 3a699528 3a676048 341 cdraccept called > > > > XTF_CDR_NIF XTF_MSG common/cdrRsam.c 2434 5356 19:01:52 7 0 > > > > 531 3a699528 3a676048 341 ----ASF receive--- > > > > XTF_CDR_NIF XTF_MSG common/cdrRsam.c 2465 5356 19:01:52 8 0 > > > > 531 3a699528 3a676048 341 c00000003b621028 00 00 00 27 > > > > | ...' > > > > XTF_CDR_NIF XTF_MSG common/cdrRsam.c 2434 5356 19:01:52 9 0 > > > > 531 3a699528 3a676048 341 ----ASF receive--- > > > > XTF_CDR_NIF XTF_MSG common/cdrRsam.c 2465 5356 19:01:52 10 0 > > > > 531 3a699528 3a676048 341 c00000003b62102c 00 06 00 04 00 00 00 > > > > 27 00 15 00 00 00 00 00 50 | .......'.......P > > > > XTF_CDR_NIF XTF_MSG common/cdrRsam.c 2465 5356 19:01:52 11 0 > > > > 531 3a699528 3a676048 341 c00000003b62103c 3d 1a 4b 40 67 5f 61 > > > > 6c 6d 77 68 72 00 00 00 00 | =.K@g_almwhr.... > > > > XTF_CDR_NIF XTF_MSG common/cdrRsam.c 2465 5356 19:01:52 12 0 > > > > 531 3a699528 3a676048 341 c00000003b62104c 00 00 00 00 00 00 00 > > > > | ....... > > > > XTF_CDR_NIF XTF_CDR_SES nif/nifasf.c 613 5356 19:01:52 13 0 > > > > 531 3a699528 3a676048 341 nifasf_freerecv nab: c00000004d3c67b0 > > > > rcvbuf: c00000004d3d2158 > > > > XTF_CDR_NIF XTF_CDR_SES nif/nifismgr.c 928 5356 19:01:52 14 0 > > > > 531 3a699528 3a676048 341 NIF receive dharma site: 'g_almwhr' > > > > vers: 6 flag: 0x50 clock: 1025133376 > > > > XTF_CDR_NIF XTF_DEBUG nif/nifismgr.c 945 5356 19:01:52 15 0 > > > > 531 3a699528 3a676048 341 nifiRecvDharma status 0x50, rc: 0 > > > > XTF_CDR_GCC XTF_PASS globcat/gcext.c 1357 5356 19:01:52 16 0 > > > > 531 3a699528 3a676048 341 servname2id: srv <g_almwhr> notfound > > > > -------------------------------------------- > > > > > > > > > > > > ----------- almwhr.trace content ----------- > > > > Component Feature File Line Pid Time Stamp csvr thrd > > > > trans rstcb session MESSAGE > > > > XTF_CDR_GCC XTF_PASS globcat/dacRepl.c 2167 12383 19:16:08 1 0 > > > > 132 2cb8e08 2c788c8 115 dac_define_serv server g_almwhr > > > > sflags 0x160 > > > > XTF_CDR_GCC XTF_DEBUG globcat/dacRepl.c 2229 12383 19:16:08 2 0 > > > > 132 2cb8e08 2c788c8 115 myid = 8 islocal=1 > > > > XTF_CDR_NIF XTF_CALL nif/nifext.c 58 12383 19:16:12 3 0 > > > > 132 2cb8e08 2c788c8 115 nifiInit entry > > > > XTF_CDR_NIF XTF_CALL nif/nifext.c 121 12383 19:16:12 4 0 > > > > 132 2cb8e08 2c788c8 115 nifInit return anchor:c000000003297600. > > > > XTF_CDR_GCC XTF_PASS globcat/gcext.c 1245 12383 19:16:12 5 0 > > > > 132 2cb8e08 2c788c8 115 servid2name: srv 21 not found > > > > XTF_CDR_GCC XTF_PASS globcat/gcext.c 1245 12383 19:16:13 6 0 > > > > 132 2cb8e08 2c788c8 115 servid2name: srv 8 not found > > > > XTF_CDR_NIF XTF_CALL nif/nifext.c 295 12383 19:16:14 7 0 > > > > 132 2cb8e08 2c788c8 115 nifSetIdleTime entry siteId: 8, > > > > newTime: 0. > > > > XTF_CDR_NIF XTF_CDR_INTERNAL nif/nifismgr.c 109 12383 19:16:14 8 > > > > 0 132 2cb8e08 2c788c8 115 nifiFindSite
Hari Gupta wrote: > you are a REAL genius. I have seen many posts in the past for ER. You > had been able to advise promptly for those and they fixed as well. > Well done. Madison *wrote* ER, I would bloody well hope he knew how to advise people on how to use it... :o) -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"