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 8211

4 posts in General Discussion Last posting was on 2004-01-12 13:28:30.0Z
Marsha Ramsey Posted on 2004-01-06 15:58:01.0Z
From: Marsha Ramsey <Mramsey22A@netscape.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Error 8211
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 209.243.55.162
Message-ID: <3ffadd19$1@forums-2-dub>
X-Original-Trace: 6 Jan 2004 08:06:49 -0800, 209.243.55.162
Lines: 183
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Jan 2004 07:43:38 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Jan 2004 07:58:01 -0800
X-Trace: forums-1-dub 1073404681 10.22.108.75 (6 Jan 2004 07:58:01 -0800)
X-Original-Trace: 6 Jan 2004 07:58:01 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:13291
Article PK: 61588

Hi All,

I recently change my server sort order from 50 to 54 and now I keep
getting this error while trying to bring up my server....I have done the
dbcc reindex and rebooted server (several times) but error still
appears...I ran a couple of commands in the server and the results are
below also I have included a snippet of my errorlog...

Another solution was to drop corrupt table but I can't seem to be able
to identify which table that is....any suggestions?

Thanks...Marsha

****************

1> select * from sysdatabases
2> go
Msg 8211, Level 26, State 1:
Server 'linux01', Line 1:
Mismatch found between the name and id descriptor hash table. Descriptor
hashed
by name = 0x0 and hashed by id = 0x442de940.
1> select * from sysobjects
2> go
Msg 8211, Level 26, State 1:
Server 'linux01', Line 1:
Mismatch found between the name and id descriptor hash table. Descriptor
hashed
by name = 0x0 and hashed by id = 0x442e590c.
1> select count(*) from sysobjects
2> go
Msg 8211, Level 26, State 1:
Server 'linux01', Line 1:
Mismatch found between the name and id descriptor hash table. Descriptor
hashed
by name = 0x0 and hashed by id = 0x442e590c.
1> select count(*) from sysdatabases
2> go
Msg 8211, Level 26, State 1:
Server 'linux01', Line 1:
Mismatch found between the name and id descriptor hash table. Descriptor
hashed
by name = 0x0 and hashed by id = 0x442de940.
1> select @@version
2> go





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

Adaptive Server Enterprise/12.5.1/EBF 11523/P/Linux Intel/Enterprise
Linux/ase1
251/1824/32-bit/OPT/Mon Sep 29 20:27:55 2003



(1 row affected)

**************ERRORLOG*****************

00:00000:00001:2004/01/06 10:23:38.41 server Recovery complete.
00:00000:00001:2004/01/06 10:23:38.41 server Now loading SQL Server's
new default sort order and character set
00:00000:00001:2004/01/06 10:23:38.41 server Checking sysobjects:
Logical pagesize is 2048 bytes
00:00000:00001:2004/01/06 10:23:38.43 server Checking systypes: Logical
pagesize is 2048 bytes
00:00000:00001:2004/01/06 10:23:38.43 server Checking sysusers: Logical
pagesize is 2048 bytes
-- CUT --
00:00000:00001:2004/01/06 10:23:39.22 server Checking syslanguages:
Logical pagesize is 2048 bytes
00:00000:00001:2004/01/06 10:23:39.22 server Checking syslanguages:
Logical pagesize is 2048 bytes
00:00000:00001:2004/01/06 10:23:39.22 server Checking syscharsets:
Logical pagesize is 2048 bytes
00:00000:00001:2004/01/06 10:23:39.22 server Checking
sysresourcelimits: Logical pagesize is 2048 bytes
00:00000:00001:2004/01/06 10:23:39.23 kernel current process (0x230023)
infected with 11
00:00000:00001:2004/01/06 10:23:39.23 kernel
************************************
00:00000:00001:2004/01/06 10:23:39.23 kernel SQL causing error :
00:00000:00001:2004/01/06 10:23:39.23 kernel
************************************
00:00000:00001:2004/01/06 10:23:39.23 server SQL Text:
00:00000:00001:2004/01/06 10:23:39.23 kernel curdb = 1 tempdb = 2 pstat
= 0x0
00:00000:00001:2004/01/06 10:23:39.23 kernel lasterror = 0 preverror =
0 transtate = 1
00:00000:00001:2004/01/06 10:23:39.23 kernel curcmd = 0 program =
00:00000:00001:2004/01/06 10:23:39.23 kernel pc 0x87637e1
ucbacktrace+0x89(0x0,0x1,0x915180c,0x0,0x400)
00:00000:00001:2004/01/06 10:23:39.23 kernel pc 0x8185349
terminate_process+0xaa9(0x0,0xffffffff,0x400acb18,0x0,0x4463e14c)
00:00000:00001:2004/01/06 10:23:39.23 kernel pc 0x877eba2
kisignal+0xc6(0xb,0x4274eca8,0x4274ed28,0x400a1f4a,0x915180c)
00:00000:00001:2004/01/06 10:23:39.32 kernel pc 0x400a1f93
init_dummy+0x37597ff3(0xb,0x4274eca8,0x4274ed28,0xb,0x0)
00:00000:00001:2004/01/06 10:23:39.32 kernel pc 0x42029180
init_dummy+0x3951f1e0(0x0,0x915180c,0x45965af8,0x4463e14c,0x45968e70)
00:00000:00001:2004/01/06 10:23:39.32 kernel pc 0x82df59e
xact__commitxact+0x5c6(0x45965af8,0x915180c,0x82e5838,0x4274f10c,0x8ee32e4)
00:00000:00001:2004/01/06 10:23:39.32 kernel pc 0x82def62
xact__commit_local+0xea(0x915180c,0x4463eae0,0x4274f128,0x83e4661,0x4274f0e0)
00:00000:00001:2004/01/06 10:23:39.32 kernel pc 0x82e583d
xact_commit+0x41(0x4274f0e0,0x0,0x1e84872,0x1,0x915180c)
00:00000:00001:2004/01/06 10:23:39.32 kernel pc 0x83e4661
rec_system_ix+0x1f9(0x0,0x1e84872,0x14,0x1,0x5)
00:00000:00001:2004/01/06 10:23:39.32 kernel pc 0x8188725
dsinit__change_so_cs+0xd9(0x0,0x0,0x0,0x0,0x0)
00:00000:00001:2004/01/06 10:23:39.32 kernel pc 0x81840ca
dsinit+0x10c2(0x0,0x4274f3d8,0x895eed31,0x0,0x0)
00:00000:00001:2004/01/06 10:23:39.32 kernel pc 0x879c454
kpexit(0x0,0x0,0x0,0x4250f100,0x24)
00:00000:00001:2004/01/06 10:23:39.32 kernel pc 0x895eed31
init_dummy+0x80ae4d91(0x0,0x4250f100,0x24,0x1,0x5374616b)
00:00000:00001:2004/01/06 10:23:39.32 kernel end of stack trace, spid
1, kpid 2293795, suid 0

-- CUT --

00:00000:00006:2004/01/06 10:28:31.25 server Error: 8211, Severity: 26,
State: 1
00:00000:00006:2004/01/06 10:28:31.25 server Mismatch found between the
name and id descriptor hash table. Descriptor hashed by name = 0x0 and
hashed by id = 0x442e0a60.
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x87637e1
ucbacktrace+0x89(0x2a002a,0x1,0x915180c,0x4469a4d8,0x0)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x824f7e2
des__errhdl+0x3a(0x52,0xb,0x1a,0x1,0x427be854)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x81dafb4
ex_raise+0x2f8(0x52,0xb,0x1a,0x1,0x0)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x8247db7
des__hashinst+0x2e3(0x44063544,0x3,0x915180c,0x1,0x44063544)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x8247ed8
des__install+0xe0(0x44063544,0x44455940,0x915180c,0x1,0x44694e54)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x824a780
des__fill_common+0x2f0(0x44063544,0x44455940,0x0,0x44694e54,0x43fac6d0)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x8247238
des__fill+0x4f4(0x44063544,0x44455940,0x1,0x0,0x45d08080)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x8242f2f
des_get+0xc13(0x44455940,0x1,0x0,0x45d08080,0xc)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x8343c19
open__lookup+0x2d(0x427bece0,0x1,0x44455940,0x45d08080,0xc)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x8342121
open__byname+0x221(0x1,0x1,0x0,0x45d08080,0xc)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x8341c32
open_user_table+0xb6(0x0,0x0,0x1,0x0,0x45d08080)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x846c9ff
get_range_sdes+0xab(0x45d08000,0x0,0x0,0x915180c,0x427b0001)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x846c365
open_range+0x4d5(0x0,0x45ce6dac,0x0,0x1,0x915180c)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x845822f
col_open_range+0x3b(0x45ce6d28,0x427bee54,0x427bee58,0x915180c,0x45d08000)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x8457f4a
colnames_driver+0x3e(0x45ce6efc,0x45ce6d28,0x1,0x915180c,0x446948c4)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x8498b45
s_normquery+0x159(0x45ce6efc,0x0,0x915180c,0xc1,0x45ce6efc)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x849ce64
s__call_normquery+0x78(0x45ce6efc,0x0,0x915180c,0x0,0x427b0468)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x8498070
s_normalize+0x85c(0x0,0x0,0x915180c,0x0,0x44694800)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x849681c
sequencer+0x2a4(0x45ce6800,0x915180c,0x0,0x44694800,0x819892e)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x81b3361
tdsrecv_language+0x2ed(0x0,0x0,0x0,0x0,0x0)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x81c2aa5
conn_hdlr+0x2601(0x3,0x427bf464,0x895eed31,0x0,0x0)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x8211bf3
ex_cleanup(0x0,0x0,0x0,0x4250f100,0x2b)
00:00000:00007:2004/01/06 10:29:07.58 kernel pc 0x895eed31
init_dummy+0x80ae4d91(0x0,0x4250f100,0x2b,0x1,0x5374616b)
00:00000:00007:2004/01/06 10:29:07.58 kernel end of stack trace, spid
7, kpid 2752554, suid 1
00:00000:00007:2004/01/06 10:29:07.58 server Error: 8211, Severity: 26,
State: 1
00:00000:00007:2004/01/06 10:29:07.58 server Mismatch found between the
name and id descriptor hash table. Descriptor hashed by name = 0x0 and
hashed by id = 0x442de940.


Jason L. Froebe [TeamSybase] Posted on 2004-01-06 17:42:31.0Z
From: "Jason L. Froebe [TeamSybase]" <jason@froebe.net>
Newsgroups: sybase.public.ase.general
Organization: TeamSybase[146.180.106.195]
References: <3ffadd19$1@forums-2-dub>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: Error 8211
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 64.79.161.46
Message-ID: <3ffaf595@forums-2-dub>
X-Original-Trace: 6 Jan 2004 09:51:17 -0800, 64.79.161.46
Lines: 39
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Jan 2004 09:28:06 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Jan 2004 09:42:31 -0800
X-Trace: forums-1-dub 1073410951 10.22.108.75 (6 Jan 2004 09:42:31 -0800)
X-Original-Trace: 6 Jan 2004 09:42:31 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:13294
Article PK: 61578

On 6 Jan 2004 07:58:01 -0800,
in sybase.public.ase.general

Marsha Ramsey <Mramsey22A@netscape.net> wrote:
>Hi All,
>
>I recently change my server sort order from 50 to 54 and now I keep
>getting this error while trying to bring up my server....I have done the
>dbcc reindex and rebooted server (several times) but error still
>appears...I ran a couple of commands in the server and the results are
>below also I have included a snippet of my errorlog...
>
>Another solution was to drop corrupt table but I can't seem to be able
>to identify which table that is....any suggestions?
>
>Thanks...Marsha
>

Hi Marsha,

dbcc checkalloc should be able to identify all the tables that are having
issues.

Go ahead and run sp_fixindex on the system tables while the sybase server is in
single user mode:

1> use master
2> go
1> sp_configure "allow updates", 1
2> go
1> set role "sa_role" on
2> go

run for the tables identified by dbcc checkalloc:
1> sp_fixindex database_name, object_name, index_ID
2> go
TeamSybase (http://www.teamsybase.com)
ISUG member (http://www.isug.com)
Bookcrossing (http://jfroebe.bookcrossing.com)
HealthyPals (http://www.healthypals.com)


Marsha Ramsey Posted on 2004-01-06 22:25:36.0Z
Message-ID: <3FFB3280.7030006@netscape.net>
From: Marsha Ramsey <Mramsey22A@netscape.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: "Jason L. Froebe [TeamSybase]" <jason@froebe.net>
Subject: Re: Error 8211
References: <3ffadd19$1@forums-2-dub> <3ffaf595@forums-2-dub>
In-Reply-To: <3ffaf595@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 209.243.55.162
X-Original-NNTP-Posting-Host: 209.243.55.162
Date: 6 Jan 2004 14:25:36 -0800
X-Trace: forums-1-dub 1073427936 209.243.55.162 (6 Jan 2004 14:25:36 -0800)
X-Original-Trace: 6 Jan 2004 14:25:36 -0800, 209.243.55.162
Lines: 80
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:13299
Article PK: 61589

Hi Jason,

I ran all as you instructed...I had failure on only ONE table...I can't
this to work with either options....can this table be dropped and
recreated? I tried bcp out but it fails with the same 8211 error...


here are the error messages:

*********Index*********
CREATE CLUSTERED INDEX spt_valuesclust
ON dbo.spt_values(number,type)
ON system
go

ERROR Messages************

1> sp_fixindex master, spt_values, 1
2> go
Msg 18055, Level 16, State 1:
Server 'linux01', Procedure 'sp_fixindex', Line 84:
Procedure should be used on system tables only.
(return status = 1)
1> dbcc reindex (spt_values)
2> go
Msg 8211, Level 26, State 1:
Server 'linux01', Line 1:
Mismatch found between the name and id descriptor hash table. Descriptor
hashed
by name = 0x0 and hashed by id = 0x44055df4.
DBCC execution completed. If DBCC printed error messages, contact a user
with
System Administrator (SA) role.

Jason L. Froebe [TeamSybase] wrote:

> On 6 Jan 2004 07:58:01 -0800,
> in sybase.public.ase.general
> Marsha Ramsey <Mramsey22A@netscape.net> wrote:
>
>>Hi All,
>>
>>I recently change my server sort order from 50 to 54 and now I keep
>>getting this error while trying to bring up my server....I have done the
>>dbcc reindex and rebooted server (several times) but error still
>>appears...I ran a couple of commands in the server and the results are
>>below also I have included a snippet of my errorlog...
>>
>>Another solution was to drop corrupt table but I can't seem to be able
>>to identify which table that is....any suggestions?
>>
>>Thanks...Marsha
>>
>
>
> Hi Marsha,
>
> dbcc checkalloc should be able to identify all the tables that are having
> issues.
>
> Go ahead and run sp_fixindex on the system tables while the sybase server is in
> single user mode:
>
> 1> use master
> 2> go
> 1> sp_configure "allow updates", 1
> 2> go
> 1> set role "sa_role" on
> 2> go
>
> run for the tables identified by dbcc checkalloc:
> 1> sp_fixindex database_name, object_name, index_ID
> 2> go
> TeamSybase (http://www.teamsybase.com)
> ISUG member (http://www.isug.com)
> Bookcrossing (http://jfroebe.bookcrossing.com)
> HealthyPals (http://www.healthypals.com)


Marsha Ramsey Posted on 2004-01-12 13:28:30.0Z
From: Marsha Ramsey <Mramsey22A@netscape.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Error 8211
References: <3ffadd19$1@forums-2-dub> <3ffaf595@forums-2-dub> <3FFB3280.7030006@netscape.net>
In-Reply-To: <3FFB3280.7030006@netscape.net>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 209.243.55.162
X-Original-NNTP-Posting-Host: 209.243.55.162
Message-ID: <4002a0fe$2@forums-1-dub>
Date: 12 Jan 2004 05:28:30 -0800
X-Trace: forums-1-dub 1073914110 209.243.55.162 (12 Jan 2004 05:28:30 -0800)
X-Original-Trace: 12 Jan 2004 05:28:30 -0800, 209.243.55.162
Lines: 92
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:13339
Article PK: 63049

Hi All,

I ended up rebuilding master db to get this to finally work.

Jason, thanks for your suggestions...

Thanks...Marsha

Marsha Ramsey wrote:
> Hi Jason,
>
> I ran all as you instructed...I had failure on only ONE table...I can't
> this to work with either options....can this table be dropped and
> recreated? I tried bcp out but it fails with the same 8211 error...
>
>
> here are the error messages:
>
> *********Index*********
> CREATE CLUSTERED INDEX spt_valuesclust
> ON dbo.spt_values(number,type)
> ON system
> go
>
> ERROR Messages************
>
> 1> sp_fixindex master, spt_values, 1
> 2> go
> Msg 18055, Level 16, State 1:
> Server 'linux01', Procedure 'sp_fixindex', Line 84:
> Procedure should be used on system tables only.
> (return status = 1)
> 1> dbcc reindex (spt_values)
> 2> go
> Msg 8211, Level 26, State 1:
> Server 'linux01', Line 1:
> Mismatch found between the name and id descriptor hash table. Descriptor
> hashed
> by name = 0x0 and hashed by id = 0x44055df4.
> DBCC execution completed. If DBCC printed error messages, contact a user
> with
> System Administrator (SA) role.
>
>
>
> Jason L. Froebe [TeamSybase] wrote:
>
>> On 6 Jan 2004 07:58:01 -0800,
>> in sybase.public.ase.general
>> Marsha Ramsey <Mramsey22A@netscape.net> wrote:
>>
>>> Hi All,
>>>
>>> I recently change my server sort order from 50 to 54 and now I keep
>>> getting this error while trying to bring up my server....I have done
>>> the dbcc reindex and rebooted server (several times) but error still
>>> appears...I ran a couple of commands in the server and the results
>>> are below also I have included a snippet of my errorlog...
>>>
>>> Another solution was to drop corrupt table but I can't seem to be
>>> able to identify which table that is....any suggestions?
>>>
>>> Thanks...Marsha
>>>
>>
>>
>> Hi Marsha,
>>
>> dbcc checkalloc should be able to identify all the tables that are having
>> issues.
>>
>> Go ahead and run sp_fixindex on the system tables while the sybase
>> server is in
>> single user mode:
>>
>> 1> use master
>> 2> go
>> 1> sp_configure "allow updates", 1
>> 2> go
>> 1> set role "sa_role" on
>> 2> go
>>
>> run for the tables identified by dbcc checkalloc:
>> 1> sp_fixindex database_name, object_name, index_ID
>> 2> go
>> TeamSybase (http://www.teamsybase.com)
>> ISUG member (http://www.isug.com)
>> Bookcrossing (http://jfroebe.bookcrossing.com)
>> HealthyPals (http://www.healthypals.com)
>
>