Oninit cdi / Archive
Talk to an expert →

Re: Enterprise Replication CDR GC cache query failed

Posted in 2004

Topics: High Availability & Replication

Madison Pruet — — source: Usenet: comp.databases.informix

Version number? This means that something has happened with the definition of the original replicate definition. We had a problem in 7.x product in which the pending states table was not properly cleaned up when a replicate's state changed that would cause this message as well. You might be running into that. M.P. "Bj" <Bruxelles.Jette@caramail.com> wrote in message news:89d8947b.0405030241.8bb3f95@posting.google.com... > Hello, > > I'm trying to activate the enterprise replication between 2 servers. > When I type on each of the servers > > ############################################################################ #### > > $ cdr list repl> REPLICATE STATE CONFLICT FREQUENCY OPTIONS > -------------------------------------------------------------------------- -- > repl_dwi_coe ACTIVE ignore time 19:0 row > repl_dwi_head ACTIVE ignore time 19:0 row > repl_dwi_item ACTIVE ignore time 19:0 row > repl_dwi_sae ACTIVE ignore time 19:0 row > repl_dwmd_bran ACTIVE ignore time 19:0 row > repl_dwmd_claim ACTIVE ignore time 19:0 row > repl_dwmd_coce ACTIVE ignore time 19:0 row > repl_dwmd_coe ACTIVE ignore time 19:0 row > repl_dwmd_cont ACTIVE ignore time 19:0 row > repl_dwmd_coun ACTIVE ignore time 19:0 row > repl_dwmd_country ACTIVE ignore time 19:0 row > repl_dwmd_kind ACTIVE ignore time 19:0 row > repl_dwmd_partn ACTIVE ignore time 19:0 row > repl_dwmd_product ACTIVE ignore time 19:0 row > repl_dwmd_region ACTIVE ignore time 19:0 row > repl_dwmd_sae ACTIVE ignore time 19:0 row > repl_dwmd_site ACTIVE ignore time 19:0 row > repl_dwmd_staff ACTIVE ignore time 19:0 row > repl_dwmd_waregroup ACTIVE ignore time 19:0 row > repl_dwo_coe ACTIVE ignore time 19:0 row > repl_dwo_head ACTIVE ignore time 19:0 row > repl_dwo_item ACTIVE ignore time 19:0 row > repl_dwo_sae ACTIVE ignore time 19:0 row > repl_mitarb ACTIVE ignore time 19:0 row > repl_yag ACTIVE ignore time 19:0 row > repl_ykag ACTIVE ignore time 19:0 row > repl_yvowg ACTIVE ignore time 19:0 row > repl_yvuwg ACTIVE ignore time 19:0 row > cdr: can't fetch replicate > SQL code -461 :Cannot open file 'csql.iem'. > > ISAM 0 : > > ############################################################################ #### > > BUT on the online.log, I receive a lot of messages > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422539. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422546. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422545. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422534. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422548. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422550. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422542. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422541. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422544. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422543. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422540. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422538. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422547. > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422549.> > Can someone say me why ? > > Regards, > Bj

↪ replying to Madison Pruet
Bj — — source: Usenet: comp.databases.informix

HELLO, I'm working with 2 SCO OpenServer 5.0.7. Each with Informix Dynamic Server Version 7.31.UC2 Here is an example of one of my replicate definition cdr define repl -C ignore -a "19:00" repl_dwmd_partn "P alcib_53@g_MRX2:awserv.dwmd_partn" "select pano,patype from dwmd_partn" "R alcib_720@g_UGND:informix.dwmd_partn" "select siteno,pano,patype from dwmd_partn;update dwmd_partn set siteno=53" As you can see, I have a primary with only 2 columns and I try to replicate it on a target with 3 columns where I force the 1st column "siteno" to still have the integer 53 as value. Am I wrong when I do like that ? Regards, Noreddine "Madison Pruet" <mpruet@comcast.net> wrote in message news:<qUslc.16546$IG1.572692@attbi_s04>... > Version number? > > This means that something has happened with the definition of the original > replicate definition. > We had a problem in 7.x product in which the pending states table was not > properly cleaned up when a replicate's state changed that would cause this > message as well. You might be running into that. > > M.P. > > > "Bj" <Bruxelles.Jette@caramail.com> wrote in message > news:89d8947b.0405030241.8bb3f95@posting.google.com... > > Hello, > > > > I'm trying to activate the enterprise replication between 2 servers. > > When I type on each of the servers > > > > > ############################################################################ > #### > > > > $ cdr list repl> > REPLICATE STATE CONFLICT FREQUENCY OPTIONS > > -------------------------------------------------------------------------- > -- > > repl_dwi_coe ACTIVE ignore time 19:0 row > > repl_dwi_head ACTIVE ignore time 19:0 row > > repl_dwi_item ACTIVE ignore time 19:0 row > > repl_dwi_sae ACTIVE ignore time 19:0 row > > repl_dwmd_bran ACTIVE ignore time 19:0 row > > repl_dwmd_claim ACTIVE ignore time 19:0 row > > repl_dwmd_coce ACTIVE ignore time 19:0 row > > repl_dwmd_coe ACTIVE ignore time 19:0 row > > repl_dwmd_cont ACTIVE ignore time 19:0 row > > repl_dwmd_coun ACTIVE ignore time 19:0 row > > repl_dwmd_country ACTIVE ignore time 19:0 row > > repl_dwmd_kind ACTIVE ignore time 19:0 row > > repl_dwmd_partn ACTIVE ignore time 19:0 row > > repl_dwmd_product ACTIVE ignore time 19:0 row > > repl_dwmd_region ACTIVE ignore time 19:0 row > > repl_dwmd_sae ACTIVE ignore time 19:0 row > > repl_dwmd_site ACTIVE ignore time 19:0 row > > repl_dwmd_staff ACTIVE ignore time 19:0 row > > repl_dwmd_waregroup ACTIVE ignore time 19:0 row > > repl_dwo_coe ACTIVE ignore time 19:0 row > > repl_dwo_head ACTIVE ignore time 19:0 row > > repl_dwo_item ACTIVE ignore time 19:0 row > > repl_dwo_sae ACTIVE ignore time 19:0 row > > repl_mitarb ACTIVE ignore time 19:0 row > > repl_yag ACTIVE ignore time 19:0 row > > repl_ykag ACTIVE ignore time 19:0 row > > repl_yvowg ACTIVE ignore time 19:0 row > > repl_yvuwg ACTIVE ignore time 19:0 row > > cdr: can't fetch replicate > > SQL code -461 :Cannot open file 'csql.iem'. > > > > ISAM 0 : > > > > > ############################################################################ > #### > > > > BUT on the online.log, I receive a lot of messages > > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422539. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422546. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422545. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422534. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422548. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422550. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422542. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422541. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422544. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422543. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422540. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422538. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422547. > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422549.> > > > Can someone say me why ? > > > > Regards, > > Bj

↪ replying to Bj
Madison Pruet — — source: Usenet: comp.databases.informix

7.31 still uses the pending states table. I suspect that is where the error messages are coming from. There was a problem with the pending states table not being properly cleaned up when the state changed. It has been fixed with current releases of 7.31. "Bj" <Bruxelles.Jette@caramail.com> wrote in message news:89d8947b.0405040029.2775c357@posting.google.com... > HELLO, > > I'm working with 2 SCO OpenServer 5.0.7. > Each with Informix Dynamic Server Version 7.31.UC2 > > Here is an example of one of my replicate definition > > cdr define repl -C ignore -a "19:00" repl_dwmd_partn > "P alcib_53@g_MRX2:awserv.dwmd_partn" > "select pano,patype from dwmd_partn" > "R alcib_720@g_UGND:informix.dwmd_partn" > "select siteno,pano,patype from dwmd_partn;update dwmd_partn set > siteno=53" > > As you can see, I have a primary with only 2 columns and I try to > replicate it on a target with 3 columns where I force the 1st column > "siteno" to still have the integer 53 as value. > Am I wrong when I do like that ? > > Regards, > Noreddine > > "Madison Pruet" <mpruet@comcast.net> wrote in message news:<qUslc.16546$IG1.572692@attbi_s04>... > > Version number? > > > > This means that something has happened with the definition of the original > > replicate definition. > > We had a problem in 7.x product in which the pending states table was not > > properly cleaned up when a replicate's state changed that would cause this > > message as well. You might be running into that. > > > > M.P. > > > > > > "Bj" <Bruxelles.Jette@caramail.com> wrote in message > > news:89d8947b.0405030241.8bb3f95@posting.google.com... > > > Hello, > > > > > > I'm trying to activate the enterprise replication between 2 servers. > > > When I type on each of the servers > > > > > > > > ############################################################################ > > #### > > > > > > $ cdr list repl> > > REPLICATE STATE CONFLICT FREQUENCY OPTIONS > > > -------------------------------------------------------------------------- > > -- > > > repl_dwi_coe ACTIVE ignore time 19:0 row > > > repl_dwi_head ACTIVE ignore time 19:0 row > > > repl_dwi_item ACTIVE ignore time 19:0 row > > > repl_dwi_sae ACTIVE ignore time 19:0 row > > > repl_dwmd_bran ACTIVE ignore time 19:0 row > > > repl_dwmd_claim ACTIVE ignore time 19:0 row > > > repl_dwmd_coce ACTIVE ignore time 19:0 row > > > repl_dwmd_coe ACTIVE ignore time 19:0 row > > > repl_dwmd_cont ACTIVE ignore time 19:0 row > > > repl_dwmd_coun ACTIVE ignore time 19:0 row > > > repl_dwmd_country ACTIVE ignore time 19:0 row > > > repl_dwmd_kind ACTIVE ignore time 19:0 row > > > repl_dwmd_partn ACTIVE ignore time 19:0 row > > > repl_dwmd_product ACTIVE ignore time 19:0 row > > > repl_dwmd_region ACTIVE ignore time 19:0 row > > > repl_dwmd_sae ACTIVE ignore time 19:0 row > > > repl_dwmd_site ACTIVE ignore time 19:0 row > > > repl_dwmd_staff ACTIVE ignore time 19:0 row > > > repl_dwmd_waregroup ACTIVE ignore time 19:0 row > > > repl_dwo_coe ACTIVE ignore time 19:0 row > > > repl_dwo_head ACTIVE ignore time 19:0 row > > > repl_dwo_item ACTIVE ignore time 19:0 row > > > repl_dwo_sae ACTIVE ignore time 19:0 row > > > repl_mitarb ACTIVE ignore time 19:0 row > > > repl_yag ACTIVE ignore time 19:0 row > > > repl_ykag ACTIVE ignore time 19:0 row > > > repl_yvowg ACTIVE ignore time 19:0 row > > > repl_yvuwg ACTIVE ignore time 19:0 row > > > cdr: can't fetch replicate > > > SQL code -461 :Cannot open file 'csql.iem'. > > > > > > ISAM 0 : > > > > > > > > ############################################################################ > > #### > > > > > > BUT on the online.log, I receive a lot of messages > > > > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422539. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422546. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422545. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422534. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422548. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422550. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422542. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422541. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422544. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422543. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422540. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422538. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422547. > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422549.> > > > > > Can someone say me why ? > > > > > > Regards, > > > Bj

Glossary