Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007

    Unanswered: Replication & transaction log problems


    I have a problem with my warm standby system. One of the transactions caused an error and stopped DSI thread for secondary database. After issuing "resume connection to <server>.<db> skip transaction" command replication agent in primary database won't resume processing of transaction log. All replication threads are active, replication agent in primary database is running. When I query syslogshold table, $replication_truncation_point remains on the same page. The only thing that helped so far was restart of replication agent & replication server. Has anyone encountered this problem before ? Sybase version 12.5.3/EBF 13325 ESD#7 on Solaris 8.

    Best regards,

    Peter M.

  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    You should look at the page pointer in syslogshold output and check that if it is incrementing?

    If the page pointer does not move for a while in a WS environment, it is possible your RA is hanging. A situation usually can be resolved by restart of RA.

    Note, if your RA is hung, the primary transaction log will fill up very quickly on a busy dataserver.

    If everything on the primary looks dandy, check the sqm_readers. See if they are moving.

    If possible, insert a dummy record in to a replicated table and monitor it at the replicate and also check the rs_lastcommit on the replicate.

  3. #3
    Join Date
    Mar 2007
    Yes, RA was hanging, but I'd like to find out why (unfortunately there were no errors in repserver or dataserver errorlogs regarding this issue). Also, I've noticed that RA can be stopped only with 'nowait' option.

  4. #4
    Join Date
    Mar 2007
    Well, now I got this error in repserver log after stopping replication agent with 'nowait' option:

    E. 2007/09/18 17:15:26. ERROR #60024 REP AGENT(<server>.<database>) - /execint.c(3508)
    Synchronization model CONDITION VARIABLE, element Executor <repserver_name>_ra TSD CV 15229b8 was interrupted waiting for a lock. (4107)eneric/useful/sync.c.

    After I tried to start RA again, I keep getting this error:

    E. 2007/09/18 17:16:36. ERROR #14067 USER(<repserver_name>_ra) - /execint.c(1815)
    Replication Agent for '<server_name>.<db_name>' is in the process of disconnecting. Possibly wait and try again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts