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.

Error: 12301 but no dbcc error

10 posts in General Discussion Last posting was on 2007-07-19 06:22:08.0Z
PDreyer Posted on 2007-07-18 07:58:00.0Z
Sender: 4f53.469dc489.1804289383@sybase.com
From: PDreyer
Newsgroups: sybase.public.ase.general
Subject: Error: 12301 but no dbcc error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <469dc808.4fb3.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jul 2007 00:58:00 -0700
X-Trace: forums-1-dub 1184745480 10.22.241.41 (18 Jul 2007 00:58:00 -0700)
X-Original-Trace: 18 Jul 2007 00:58:00 -0700, 10.22.241.41
Lines: 152
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:22820
Article PK: 70758

What could be causing this error but no dbcc errors
---------------------------------------------------
01:00000:00142:2007/07/18 01:52:00.99 server Error: 12301,
Severity: 20, State: 1
01:00000:00142:2007/07/18 01:52:01.00 server Internal
error: the index (id = 2) and the data for row (1431128, 5)
in table 'GMP_GRCV_DBF', database 8 are inconsistent; data
is marked deleted but index is not. Aborting the
transaction.
02:00000:00086:2007/07/18 03:06:39.10 server Error: 12301,
Severity: 20, State: 1
02:00000:00086:2007/07/18 03:06:39.10 server Internal
error: the index (id = 2) and the data for row (1431128, 5)
in table 'GMP_GRCV_DBF', database 8 are inconsistent; data
is marked deleted but index is not. Aborting the
transaction.
---------------------------------------------------
Adaptive Server Enterprise/12.5.3/EBF 13055
ESD#5/P/Sun_svr4/OS 5.8/ase1253/1939/64-bit/FBO/Tue Dec 6
09:13:20 2005
---------------------------------------------------
> dbcc tablealloc(GMP_GRCV_DBF)
2> go
The default report option of OPTIMIZED is used for this run.
The default fix option of FIX is used for this run.
***************************************************************
TABLE: GMP_GRCV_DBF OBJID = 2096723491
INDID=0 FIRST=734121 ROOT=734121 SORT=0
Data level: 0. 144 Data pages allocated and 20
Extents allocated.
INDID=2 FIRST=2445761 ROOT=2445760 SORT=1
Indid : 2. 8 Index pages allocated and 2
Extents allocated.
TOTAL # of extents = 22
Alloc page 733952 (# of extent=2 used pages=16 ref pages=16)
Alloc page 791552 (# of extent=1 used pages=8 ref pages=8)
Alloc page 798464 (# of extent=1 used pages=8 ref pages=8)
Alloc page 1431040 (# of extent=1 used pages=1 ref pages=1)
Alloc page 1868544 (# of extent=1 used pages=7 ref pages=7)
Alloc page 4050688 (# of extent=1 used pages=8 ref pages=8)
Alloc page 4516608 (# of extent=1 used pages=8 ref pages=8)
Alloc page 4674560 (# of extent=1 used pages=8 ref pages=8)
Alloc page 7592960 (# of extent=1 used pages=6 ref pages=6)
Alloc page 8346368 (# of extent=1 used pages=8 ref pages=8)
Alloc page 8786432 (# of extent=1 used pages=6 ref pages=6)
Alloc page 9601536 (# of extent=1 used pages=8 ref pages=8)
Alloc page 9714944 (# of extent=1 used pages=8 ref pages=8)
Alloc page 11449600 (# of extent=1 used pages=8 ref pages=8)
Alloc page 11793408 (# of extent=1 used pages=7 ref pages=7)
Alloc page 13112832 (# of extent=1 used pages=8 ref pages=8)
Alloc page 13115392 (# of extent=3 used pages=24 ref
pages=24)
Alloc page 2445568 (# of extent=2 used pages=9 ref pages=9)
Total (# of extent=22 used pages=156 ref pages=156) in this
database
DBCC execution completed. If DBCC printed error messages,
contact a user with System Administrator (SA) role.
1> dbcc checktable(GMP_GRCV_DBF)
2> go
Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
The total number of data pages in this table is 144.
The total number of pages which could be garbage collected
to free up some space is 17.
Table has 2256 data rows.
DBCC execution completed. If DBCC printed error messages,
contact a user with System Administrator (SA) role.
---------------------------------------------------
Then later got the error again
---------------------------------------------------
03:00000:00245:2007/07/18 08:37:42.02 server Error: 12301,
Severity: 20, State: 1
03:00000:00245:2007/07/18 08:37:42.02 server Internal
error: the index (id = 2) and the data for row (1431128, 7)
in table 'GMP_GRCV_DBF', database 8 are inconsistent; data
is marked deleted but index is not. Aborting the
transaction.
---------------------------------------------------
And again no dbcc errors
---------------------------------------------------
1> dbcc tablealloc ('GMP_GRCV_DBF',full,nofix)
2> go
***************************************************************
TABLE: GMP_GRCV_DBF OBJID = 2096723491
INDID=0 FIRST=734121 ROOT=734121 SORT=0
Data level: 0. 145 Data pages allocated and 20
Extents allocated.
INDID=2 FIRST=2445761 ROOT=2445760 SORT=1
Indid : 2. 8 Index pages allocated and 2
Extents allocated.
TOTAL # of extents = 22
Alloc page 733952 (# of extent=2 used pages=16 ref pages=16)
Alloc page 791552 (# of extent=1 used pages=8 ref pages=8)
Alloc page 798464 (# of extent=1 used pages=8 ref pages=8)
Alloc page 1431040 (# of extent=1 used pages=2 ref pages=2)
Alloc page 1868544 (# of extent=1 used pages=7 ref pages=7)
Alloc page 2445568 (# of extent=2 used pages=9 ref pages=9)
Alloc page 4050688 (# of extent=1 used pages=8 ref pages=8)
Alloc page 4516608 (# of extent=1 used pages=8 ref pages=8)
Alloc page 4674560 (# of extent=1 used pages=8 ref pages=8)
Alloc page 7592960 (# of extent=1 used pages=6 ref pages=6)
Alloc page 8346368 (# of extent=1 used pages=8 ref pages=8)
Alloc page 8786432 (# of extent=1 used pages=6 ref pages=6)
Alloc page 9601536 (# of extent=1 used pages=8 ref pages=8)
Alloc page 9714944 (# of extent=1 used pages=8 ref pages=8)
Alloc page 11449600 (# of extent=1 used pages=8 ref pages=8)
Alloc page 11793408 (# of extent=1 used pages=7 ref pages=7)
Alloc page 13112832 (# of extent=1 used pages=8 ref pages=8)
Alloc page 13115392 (# of extent=3 used pages=24 ref
pages=24)
Total (# of extent=22 used pages=157 ref pages=157) in this
database
DBCC execution completed. If DBCC printed error messages,
contact a user with System Administrator (SA) role.
1> dbcc indexalloc ('GMP_GRCV_DBF',2,full,nofix)
2> go
***************************************************************
TABLE: GMP_GRCV_DBF OBJID = 2096723491
INDID=2 FIRST=2445761 ROOT=2445760 SORT=1
Indid : 2. 8 Index pages allocated and 2
Extents allocated.
TOTAL # of extents = 2
Alloc page 2445568 (# of extent=2 used pages=9 ref pages=9)
Total (# of extent=2 used pages=9 ref pages=9) in this
database
DBCC execution completed. If DBCC printed error messages,
contact a user with System Administrator (SA) role.
1> dbcc checktable ('GMP_GRCV_DBF')
2> go
Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
The total number of data pages in this table is 146.
The total number of pages which could be garbage collected
to free up some space is 17.
Table has 2261 data rows.
DBCC execution completed. If DBCC printed error messages,
contact a user with System Administrator (SA) role.
1> dbcc checkindex ('GMP_GRCV_DBF',2)
2> go
Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
The total number of data pages in this table is 144.
The total number of pages which could be garbage collected
to free up some space is 17.
Table has 2257 data rows.
DBCC execution completed. If DBCC printed error messages,
contact a user with System Administrator (SA) role.
1> select db_id()
2> go

------
8

(1 row affected)
---------------------------------------------------


Rob Verschoor Posted on 2007-07-18 08:24:34.0Z
Reply-To: "Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.general
References: <469dc808.4fb3.1681692777@sybase.com>
Subject: Re: Error: 12301 but no dbcc error
Lines: 178
Organization: Sypron B.V. / TeamSybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: a123048.upc-a.chello.nl
X-Original-NNTP-Posting-Host: a123048.upc-a.chello.nl
Message-ID: <469dce42$2@forums-1-dub>
Date: 18 Jul 2007 01:24:34 -0700
X-Trace: forums-1-dub 1184747074 62.163.123.48 (18 Jul 2007 01:24:34 -0700)
X-Original-Trace: 18 Jul 2007 01:24:34 -0700, a123048.upc-a.chello.nl
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:22822
Article PK: 70762

The classic dbcc commands which you've listed do not detect all errors. Did
you try dbcc checkstorage?

HTH,

Rob V.
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (new edition!)
"The Complete Sybase ASE Quick Reference Guide" (new edition!)
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

<PDreyer> wrote in message news:469dc808.4fb3.1681692777@sybase.com...
> What could be causing this error but no dbcc errors
> ---------------------------------------------------
> 01:00000:00142:2007/07/18 01:52:00.99 server Error: 12301,
> Severity: 20, State: 1
> 01:00000:00142:2007/07/18 01:52:01.00 server Internal
> error: the index (id = 2) and the data for row (1431128, 5)
> in table 'GMP_GRCV_DBF', database 8 are inconsistent; data
> is marked deleted but index is not. Aborting the
> transaction.
> 02:00000:00086:2007/07/18 03:06:39.10 server Error: 12301,
> Severity: 20, State: 1
> 02:00000:00086:2007/07/18 03:06:39.10 server Internal
> error: the index (id = 2) and the data for row (1431128, 5)
> in table 'GMP_GRCV_DBF', database 8 are inconsistent; data
> is marked deleted but index is not. Aborting the
> transaction.
> ---------------------------------------------------
> Adaptive Server Enterprise/12.5.3/EBF 13055
> ESD#5/P/Sun_svr4/OS 5.8/ase1253/1939/64-bit/FBO/Tue Dec 6
> 09:13:20 2005
> ---------------------------------------------------
>> dbcc tablealloc(GMP_GRCV_DBF)
> 2> go
> The default report option of OPTIMIZED is used for this run.
> The default fix option of FIX is used for this run.
> ***************************************************************
> TABLE: GMP_GRCV_DBF OBJID = 2096723491
> INDID=0 FIRST=734121 ROOT=734121 SORT=0
> Data level: 0. 144 Data pages allocated and 20
> Extents allocated.
> INDID=2 FIRST=2445761 ROOT=2445760 SORT=1
> Indid : 2. 8 Index pages allocated and 2
> Extents allocated.
> TOTAL # of extents = 22
> Alloc page 733952 (# of extent=2 used pages=16 ref pages=16)
> Alloc page 791552 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 798464 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 1431040 (# of extent=1 used pages=1 ref pages=1)
> Alloc page 1868544 (# of extent=1 used pages=7 ref pages=7)
> Alloc page 4050688 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 4516608 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 4674560 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 7592960 (# of extent=1 used pages=6 ref pages=6)
> Alloc page 8346368 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 8786432 (# of extent=1 used pages=6 ref pages=6)
> Alloc page 9601536 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 9714944 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 11449600 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 11793408 (# of extent=1 used pages=7 ref pages=7)
> Alloc page 13112832 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 13115392 (# of extent=3 used pages=24 ref
> pages=24)
> Alloc page 2445568 (# of extent=2 used pages=9 ref pages=9)
> Total (# of extent=22 used pages=156 ref pages=156) in this
> database
> DBCC execution completed. If DBCC printed error messages,
> contact a user with System Administrator (SA) role.
> 1> dbcc checktable(GMP_GRCV_DBF)
> 2> go
> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
> The total number of data pages in this table is 144.
> The total number of pages which could be garbage collected
> to free up some space is 17.
> Table has 2256 data rows.
> DBCC execution completed. If DBCC printed error messages,
> contact a user with System Administrator (SA) role.
> ---------------------------------------------------
> Then later got the error again
> ---------------------------------------------------
> 03:00000:00245:2007/07/18 08:37:42.02 server Error: 12301,
> Severity: 20, State: 1
> 03:00000:00245:2007/07/18 08:37:42.02 server Internal
> error: the index (id = 2) and the data for row (1431128, 7)
> in table 'GMP_GRCV_DBF', database 8 are inconsistent; data
> is marked deleted but index is not. Aborting the
> transaction.
> ---------------------------------------------------
> And again no dbcc errors
> ---------------------------------------------------
> 1> dbcc tablealloc ('GMP_GRCV_DBF',full,nofix)
> 2> go
> ***************************************************************
> TABLE: GMP_GRCV_DBF OBJID = 2096723491
> INDID=0 FIRST=734121 ROOT=734121 SORT=0
> Data level: 0. 145 Data pages allocated and 20
> Extents allocated.
> INDID=2 FIRST=2445761 ROOT=2445760 SORT=1
> Indid : 2. 8 Index pages allocated and 2
> Extents allocated.
> TOTAL # of extents = 22
> Alloc page 733952 (# of extent=2 used pages=16 ref pages=16)
> Alloc page 791552 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 798464 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 1431040 (# of extent=1 used pages=2 ref pages=2)
> Alloc page 1868544 (# of extent=1 used pages=7 ref pages=7)
> Alloc page 2445568 (# of extent=2 used pages=9 ref pages=9)
> Alloc page 4050688 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 4516608 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 4674560 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 7592960 (# of extent=1 used pages=6 ref pages=6)
> Alloc page 8346368 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 8786432 (# of extent=1 used pages=6 ref pages=6)
> Alloc page 9601536 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 9714944 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 11449600 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 11793408 (# of extent=1 used pages=7 ref pages=7)
> Alloc page 13112832 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 13115392 (# of extent=3 used pages=24 ref
> pages=24)
> Total (# of extent=22 used pages=157 ref pages=157) in this
> database
> DBCC execution completed. If DBCC printed error messages,
> contact a user with System Administrator (SA) role.
> 1> dbcc indexalloc ('GMP_GRCV_DBF',2,full,nofix)
> 2> go
> ***************************************************************
> TABLE: GMP_GRCV_DBF OBJID = 2096723491
> INDID=2 FIRST=2445761 ROOT=2445760 SORT=1
> Indid : 2. 8 Index pages allocated and 2
> Extents allocated.
> TOTAL # of extents = 2
> Alloc page 2445568 (# of extent=2 used pages=9 ref pages=9)
> Total (# of extent=2 used pages=9 ref pages=9) in this
> database
> DBCC execution completed. If DBCC printed error messages,
> contact a user with System Administrator (SA) role.
> 1> dbcc checktable ('GMP_GRCV_DBF')
> 2> go
> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
> The total number of data pages in this table is 146.
> The total number of pages which could be garbage collected
> to free up some space is 17.
> Table has 2261 data rows.
> DBCC execution completed. If DBCC printed error messages,
> contact a user with System Administrator (SA) role.
> 1> dbcc checkindex ('GMP_GRCV_DBF',2)
> 2> go
> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
> The total number of data pages in this table is 144.
> The total number of pages which could be garbage collected
> to free up some space is 17.
> Table has 2257 data rows.
> DBCC execution completed. If DBCC printed error messages,
> contact a user with System Administrator (SA) role.
> 1> select db_id()
> 2> go
>
> ------
> 8
>
> (1 row affected)
> ---------------------------------------------------


PDreyer Posted on 2007-07-18 09:32:32.0Z
Sender: 502a.469dccc8.1804289383@sybase.com
From: PDreyer
Newsgroups: sybase.public.ase.general
Subject: Re: Error: 12301 but no dbcc error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <469dde30.5198.1681692777@sybase.com>
References: <469dce42$2@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jul 2007 02:32:32 -0700
X-Trace: forums-1-dub 1184751152 10.22.241.41 (18 Jul 2007 02:32:32 -0700)
X-Original-Trace: 18 Jul 2007 02:32:32 -0700, 10.22.241.41
Lines: 200
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:22823
Article PK: 70765

No, I do not have the dbccdb installed on this server.

I tried reorg rebuild on the table, it completed with no
errors.
Then after a while I got the error again.

I will setup dbccdb next.

PS. Sorry for the duplicate posts - Browser interface was
slow

> The classic dbcc commands which you've listed do not
> detect all errors. Did you try dbcc checkstorage?
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> --- Rob Verschoor
>
> Certified Sybase Professional DBA for ASE
> 12.5/12.0/11.5/11.0 and Replication Server 12.5 /
> TeamSybase
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> ASE" (new edition!) "The Complete Sybase ASE Quick
> Reference Guide" (new edition!) "The Complete Sybase
> Replication Server Quick Reference Guide"
>
> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
> http://www.sypron.nl
> Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The
> Netherlands
> ----------------------------------------------------------
> ---
>
> <PDreyer> wrote in message
> > news:469dc808.4fb3.1681692777@sybase.com... What could
> > be causing this error but no dbcc errors
> > ---------------------------------------------------
> 01:00000:00142:2007/07/18 01:52:00.99 server Error: 12301
> > , Severity: 20, State: 1
> > 01:00000:00142:2007/07/18 01:52:01.00 server Internal
> > error: the index (id = 2) and the data for row (1431128,
> > 5) in table 'GMP_GRCV_DBF', database 8 are inconsistent;
> > data is marked deleted but index is not. Aborting the
> > transaction.
> > 02:00000:00086:2007/07/18 03:06:39.10 server Error:
> > 12301, Severity: 20, State: 1
> > 02:00000:00086:2007/07/18 03:06:39.10 server Internal
> > error: the index (id = 2) and the data for row (1431128,
> > 5) in table 'GMP_GRCV_DBF', database 8 are inconsistent;
> > data is marked deleted but index is not. Aborting the
> > transaction.
> > ---------------------------------------------------
> > Adaptive Server Enterprise/12.5.3/EBF 13055
> > ESD#5/P/Sun_svr4/OS 5.8/ase1253/1939/64-bit/FBO/Tue Dec
> > 6 09:13:20 2005
> > ---------------------------------------------------
> >> dbcc tablealloc(GMP_GRCV_DBF)
> > 2> go
> > The default report option of OPTIMIZED is used for this
> > run. The default fix option of FIX is used for this
> > run.
> **********************************************************
> > ***** TABLE: GMP_GRCV_DBF OBJID = 2096723491
> > INDID=0 FIRST=734121 ROOT=734121 SORT=0
> > Data level: 0. 144 Data pages allocated and 20
> > Extents allocated.
> > INDID=2 FIRST=2445761 ROOT=2445760 SORT=1
> > Indid : 2. 8 Index pages allocated and 2
> > Extents allocated.
> > TOTAL # of extents = 22
> > Alloc page 733952 (# of extent=2 used pages=16 ref
> > pages=16) Alloc page 791552 (# of extent=1 used pages=8
> > ref pages=8) Alloc page 798464 (# of extent=1 used
> > pages=8 ref pages=8) Alloc page 1431040 (# of extent=1
> > used pages=1 ref pages=1) Alloc page 1868544 (# of
> > extent=1 used pages=7 ref pages=7) Alloc page 4050688 (#
> > of extent=1 used pages=8 ref pages=8) Alloc page 4516608
> > (# of extent=1 used pages=8 ref pages=8) Alloc page
> > 4674560 (# of extent=1 used pages=8 ref pages=8) Alloc
> > page 7592960 (# of extent=1 used pages=6 ref pages=6)
> Alloc page 8346368 (# of extent=1 used pages=8 ref
> > pages=8) Alloc page 8786432 (# of extent=1 used pages=6
> > ref pages=6) Alloc page 9601536 (# of extent=1 used
> > pages=8 ref pages=8) Alloc page 9714944 (# of extent=1
> > used pages=8 ref pages=8) Alloc page 11449600 (# of
> > extent=1 used pages=8 ref pages=8) Alloc page 11793408
> > (# of extent=1 used pages=7 ref pages=7) Alloc page
> > 13112832 (# of extent=1 used pages=8 ref pages=8) Alloc
> > page 13115392 (# of extent=3 used pages=24 ref pages=24)
> > Alloc page 2445568 (# of extent=2 used pages=9 ref
> > pages=9) Total (# of extent=22 used pages=156 ref
> > pages=156) in this database
> > DBCC execution completed. If DBCC printed error messages
> > , contact a user with System Administrator (SA) role.
> > 1> dbcc checktable(GMP_GRCV_DBF)
> > 2> go
> > Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
> > The total number of data pages in this table is 144.
> > The total number of pages which could be garbage
> > collected to free up some space is 17.
> > Table has 2256 data rows.
> > DBCC execution completed. If DBCC printed error messages
> > , contact a user with System Administrator (SA) role.
> > ---------------------------------------------------
> > Then later got the error again
> > ---------------------------------------------------
> > 03:00000:00245:2007/07/18 08:37:42.02 server Error:
> > 12301, Severity: 20, State: 1
> > 03:00000:00245:2007/07/18 08:37:42.02 server Internal
> > error: the index (id = 2) and the data for row (1431128,
> > 7) in table 'GMP_GRCV_DBF', database 8 are inconsistent;
> > data is marked deleted but index is not. Aborting the
> > transaction.
> > ---------------------------------------------------
> > And again no dbcc errors
> > ---------------------------------------------------
> > 1> dbcc tablealloc ('GMP_GRCV_DBF',full,nofix)
> > 2> go
> >
> **********************************************************
> > ***** TABLE: GMP_GRCV_DBF OBJID = 2096723491
> > INDID=0 FIRST=734121 ROOT=734121 SORT=0
> > Data level: 0. 145 Data pages allocated and 20
> > Extents allocated.
> > INDID=2 FIRST=2445761 ROOT=2445760 SORT=1
> > Indid : 2. 8 Index pages allocated and 2
> > Extents allocated.
> > TOTAL # of extents = 22
> > Alloc page 733952 (# of extent=2 used pages=16 ref
> > pages=16) Alloc page 791552 (# of extent=1 used pages=8
> > ref pages=8) Alloc page 798464 (# of extent=1 used
> > pages=8 ref pages=8) Alloc page 1431040 (# of extent=1
> > used pages=2 ref pages=2) Alloc page 1868544 (# of
> > extent=1 used pages=7 ref pages=7) Alloc page 2445568 (#
> > of extent=2 used pages=9 ref pages=9) Alloc page 4050688
> > (# of extent=1 used pages=8 ref pages=8) Alloc page
> > 4516608 (# of extent=1 used pages=8 ref pages=8) Alloc
> > page 4674560 (# of extent=1 used pages=8 ref pages=8)
> Alloc page 7592960 (# of extent=1 used pages=6 ref
> > pages=6) Alloc page 8346368 (# of extent=1 used pages=8
> > ref pages=8) Alloc page 8786432 (# of extent=1 used
> > pages=6 ref pages=6) Alloc page 9601536 (# of extent=1
> > used pages=8 ref pages=8) Alloc page 9714944 (# of
> > extent=1 used pages=8 ref pages=8) Alloc page 11449600
> > (# of extent=1 used pages=8 ref pages=8) Alloc page
> > 11793408 (# of extent=1 used pages=7 ref pages=7) Alloc
> > page 13112832 (# of extent=1 used pages=8 ref pages=8)
> > Alloc page 13115392 (# of extent=3 used pages=24 ref
> > pages=24) Total (# of extent=22 used pages=157 ref
> > pages=157) in this database
> > DBCC execution completed. If DBCC printed error messages
> > , contact a user with System Administrator (SA) role.
> > 1> dbcc indexalloc ('GMP_GRCV_DBF',2,full,nofix)
> > 2> go
> >
> **********************************************************
> > ***** TABLE: GMP_GRCV_DBF OBJID = 2096723491
> > INDID=2 FIRST=2445761 ROOT=2445760 SORT=1
> > Indid : 2. 8 Index pages allocated and 2
> > Extents allocated.
> > TOTAL # of extents = 2
> > Alloc page 2445568 (# of extent=2 used pages=9 ref
> > pages=9) Total (# of extent=2 used pages=9 ref pages=9)
> > in this database
> > DBCC execution completed. If DBCC printed error messages
> > , contact a user with System Administrator (SA) role.
> > 1> dbcc checktable ('GMP_GRCV_DBF')
> > 2> go
> > Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
> > The total number of data pages in this table is 146.
> > The total number of pages which could be garbage
> > collected to free up some space is 17.
> > Table has 2261 data rows.
> > DBCC execution completed. If DBCC printed error messages
> > , contact a user with System Administrator (SA) role.
> > 1> dbcc checkindex ('GMP_GRCV_DBF',2)
> > 2> go
> > Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
> > The total number of data pages in this table is 144.
> > The total number of pages which could be garbage
> > collected to free up some space is 17.
> > Table has 2257 data rows.
> > DBCC execution completed. If DBCC printed error messages
> > , contact a user with System Administrator (SA) role.
> > 1> select db_id()
> > 2> go
> >
> > ------
> > 8
> >
> > (1 row affected)
> > ---------------------------------------------------
>
>
>


Emmanuel Torre Posted on 2007-07-18 18:05:50.0Z
From: Emmanuel Torre <etorre@capdata.fr>
User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Error: 12301 but no dbcc error
References: <469dde30.5198.1681692777@sybase.com> <469e0c52.5644.1681692777@sybase.com>
In-Reply-To: <469e0c52.5644.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: did75-1-81-57-20-91.fbx.proxad.net
X-Original-NNTP-Posting-Host: did75-1-81-57-20-91.fbx.proxad.net
Message-ID: <469e567e@forums-1-dub>
Date: 18 Jul 2007 11:05:50 -0700
X-Trace: forums-1-dub 1184781950 81.57.20.91 (18 Jul 2007 11:05:50 -0700)
X-Original-Trace: 18 Jul 2007 11:05:50 -0700, did75-1-81-57-20-91.fbx.proxad.net
Lines: 253
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:22828
Article PK: 70770

PDreyer a écrit :

> dbccdb installed but dbcc checkstorage do not report a fault
> on GMP_GRCV_DBF. Anything else I might be missing?
>
> 1> dbcc checkstorage (prelive)
> 2> go
> Checking prelive: Logical pagesize is 4096 bytes
> Storage checks for 'prelive' are complete. DBCC is now
> recording the results in the dbccdb database.
> DBCC CHECKSTORAGE for database 'prelive' sequence 1
> completed at Jul 18 2007 2:24PM. 0 faults and 49 suspect
> conditions were located. 0 checks were aborted. You should
> investigate the recorded faults, and plan a course of action
> that will correct
> them.
> Suspect conditions are to be treated as faults if the same
> suspect condition persists in subsequent CHECKSTORAGE
> operations, or if they are also detected by other DBCC
> functions.
> 1> sp_dbcc_faultreport
> 2> go
>
> Database Name : prelive
>
> Table Name Index Type Code
> Description Page
> Number
> ------------------------------ ------ -----------
> --------------------------------------------------
> -----------
> syslogs 0 100003 page
> object id error 6938841
> syslogs 0 100022 chain
> start error 6938841
> syslogs 0 100031 page not
> allocated 6938841
>
> (1 row affected)
> (return status = 0)
>
>
>
>> No, I do not have the dbccdb installed on this server.
>>
>> I tried reorg rebuild on the table, it completed with no
>> errors.
>> Then after a while I got the error again.
>>
>> I will setup dbccdb next.
>>
>> PS. Sorry for the duplicate posts - Browser interface was
>> slow
>>
>>
>>> The classic dbcc commands which you've listed do not
>>> detect all errors. Did you try dbcc checkstorage?
>>>
>>> HTH,
>>>
>>> Rob V.
>>>
>>>
>> ----------------------------------------------------------
>> --- Rob Verschoor >
>>> Certified Sybase Professional DBA for ASE
>>> 12.5/12.0/11.5/11.0 and Replication Server 12.5 /
>>> TeamSybase
>>>
>>> Author of Sybase books (order online at
>>> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
>>> ASE" (new edition!) "The Complete Sybase ASE Quick
>>> Reference Guide" (new edition!) "The Complete Sybase
>>> Replication Server Quick Reference Guide"
>>>
>>> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
>>> http://www.sypron.nl
>>> Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The
>>> Netherlands
>>>
>>>
>> ----------------------------------------------------------
>> --- >
>>> <PDreyer> wrote in message
>>>> news:469dc808.4fb3.1681692777@sybase.com... What could
>>>> be causing this error but no dbcc errors
>>>> ---------------------------------------------------
>>> 01:00000:00142:2007/07/18 01:52:00.99 server Error:
>>>> 12301 , Severity: 20, State: 1
>>>> 01:00000:00142:2007/07/18 01:52:01.00 server Internal
>>>> error: the index (id = 2) and the data for row
>>>> (1431128, 5) in table 'GMP_GRCV_DBF', database 8 are
>>>> inconsistent; data is marked deleted but index is not.
>>>> Aborting the transaction.
>>>> 02:00000:00086:2007/07/18 03:06:39.10 server Error:
>>>> 12301, Severity: 20, State: 1
>>>> 02:00000:00086:2007/07/18 03:06:39.10 server Internal
>>>> error: the index (id = 2) and the data for row
>>>> (1431128, 5) in table 'GMP_GRCV_DBF', database 8 are
>>>> inconsistent; data is marked deleted but index is not.
>>>> Aborting the transaction.
>>>> ---------------------------------------------------
>>>> Adaptive Server Enterprise/12.5.3/EBF 13055
>>>> ESD#5/P/Sun_svr4/OS 5.8/ase1253/1939/64-bit/FBO/Tue
>>>> Dec 6 09:13:20 2005
>>>> ---------------------------------------------------
>>>>> dbcc tablealloc(GMP_GRCV_DBF)
>>>> 2> go
>>>> The default report option of OPTIMIZED is used for
>>>> this run. The default fix option of FIX is used for
>>>> this run.
>> **********************************************************
>>>> ***** TABLE: GMP_GRCV_DBF OBJID =
>>>> 2096723491 INDID=0 FIRST=734121 ROOT=734121
>>>> SORT=0 Data level: 0. 144 Data pages allocated
>>>> and 20 Extents allocated. INDID=2 FIRST=2445761
>>>> ROOT=2445760 SORT=1 Indid : 2. 8 Index
>>>> pages allocated and 2 Extents allocated.
>>>> TOTAL # of extents = 22
>>>> Alloc page 733952 (# of extent=2 used pages=16 ref
>>>> pages=16) Alloc page 791552 (# of extent=1 used
>>>> pages=8 ref pages=8) Alloc page 798464 (# of extent=1
>>>> used pages=8 ref pages=8) Alloc page 1431040 (# of
>>>> extent=1 used pages=1 ref pages=1) Alloc page 1868544
>>>> (# of extent=1 used pages=7 ref pages=7) Alloc page
>>>> 4050688 (# of extent=1 used pages=8 ref pages=8) Alloc
>>>> page 4516608 (# of extent=1 used pages=8 ref pages=8)
>>>> Alloc page 4674560 (# of extent=1 used pages=8 ref
>>>> pages=8) Alloc page 7592960 (# of extent=1 used
>>> pages=6 ref pages=6) Alloc page 8346368 (# of extent=1
>>>> used pages=8 ref pages=8) Alloc page 8786432 (# of
>>>> extent=1 used pages=6 ref pages=6) Alloc page 9601536
>>>> (# of extent=1 used pages=8 ref pages=8) Alloc page
>>>> 9714944 (# of extent=1 used pages=8 ref pages=8) Alloc
>>>> page 11449600 (# of extent=1 used pages=8 ref pages=8)
>>>> Alloc page 11793408 (# of extent=1 used pages=7 ref
>>>> pages=7) Alloc page 13112832 (# of extent=1 used
>>>> pages=8 ref pages=8) Alloc page 13115392 (# of
>>>> extent=3 used pages=24 ref pages=24) Alloc page
>>>> 2445568 (# of extent=2 used pages=9 ref pages=9) Total
>>>> (# of extent=22 used pages=156 ref pages=156) in this
>>>> database DBCC execution completed. If DBCC printed
>>>> error messages , contact a user with System
>>>> Administrator (SA) role. 1> dbcc
>>>> checktable(GMP_GRCV_DBF) 2> go
>>>> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>>>> The total number of data pages in this table is 144.
>>>> The total number of pages which could be garbage
>>>> collected to free up some space is 17.
>>>> Table has 2256 data rows.
>>>> DBCC execution completed. If DBCC printed error
>>>> messages , contact a user with System Administrator
>>>> (SA) role.
>>>> ---------------------------------------------------
>>>> Then later got the error again
>>>> ---------------------------------------------------
>>>> 03:00000:00245:2007/07/18 08:37:42.02 server Error:
>>>> 12301, Severity: 20, State: 1
>>>> 03:00000:00245:2007/07/18 08:37:42.02 server Internal
>>>> error: the index (id = 2) and the data for row
>> (1431128, 7) in table 'GMP_GRCV_DBF', database 8 are
>>>> inconsistent; data is marked deleted but index is not.
>>>> Aborting the transaction.
>>>> ---------------------------------------------------
>>>> And again no dbcc errors
>>>> ---------------------------------------------------
>>>> 1> dbcc tablealloc ('GMP_GRCV_DBF',full,nofix)
>>>> 2> go
>>>>
>> **********************************************************
>>>> ***** TABLE: GMP_GRCV_DBF OBJID =
>>>> 2096723491 INDID=0 FIRST=734121 ROOT=734121
>>>> SORT=0 Data level: 0. 145 Data pages allocated
>>>> and 20 Extents allocated. INDID=2 FIRST=2445761
>>>> ROOT=2445760 SORT=1 Indid : 2. 8 Index
>>>> pages allocated and 2 Extents allocated.
>>>> TOTAL # of extents = 22
>>>> Alloc page 733952 (# of extent=2 used pages=16 ref
>>>> pages=16) Alloc page 791552 (# of extent=1 used
>>>> pages=8 ref pages=8) Alloc page 798464 (# of extent=1
>>>> used pages=8 ref pages=8) Alloc page 1431040 (# of
>>>> extent=1 used pages=2 ref pages=2) Alloc page 1868544
>>>> (# of extent=1 used pages=7 ref pages=7) Alloc page
>>>> 2445568 (# of extent=2 used pages=9 ref pages=9) Alloc
>>>> page 4050688 (# of extent=1 used pages=8 ref pages=8)
>>>> Alloc page 4516608 (# of extent=1 used pages=8 ref
>>>> pages=8) Alloc page 4674560 (# of extent=1 used
>>> pages=8 ref pages=8) Alloc page 7592960 (# of extent=1
>>>> used pages=6 ref pages=6) Alloc page 8346368 (# of
>>>> extent=1 used pages=8 ref pages=8) Alloc page 8786432
>>>> (# of extent=1 used pages=6 ref pages=6) Alloc page
>>>> 9601536 (# of extent=1 used pages=8 ref pages=8) Alloc
>>>> page 9714944 (# of extent=1 used pages=8 ref pages=8)
>>>> Alloc page 11449600 (# of extent=1 used pages=8 ref
>>>> pages=8) Alloc page 11793408 (# of extent=1 used
>>>> pages=7 ref pages=7) Alloc page 13112832 (# of
>>>> extent=1 used pages=8 ref pages=8) Alloc page 13115392
>>>> (# of extent=3 used pages=24 ref pages=24) Total (# of
>>>> extent=22 used pages=157 ref pages=157) in this
>>>> database DBCC execution completed. If DBCC printed
>>>> error messages , contact a user with System
>>>> Administrator (SA) role. 1> dbcc indexalloc
>>>> ('GMP_GRCV_DBF',2,full,nofix) 2> go
>>>>
>> **********************************************************
>>>> ***** TABLE: GMP_GRCV_DBF OBJID =
>>>> 2096723491 INDID=2 FIRST=2445761
>> ROOT=2445760 SORT=1 Indid : 2. 8 Index pages
>>>> allocated and 2 Extents allocated.
>>>> TOTAL # of extents = 2
>>>> Alloc page 2445568 (# of extent=2 used pages=9 ref
>>>> pages=9) Total (# of extent=2 used pages=9 ref
>>>> pages=9) in this database
>>>> DBCC execution completed. If DBCC printed error
>>>> messages , contact a user with System Administrator
>>>> (SA) role. 1> dbcc checktable ('GMP_GRCV_DBF')
>>>> 2> go
>>>> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>>>> The total number of data pages in this table is 146.
>>>> The total number of pages which could be garbage
>>>> collected to free up some space is 17.
>>>> Table has 2261 data rows.
>>>> DBCC execution completed. If DBCC printed error
>>>> messages , contact a user with System Administrator
>>>> (SA) role. 1> dbcc checkindex ('GMP_GRCV_DBF',2)
>>>> 2> go
>>>> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>>>> The total number of data pages in this table is 144.
>>>> The total number of pages which could be garbage
>>>> collected to free up some space is 17.
>>>> Table has 2257 data rows.
>>>> DBCC execution completed. If DBCC printed error
>>>> messages , contact a user with System Administrator
>>>> (SA) role. 1> select db_id()
>>>> 2> go
>>>>
>>>> ------
>>>> 8
>>>>
>>>> (1 row affected)
>>>> ---------------------------------------------------
>>>
>>>

run dbcc checkverify after a checkstorage to see if the suspects
conditions are faults. Checkverify should run just after checkstorage
to confirm problems seen by the checkstorage.

but honestly, if a severe error existed a checkstorage would have raised it.

If you can fix it, drop the indexes and recreate them ? if not enough,
drop the indexes, copy the table with SELECT INTO and recreate the index

rgds,
Emmanuel


A Cornell Posted on 2007-07-19 02:40:36.0Z
From: "A Cornell" <agcornellnospam@msn.com>
Newsgroups: sybase.public.ase.general
References: <469dde30.5198.1681692777@sybase.com> <469e0c52.5644.1681692777@sybase.com> <469e567e@forums-1-dub>
Subject: Re: Error: 12301 but no dbcc error
Lines: 260
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: 71-218-169-185.hlrn.qwest.net
X-Original-NNTP-Posting-Host: 71-218-169-185.hlrn.qwest.net
Message-ID: <469ecf24@forums-1-dub>
Date: 18 Jul 2007 19:40:36 -0700
X-Trace: forums-1-dub 1184812836 71.218.169.185 (18 Jul 2007 19:40:36 -0700)
X-Original-Trace: 18 Jul 2007 19:40:36 -0700, 71-218-169-185.hlrn.qwest.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:22833
Article PK: 70773

You may also tru dbcc reindex ("tablenaem")

"Emmanuel Torre" <etorre@capdata.fr> wrote in message
news:469e567e@forums-1-dub...
> PDreyer a écrit :
>> dbccdb installed but dbcc checkstorage do not report a fault
>> on GMP_GRCV_DBF. Anything else I might be missing?
>>
>> 1> dbcc checkstorage (prelive)
>> 2> go
>> Checking prelive: Logical pagesize is 4096 bytes
>> Storage checks for 'prelive' are complete. DBCC is now
>> recording the results in the dbccdb database.
>> DBCC CHECKSTORAGE for database 'prelive' sequence 1
>> completed at Jul 18 2007 2:24PM. 0 faults and 49 suspect
>> conditions were located. 0 checks were aborted. You should
>> investigate the recorded faults, and plan a course of action
>> that will correct
>> them.
>> Suspect conditions are to be treated as faults if the same
>> suspect condition persists in subsequent CHECKSTORAGE
>> operations, or if they are also detected by other DBCC
>> functions.
>> 1> sp_dbcc_faultreport
>> 2> go
>>
>> Database Name : prelive
>>
>> Table Name Index Type Code Description
>> Page
>> Number
>> ------------------------------ ------ -----------
>> --------------------------------------------------
>> -----------
>> syslogs 0 100003 page
>> object id error 6938841
>> syslogs 0 100022 chain
>> start error 6938841
>> syslogs 0 100031 page not
>> allocated 6938841
>>
>> (1 row affected)
>> (return status = 0)
>>
>>
>>
>>> No, I do not have the dbccdb installed on this server.
>>>
>>> I tried reorg rebuild on the table, it completed with no
>>> errors.
>>> Then after a while I got the error again.
>>>
>>> I will setup dbccdb next.
>>>
>>> PS. Sorry for the duplicate posts - Browser interface was
>>> slow
>>>
>>>
>>>> The classic dbcc commands which you've listed do not
>>>> detect all errors. Did you try dbcc checkstorage?
>>>>
>>>> HTH,
>>>>
>>>> Rob V.
>>>>
>>>>
>>> ----------------------------------------------------------
>>> --- Rob Verschoor >
>>>> Certified Sybase Professional DBA for ASE
>>>> 12.5/12.0/11.5/11.0 and Replication Server 12.5 /
>>>> TeamSybase
>>>>
>>>> Author of Sybase books (order online at
>>>> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
>>>> ASE" (new edition!) "The Complete Sybase ASE Quick
>>>> Reference Guide" (new edition!) "The Complete Sybase
>>>> Replication Server Quick Reference Guide"
>>>>
>>>> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
>>>> http://www.sypron.nl
>>>> Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The
>>>> Netherlands
>>>>
>>>>
>>> ----------------------------------------------------------
>>> --- >
>>>> <PDreyer> wrote in message
>>>>> news:469dc808.4fb3.1681692777@sybase.com... What could
>>>>> be causing this error but no dbcc errors
>>>>> ---------------------------------------------------
>>>> 01:00000:00142:2007/07/18 01:52:00.99 server Error:
>>>>> 12301 , Severity: 20, State: 1
>>>>> 01:00000:00142:2007/07/18 01:52:01.00 server Internal
>>>>> error: the index (id = 2) and the data for row
>>>>> (1431128, 5) in table 'GMP_GRCV_DBF', database 8 are
>>>>> inconsistent; data is marked deleted but index is not.
>>>>> Aborting the transaction.
>>>>> 02:00000:00086:2007/07/18 03:06:39.10 server Error:
>>>>> 12301, Severity: 20, State: 1
>>>>> 02:00000:00086:2007/07/18 03:06:39.10 server Internal
>>>>> error: the index (id = 2) and the data for row
>>>>> (1431128, 5) in table 'GMP_GRCV_DBF', database 8 are
>>>>> inconsistent; data is marked deleted but index is not.
>>>>> Aborting the transaction.
>>>>> ---------------------------------------------------
>>>>> Adaptive Server Enterprise/12.5.3/EBF 13055
>>>>> ESD#5/P/Sun_svr4/OS 5.8/ase1253/1939/64-bit/FBO/Tue
>>>>> Dec 6 09:13:20 2005
>>>>> ---------------------------------------------------
>>>>>> dbcc tablealloc(GMP_GRCV_DBF)
>>>>> 2> go
>>>>> The default report option of OPTIMIZED is used for
>>>>> this run. The default fix option of FIX is used for
>>>>> this run.
>>> **********************************************************
>>>>> ***** TABLE: GMP_GRCV_DBF OBJID =
>>>>> 2096723491 INDID=0 FIRST=734121 ROOT=734121
>>>>> SORT=0 Data level: 0. 144 Data pages allocated
>>>>> and 20 Extents allocated. INDID=2 FIRST=2445761
>>>>> ROOT=2445760 SORT=1 Indid : 2. 8 Index
>>>>> pages allocated and 2 Extents allocated.
>>>>> TOTAL # of extents = 22
>>>>> Alloc page 733952 (# of extent=2 used pages=16 ref
>>>>> pages=16) Alloc page 791552 (# of extent=1 used
>>>>> pages=8 ref pages=8) Alloc page 798464 (# of extent=1
>>>>> used pages=8 ref pages=8) Alloc page 1431040 (# of
>>>>> extent=1 used pages=1 ref pages=1) Alloc page 1868544
>>>>> (# of extent=1 used pages=7 ref pages=7) Alloc page
>>>>> 4050688 (# of extent=1 used pages=8 ref pages=8) Alloc
>>>>> page 4516608 (# of extent=1 used pages=8 ref pages=8)
>>>>> Alloc page 4674560 (# of extent=1 used pages=8 ref
>>>>> pages=8) Alloc page 7592960 (# of extent=1 used
>>>> pages=6 ref pages=6) Alloc page 8346368 (# of extent=1
>>>>> used pages=8 ref pages=8) Alloc page 8786432 (# of
>>>>> extent=1 used pages=6 ref pages=6) Alloc page 9601536
>>>>> (# of extent=1 used pages=8 ref pages=8) Alloc page
>>>>> 9714944 (# of extent=1 used pages=8 ref pages=8) Alloc
>>>>> page 11449600 (# of extent=1 used pages=8 ref pages=8)
>>>>> Alloc page 11793408 (# of extent=1 used pages=7 ref
>>>>> pages=7) Alloc page 13112832 (# of extent=1 used
>>>>> pages=8 ref pages=8) Alloc page 13115392 (# of
>>>>> extent=3 used pages=24 ref pages=24) Alloc page
>>>>> 2445568 (# of extent=2 used pages=9 ref pages=9) Total
>>>>> (# of extent=22 used pages=156 ref pages=156) in this
>>>>> database DBCC execution completed. If DBCC printed
>>>>> error messages , contact a user with System
>>>>> Administrator (SA) role. 1> dbcc
>>>>> checktable(GMP_GRCV_DBF) 2> go
>>>>> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>>>>> The total number of data pages in this table is 144.
>>>>> The total number of pages which could be garbage
>>>>> collected to free up some space is 17.
>>>>> Table has 2256 data rows.
>>>>> DBCC execution completed. If DBCC printed error
>>>>> messages , contact a user with System Administrator
>>>>> (SA) role.
>>>>> ---------------------------------------------------
>>>>> Then later got the error again
>>>>> ---------------------------------------------------
>>>>> 03:00000:00245:2007/07/18 08:37:42.02 server Error:
>>>>> 12301, Severity: 20, State: 1
>>>>> 03:00000:00245:2007/07/18 08:37:42.02 server Internal
>>>>> error: the index (id = 2) and the data for row
>>> (1431128, 7) in table 'GMP_GRCV_DBF', database 8 are
>>>>> inconsistent; data is marked deleted but index is not.
>>>>> Aborting the transaction.
>>>>> ---------------------------------------------------
>>>>> And again no dbcc errors
>>>>> ---------------------------------------------------
>>>>> 1> dbcc tablealloc ('GMP_GRCV_DBF',full,nofix)
>>>>> 2> go
>>>>>
>>> **********************************************************
>>>>> ***** TABLE: GMP_GRCV_DBF OBJID =
>>>>> 2096723491 INDID=0 FIRST=734121 ROOT=734121
>>>>> SORT=0 Data level: 0. 145 Data pages allocated
>>>>> and 20 Extents allocated. INDID=2 FIRST=2445761
>>>>> ROOT=2445760 SORT=1 Indid : 2. 8 Index
>>>>> pages allocated and 2 Extents allocated.
>>>>> TOTAL # of extents = 22
>>>>> Alloc page 733952 (# of extent=2 used pages=16 ref
>>>>> pages=16) Alloc page 791552 (# of extent=1 used
>>>>> pages=8 ref pages=8) Alloc page 798464 (# of extent=1
>>>>> used pages=8 ref pages=8) Alloc page 1431040 (# of
>>>>> extent=1 used pages=2 ref pages=2) Alloc page 1868544
>>>>> (# of extent=1 used pages=7 ref pages=7) Alloc page
>>>>> 2445568 (# of extent=2 used pages=9 ref pages=9) Alloc
>>>>> page 4050688 (# of extent=1 used pages=8 ref pages=8)
>>>>> Alloc page 4516608 (# of extent=1 used pages=8 ref
>>>>> pages=8) Alloc page 4674560 (# of extent=1 used
>>>> pages=8 ref pages=8) Alloc page 7592960 (# of extent=1
>>>>> used pages=6 ref pages=6) Alloc page 8346368 (# of
>>>>> extent=1 used pages=8 ref pages=8) Alloc page 8786432
>>>>> (# of extent=1 used pages=6 ref pages=6) Alloc page
>>>>> 9601536 (# of extent=1 used pages=8 ref pages=8) Alloc
>>>>> page 9714944 (# of extent=1 used pages=8 ref pages=8)
>>>>> Alloc page 11449600 (# of extent=1 used pages=8 ref
>>>>> pages=8) Alloc page 11793408 (# of extent=1 used
>>>>> pages=7 ref pages=7) Alloc page 13112832 (# of
>>>>> extent=1 used pages=8 ref pages=8) Alloc page 13115392
>>>>> (# of extent=3 used pages=24 ref pages=24) Total (# of
>>>>> extent=22 used pages=157 ref pages=157) in this
>>>>> database DBCC execution completed. If DBCC printed
>>>>> error messages , contact a user with System
>>>>> Administrator (SA) role. 1> dbcc indexalloc
>>>>> ('GMP_GRCV_DBF',2,full,nofix) 2> go
>>>>>
>>> **********************************************************
>>>>> ***** TABLE: GMP_GRCV_DBF OBJID =
>>>>> 2096723491 INDID=2 FIRST=2445761
>>> ROOT=2445760 SORT=1 Indid : 2. 8 Index pages
>>>>> allocated and 2 Extents allocated.
>>>>> TOTAL # of extents = 2
>>>>> Alloc page 2445568 (# of extent=2 used pages=9 ref
>>>>> pages=9) Total (# of extent=2 used pages=9 ref
>>>>> pages=9) in this database
>>>>> DBCC execution completed. If DBCC printed error
>>>>> messages , contact a user with System Administrator
>>>>> (SA) role. 1> dbcc checktable ('GMP_GRCV_DBF')
>>>>> 2> go
>>>>> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>>>>> The total number of data pages in this table is 146.
>>>>> The total number of pages which could be garbage
>>>>> collected to free up some space is 17.
>>>>> Table has 2261 data rows.
>>>>> DBCC execution completed. If DBCC printed error
>>>>> messages , contact a user with System Administrator
>>>>> (SA) role. 1> dbcc checkindex ('GMP_GRCV_DBF',2)
>>>>> 2> go
>>>>> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>>>>> The total number of data pages in this table is 144.
>>>>> The total number of pages which could be garbage
>>>>> collected to free up some space is 17.
>>>>> Table has 2257 data rows.
>>>>> DBCC execution completed. If DBCC printed error
>>>>> messages , contact a user with System Administrator
>>>>> (SA) role. 1> select db_id()
>>>>> 2> go
>>>>>
>>>>> ------
>>>>> 8
>>>>>
>>>>> (1 row affected)
>>>>> ---------------------------------------------------
>>>>
>>>>
> run dbcc checkverify after a checkstorage to see if the suspects
> conditions are faults. Checkverify should run just after checkstorage
> to confirm problems seen by the checkstorage.
>
> but honestly, if a severe error existed a checkstorage would have raised
> it.
>
> If you can fix it, drop the indexes and recreate them ? if not enough,
> drop the indexes, copy the table with SELECT INTO and recreate the index
>
> rgds,
> Emmanuel


"Mark A. Parsons" <iron_horse Posted on 2007-07-18 23:49:07.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Error: 12301 but no dbcc error
References: <469dde30.5198.1681692777@sybase.com> <469e0c52.5644.1681692777@sybase.com>
In-Reply-To: <469e0c52.5644.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: ool-4357fce9.dyn.optonline.net
X-Original-NNTP-Posting-Host: ool-4357fce9.dyn.optonline.net
Message-ID: <469ea6f3$1@forums-1-dub>
Date: 18 Jul 2007 16:49:07 -0700
X-Trace: forums-1-dub 1184802547 67.87.252.233 (18 Jul 2007 16:49:07 -0700)
X-Original-Trace: 18 Jul 2007 16:49:07 -0700, ool-4357fce9.dyn.optonline.net
Lines: 261
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:22831
Article PK: 70772

I found a couple solved cases at sybase.com which recommend:

- reorg rebuild
- drop / recreate the index in question

-------------------

I also found a couple solved cases at sybase.com that suggest this problem is fixed ... fixed in older ASE versions that
what you're running.

So it may behoove you to contact Sybase TechSupport to see if there's anything else to this error (eg, why is it
happening if it was suppose to have been fixed in older ASE versions).

-------------------

Sorry, I've no idea (at the moment) why none of the dbcc's are reporting an issue ... unless this is an issue outside
the scope of dbcc's.

PDreyer wrote:
> dbccdb installed but dbcc checkstorage do not report a fault
> on GMP_GRCV_DBF. Anything else I might be missing?
>
> 1> dbcc checkstorage (prelive)
> 2> go
> Checking prelive: Logical pagesize is 4096 bytes
> Storage checks for 'prelive' are complete. DBCC is now
> recording the results in the dbccdb database.
> DBCC CHECKSTORAGE for database 'prelive' sequence 1
> completed at Jul 18 2007 2:24PM. 0 faults and 49 suspect
> conditions were located. 0 checks were aborted. You should
> investigate the recorded faults, and plan a course of action
> that will correct
> them.
> Suspect conditions are to be treated as faults if the same
> suspect condition persists in subsequent CHECKSTORAGE
> operations, or if they are also detected by other DBCC
> functions.
> 1> sp_dbcc_faultreport
> 2> go
>
> Database Name : prelive
>
> Table Name Index Type Code
> Description Page
> Number
> ------------------------------ ------ -----------
> --------------------------------------------------
> -----------
> syslogs 0 100003 page
> object id error 6938841
> syslogs 0 100022 chain
> start error 6938841
> syslogs 0 100031 page not
> allocated 6938841
>
> (1 row affected)
> (return status = 0)
>
>
>
>> No, I do not have the dbccdb installed on this server.
>>
>> I tried reorg rebuild on the table, it completed with no
>> errors.
>> Then after a while I got the error again.
>>
>> I will setup dbccdb next.
>>
>> PS. Sorry for the duplicate posts - Browser interface was
>> slow
>>
>>
>>> The classic dbcc commands which you've listed do not
>>> detect all errors. Did you try dbcc checkstorage?
>>>
>>> HTH,
>>>
>>> Rob V.
>>>
>>>
>> ----------------------------------------------------------
>> --- Rob Verschoor >
>>> Certified Sybase Professional DBA for ASE
>>> 12.5/12.0/11.5/11.0 and Replication Server 12.5 /
>>> TeamSybase
>>>
>>> Author of Sybase books (order online at
>>> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
>>> ASE" (new edition!) "The Complete Sybase ASE Quick
>>> Reference Guide" (new edition!) "The Complete Sybase
>>> Replication Server Quick Reference Guide"
>>>
>>> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
>>> http://www.sypron.nl
>>> Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The
>>> Netherlands
>>>
>>>
>> ----------------------------------------------------------
>> --- >
>>> <PDreyer> wrote in message
>>>> news:469dc808.4fb3.1681692777@sybase.com... What could
>>>> be causing this error but no dbcc errors
>>>> ---------------------------------------------------
>>> 01:00000:00142:2007/07/18 01:52:00.99 server Error:
>>>> 12301 , Severity: 20, State: 1
>>>> 01:00000:00142:2007/07/18 01:52:01.00 server Internal
>>>> error: the index (id = 2) and the data for row
>>>> (1431128, 5) in table 'GMP_GRCV_DBF', database 8 are
>>>> inconsistent; data is marked deleted but index is not.
>>>> Aborting the transaction.
>>>> 02:00000:00086:2007/07/18 03:06:39.10 server Error:
>>>> 12301, Severity: 20, State: 1
>>>> 02:00000:00086:2007/07/18 03:06:39.10 server Internal
>>>> error: the index (id = 2) and the data for row
>>>> (1431128, 5) in table 'GMP_GRCV_DBF', database 8 are
>>>> inconsistent; data is marked deleted but index is not.
>>>> Aborting the transaction.
>>>> ---------------------------------------------------
>>>> Adaptive Server Enterprise/12.5.3/EBF 13055
>>>> ESD#5/P/Sun_svr4/OS 5.8/ase1253/1939/64-bit/FBO/Tue
>>>> Dec 6 09:13:20 2005
>>>> ---------------------------------------------------
>>>>> dbcc tablealloc(GMP_GRCV_DBF)
>>>> 2> go
>>>> The default report option of OPTIMIZED is used for
>>>> this run. The default fix option of FIX is used for
>>>> this run.
>> **********************************************************
>>>> ***** TABLE: GMP_GRCV_DBF OBJID =
>>>> 2096723491 INDID=0 FIRST=734121 ROOT=734121
>>>> SORT=0 Data level: 0. 144 Data pages allocated
>>>> and 20 Extents allocated. INDID=2 FIRST=2445761
>>>> ROOT=2445760 SORT=1 Indid : 2. 8 Index
>>>> pages allocated and 2 Extents allocated.
>>>> TOTAL # of extents = 22
>>>> Alloc page 733952 (# of extent=2 used pages=16 ref
>>>> pages=16) Alloc page 791552 (# of extent=1 used
>>>> pages=8 ref pages=8) Alloc page 798464 (# of extent=1
>>>> used pages=8 ref pages=8) Alloc page 1431040 (# of
>>>> extent=1 used pages=1 ref pages=1) Alloc page 1868544
>>>> (# of extent=1 used pages=7 ref pages=7) Alloc page
>>>> 4050688 (# of extent=1 used pages=8 ref pages=8) Alloc
>>>> page 4516608 (# of extent=1 used pages=8 ref pages=8)
>>>> Alloc page 4674560 (# of extent=1 used pages=8 ref
>>>> pages=8) Alloc page 7592960 (# of extent=1 used
>>> pages=6 ref pages=6) Alloc page 8346368 (# of extent=1
>>>> used pages=8 ref pages=8) Alloc page 8786432 (# of
>>>> extent=1 used pages=6 ref pages=6) Alloc page 9601536
>>>> (# of extent=1 used pages=8 ref pages=8) Alloc page
>>>> 9714944 (# of extent=1 used pages=8 ref pages=8) Alloc
>>>> page 11449600 (# of extent=1 used pages=8 ref pages=8)
>>>> Alloc page 11793408 (# of extent=1 used pages=7 ref
>>>> pages=7) Alloc page 13112832 (# of extent=1 used
>>>> pages=8 ref pages=8) Alloc page 13115392 (# of
>>>> extent=3 used pages=24 ref pages=24) Alloc page
>>>> 2445568 (# of extent=2 used pages=9 ref pages=9) Total
>>>> (# of extent=22 used pages=156 ref pages=156) in this
>>>> database DBCC execution completed. If DBCC printed
>>>> error messages , contact a user with System
>>>> Administrator (SA) role. 1> dbcc
>>>> checktable(GMP_GRCV_DBF) 2> go
>>>> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>>>> The total number of data pages in this table is 144.
>>>> The total number of pages which could be garbage
>>>> collected to free up some space is 17.
>>>> Table has 2256 data rows.
>>>> DBCC execution completed. If DBCC printed error
>>>> messages , contact a user with System Administrator
>>>> (SA) role.
>>>> ---------------------------------------------------
>>>> Then later got the error again
>>>> ---------------------------------------------------
>>>> 03:00000:00245:2007/07/18 08:37:42.02 server Error:
>>>> 12301, Severity: 20, State: 1
>>>> 03:00000:00245:2007/07/18 08:37:42.02 server Internal
>>>> error: the index (id = 2) and the data for row
>> (1431128, 7) in table 'GMP_GRCV_DBF', database 8 are
>>>> inconsistent; data is marked deleted but index is not.
>>>> Aborting the transaction.
>>>> ---------------------------------------------------
>>>> And again no dbcc errors
>>>> ---------------------------------------------------
>>>> 1> dbcc tablealloc ('GMP_GRCV_DBF',full,nofix)
>>>> 2> go
>>>>
>> **********************************************************
>>>> ***** TABLE: GMP_GRCV_DBF OBJID =
>>>> 2096723491 INDID=0 FIRST=734121 ROOT=734121
>>>> SORT=0 Data level: 0. 145 Data pages allocated
>>>> and 20 Extents allocated. INDID=2 FIRST=2445761
>>>> ROOT=2445760 SORT=1 Indid : 2. 8 Index
>>>> pages allocated and 2 Extents allocated.
>>>> TOTAL # of extents = 22
>>>> Alloc page 733952 (# of extent=2 used pages=16 ref
>>>> pages=16) Alloc page 791552 (# of extent=1 used
>>>> pages=8 ref pages=8) Alloc page 798464 (# of extent=1
>>>> used pages=8 ref pages=8) Alloc page 1431040 (# of
>>>> extent=1 used pages=2 ref pages=2) Alloc page 1868544
>>>> (# of extent=1 used pages=7 ref pages=7) Alloc page
>>>> 2445568 (# of extent=2 used pages=9 ref pages=9) Alloc
>>>> page 4050688 (# of extent=1 used pages=8 ref pages=8)
>>>> Alloc page 4516608 (# of extent=1 used pages=8 ref
>>>> pages=8) Alloc page 4674560 (# of extent=1 used
>>> pages=8 ref pages=8) Alloc page 7592960 (# of extent=1
>>>> used pages=6 ref pages=6) Alloc page 8346368 (# of
>>>> extent=1 used pages=8 ref pages=8) Alloc page 8786432
>>>> (# of extent=1 used pages=6 ref pages=6) Alloc page
>>>> 9601536 (# of extent=1 used pages=8 ref pages=8) Alloc
>>>> page 9714944 (# of extent=1 used pages=8 ref pages=8)
>>>> Alloc page 11449600 (# of extent=1 used pages=8 ref
>>>> pages=8) Alloc page 11793408 (# of extent=1 used
>>>> pages=7 ref pages=7) Alloc page 13112832 (# of
>>>> extent=1 used pages=8 ref pages=8) Alloc page 13115392
>>>> (# of extent=3 used pages=24 ref pages=24) Total (# of
>>>> extent=22 used pages=157 ref pages=157) in this
>>>> database DBCC execution completed. If DBCC printed
>>>> error messages , contact a user with System
>>>> Administrator (SA) role. 1> dbcc indexalloc
>>>> ('GMP_GRCV_DBF',2,full,nofix) 2> go
>>>>
>> **********************************************************
>>>> ***** TABLE: GMP_GRCV_DBF OBJID =
>>>> 2096723491 INDID=2 FIRST=2445761
>> ROOT=2445760 SORT=1 Indid : 2. 8 Index pages
>>>> allocated and 2 Extents allocated.
>>>> TOTAL # of extents = 2
>>>> Alloc page 2445568 (# of extent=2 used pages=9 ref
>>>> pages=9) Total (# of extent=2 used pages=9 ref
>>>> pages=9) in this database
>>>> DBCC execution completed. If DBCC printed error
>>>> messages , contact a user with System Administrator
>>>> (SA) role. 1> dbcc checktable ('GMP_GRCV_DBF')
>>>> 2> go
>>>> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>>>> The total number of data pages in this table is 146.
>>>> The total number of pages which could be garbage
>>>> collected to free up some space is 17.
>>>> Table has 2261 data rows.
>>>> DBCC execution completed. If DBCC printed error
>>>> messages , contact a user with System Administrator
>>>> (SA) role. 1> dbcc checkindex ('GMP_GRCV_DBF',2)
>>>> 2> go
>>>> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>>>> The total number of data pages in this table is 144.
>>>> The total number of pages which could be garbage
>>>> collected to free up some space is 17.
>>>> Table has 2257 data rows.
>>>> DBCC execution completed. If DBCC printed error
>>>> messages , contact a user with System Administrator
>>>> (SA) role. 1> select db_id()
>>>> 2> go
>>>>
>>>> ------
>>>> 8
>>>>
>>>> (1 row affected)
>>>> ---------------------------------------------------
>>>
>>>


PDreyer Posted on 2007-07-19 06:15:38.0Z
Sender: 763e.469efd55.1804289383@sybase.com
From: PDreyer
Newsgroups: sybase.public.ase.general
Subject: Re: Error: 12301 but no dbcc error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <469f018a.76ba.1681692777@sybase.com>
References: <469ea6f3$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jul 2007 23:15:38 -0700
X-Trace: forums-1-dub 1184825738 10.22.241.41 (18 Jul 2007 23:15:38 -0700)
X-Original-Trace: 18 Jul 2007 23:15:38 -0700, 10.22.241.41
Lines: 284
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:22836
Article PK: 70774

dbcc checkverify also reports no errors
3 suspect conditions considered, 0 identified as faults, 3
identified as harmless, and 0 could not be checked. 0
objects could not be checked.

It seems as if this problem might be related to a
misbehaving app that core dumps while using this table.

I have dropped and recreated the index just in case there
are something else.

I have logged this with the local Sybase TechSupport to see
if there's anything else to this error. Will let you know if
they come up with anything else.

Thanks everyone for your assistance

> I found a couple solved cases at sybase.com which
> recommend:
>
> - reorg rebuild
> - drop / recreate the index in question
>
> -------------------
>
> I also found a couple solved cases at sybase.com that
> suggest this problem is fixed ... fixed in older ASE
> versions that what you're running.
>
> So it may behoove you to contact Sybase TechSupport to see
> if there's anything else to this error (eg, why is it
> happening if it was suppose to have been fixed in older
> ASE versions).
>
> -------------------
>
> Sorry, I've no idea (at the moment) why none of the dbcc's
> are reporting an issue ... unless this is an issue outside
> the scope of dbcc's.
>
>
> PDreyer wrote:
> > dbccdb installed but dbcc checkstorage do not report a
> > fault on GMP_GRCV_DBF. Anything else I might be missing?
> >
> > 1> dbcc checkstorage (prelive)
> > 2> go
> > Checking prelive: Logical pagesize is 4096 bytes
> > Storage checks for 'prelive' are complete. DBCC is now
> > recording the results in the dbccdb database.
> > DBCC CHECKSTORAGE for database 'prelive' sequence 1
> > completed at Jul 18 2007 2:24PM. 0 faults and 49
> > suspect conditions were located. 0 checks were aborted.
> > You should investigate the recorded faults, and plan a
> > course of action that will correct
> > them.
> > Suspect conditions are to be treated as faults if the
> > same suspect condition persists in subsequent
> > CHECKSTORAGE operations, or if they are also detected by
> > other DBCC functions.
> > 1> sp_dbcc_faultreport
> > 2> go
> >
> > Database Name : prelive
> >
> > Table Name Index Type Code
> > Description Page
> > Number
> > ------------------------------ ------ -----------
> > --------------------------------------------------
> > -----------
> > syslogs 0 100003 page
> > object id error
> > 6938841 syslogs 0
> > 100022 chain start error
> > 6938841 syslogs 0
> > 100031 page not allocated
> > 6938841
> > (1 row affected)
> > (return status = 0)
> >
> >
> >
> >> No, I do not have the dbccdb installed on this server.
> >>
> >> I tried reorg rebuild on the table, it completed with
> no >> errors.
> >> Then after a while I got the error again.
> >>
> >> I will setup dbccdb next.
> >>
> >> PS. Sorry for the duplicate posts - Browser interface
> was >> slow
> >>
> >>
> >>> The classic dbcc commands which you've listed do not
> >>> detect all errors. Did you try dbcc checkstorage?
> >>>
> >>> HTH,
> >>>
> >>> Rob V.
> >>>
> >>>
> >>
> ----------------------------------------------------------
> >> --- Rob Verschoor > >>> Certified Sybase Professional
> DBA for ASE >>> 12.5/12.0/11.5/11.0 and Replication Server
> 12.5 / >>> TeamSybase
> >>>
> >>> Author of Sybase books (order online at
> >>> www.sypron.nl/shop): "Tips, Tricks & Recipes for
> Sybase >>> ASE" (new edition!) "The Complete Sybase ASE
> Quick >>> Reference Guide" (new edition!) "The Complete
> Sybase >>> Replication Server Quick Reference Guide"
> >>>
> >>> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
> >>> http://www.sypron.nl
> >>> Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The
> >>> Netherlands
> >>>
> >>>
> >>
> ----------------------------------------------------------
> >> --- > >>> <PDreyer> wrote in message
> >>>> news:469dc808.4fb3.1681692777@sybase.com... What
> could >>>> be causing this error but no dbcc errors
> >>>> ---------------------------------------------------
> >>> 01:00000:00142:2007/07/18 01:52:00.99 server Error:
> >>>> 12301 , Severity: 20, State: 1
> >>>> 01:00000:00142:2007/07/18 01:52:01.00 server
> Internal >>>> error: the index (id = 2) and the data for
> row >>>> (1431128, 5) in table 'GMP_GRCV_DBF', database 8
> are >>>> inconsistent; data is marked deleted but index is
> not. >>>> Aborting the transaction.
> >>>> 02:00000:00086:2007/07/18 03:06:39.10 server Error:
> >>>> 12301, Severity: 20, State: 1
> >>>> 02:00000:00086:2007/07/18 03:06:39.10 server
> Internal >>>> error: the index (id = 2) and the data for
> row >>>> (1431128, 5) in table 'GMP_GRCV_DBF', database 8
> are >>>> inconsistent; data is marked deleted but index is
> not. >>>> Aborting the transaction.
> >>>> ---------------------------------------------------
> >>>> Adaptive Server Enterprise/12.5.3/EBF 13055
> >>>> ESD#5/P/Sun_svr4/OS 5.8/ase1253/1939/64-bit/FBO/Tue
> >>>> Dec 6 09:13:20 2005
> >>>> ---------------------------------------------------
> >>>>> dbcc tablealloc(GMP_GRCV_DBF)
> >>>> 2> go
> >>>> The default report option of OPTIMIZED is used for
> >>>> this run. The default fix option of FIX is used for
> >>>> this run.
> >>
> **********************************************************
> >>>> ***** TABLE: GMP_GRCV_DBF OBJID = >>>>
> 2096723491 INDID=0 FIRST=734121 ROOT=734121 >>>>
> SORT=0 Data level: 0. 144 Data pages allocated >>>> and
> 20 Extents allocated. INDID=2 FIRST=2445761 >>>>
> ROOT=2445760 SORT=1 Indid : 2. 8 Index >>>> pages
> allocated and 2 Extents allocated. >>>> TOTAL # of extents
> = 22 >>>> Alloc page 733952 (# of extent=2 used pages=16
> ref >>>> pages=16) Alloc page 791552 (# of extent=1 used
> >>>> pages=8 ref pages=8) Alloc page 798464 (# of extent=1
> >>>> used pages=8 ref pages=8) Alloc page 1431040 (# of
> >>>> extent=1 used pages=1 ref pages=1) Alloc page 1868544
> >>>> (# of extent=1 used pages=7 ref pages=7) Alloc page
> >>>> 4050688 (# of extent=1 used pages=8 ref pages=8)
> Alloc >>>> page 4516608 (# of extent=1 used pages=8 ref
> pages=8) >>>> Alloc page 4674560 (# of extent=1 used
> pages=8 ref >>>> pages=8) Alloc page 7592960 (# of
> extent=1 used >>> pages=6 ref pages=6) Alloc page 8346368
> (# of extent=1 >>>> used pages=8 ref pages=8) Alloc page
> 8786432 (# of >>>> extent=1 used pages=6 ref pages=6)
> Alloc page 9601536 >>>> (# of extent=1 used pages=8 ref
> pages=8) Alloc page >>>> 9714944 (# of extent=1 used
> pages=8 ref pages=8) Alloc >>>> page 11449600 (# of
> extent=1 used pages=8 ref pages=8) >>>> Alloc page
> 11793408 (# of extent=1 used pages=7 ref >>>> pages=7)
> Alloc page 13112832 (# of extent=1 used >>>> pages=8 ref
> pages=8) Alloc page 13115392 (# of >>>> extent=3 used
> pages=24 ref pages=24) Alloc page >>>> 2445568 (# of
> extent=2 used pages=9 ref pages=9) Total >>>> (# of
> extent=22 used pages=156 ref pages=156) in this >>>>
> database DBCC execution completed. If DBCC printed >>>>
> error messages , contact a user with System >>>>
> Administrator (SA) role. 1> dbcc >>>>
> checktable(GMP_GRCV_DBF) 2> go >>>> Checking GMP_GRCV_DBF:
> Logical pagesize is 4096 bytes >>>> The total number of
> data pages in this table is 144. >>>> The total number of
> pages which could be garbage >>>> collected to free up
> some space is 17. >>>> Table has 2256 data rows.
> >>>> DBCC execution completed. If DBCC printed error
> >>>> messages , contact a user with System Administrator
> >>>> (SA) role.
> >>>> ---------------------------------------------------
> >>>> Then later got the error again
> >>>> ---------------------------------------------------
> >>>> 03:00000:00245:2007/07/18 08:37:42.02 server Error:
> >>>> 12301, Severity: 20, State: 1
> >>>> 03:00000:00245:2007/07/18 08:37:42.02 server
> Internal >>>> error: the index (id = 2) and the data for
> row >> (1431128, 7) in table 'GMP_GRCV_DBF', database 8
> are >>>> inconsistent; data is marked deleted but index is
> not. >>>> Aborting the transaction.
> >>>> ---------------------------------------------------
> >>>> And again no dbcc errors
> >>>> ---------------------------------------------------
> >>>> 1> dbcc tablealloc ('GMP_GRCV_DBF',full,nofix)
> >>>> 2> go
> >>>>
> >>
> **********************************************************
> >>>> ***** TABLE: GMP_GRCV_DBF OBJID = >>>>
> 2096723491 INDID=0 FIRST=734121 ROOT=734121 >>>>
> SORT=0 Data level: 0. 145 Data pages allocated >>>> and
> 20 Extents allocated. INDID=2 FIRST=2445761 >>>>
> ROOT=2445760 SORT=1 Indid : 2. 8 Index >>>> pages
> allocated and 2 Extents allocated. >>>> TOTAL # of extents
> = 22 >>>> Alloc page 733952 (# of extent=2 used pages=16
> ref >>>> pages=16) Alloc page 791552 (# of extent=1 used
> >>>> pages=8 ref pages=8) Alloc page 798464 (# of extent=1
> >>>> used pages=8 ref pages=8) Alloc page 1431040 (# of
> >>>> extent=1 used pages=2 ref pages=2) Alloc page 1868544
> >>>> (# of extent=1 used pages=7 ref pages=7) Alloc page
> >>>> 2445568 (# of extent=2 used pages=9 ref pages=9)
> Alloc >>>> page 4050688 (# of extent=1 used pages=8 ref
> pages=8) >>>> Alloc page 4516608 (# of extent=1 used
> pages=8 ref >>>> pages=8) Alloc page 4674560 (# of
> extent=1 used >>> pages=8 ref pages=8) Alloc page 7592960
> (# of extent=1 >>>> used pages=6 ref pages=6) Alloc page
> 8346368 (# of >>>> extent=1 used pages=8 ref pages=8)
> Alloc page 8786432 >>>> (# of extent=1 used pages=6 ref
> pages=6) Alloc page >>>> 9601536 (# of extent=1 used
> pages=8 ref pages=8) Alloc >>>> page 9714944 (# of
> extent=1 used pages=8 ref pages=8) >>>> Alloc page
> 11449600 (# of extent=1 used pages=8 ref >>>> pages=8)
> Alloc page 11793408 (# of extent=1 used >>>> pages=7 ref
> pages=7) Alloc page 13112832 (# of >>>> extent=1 used
> pages=8 ref pages=8) Alloc page 13115392 >>>> (# of
> extent=3 used pages=24 ref pages=24) Total (# of >>>>
> extent=22 used pages=157 ref pages=157) in this >>>>
> database DBCC execution completed. If DBCC printed >>>>
> error messages , contact a user with System >>>>
> Administrator (SA) role. 1> dbcc indexalloc >>>>
> ('GMP_GRCV_DBF',2,full,nofix) 2> go >>>>
> >>
> **********************************************************
> >>>> ***** TABLE: GMP_GRCV_DBF OBJID = >>>>
> 2096723491 INDID=2 FIRST=2445761 >> ROOT=2445760
> SORT=1 Indid : 2. 8 Index pages >>>> allocated and 2
> Extents allocated. >>>> TOTAL # of extents = 2
> >>>> Alloc page 2445568 (# of extent=2 used pages=9 ref
> >>>> pages=9) Total (# of extent=2 used pages=9 ref
> >>>> pages=9) in this database
> >>>> DBCC execution completed. If DBCC printed error
> >>>> messages , contact a user with System Administrator
> >>>> (SA) role. 1> dbcc checktable ('GMP_GRCV_DBF')
> >>>> 2> go
> >>>> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
> >>>> The total number of data pages in this table is 146.
> >>>> The total number of pages which could be garbage
> >>>> collected to free up some space is 17.
> >>>> Table has 2261 data rows.
> >>>> DBCC execution completed. If DBCC printed error
> >>>> messages , contact a user with System Administrator
> >>>> (SA) role. 1> dbcc checkindex ('GMP_GRCV_DBF',2)
> >>>> 2> go
> >>>> Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
> >>>> The total number of data pages in this table is 144.
> >>>> The total number of pages which could be garbage
> >>>> collected to free up some space is 17.
> >>>> Table has 2257 data rows.
> >>>> DBCC execution completed. If DBCC printed error
> >>>> messages , contact a user with System Administrator
> >>>> (SA) role. 1> select db_id()
> >>>> 2> go
> >>>>
> >>>> ------
> >>>> 8
> >>>>
> >>>> (1 row affected)
> >>>> ---------------------------------------------------
> >>>
> >>>


Mark K Posted on 2007-07-19 05:31:10.0Z
From: "Mark K" <xxxx>
Newsgroups: sybase.public.ase.general
References: <469dde30.5198.1681692777@sybase.com> <469e0c52.5644.1681692777@sybase.com>
Subject: Re: Error: 12301 but no dbcc error
Lines: 261
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vpn-concord-123.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-123.sybase.com
Message-ID: <469ef71e$1@forums-1-dub>
Date: 18 Jul 2007 22:31:10 -0700
X-Trace: forums-1-dub 1184823070 158.159.8.123 (18 Jul 2007 22:31:10 -0700)
X-Original-Trace: 18 Jul 2007 22:31:10 -0700, vpn-concord-123.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:22834
Article PK: 70779

I would have expected checktable and checkindex to catch this. I *would not*
expect tablealloc/indexalloc to report a problem.

Since this is a DOL table, can you try
dbcc checkindex('GMP_GRCV_DBF',2,bottom_up)
and report the output.

Thanks,
Mark Kusma

<PDreyer> wrote in message news:469e0c52.5644.1681692777@sybase.com...
> dbccdb installed but dbcc checkstorage do not report a fault
> on GMP_GRCV_DBF. Anything else I might be missing?
>
> 1> dbcc checkstorage (prelive)
> 2> go
> Checking prelive: Logical pagesize is 4096 bytes
> Storage checks for 'prelive' are complete. DBCC is now
> recording the results in the dbccdb database.
> DBCC CHECKSTORAGE for database 'prelive' sequence 1
> completed at Jul 18 2007 2:24PM. 0 faults and 49 suspect
> conditions were located. 0 checks were aborted. You should
> investigate the recorded faults, and plan a course of action
> that will correct
> them.
> Suspect conditions are to be treated as faults if the same
> suspect condition persists in subsequent CHECKSTORAGE
> operations, or if they are also detected by other DBCC
> functions.
> 1> sp_dbcc_faultreport
> 2> go
>
> Database Name : prelive
>
> Table Name Index Type Code
> Description Page
> Number
> ------------------------------ ------ -----------
> --------------------------------------------------
> -----------
> syslogs 0 100003 page
> object id error 6938841
> syslogs 0 100022 chain
> start error 6938841
> syslogs 0 100031 page not
> allocated 6938841
>
> (1 row affected)
> (return status = 0)
>
>
>
>> No, I do not have the dbccdb installed on this server.
>>
>> I tried reorg rebuild on the table, it completed with no
>> errors.
>> Then after a while I got the error again.
>>
>> I will setup dbccdb next.
>>
>> PS. Sorry for the duplicate posts - Browser interface was
>> slow
>>
>>
>> > The classic dbcc commands which you've listed do not
>> > detect all errors. Did you try dbcc checkstorage?
>> >
>> > HTH,
>> >
>> > Rob V.
>> >
>> >
>> ----------------------------------------------------------
>> --- Rob Verschoor >
>> > Certified Sybase Professional DBA for ASE
>> > 12.5/12.0/11.5/11.0 and Replication Server 12.5 /
>> > TeamSybase
>> >
>> > Author of Sybase books (order online at
>> > www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
>> > ASE" (new edition!) "The Complete Sybase ASE Quick
>> > Reference Guide" (new edition!) "The Complete Sybase
>> > Replication Server Quick Reference Guide"
>> >
>> > mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
>> > http://www.sypron.nl
>> > Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The
>> > Netherlands
>> >
>> >
>> ----------------------------------------------------------
>> --- >
>> > <PDreyer> wrote in message
>> > > news:469dc808.4fb3.1681692777@sybase.com... What could
>> > > be causing this error but no dbcc errors
>> > > ---------------------------------------------------
>> > 01:00000:00142:2007/07/18 01:52:00.99 server Error:
>> > > 12301 , Severity: 20, State: 1
>> > > 01:00000:00142:2007/07/18 01:52:01.00 server Internal
>> > > error: the index (id = 2) and the data for row
>> > > (1431128, 5) in table 'GMP_GRCV_DBF', database 8 are
>> > > inconsistent; data is marked deleted but index is not.
>> > > Aborting the transaction.
>> > > 02:00000:00086:2007/07/18 03:06:39.10 server Error:
>> > > 12301, Severity: 20, State: 1
>> > > 02:00000:00086:2007/07/18 03:06:39.10 server Internal
>> > > error: the index (id = 2) and the data for row
>> > > (1431128, 5) in table 'GMP_GRCV_DBF', database 8 are
>> > > inconsistent; data is marked deleted but index is not.
>> > > Aborting the transaction.
>> > > ---------------------------------------------------
>> > > Adaptive Server Enterprise/12.5.3/EBF 13055
>> > > ESD#5/P/Sun_svr4/OS 5.8/ase1253/1939/64-bit/FBO/Tue
>> > > Dec 6 09:13:20 2005
>> > > ---------------------------------------------------
>> > >> dbcc tablealloc(GMP_GRCV_DBF)
>> > > 2> go
>> > > The default report option of OPTIMIZED is used for
>> > > this run. The default fix option of FIX is used for
>> > > this run.
>> >
>> > >
>> **********************************************************
>> > > ***** TABLE: GMP_GRCV_DBF OBJID =
>> > > 2096723491 INDID=0 FIRST=734121 ROOT=734121
>> > > SORT=0 Data level: 0. 144 Data pages allocated
>> > > and 20 Extents allocated. INDID=2 FIRST=2445761
>> > > ROOT=2445760 SORT=1 Indid : 2. 8 Index
>> > > pages allocated and 2 Extents allocated.
>> > > TOTAL # of extents = 22
>> > > Alloc page 733952 (# of extent=2 used pages=16 ref
>> > > pages=16) Alloc page 791552 (# of extent=1 used
>> > > pages=8 ref pages=8) Alloc page 798464 (# of extent=1
>> > > used pages=8 ref pages=8) Alloc page 1431040 (# of
>> > > extent=1 used pages=1 ref pages=1) Alloc page 1868544
>> > > (# of extent=1 used pages=7 ref pages=7) Alloc page
>> > > 4050688 (# of extent=1 used pages=8 ref pages=8) Alloc
>> > > page 4516608 (# of extent=1 used pages=8 ref pages=8)
>> > > Alloc page 4674560 (# of extent=1 used pages=8 ref
>> > > pages=8) Alloc page 7592960 (# of extent=1 used
>> > pages=6 ref pages=6) Alloc page 8346368 (# of extent=1
>> > > used pages=8 ref pages=8) Alloc page 8786432 (# of
>> > > extent=1 used pages=6 ref pages=6) Alloc page 9601536
>> > > (# of extent=1 used pages=8 ref pages=8) Alloc page
>> > > 9714944 (# of extent=1 used pages=8 ref pages=8) Alloc
>> > > page 11449600 (# of extent=1 used pages=8 ref pages=8)
>> > > Alloc page 11793408 (# of extent=1 used pages=7 ref
>> > > pages=7) Alloc page 13112832 (# of extent=1 used
>> > > pages=8 ref pages=8) Alloc page 13115392 (# of
>> > > extent=3 used pages=24 ref pages=24) Alloc page
>> > > 2445568 (# of extent=2 used pages=9 ref pages=9) Total
>> > > (# of extent=22 used pages=156 ref pages=156) in this
>> > > database DBCC execution completed. If DBCC printed
>> > > error messages , contact a user with System
>> > > Administrator (SA) role. 1> dbcc
>> > > checktable(GMP_GRCV_DBF) 2> go
>> > > Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>> > > The total number of data pages in this table is 144.
>> > > The total number of pages which could be garbage
>> > > collected to free up some space is 17.
>> > > Table has 2256 data rows.
>> > > DBCC execution completed. If DBCC printed error
>> > > messages , contact a user with System Administrator
>> > > (SA) role.
>> > > ---------------------------------------------------
>> > > Then later got the error again
>> > > ---------------------------------------------------
>> > > 03:00000:00245:2007/07/18 08:37:42.02 server Error:
>> > > 12301, Severity: 20, State: 1
>> > > 03:00000:00245:2007/07/18 08:37:42.02 server Internal
>> > > error: the index (id = 2) and the data for row
>> (1431128, 7) in table 'GMP_GRCV_DBF', database 8 are
>> > > inconsistent; data is marked deleted but index is not.
>> > > Aborting the transaction.
>> > > ---------------------------------------------------
>> > > And again no dbcc errors
>> > > ---------------------------------------------------
>> > > 1> dbcc tablealloc ('GMP_GRCV_DBF',full,nofix)
>> > > 2> go
>> > >
>> >
>> > >
>> **********************************************************
>> > > ***** TABLE: GMP_GRCV_DBF OBJID =
>> > > 2096723491 INDID=0 FIRST=734121 ROOT=734121
>> > > SORT=0 Data level: 0. 145 Data pages allocated
>> > > and 20 Extents allocated. INDID=2 FIRST=2445761
>> > > ROOT=2445760 SORT=1 Indid : 2. 8 Index
>> > > pages allocated and 2 Extents allocated.
>> > > TOTAL # of extents = 22
>> > > Alloc page 733952 (# of extent=2 used pages=16 ref
>> > > pages=16) Alloc page 791552 (# of extent=1 used
>> > > pages=8 ref pages=8) Alloc page 798464 (# of extent=1
>> > > used pages=8 ref pages=8) Alloc page 1431040 (# of
>> > > extent=1 used pages=2 ref pages=2) Alloc page 1868544
>> > > (# of extent=1 used pages=7 ref pages=7) Alloc page
>> > > 2445568 (# of extent=2 used pages=9 ref pages=9) Alloc
>> > > page 4050688 (# of extent=1 used pages=8 ref pages=8)
>> > > Alloc page 4516608 (# of extent=1 used pages=8 ref
>> > > pages=8) Alloc page 4674560 (# of extent=1 used
>> > pages=8 ref pages=8) Alloc page 7592960 (# of extent=1
>> > > used pages=6 ref pages=6) Alloc page 8346368 (# of
>> > > extent=1 used pages=8 ref pages=8) Alloc page 8786432
>> > > (# of extent=1 used pages=6 ref pages=6) Alloc page
>> > > 9601536 (# of extent=1 used pages=8 ref pages=8) Alloc
>> > > page 9714944 (# of extent=1 used pages=8 ref pages=8)
>> > > Alloc page 11449600 (# of extent=1 used pages=8 ref
>> > > pages=8) Alloc page 11793408 (# of extent=1 used
>> > > pages=7 ref pages=7) Alloc page 13112832 (# of
>> > > extent=1 used pages=8 ref pages=8) Alloc page 13115392
>> > > (# of extent=3 used pages=24 ref pages=24) Total (# of
>> > > extent=22 used pages=157 ref pages=157) in this
>> > > database DBCC execution completed. If DBCC printed
>> > > error messages , contact a user with System
>> > > Administrator (SA) role. 1> dbcc indexalloc
>> > > ('GMP_GRCV_DBF',2,full,nofix) 2> go
>> > >
>> >
>> > >
>> **********************************************************
>> > > ***** TABLE: GMP_GRCV_DBF OBJID =
>> > > 2096723491 INDID=2 FIRST=2445761
>> ROOT=2445760 SORT=1 Indid : 2. 8 Index pages
>> > > allocated and 2 Extents allocated.
>> > > TOTAL # of extents = 2
>> > > Alloc page 2445568 (# of extent=2 used pages=9 ref
>> > > pages=9) Total (# of extent=2 used pages=9 ref
>> > > pages=9) in this database
>> > > DBCC execution completed. If DBCC printed error
>> > > messages , contact a user with System Administrator
>> > > (SA) role. 1> dbcc checktable ('GMP_GRCV_DBF')
>> > > 2> go
>> > > Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>> > > The total number of data pages in this table is 146.
>> > > The total number of pages which could be garbage
>> > > collected to free up some space is 17.
>> > > Table has 2261 data rows.
>> > > DBCC execution completed. If DBCC printed error
>> > > messages , contact a user with System Administrator
>> > > (SA) role. 1> dbcc checkindex ('GMP_GRCV_DBF',2)
>> > > 2> go
>> > > Checking GMP_GRCV_DBF: Logical pagesize is 4096 bytes
>> > > The total number of data pages in this table is 144.
>> > > The total number of pages which could be garbage
>> > > collected to free up some space is 17.
>> > > Table has 2257 data rows.
>> > > DBCC execution completed. If DBCC printed error
>> > > messages , contact a user with System Administrator
>> > > (SA) role. 1> select db_id()
>> > > 2> go
>> > >
>> > > ------
>> > > 8
>> > >
>> > > (1 row affected)
>> > > ---------------------------------------------------
>> >
>> >
>> >