Amith
2010-01-21 06:45:47 UTC
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
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