cancel
Showing results for 
Search instead for 
Did you mean: 

Attempt to fetch logical page (6:78) in database 5 failed.

Former Member
0 Kudos

Hello every one:

I am upgrading to SQL 2005 using sql 2000 datafiles in clustered environment.

I have followd note 799058 hemogenious system copy. However after attaching the database, we are getting the following error message, when running SQL 2005 upgrade tools.

I ran dbcheck on source database there is no issue, However dbcheck is failing in new database. I tried dbcheck with repais fast and dbcheck with data loss, however both attempts have failed with exact same message.

I am not sure how to handle this error.

Please advice.

executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select (@@microsoftversion / 65536) / 256

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from master..sysdatabases where name = 'R3T'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from R3T..sysusers where name = 'r3t'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from master..sysprocesses where dbid = db_id('R3T') and program_name like 'R3%' and uid = (select uid from R3T..sysusers where name = 'r3t')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select (@@microsoftversion / 65536) / 256

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


DECLARE @n NVARCHAR(4000) DECLARE @ns NVARCHAR(4000) SET @ns = ''

DECLARE c CURSOR FOR

select case when serverproperty('Collation') is NULL then '' else convert(sysname, serverproperty('Collation')) end

union all select case when serverproperty('Edition') is NULL then '' else convert(sysname, serverproperty('Edition')) end

union all select case when serverproperty('InstanceName') is NULL then '' else convert(sysname, serverproperty('InstanceName')) end

union all select case when serverproperty('IsClustered') is NULL then '' else convert(sysname, serverproperty('IsClustered')) end

union all select case when serverproperty('IsFullTextInstalled') is NULL then '' else convert(sysname, serverproperty('IsFullTextInstalled')) end

union all select case when serverproperty('IsIntegratedSecurityOnly') is NULL then '' else convert(sysname, serverproperty('IsIntegratedSecurityOnly')) end

union all select case when serverproperty('IsSingleUser') is NULL then '' else convert(sysname, serverproperty('IsSingleUser')) end

union all select case when serverproperty('IsSyncWithBackup') is NULL then '' else convert(sysname, serverproperty('IsSyncWithBackup')) end

union all select case when serverproperty('MachineName') is NULL then '' else convert(sysname, serverproperty('MachineName')) end

union all select case when serverproperty('NumLicenses') is NULL then '' else convert(sysname, serverproperty('NumLicenses')) end

union all select case when serverproperty('ProcessID') is NULL then '' else convert(sysname, serverproperty('ProcessID')) end

union all select case when serverproperty('ProductVersion') is NULL then '' else convert(sysname, serverproperty('ProductVersion')) end

union all select case when serverproperty('ProductLevel') is NULL then '' else convert(sysname, serverproperty('ProductLevel')) end

union all select case when serverproperty('ServerName') is NULL then '' else convert(sysname, serverproperty('ServerName')) end

union all select case when serverproperty('Release') is NULL then '' else convert(sysname, serverproperty('Release')) end

union all select case when serverproperty('Patch') is NULL then '' else convert(sysname, serverproperty('Patch')) end

union all select case when serverproperty('IsSysAdmin') is NULL then '' else convert(sysname, serverproperty('IsSysAdmin')) end

OPEN c FETCH NEXT FROM c INTO @n

WHILE @@FETCH_STATUS = 0

BEGIN set @ns = @ns + @n + ';' FETCH NEXT FROM c INTO @n END

CLOSE c DEALLOCATE c select @ns

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select IS_SRVROLEMEMBER('sysadmin')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from master..sysdatabases where name = 'R3T'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from R3T..sysusers where name = 'r3t'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from R3T..sysusers where name = 'r3t'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


use R3T

declare @info nvarchar(2000)

declare @cs nvarchar(100)

declare @tmp nvarchar(200)

declare @rel nvarchar(100)

declare @patch nvarchar(100)

declare @sql nvarchar(2000)

declare schema_cursor cursor for

select name

from dbo.sysusers

where islogin = '1'

open schema_cursor

select @info = ''

fetch next from schema_cursor into @cs

while @@fetch_status = 0

begin

select @info = @info + @cs

select @info = @info + ':'

select @info = @info + cast(count(*) as varchar(20)) from sysobjects where uid = user_id(@cs) and name not in ('dtproperties')

select @info = @info + ':'

select @info = @info + cast(count(*) as varchar(20)) from sysobjects where uid = user_id(@cs) and type = 'U' and name not in ('dtproperties')

if exists(select * from sysobjects where name = 'CVERS' and uid = user_id(@cs) and type = 'U')

begin

select @info = @info + ':1'

select @sql = 'select @rel = RELEASE, @patch = EXTRELEASE from ' + @cs + '.CVERS where COMPONENT = ''SAP_BASIS'''

exec sp_executesql @sql, N'@rel nvarchar(100) output, @patch nvarchar(100) output', @rel output, @patch output

select @info = @info + ':'

select @info = @info + @rel

select @info = @info + ':'

select @info = @info + @patch

end

else select @info = @info + ':0'

if exists(select * from sysobjects where name = 'BC_CVERS' and uid = user_id(@cs) and type = 'U')

begin

select @info = @info + ':1'

end

else select @info = @info + ':0'

select @info = @info + ';'

fetch next from schema_cursor into @cs

end

close schema_cursor

deallocate schema_cursor

select @info

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


use [R3T] select count(*) from sysobjects where name like 'Y%' and type='P' and uid=user_id('r3t')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from R3T..sysusers where name = 'SAPR3TDB'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


DECLARE @n NVARCHAR(4000) DECLARE @ns NVARCHAR(4000) SET @ns = ''

DECLARE c CURSOR FOR

select case when serverproperty('Collation') is NULL then '' else convert(sysname, serverproperty('Collation')) end

union all select case when serverproperty('Edition') is NULL then '' else convert(sysname, serverproperty('Edition')) end

union all select case when serverproperty('InstanceName') is NULL then '' else convert(sysname, serverproperty('InstanceName')) end

union all select case when serverproperty('IsClustered') is NULL then '' else convert(sysname, serverproperty('IsClustered')) end

union all select case when serverproperty('IsFullTextInstalled') is NULL then '' else convert(sysname, serverproperty('IsFullTextInstalled')) end

union all select case when serverproperty('IsIntegratedSecurityOnly') is NULL then '' else convert(sysname, serverproperty('IsIntegratedSecurityOnly')) end

union all select case when serverproperty('IsSingleUser') is NULL then '' else convert(sysname, serverproperty('IsSingleUser')) end

union all select case when serverproperty('IsSyncWithBackup') is NULL then '' else convert(sysname, serverproperty('IsSyncWithBackup')) end

union all select case when serverproperty('MachineName') is NULL then '' else convert(sysname, serverproperty('MachineName')) end

union all select case when serverproperty('NumLicenses') is NULL then '' else convert(sysname, serverproperty('NumLicenses')) end

union all select case when serverproperty('ProcessID') is NULL then '' else convert(sysname, serverproperty('ProcessID')) end

union all select case when serverproperty('ProductVersion') is NULL then '' else convert(sysname, serverproperty('ProductVersion')) end

union all select case when serverproperty('ProductLevel') is NULL then '' else convert(sysname, serverproperty('ProductLevel')) end

union all select case when serverproperty('ServerName') is NULL then '' else convert(sysname, serverproperty('ServerName')) end

union all select case when serverproperty('Release') is NULL then '' else convert(sysname, serverproperty('Release')) end

union all select case when serverproperty('Patch') is NULL then '' else convert(sysname, serverproperty('Patch')) end

union all select case when serverproperty('IsSysAdmin') is NULL then '' else convert(sysname, serverproperty('IsSysAdmin')) end

OPEN c FETCH NEXT FROM c INTO @n

WHILE @@FETCH_STATUS = 0

BEGIN set @ns = @ns + @n + ';' FETCH NEXT FROM c INTO @n END

CLOSE c DEALLOCATE c select @ns

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select IS_SRVROLEMEMBER('sysadmin')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


DECLARE @n NVARCHAR(4000) DECLARE @ns NVARCHAR(4000) SET @ns = ''

DECLARE c CURSOR FOR

select case when serverproperty('Collation') is NULL then '' else convert(sysname, serverproperty('Collation')) end

union all select case when serverproperty('Edition') is NULL then '' else convert(sysname, serverproperty('Edition')) end

union all select case when serverproperty('InstanceName') is NULL then '' else convert(sysname, serverproperty('InstanceName')) end

union all select case when serverproperty('IsClustered') is NULL then '' else convert(sysname, serverproperty('IsClustered')) end

union all select case when serverproperty('IsFullTextInstalled') is NULL then '' else convert(sysname, serverproperty('IsFullTextInstalled')) end

union all select case when serverproperty('IsIntegratedSecurityOnly') is NULL then '' else convert(sysname, serverproperty('IsIntegratedSecurityOnly')) end

union all select case when serverproperty('IsSingleUser') is NULL then '' else convert(sysname, serverproperty('IsSingleUser')) end

union all select case when serverproperty('IsSyncWithBackup') is NULL then '' else convert(sysname, serverproperty('IsSyncWithBackup')) end

union all select case when serverproperty('MachineName') is NULL then '' else convert(sysname, serverproperty('MachineName')) end

union all select case when serverproperty('NumLicenses') is NULL then '' else convert(sysname, serverproperty('NumLicenses')) end

union all select case when serverproperty('ProcessID') is NULL then '' else convert(sysname, serverproperty('ProcessID')) end

union all select case when serverproperty('ProductVersion') is NULL then '' else convert(sysname, serverproperty('ProductVersion')) end

union all select case when serverproperty('ProductLevel') is NULL then '' else convert(sysname, serverproperty('ProductLevel')) end

union all select case when serverproperty('ServerName') is NULL then '' else convert(sysname, serverproperty('ServerName')) end

union all select case when serverproperty('Release') is NULL then '' else convert(sysname, serverproperty('Release')) end

union all select case when serverproperty('Patch') is NULL then '' else convert(sysname, serverproperty('Patch')) end

union all select case when serverproperty('IsSysAdmin') is NULL then '' else convert(sysname, serverproperty('IsSysAdmin')) end

OPEN c FETCH NEXT FROM c INTO @n

WHILE @@FETCH_STATUS = 0

BEGIN set @ns = @ns + @n + ';' FETCH NEXT FROM c INTO @n END

CLOSE c DEALLOCATE c select @ns

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select IS_SRVROLEMEMBER('sysadmin')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


exec sp_configure 'show advanced options', 1

reconfigure with override

exec sp_configure 'xp_cmdshell', 1

reconfigure with override

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


exec sp_dbcmptlevel 'R3T', 90

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


use R3T select count(*) from sysobjects where type = 'P' and uid = user_id('r3t')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


use R3T

declare @name sysname

declare allnames cursor for

select name from sysobjects

where type = 'P'

and (name like 'Y%' or name like 'SAP%')

and uid = user_id('r3t')

open allnames

fetch next from allnames into @name

while (@@fetch_status =0)

begin

exec ('drop procedure [r3t].[' + @name + ']')

fetch next from allnames into @name

end

close allnames

deallocate allnames

-


[Microsoft][ODBC SQL Server Driver][SQL Server]Attempt to fetch logical page (6:78) in database 5 failed. It belongs to allocation unit 71905451171905536 not to 281474979397632.

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


use R3T select count(*) from sysobjects where type = 'P' and uid = user_id('r3t')

-


executeSQL is called with following parameters:

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

THIS IS THE SQL ERROR LOGS:

2008-05-28 15:49:20.79 spid21s Starting up database 'R3T'.

2008-05-28 15:49:20.79 spid20s Starting up database 'msdb'.

2008-05-28 15:49:20.82 spid20s 1 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.

2008-05-28 15:49:20.84 spid20s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.

2008-05-28 15:49:20.84 spid20s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.

2008-05-28 15:49:20.88 spid21s Analysis of database 'R3T' (5) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.

2008-05-28 15:49:20.90 spid21s 1 transactions rolled forward in database 'R3T' (5). This is an informational message only. No user action is required.

2008-05-28 15:49:21.06 spid21s 0 transactions rolled back in database 'R3T' (5). This is an informational message only. No user action is required.

2008-05-28 15:49:21.06 spid21s Recovery is writing a checkpoint in database 'R3T' (5). This is an informational message only. No user action is required.

2008-05-28 15:49:21.06 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.

2008-05-28 15:49:21.06 spid5s Recovery is complete. This is an informational message only. No user action is required.

2008-05-28 15:49:25.60 spid51 Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.

2008-05-28 15:49:25.74 spid51 Using 'xpsqlbot.dll' version '2005.90.3042' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.

2008-05-28 15:49:25.81 spid51 Using 'xpstar90.dll' version '2005.90.3042' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.

2008-05-28 15:49:25.82 spid51 Using 'xplog70.dll' version '2005.90.3042' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.

2008-05-28 15:58:29.52 spid53 Setting database option SINGLE_USER to ON for database R3T.

2008-05-28 15:58:29.52 spid53 Setting database option SINGLE_USER to ON for database R3T.

2008-05-28 15:59:15.77 spid53 Error: 605, Severity: 21, State: 3.

2008-05-28 15:59:15.77 spid53 Attempt to fetch logical page (6:72) in database 5 failed. It belongs to allocation unit 71905451171905536 not to 281474979397632.

2008-05-28 15:59:15.78 spid53 DBCC CHECKDB (R3T, repair_fast) WITH all_errormsgs, no_infomsgs executed by sa terminated abnormally due to error state 5. Elapsed time: 0 hours 0 minutes 18 seconds.

2008-05-28 16:02:17.43 spid54 Error: 605, Severity: 21, State: 3.

2008-05-28 16:02:17.43 spid54 Attempt to fetch logical page (6:72) in database 5 failed. It belongs to allocation unit 71905451171905536 not to 281474979397632.

2008-05-28 16:02:17.44 spid54 DBCC CHECKDB (R3T, repair_allow_data_loss) WITH all_errormsgs, no_infomsgs executed by sa terminated abnormally due to error state 5. Elapsed time: 0 hours 0 minutes 10 seconds.

2008-05-28 16:04:53.26 spid54 Setting database option MULTI_USER to ON for database R3T.

2008-05-28 16:04:53.26 spid54 Setting database option MULTI_USER to ON for database R3T.

2008-05-29 00:00:06.31 spid15s This instance of SQL Server has been using a process ID of 2016 since 5/28/2008 3:49:21 PM (local) 5/28/2008 10:49:21 PM (UTC). This is an informational message only; no user action is required.

2008-05-29 09:45:59.67 spid54 Error: 605, Severity: 12, State: 3.

2008-05-29 09:45:59.67 spid54 Attempt to fetch logical page (6:72) in database 6 failed. It belongs to allocation unit 71905451171905536 not to 281474979397632.

2008-05-29 09:45:59.69 spid54 DBCC CHECKDB (R3T) WITH no_infomsgs executed by sa terminated abnormally due to error state 5. Elapsed time: 0 hours 1 minutes 20 seconds.

Former Member
0 Kudos

Hi,

Error: 605, Severity: 12, State: 3

This usually means that you have to recover the database.

Also the fact that DBCC CHECKDB do not run (Error state: 5) indicates database error.

Can't you upgrade to SQL-2005 first

(point 6 in OSS # 799058),

and then attach the database (point 8 in OSS # 799058)?

or am I getting this completely wrong ?

Former Member
0 Kudos

No you are completly correct. That was the road to go, however it has been changed since we had allots of issues with clustering the servers. mangment changed the plan in last minute.

Can you elaborate on recovering the database, As I am not a DBA.

Regards,

KG

Former Member
0 Kudos

You are talking about a "source database" is it possible for you to make another copy of that source database (I think the actual copy went wrong) without loosing anything ?

Otherwise, if you have been running the database in the Cluster for a while (adding important data), the only way to get back is via restore from a backup.

In that case (added important data), there's no other way than restore.

Former Member
0 Kudos

Tomas,

Source database was not clustered, we copied the source to clustered database. Can you confirm my steps please.

Detach database (SQL2000)

copied data files over

Attached database (SQL2005)

Run sapinst migration tool (Upgrade to sql 2005)

Regards

Former Member
0 Kudos

Hi,

The steps are correct. That's the way I do it.

Somebody might say that you do not need to detach the database.

It is correct that you can simply stop SQL Server and then copy the files.

But, In my mind, the risk for somebody else to start SQL Server by mistake is there so an detach is better in this case.