fadyabuzuaiter
asked on
Sybase Database Corruption From Rep Server
Hello,
i have big problem , after startup the sybase rep agent the main databases got corrupted , is the rep server will corrupt the database ?
00:00000:02611:2011/09/25 15:07:01.61 server Started Rep Agent on database, 'xxx' (dbid = 16).
01:00000:02611:2011/09/25 15:07:01.76 server Error: 624, Severity: 21, State: 1
01:00000:02611:2011/09/25 15:07:01.76 server Adaptive Server failed to retrieve a row via its RID in database 'xxx' because the requested RID has a high
er number than the last RID on the page. Rid pageid = 0x281eacd; row num = 0x4. Page pointer = 0x10472ffe800, pageno = 42068685, status = 0x105, objectid = 8
, indexid = 0, level = 0.
01:00000:02611:2011/09/25 15:07:01.76 server Rep Agent Thread for database 'xxx' (dbid = 16) terminated abnormally with error. (major 0, minor 24)
00:00000:05356:2011/09/25 15:07:05.92 server Started Rep Agent on database, 'xxx' (dbid = 16).
01:00000:05356:2011/09/25 15:07:06.04 server Error: 624, Severity: 21, State: 1
01:00000:05356:2011/09/25 15:07:06.04 server Adaptive Server failed to retrieve a row via its RID in database 'xxx' because the requested RID has a high
er number than the last RID on the page. Rid pageid = 0x281eacd; row num = 0x4. Page pointer = 0x10472ffe800, pageno = 42068685, status = 0x105, objectid = 8
, indexid = 0, level = 0.
01:00000:05356:2011/09/25 15:07:06.04 server Rep Agent Thread for database 'xxx' (dbid = 16) terminated abnormally with error. (major 0, minor 24)
03:00000:05342:2011/09/25 15:07:08.94 kernel Cannot read, host process disconnected: spid: 5342
00:00000:06013:2011/09/25 15:07:09.23 server Started Rep Agent on database, 'xxx' (dbid = 16).
01:00000:06013:2011/09/25 15:07:09.29 server Error: 624, Severity: 21, State: 1
01:00000:06013:2011/09/25 15:07:09.29 server Adaptive Server failed to retrieve a row via its RID in database 'xxx' because the requested RID has a high
er number than the last RID on the page. Rid pageid = 0x281eacd; row num = 0x4. Page pointer = 0x10472ffe800, pageno = 42068685, status = 0x105, objectid = 8
, indexid = 0, level = 0.
01:00000:06013:2011/09/25 15:07:09.29 server Rep Agent Thread for database 'xxx' (dbid = 16) terminated abnormally with error. (major 0, minor 24)
i have big problem , after startup the sybase rep agent the main databases got corrupted , is the rep server will corrupt the database ?
00:00000:02611:2011/09/25 15:07:01.61 server Started Rep Agent on database, 'xxx' (dbid = 16).
01:00000:02611:2011/09/25 15:07:01.76 server Error: 624, Severity: 21, State: 1
01:00000:02611:2011/09/25 15:07:01.76 server Adaptive Server failed to retrieve a row via its RID in database 'xxx' because the requested RID has a high
er number than the last RID on the page. Rid pageid = 0x281eacd; row num = 0x4. Page pointer = 0x10472ffe800, pageno = 42068685, status = 0x105, objectid = 8
, indexid = 0, level = 0.
01:00000:02611:2011/09/25 15:07:01.76 server Rep Agent Thread for database 'xxx' (dbid = 16) terminated abnormally with error. (major 0, minor 24)
00:00000:05356:2011/09/25 15:07:05.92 server Started Rep Agent on database, 'xxx' (dbid = 16).
01:00000:05356:2011/09/25 15:07:06.04 server Error: 624, Severity: 21, State: 1
01:00000:05356:2011/09/25 15:07:06.04 server Adaptive Server failed to retrieve a row via its RID in database 'xxx' because the requested RID has a high
er number than the last RID on the page. Rid pageid = 0x281eacd; row num = 0x4. Page pointer = 0x10472ffe800, pageno = 42068685, status = 0x105, objectid = 8
, indexid = 0, level = 0.
01:00000:05356:2011/09/25 15:07:06.04 server Rep Agent Thread for database 'xxx' (dbid = 16) terminated abnormally with error. (major 0, minor 24)
03:00000:05342:2011/09/25 15:07:08.94 kernel Cannot read, host process disconnected: spid: 5342
00:00000:06013:2011/09/25 15:07:09.23 server Started Rep Agent on database, 'xxx' (dbid = 16).
01:00000:06013:2011/09/25 15:07:09.29 server Error: 624, Severity: 21, State: 1
01:00000:06013:2011/09/25 15:07:09.29 server Adaptive Server failed to retrieve a row via its RID in database 'xxx' because the requested RID has a high
er number than the last RID on the page. Rid pageid = 0x281eacd; row num = 0x4. Page pointer = 0x10472ffe800, pageno = 42068685, status = 0x105, objectid = 8
, indexid = 0, level = 0.
01:00000:06013:2011/09/25 15:07:09.29 server Rep Agent Thread for database 'xxx' (dbid = 16) terminated abnormally with error. (major 0, minor 24)
Work Around:
use RSSD
go
rs_zeroltm servername, database
go
Good luck,
Vinod Pottekkatt
Sorry, can't agree with Vinod's solution. That's a RepServer "fix" for an ASE problem. It won't fix the ASE problem and it might introduce a RepServer issue in that it will reset where it thinks the RepAgent is up to.
This isn't actually a RepServer problem and doesn't need any kind of RepServer solution. You have an ASE data corruption which was discovered by but is not related to the Rep Agent. Fix the data corruption in ASE.
This isn't actually a RepServer problem and doesn't need any kind of RepServer solution. You have an ASE data corruption which was discovered by but is not related to the Rep Agent. Fix the data corruption in ASE.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
any luck?
RepServer doesn't corrupt databases, in fact it's one of the few things you can do to protect yourself against database corruption because no data is copied. (Database dumps and disk replication copy physical data, so if the source is corrupt, the target will be too. Replication reapplies transactions on a completely separate copy of data.)
Given you have data corruption, all use can make it worse. This is not specific to RepAgent or RepServer. You need to give dbid 16 a full set of dbccs as soon as you can. (dbcc checkstorage + dbcc checkverify, or the older style dbcc checkcatalog + dbcc checkalloc + dbcc checkdb)