Discussion:
Error: 8211, Severity: 26, State: 1
(too old to reply)
Amith
2010-01-21 06:45:47 UTC
Permalink
Hi

I got the below error in ASE server. when checked at sybooks it says
to reboot to clear the caches.but i havent rebooted and still the
server is running fine.

and i also want to know how to find the table in which the mismatch
happened from errorlog.

let me know your suggestions on this.

00:00000:00375:2010/01/17 15:59:34.69 server Error: 8211, Severity:
26, State: 1

00:00000:00375:2010/01/17 15:59:34.69 server Error: 8211, Severity:
26, State: 1

00:00000:00375:2010/01/17 15:59:34.69 server Mismatch found between
the name and id descriptor hash table. Descriptor hashed by name = 0x0
and hashed by id = 0x22558dd8.

00:00000:00375:2010/01/17 15:59:34.70 kernel
************************************

00:00000:00375:2010/01/17 15:59:34.70 kernel SQL causing error : ID
= ac_uid_t.UID_ID and ac_uid_t.UID_LIVEFLAG = ? and ac_uid_t.UID_ID
= ?) and exists (select 1 from AC_ROL_UID_T rol_uid where ro

00:00000:00375:2010/01/17 15:59:34.70 kernel
************************************

00:00000:00375:2010/01/17 15:59:34.70 server SQL Text: ID =
ac_uid_t.UID_ID and ac_uid_t.UID_LIVEFLAG = ? and ac_uid_t.UID_ID
= ?) and exists (select 1 from AC_ROL_UID_T rol_uid where
rol_uid.ROL_

00:00000:00375:2010/01/17 15:59:34.70 kernel curdb = 2 tempdb = 2
pstat = 0x40010000

00:00000:00375:2010/01/17 15:59:34.70 kernel lasterror = 8211
preverror = 0 transtate = 0

00:00000:00375:2010/01/17 15:59:34.70 kernel curcmd = 193 program =
RICOS(JDBC)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x007c1670 pcstkwalk
+0x28(0x00000000, 0x109f105c, 0x0000270f, 0x00000002, 0xfffffff8)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x007c155c
ucstkgentrace+0x1ac(0x24836960, 0x254742f0, 0x0000270f, 0x00000000,
0x00000000)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x0076df90
ucbacktrace+0xa8(0x00000000, 0x00000001, 0x0000001e, 0x248452ec,
0x0ec00000)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x00153a94
terminate_process+0xdf4(0x00cb0000, 0x00000000, 0x24836960,
0x00006ed8, 0x2483c4c8)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x001aca74
hdl_default+0x48(0x00000052, 0x0000000b, 0x0000001a, 0x00000001,
0x109f1a58)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x004896b4 s_handle
+0xde0(0x00cb0000, 0x00006c00, 0x00007400, 0xffffffff, 0x00005400)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x001ac468 ex_raise
+0x1b0(0x24836960, 0x2483c4c8, 0x51eb8400, 0x00000001, 0x00000000)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x0021f0b0
des__hashinst+0x240(0xfe88fe3c, 0x00000002, 0x22a16364, 0x00000016,
0x00000000)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x0021f248
des__install+0x60(0x22a16308, 0x22af0540, 0xffffffff, 0x109f1f88,
0x120243dc)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x0022258c
des_lwpdescreate+0xc8(0x00000001, 0xfe88fe3c, 0x109f1f88, 0x00000016,
0x00ceb000)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x0032ef40
open__lwpbyname+0x160(0x109f1f88, 0x00000016, 0xfffffffe, 0x00000000,
0xfffffff8)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x0032d2bc
open__byname+0x274(0x00005800, 0x2483c160, 0xfffffffe, 0x109f1f88,
0x00000016)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x0032caec
open_user_table+0x94(0x012d1c00, 0x2483dd60, 0x00000004, 0xfffffffe,
0x109f1f88)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x0026a7dc proc_get
+0x78(0x00000000, 0x00000000, 0x00000001, 0x00000001, 0x00000004)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x0047e998
s_getTreeOrPlan+0x58(0x00000004, 0x00040000, 0x00000000, 0x00000001,
0x00000004)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x004876d0
s_procinstall_lwp+0x16c(0x00000002, 0x00000004, 0x2483c160,
0x00000001, 0x00000001)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x00487eec
s_renormalize+0xf8(0x2bbef800, 0x28715800, 0x00001012, 0x00007400,
0x012d1c00)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x00487bb8
s_recompile+0x43c(0x00005800, 0x2483d560, 0x012d1c00, 0x2483c160,
0x00000304)

00:00000:00375:2010/01/17 15:59:34.71 kernel [Handler pc: 0x004888d4
s_handle installed by the following function:-]

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x004850f0 sequencer
+0x12d8(0x00007400, 0x012d4000, 0x00001012, 0x00007700, 0x00001000)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x004714d4 execproc
+0x904(0x00000000, 0x00000004, 0x00005800, 0x00000039, 0x00000001)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x00469bb4 s_execute
+0x29e4(0x00000000, 0x0f14c140, 0x00000001, 0x012d4000, 0x00cb0000)

00:00000:00375:2010/01/17 15:59:34.71 kernel [Handler pc: 0x004888d4
s_handle installed by the following function:-]

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x00484f20 sequencer
+0x1108(0x00007400, 0x012d4000, 0x00006c00, 0x00007700, 0x00000000)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x00185744
tdsrecv__dynexec+0xcc(0x109f2dd8, 0x00006c00, 0x00000006, 0x012d1c00,
0x2483dd60)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x0018328c
tdsrecv_dynamic+0x224(0x000000e7, 0x00000000, 0x2483d560, 0x00006c00,
0x2483c160)

00:00000:00375:2010/01/17 15:59:34.71 kernel [Handler pc: 0x001ac6c0
hdl_backout installed by the following function:-]

00:00000:00375:2010/01/17 15:59:34.71 kernel [Handler pc: 0x003fc518
ut_handle installed by the following function:-]

00:00000:00375:2010/01/17 15:59:34.71 kernel [Handler pc: 0x003fc518
ut_handle installed by the following function:-]

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x00195224 conn_hdlr
+0x2048(0x01367800, 0x2483c160, 0x2483d560, 0xffffffff, 0x00000001)

00:00000:00375:2010/01/17 15:59:34.71 kernel pc: 0x007d5834
_coldstart(0x000000ea, 0x001931dc, 0x00000000, 0x00000000, 0x00000000)

00:00000:00375:2010/01/17 15:59:34.71 kernel end of stack trace,
spid 375, kpid 1212612940, suid 1
Manish Negandhi [TeamSybase]
2010-01-21 09:28:01 UTC
Permalink
Post by Amith
 Hi
I got the below error in ASE server. when checked at sybooks it says
to reboot to clear the caches.but i havent rebooted and still the
server is running fine.
and i also want to know how to find the table in which the mismatch
happened from errorlog.
let me know your suggestions on this.
What ASE version are you using ?, desciptor lies within memory and a
reboot should clear it. You might also want to look at CR
http://search.sybase.com/kbx/changerequests?bug_id=345479

-HTH
Manish Negandhi
[TeamSybase]

Loading...