Difference between revisions of "Fixing system tables in the master database after a change of Characterset / SortOrder"
m (→Fixing system tables in the master database after a change of Characterset/SortOrder) |
m (→Fixing system tables in the master database after a change of Characterset/SortOrder) |
||
Line 8: | Line 8: | ||
{| border="1" | {| border="1" | ||
|- | |- | ||
− | | | + | | |
+ | server Error: 614, Severity: 21, State: 7 | ||
+ | server Adaptive Server accessed a row that has an illegal length of 16640 while in data base 'master'. Page pointer = 0x1abe59800, pageno = 1098, status = 0x2, objectid = 224000798, indexid = 2, level = 0. The minimum row length is 13. The page size is 2048. | ||
+ | kernel ************************************ | ||
+ | kernel SQL causing error : spt_ijdbc_mda | ||
+ | kernel ************************************ | ||
+ | server SQL Text: spt_ijdbc_mda | ||
+ | kernel curdb = 1 pstat = 0x10000 lasterror = 614 | ||
+ | kernel preverror = 0 transtate = 1 | ||
+ | kernel curcmd = 326 program = isql | ||
+ | kernel pc: 0x00000001208c5260 pcstkwalk+0x50() | ||
+ | kernel pc: 0x00000001208c4fa0 ucstkgentrace+0x250() | ||
+ | kernel pc: 0x0000000120830664 ucbacktrace+0x104() | ||
+ | kernel pc: 0x00000001202cf084 terminate_process+0xbc4() | ||
+ | kernel pc: 0x00000001203d6a58 hdl_default+0x68() | ||
+ | kernel pc: 0x00000001205370e0 ut_handle+0x130() | ||
+ | kernel pc: 0x0000000120324a34 ex_raise+0x364() | ||
+ | kernel pc: 0x00000001201851e0 rowsize+0x270() | ||
+ | kernel pc: 0x00000001205622b8 ups_main+0x10b8() | ||
+ | kernel pc: 0x00000001202359a0 getnext+0x150() | ||
+ | kernel pc: 0x00000001201dc3b8 ups_deadlock_getnext+0x28() | ||
+ | kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] | ||
+ | kernel pc: 0x0000000120563630 ups_main+0x2430() | ||
+ | kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] | ||
+ | kernel pc: 0x00000001205617bc ups_main+0x5bc() | ||
+ | kernel pc: 0x00000001202817fc s_execute_cold_3+0x2bac() | ||
+ | kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] | ||
+ | kernel pc: 0x0000000120245280 sequencer+0x440() | ||
+ | kernel [Handler pc: 0x0000000120521ad0 hsm_memobjsize+0x10 installed by the following function:-] | ||
+ | kernel pc: 0x000000012033f498 internal_sql+0x6a8() | ||
+ | kernel pc: 0x0000000120280974 s_execute_cold_3+0x1d24() | ||
+ | kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] | ||
+ | kernel pc: 0x0000000120245280 sequencer+0x440() | ||
+ | kernel pc: 0x00000001202456c0 execproc+0x3c0() | ||
+ | kernel pc: 0x000000012027f4ec s_execute_cold_3+0x89c() | ||
+ | kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] | ||
+ | kernel pc: 0x0000000120245280 sequencer+0x440() | ||
+ | kernel pc: 0x00000001202456c0 execproc+0x3c0() | ||
+ | kernel pc: 0x000000012027f4ec s_execute_cold_3+0x89c() | ||
+ | kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] | ||
+ | kernel pc: 0x0000000120245280 sequencer+0x440() | ||
+ | kernel pc: 0x0000000120172d28 tdsrecv_language+0x348() | ||
+ | kernel [Handler pc: 0x00000001203d6520 hdl_backout installed by the following function:-] | ||
+ | kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] | ||
+ | kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] | ||
+ | kernel pc: 0x000000012016f560 conn_hdlr_cold_347+0x830() | ||
+ | kernel end of stack trace, spid 76, kpid 261554288, suid 30 | ||
+ | |||
|} | |} | ||
hallo | hallo |
Revision as of 15:16, 10 March 2006
Things about Adaptive Server Enterprise
Administration
Fixing system tables in the master database after a change of Characterset/SortOrder
When you have changed the characterset and/or sort order for a server it might be necesarry to fix a few system tables in the master database. When you have not done this, a stacktrace similiar to this one will be shown in the errorlog.
server Error: 614, Severity: 21, State: 7 server Adaptive Server accessed a row that has an illegal length of 16640 while in data base 'master'. Page pointer = 0x1abe59800, pageno = 1098, status = 0x2, objectid = 224000798, indexid = 2, level = 0. The minimum row length is 13. The page size is 2048. kernel ************************************ kernel SQL causing error : spt_ijdbc_mda kernel ************************************ server SQL Text: spt_ijdbc_mda kernel curdb = 1 pstat = 0x10000 lasterror = 614 kernel preverror = 0 transtate = 1 kernel curcmd = 326 program = isql kernel pc: 0x00000001208c5260 pcstkwalk+0x50() kernel pc: 0x00000001208c4fa0 ucstkgentrace+0x250() kernel pc: 0x0000000120830664 ucbacktrace+0x104() kernel pc: 0x00000001202cf084 terminate_process+0xbc4() kernel pc: 0x00000001203d6a58 hdl_default+0x68() kernel pc: 0x00000001205370e0 ut_handle+0x130() kernel pc: 0x0000000120324a34 ex_raise+0x364() kernel pc: 0x00000001201851e0 rowsize+0x270() kernel pc: 0x00000001205622b8 ups_main+0x10b8() kernel pc: 0x00000001202359a0 getnext+0x150() kernel pc: 0x00000001201dc3b8 ups_deadlock_getnext+0x28() kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] kernel pc: 0x0000000120563630 ups_main+0x2430() kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] kernel pc: 0x00000001205617bc ups_main+0x5bc() kernel pc: 0x00000001202817fc s_execute_cold_3+0x2bac() kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] kernel pc: 0x0000000120245280 sequencer+0x440() kernel [Handler pc: 0x0000000120521ad0 hsm_memobjsize+0x10 installed by the following function:-] kernel pc: 0x000000012033f498 internal_sql+0x6a8() kernel pc: 0x0000000120280974 s_execute_cold_3+0x1d24() kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] kernel pc: 0x0000000120245280 sequencer+0x440() kernel pc: 0x00000001202456c0 execproc+0x3c0() kernel pc: 0x000000012027f4ec s_execute_cold_3+0x89c() kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] kernel pc: 0x0000000120245280 sequencer+0x440() kernel pc: 0x00000001202456c0 execproc+0x3c0() kernel pc: 0x000000012027f4ec s_execute_cold_3+0x89c() kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] kernel pc: 0x0000000120245280 sequencer+0x440() kernel pc: 0x0000000120172d28 tdsrecv_language+0x348() kernel [Handler pc: 0x00000001203d6520 hdl_backout installed by the following function:-] kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] kernel pc: 0x000000012016f560 conn_hdlr_cold_347+0x830() kernel end of stack trace, spid 76, kpid 261554288, suid 30 |
hallo