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.

DBCC checkalloc errors

4 posts in Windows NT Last posting was on 2001-04-10 18:33:27.0Z
kerry_mcginn Posted on 2001-04-09 20:52:50.0Z
From: kerry_mcginn@amsinc.com
Date: Mon, 9 Apr 2001 16:52:50 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: DBCC checkalloc errors
Message-ID: <BB4930245AD59EF50072B37A85256A29.0072B38B85256A29@webforums>
Lines: 253
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:975
Article PK: 1087582

A database dump created from an ASE 11.0.3.3 database was loaded into a ASE
12.0.0.2 SWR 9503 database. The load appeared to complete successfully. The
problem arises when executing DBCC checkalloc(dbname). Trying to resolve
the errors with DBCC checkalloc(dbname,fix) option did not fix the errors.
The DBCC errors are listed below. Any ideas? Thanks.

DBCC LOG LIST
DBCC execution completed. If DBCC printed error messages, contact a user
with System Administrator (SA) role.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=1 (name = sysobjects) inconsistent after Large Scale
Allocation. Page 20 in extent 16 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=2 (name = sysindexes) inconsistent after Large Scale
Allocation. Page 27 in extent 24 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=2 (name = sysindexes) inconsistent after Large Scale
Allocation. Page 28 in extent 24 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=3 (name = syscolumns) inconsistent after Large Scale
Allocation. Page 52 in extent 48 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=3 (name = syscolumns) inconsistent after Large Scale
Allocation. Page 53 in extent 48 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=3 (name = syscolumns) inconsistent after Large Scale
Allocation. Page 61 in extent 56 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=3 (name = syscolumns) inconsistent after Large Scale
Allocation. Page 59 in extent 56 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=3 (name = syscolumns) inconsistent after Large Scale
Allocation. Page 60 in extent 56 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=5 (name = sysprocedures) inconsistent after Large
Scale Allocation. Page 91 in extent 88 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=5 (name = sysprocedures) inconsistent after Large
Scale Allocation. Page 92 in extent 88 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=5 (name = sysprocedures) inconsistent after Large
Scale Allocation. Page 94 in extent 88 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=5 (name = sysprocedures) inconsistent after Large
Scale Allocation. Page 101 in extent 96 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=5 (name = sysprocedures) inconsistent after Large
Scale Allocation. Page 102 in extent 96 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=12 (name = sysdepends) inconsistent after Large Scale
Allocation. Page 223 in extent 216 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=12 (name = sysdepends) inconsistent after Large Scale
Allocation. Page 220 in extent 216 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=12 (name = sysdepends) inconsistent after Large Scale
Allocation. Page 219 in extent 216 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=12 (name = sysdepends) inconsistent after Large Scale
Allocation. Page 222 in extent 216 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=1 (name = sysobjects) inconsistent after Large Scale
Allocation. Page 11 in extent 8 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=1 (name = sysobjects) inconsistent after Large Scale
Allocation. Page 20 in extent 16 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=2 (name = sysindexes) inconsistent after Large Scale
Allocation. Page 27 in extent 24 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=2 (name = sysindexes) inconsistent after Large Scale
Allocation. Page 28 in extent 24 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=2 (name = sysindexes) inconsistent after Large Scale
Allocation. Page 37 in extent 32 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=3 (name = syscolumns) inconsistent after Large Scale
Allocation. Page 52 in extent 48 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=3 (name = syscolumns) inconsistent after Large Scale
Allocation. Page 53 in extent 48 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=3 (name = syscolumns) inconsistent after Large Scale
Allocation. Page 59 in extent 56 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=3 (name = syscolumns) inconsistent after Large Scale
Allocation. Page 60 in extent 56 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=3 (name = syscolumns) inconsistent after Large Scale
Allocation. Page 61 in extent 56 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=4 (name = systypes) inconsistent after Large Scale
Allocation. Page 70 in extent 64 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=4 (name = systypes) inconsistent after Large Scale
Allocation. Page 75 in extent 72 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=4 (name = systypes) inconsistent after Large Scale
Allocation. Page 78 in extent 72 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=4 (name = systypes) inconsistent after Large Scale
Allocation. Page 84 in extent 80 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=4 (name = systypes) inconsistent after Large Scale
Allocation. Page 86 in extent 80 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=5 (name = sysprocedures) inconsistent after Large
Scale Allocation. Page 91 in extent 88 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=5 (name = sysprocedures) inconsistent after Large
Scale Allocation. Page 92 in extent 88 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=5 (name = sysprocedures) inconsistent after Large
Scale Allocation. Page 94 in extent 88 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=5 (name = sysprocedures) inconsistent after Large
Scale Allocation. Page 101 in extent 96 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=5 (name = sysprocedures) inconsistent after Large
Scale Allocation. Page 102 in extent 96 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=7 (name = syssegments) inconsistent after Large Scale
Allocation. Page 123 in extent 120 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=7 (name = syssegments) inconsistent after Large Scale
Allocation. Page 124 in extent 120 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=7 (name = syssegments) inconsistent after Large Scale
Allocation. Page 125 in extent 120 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=7 (name = syssegments) inconsistent after Large Scale
Allocation. Page 126 in extent 120 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=11 (name = sysalternates) inconsistent after Large
Scale Allocation. Page 198 in extent 192 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=11 (name = sysalternates) inconsistent after Large
Scale Allocation. Page 199 in extent 192 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=11 (name = sysalternates) inconsistent after Large
Scale Allocation. Page 203 in extent 200 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=11 (name = sysalternates) inconsistent after Large
Scale Allocation. Page 206 in extent 200 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=11 (name = sysalternates) inconsistent after Large
Scale Allocation. Page 207 in extent 200 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=12 (name = sysdepends) inconsistent after Large Scale
Allocation. Page 219 in extent 216 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=12 (name = sysdepends) inconsistent after Large Scale
Allocation. Page 220 in extent 216 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=12 (name = sysdepends) inconsistent after Large Scale
Allocation. Page 222 in extent 216 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=12 (name = sysdepends) inconsistent after Large Scale
Allocation. Page 223 in extent 216 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=12 (name = sysdepends) inconsistent after Large Scale
Allocation. Page 229 in extent 224 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=12 (name = sysdepends) inconsistent after Large Scale
Allocation. Page 230 in extent 224 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=12 (name = sysdepends) inconsistent after Large Scale
Allocation. Page 231 in extent 224 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=13 (name = syskeys) inconsistent after Large Scale
Allocation. Page 235 in extent 232 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=13 (name = syskeys) inconsistent after Large Scale
Allocation. Page 237 in extent 232 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=13 (name = syskeys) inconsistent after Large Scale
Allocation. Page 238 in extent 232 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=13 (name = syskeys) inconsistent after Large Scale
Allocation. Page 239 in extent 232 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=13 (name = syskeys) inconsistent after Large Scale
Allocation. Page 244 in extent 240 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=13 (name = syskeys) inconsistent after Large Scale
Allocation. Page 245 in extent 240 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=13 (name = syskeys) inconsistent after Large Scale
Allocation. Page 246 in extent 240 is found reserved.
Server Message: Number 12909, Severity 16
Line 1:
Table with object id=13 (name = syskeys) inconsistent after Large Scale
Allocation. Page 247 in extent 240 is found reserved.


Jim Egan Posted on 2001-04-09 22:13:08.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: DBCC checkalloc errors
Date: Mon, 9 Apr 2001 16:13:08 -0600
Message-ID: <MPG.153be1df15a3e90598b268@forums.sybase.com>
References: <BB4930245AD59EF50072B37A85256A29.0072B38B85256A29@webforums>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 6
NNTP-Posting-Host: jpe650.sybase.com 157.133.56.43
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:973
Article PK: 1087581

Did you have the database in single user mode when you ran CHECKALLOC?
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com


kerry_mcginn Posted on 2001-04-10 16:30:12.0Z
From: kerry_mcginn@amsinc.com
Date: Tue, 10 Apr 2001 12:30:12 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: DBCC checkalloc errors
Message-ID: <D172B8709DEA5A5D005AA7BD85256A2A.007CE72185256A29@webforums>
References: <BB4930245AD59EF50072B37A85256A29.0072B38B85256A29@webforums> <MPG.153be1df15a3e90598b268@forums.sybase.com>
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:969
Article PK: 1087575

Yes, it was in single-user mode using checkalloc with the fix option.


Jim Egan Posted on 2001-04-10 18:33:27.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: DBCC checkalloc errors
Date: Tue, 10 Apr 2001 12:33:27 -0600
Message-ID: <MPG.153cffdec2a359b998b272@forums.sybase.com>
References: <BB4930245AD59EF50072B37A85256A29.0072B38B85256A29@webforums> <MPG.153be1df15a3e90598b268@forums.sybase.com> <D172B8709DEA5A5D005AA7BD85256A2A.007CE72185256A29@webforums>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 6
NNTP-Posting-Host: jpe650.sybase.com 157.133.56.43
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:967
Article PK: 1087573

Call Tech Support. The way you tried to fix it is supposed to work.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com