Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Block Inconsistency

3 posts in General Discussion Last posting was on 2003-07-11 15:33:18.0Z
rhod Posted on 2003-06-30 15:43:44.0Z
From: Rhod
Date: Mon, 30 Jun 2003 11:43:44 -0400
Newsgroups: sybase.public.rep-server
Subject: Block Inconsistency
Message-ID: <51B10BCC601D9EF3005666C085256D55.005666DF85256D55@webforums>
Lines: 34
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.rep-server:4389
Article PK: 874380

ASE 12.0
RS 11.5.1 in Warm Standby Mode (4 databases)
Platform NT


Have 4 databases configured in WS.
After a DR test 3DBs were re-synch'd, the fourth wasn't involved.
During re-synch for 1 db only this error was in the log

E. 2003/06/29 21:18:55. ERROR #6025 DSI(158 SYBDR2.MFTLIVDB) - (6029)
Block consistency failed q 115:1, 0:1:0 218 contents q 114:1, 0:1:0
218. old=0.1
I. 2003/06/29 21:18:56. The DSI thread for database 'SYBDR2.MFTLIVDB' is
shutdown.

DBA at the time re-synch via dump & load and cleared the error.

The ASE & RS were cycled later that night and same error occured.
Attempting to via the inbound queue failed as it seems to think that qid
115 conatined data for qid 114.
Tried sysadmin purge_all_open but didn't seem to reduce queue size.

Performed re-synch and this appears to have cleared.

Search of google & sybase point to disk failure of Stable devices, however
no problems are encountered with other databases which are using the same
Stable Devices.

Welcome any input/thoughts

Rhod


Greg Carter Posted on 2003-07-10 16:48:26.0Z
Message-ID: <3F0D98DA.3000700@sybase.com>
Date: Thu, 10 Jul 2003 10:48:26 -0600
From: Greg Carter <gcarter@sybase.com>
Reply-To: gcarter@workmail.com
Organization: Sybase, Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: Block Inconsistency
References: <51B10BCC601D9EF3005666C085256D55.005666DF85256D55@webforums>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.rep-server
NNTP-Posting-Host: gcarter-pc.sybase.com 157.133.214.230
Lines: 35
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.rep-server:4419
Article PK: 874411

Rhod,

What do you mean by "

re-synch via dump & load and cleared the error". What did you dump and load?

--
Thanks,
G.Carter
Sybase Replication Server Engineering
mailto:greg.carter@homemail.com
mailto:greg.carter@workmail.com

Rhod wrote:

>ASE 12.0
>RS 11.5.1 in Warm Standby Mode (4 databases)
>Platform NT
>
>
>Have 4 databases configured in WS.
>After a DR test 3DBs were re-synch'd, the fourth wasn't involved.
>During re-synch for 1 db only this error was in the log
>
>E. 2003/06/29 21:18:55. ERROR #6025 DSI(158 SYBDR2.MFTLIVDB) - (6029)
> Block consistency failed q 115:1, 0:1:0 218 contents q 114:1, 0:1:0
>218. old=0.1
>I. 2003/06/29 21:18:56. The DSI thread for database 'SYBDR2.MFTLIVDB' is
>shutdown.
>
>DBA at the time re-synch via dump & load and cleared the error.
>
>The ASE & RS were cycled later that night and same error occured.
>Attempting to via the inbound queue failed as it seems to think that qid
>115 conatined data for qid 114.
>Tried sysadmin purge_all_open but didn't seem to reduce queue size.
>
>Performed re-synch and this appears to have cleared.
>
>Search of google & sybase point to disk failure of Stable devices, however
>no problems are encountered with other databases which are using the same
>Stable Devices.
>
>Welcome any input/thoughts
>
>Rhod
>
>
>
>
>


rhod Posted on 2003-07-11 15:33:18.0Z
From: rhod
Date: Fri, 11 Jul 2003 11:33:18 -0400
Newsgroups: sybase.public.rep-server
Subject: Re: Block Inconsistency
Message-ID: <54BD9851CF342ADF005570AA85256D60.0063BED785256D5F@webforums>
References: <51B10BCC601D9EF3005666C085256D55.005666DF85256D55@webforums> <3F0D98DA.3000700@sybase.com>
Lines: 10
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.rep-server:4432
Article PK: 874423

Greg

Thanks for your interest, we've raised a case (20322568) with tech support.

Re-synch with dump & load - we clear all connections, repdefs, disable
repagents and then go through the process of creating an active & standby
configuration.

Both the stable devices and the databases are held on the same
RAID5 array, which is logically partitioned into 3 drives.