Difference between revisions of "Fixing system tables in the master database after a change of Characterset / SortOrder"

From SybaseWiki
Jump to: navigation, search
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 9: Line 9:
 
|-  
 
|-  
 
|
 
|
{|
+
{||-|
|-|server  Error: 614, Severity: 21, State: 7
+
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.
+
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  ************************************
 
kernel  SQL causing error : spt_ijdbc_mda
 
kernel  SQL causing error : spt_ijdbc_mda

Revision as of 14:26, 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