[求助]

mysybase

免费乐捐，感谢支持

紧急求助！

各位大侠：现在小弟有个问题紧急求助，SYBASE复制从节点A向节点B复制数据时就DOWN下来，而且节点B的数据库也会DOWN，断开复制后数据库就可以连上。重启节点B的服务器几分钟就又DOWN了，是怎么回事啊？？？

[em06][em06][em11][em11]

flybean

把日志贴出来

mysybase

谢谢大侠:

下面是中心服务器日志:

W. 2005/12/09 19:06:02. WARNING #13092 DSI(110 TSCY_SERVER.TSCY) - seful/cm.c(4482)
The Data Server 'TSCY_SERVER' is using the 'cp850' character set for Database 'TSCY'. The Replication Server is using the 'iso_1' character set. Unexpected results may occur.
I. 2005/12/09 19:06:03. Replication Agent version (200) for 'GS_SERVER.JCCY' does not match the default LTI version for this Replication Server 300 using version 200.
I. 2005/12/09 19:06:03. Replication Agent for GS_SERVER.JCCY connected in passthru mode.
E. 2005/12/09 19:06:07. ERROR #1027 DSI EXEC(110(1) TSCY_SERVER.TSCY) - /dsiutil.c(315)
Open Client Client-Library error: Error: 84083974, Severity 5 -- 'ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect'.
E. 2005/12/09 19:06:07. ERROR #5097 DSI EXEC(110(1) TSCY_SERVER.TSCY) - /dsiutil.c(318)
The ct-lib function 'ct_results' returns FAIL for database 'TSCY_SERVER.TSCY'. The errors are retryable. The DSI thread will restart automatically. See ct-lib messages for more information.
I. 2005/12/09 19:06:32. Replication Agent version (200) for 'PX_SERVER.pxzx' does not match the default LTI version for this Replication Server 300 using version 200.
I. 2005/12/09 19:06:32. Replication Agent for PX_SERVER.pxzx connected in passthru mode.
I. 2005/12/09 19:06:49. Replication Agent for GSSD.XBSCDB connected in passthru mode.
E. 2005/12/09 19:17:23. ERROR #1027 DSI(110 TSCY_SERVER.TSCY) - seful/cm.c(2956)
Open Client Client-Library error: Error: 84083974, Severity 5 -- 'ct_connect(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect'.
E. 2005/12/09 19:17:23. ERROR #13045 DSI(110 TSCY_SERVER.TSCY) - seful/cm.c(2961)
Failed to connect to server 'TSCY_SERVER' as user 'TSCY_maint'. See CT-Lib and/or server error messages for more information.
I. 2005/12/09 19:17:23. Trying to connect to server 'TSCY_SERVER' as user 'TSCY_maint' ......
I. 2005/12/09 19:20:35. Connection to server 'GSSD' as user 'XBSCDB_maint' has been faded out (closed).
I. 2005/12/09 19:21:01. Connection to server 'POS_SERVER' as user 'xbsc_maint' has been faded out (closed).
I. 2005/12/09 19:21:20. Shutting down.
I. 2005/12/09 19:53:51. 'Replication Server/12.0/P/RS6000/AIX 4.3.2/1/OPT/Fri Dec 10 17:52:51 PST 1999'
I. 2005/12/09 19:53:51. 'Confidential property of Sybase, Inc.
Copyright 1992, 1999
Sybase, Inc. All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc. Use, duplication or disclosure of the software and documentation by
the U.S. Government is subject to restrictions set forth in a license
agreement between the Government and Sybase, Inc. or other written
agreement specifying the Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608 USA.
'
I. 2005/12/09 19:53:51. Logging messages in file '/sybase/REP-12_0/install/GSSD_RS.log'.
I. 2005/12/09 19:53:51. Using interfaces file '/sybase/interfaces'.
I. 2005/12/09 19:53:51. Server name is 'GSSD_RS'.
I. 2005/12/09 19:53:51. Reading '/sybase/REP-12_0/install/GSSD_RS.cfg' for configuration information.
I. 2005/12/09 19:53:51. Using the 'iso_1' character set.
I. 2005/12/09 19:53:51. Using the 'us_english' language.
I. 2005/12/09 19:53:51. Using the 'binary' sort order.
I. 2005/12/09 19:53:51. Using server 'GSSD_RS' for an ID Server.
I. 2005/12/09 19:53:52. Using config file password for the ID user.
I. 2005/12/09 19:53:52. Using user 'GSSD_RS_id_user' for the ID Server.
I. 2005/12/09 19:53:52. Using config file maintenance password for the RSSD maint user.
I. 2005/12/09 19:53:52. RSSD maintenace user is 'RSSD_maint'.
I. 2005/12/09 19:53:52. Using config file password for the RSSD primary user.
I. 2005/12/09 19:53:52. RSSD primary user is 'RSSD_prim'.
I. 2005/12/09 19:53:52. RSSD database is 'RSSD'.
I. 2005/12/09 19:53:52. RSSD server is 'GSSD'.
I. 2005/12/09 19:53:52. Reading 'GSSD.RSSD..rs_config' for system configuration parameters.
I. 2005/12/09 19:53:52. Value of the 'memory_limit' config parameter is: 100 megabytes.
I. 2005/12/09 19:53:52. Maximum outbound connections allowed: 64.
I. 2005/12/09 19:53:52. System outbound connection fadeout time: '30'.
I. 2005/12/09 19:53:52. System table cache size: 100 rows.
I. 2005/12/09 19:53:52. Maximum number of Open Server threads allowed: 100.
I. 2005/12/09 19:53:52. Maximum number of Open Server mutexes allowed: 128.
I. 2005/12/09 19:53:52. Maximum number of incoming client connections allowed: 30.
I. 2005/12/09 19:53:52. Maximum number of Open Server message queues allowed: 178.
I. 2005/12/09 19:53:53. Maximum number of Open Server messages allowed: 45568.
I. 2005/12/09 19:53:53. Maximum number of stable queues allowed: 32.
I. 2005/12/09 19:53:53. Password encryption option: 0.
I. 2005/12/09 19:53:53. Default for connection ha_failover is set to 'off',
I. 2005/12/09 19:53:53. System configuration complete.
I. 2005/12/09 19:53:53. Server using Open Server version Sybase Server-Library/12.0/P/rs6000/AIX 4.3.1/1/OPT/Sun Sep 26 04:57:29 1999
I. 2005/12/09 19:53:53. Server using Open Client version Sybase Client-Library/12.0/P/rs6000/AIX 4.3.1/1/OPT/Mon Oct 4 13:09:11 1999
I. 2005/12/09 19:53:53. Server site id is '16777317'.
I. 2005/12/09 19:53:53. Embedded database id is '101'.
I. 2005/12/09 19:53:57. The DSI thread for database 'DEMO_SERVER.MLJCCY' is started.
I. 2005/12/09 19:53:57. The DSI thread for database 'GSSD.JCCWDB' is started.
I. 2005/12/09 19:53:57. The DSI thread for database 'GSSD.PXCWDB' is started.
I. 2005/12/09 19:53:58. The DSI thread for database 'GSSD.RSSD' is started.
I. 2005/12/09 19:53:58. The DSI thread for database 'GSSD.XBSCDB' is started.
I. 2005/12/09 19:53:58. The DSI thread for database 'GS_SERVER.JCCY' is started.
I. 2005/12/09 19:53:58. The DSI thread for database 'POS_SERVER.xbsc' is started.
I. 2005/12/09 19:53:59. The DSI thread for database 'PX_SERVER.pxzx' is started.
W. 2005/12/09 19:53:59. WARNING #5059 GLOBAL RS(GLOBAL RS) - dsiqmext.c(191)
The DSI thread for 'XHSD_SERVER.JCCY' is not started, because the connection to the database has been suspended or the connection has not been completed.
I. 2005/12/09 19:53:59. The DSI thread for database 'TSCY_SERVER.TSCY' is started.
I. 2005/12/09 19:53:59. The DSI thread for database 'XHSD_SERVER.PXCWDB' is started.
I. 2005/12/09 19:54:00. Replication Server 'GSSD_RS' is started.
I. 2005/12/09 19:54:00. SQM starting: 102:0 GSSD.XBSCDB
I. 2005/12/09 19:54:00. SQM starting: 101:0 GSSD.RSSD
I. 2005/12/09 19:54:01. SQM starting: 102:1 GSSD.XBSCDB
I. 2005/12/09 19:54:01. SQM starting: 103:1 PX_SERVER.pxzx
I. 2005/12/09 19:54:01. SQM starting: 108:1 POS_SERVER.xbsc
I. 2005/12/09 19:54:01. SQM starting: 109:0 GSSD.PXCWDB
I. 2005/12/09 19:54:01. SQM starting: 110:0 TSCY_SERVER.TSCY
I. 2005/12/09 19:54:01. SQM starting: 111:0 GS_SERVER.JCCY
I. 2005/12/09 19:54:01. SQM starting: 112:0 GSSD.JCCWDB
I. 2005/12/09 19:54:01. SQM starting: 115:0 XHSD_SERVER.JCCY
I. 2005/12/09 19:54:01. SQM starting: 122:0 DEMO_SERVER.MLJCCY
I. 2005/12/09 19:54:01. SQM starting: 103:0 PX_SERVER.pxzx
I. 2005/12/09 19:54:01. SQM starting: 108:0 POS_SERVER.xbsc
I. 2005/12/09 19:54:01. SQM starting: 110:1 TSCY_SERVER.TSCY
I. 2005/12/09 19:54:01. SQM starting: 111:1 GS_SERVER.JCCY
I. 2005/12/09 19:54:01. SQM starting: 114:0 XHSD_SERVER.PXCWDB
I. 2005/12/09 19:54:01. SQM starting: 115:1 XHSD_SERVER.JCCY
I. 2005/12/09 19:54:01. SQM starting: 122:1 DEMO_SERVER.MLJCCY
I. 2005/12/09 19:54:01. DIST for 'TSCY_SERVER.TSCY' is Starting
I. 2005/12/09 19:54:01. DIST for 'DEMO_SERVER.MLJCCY' is Starting
I. 2005/12/09 19:54:01. DIST for 'GS_SERVER.JCCY' is Starting
I. 2005/12/09 19:54:01. DIST for 'PX_SERVER.pxzx' is Starting
I. 2005/12/09 19:54:01. DIST for 'XHSD_SERVER.JCCY' is Starting
I. 2005/12/09 19:54:01. DIST for 'GSSD.XBSCDB' is Starting
I. 2005/12/09 19:54:01. DIST for 'POS_SERVER.xbsc' is Starting
W. 2005/12/09 19:54:03. WARNING #13092 DSI(108 POS_SERVER.xbsc) - seful/cm.c(4482)
The Data Server 'POS_SERVER' is using the 'cp850' character set for Database 'xbsc'. The Replication Server is using the 'iso_1' character set. Unexpected results may occur.
W. 2005/12/09 19:54:03. WARNING #13092 DSI(103 PX_SERVER.pxzx) - seful/cm.c(4482)
The Data Server 'PX_SERVER' is using the 'cp850' character set for Database 'pxzx'. The Replication Server is using the 'iso_1' character set. Unexpected results may occur.
W. 2005/12/09 19:54:04. WARNING #13092 DSI(114 XHSD_SERVER.PXCWDB) - seful/cm.c(4482)
The Data Server 'XHSD_SERVER' is using the 'cp850' character set for Database 'PXCWDB'. The Replication Server is using the 'iso_1' character set. Unexpected results may occur.
W. 2005/12/09 19:54:04. WARNING #13092 DSI(122 DEMO_SERVER.MLJCCY) - seful/cm.c(4482)
The Data Server 'DEMO_SERVER' is using the 'cp850' character set for Database 'MLJCCY'. The Replication Server is using the 'iso_1' character set. Unexpected results may occur.
W. 2005/12/09 19:54:04. WARNING #13092 DSI(111 GS_SERVER.JCCY) - seful/cm.c(4482)
The Data Server 'GS_SERVER' is using the 'cp850' character set for Database 'JCCY'. The Replication Server is using the 'iso_1' character set. Unexpected results may occur.
W. 2005/12/09 19:54:04. WARNING #13092 DSI(110 TSCY_SERVER.TSCY) - seful/cm.c(4482)
The Data Server 'TSCY_SERVER' is using the 'cp850' character set for Database 'TSCY'. The Replication Server is using the 'iso_1' character set. Unexpected results may occur.
E. 2005/12/09 19:54:08. ERROR #1027 DSI EXEC(110(1) TSCY_SERVER.TSCY) - /dsiutil.c(315)
Open Client Client-Library error: Error: 84083974, Severity 5 -- 'ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect'.
E. 2005/12/09 19:54:08. ERROR #5097 DSI EXEC(110(1) TSCY_SERVER.TSCY) - /dsiutil.c(318)
The ct-lib function 'ct_results' returns FAIL for database 'TSCY_SERVER.TSCY'. The errors are retryable. The DSI thread will restart automatically. See ct-lib messages for more information.
I. 2005/12/09 19:54:38. Replication Agent version (200) for 'TSCY_SERVER.TSCY' does not match the default LTI version for this Replication Server 300 using version 200.
I. 2005/12/09 19:54:38. Replication Agent for TSCY_SERVER.TSCY connected in passthru mode.
I. 2005/12/09 19:54:49. Replication Agent version (200) for 'GS_SERVER.JCCY' does not match the default LTI version for this Replication Server 300 using version 200.
I. 2005/12/09 19:54:50. Replication Agent for GS_SERVER.JCCY connected in passthru mode.
I. 2005/12/09 19:55:05. Replication Agent for GSSD.XBSCDB connected in passthru mode.
I. 2005/12/09 19:55:05. Replication Agent version (200) for 'PX_SERVER.pxzx' does not match the default LTI version for this Replication Server 300 using version 200.
I. 2005/12/09 19:55:05. Replication Agent for PX_SERVER.pxzx connected in passthru mode.
E. 2005/12/09 20:38:56. ERROR #1027 DSI(110 TSCY_SERVER.TSCY) - seful/cm.c(2956)
Open Client Client-Library error: Error: 84083974, Severity 5 -- 'ct_connect(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect'.
E. 2005/12/09 20:38:56. ERROR #13045 DSI(110 TSCY_SERVER.TSCY) - seful/cm.c(2961)
Failed to connect to server 'TSCY_SERVER' as user 'TSCY_maint'. See CT-Lib and/or server error messages for more information.
I. 2005/12/09 20:38:56. Trying to connect to server 'TSCY_SERVER' as user 'TSCY_maint' ......
I. 2005/12/09 20:40:17. Shutting down.

mysybase

下面是节点B日志:

00:00000:00107:2005/12/10 03:29:19.17 kernel ************************************
00:00000:00107:2005/12/10 03:29:19.17 kernel SQL causing error :
00:00000:00107:2005/12/10 03:29:19.17 kernel ************************************
00:00000:00107:2005/12/10 03:29:19.17 server SQL Text:
00:00000:00107:2005/12/10 03:29:19.17 kernel curdb = 1 pstat = 0x10000 lasterror = 0
00:00000:00107:2005/12/10 03:29:19.17 kernel preverror = 0 transtate = 1
00:00000:00107:2005/12/10 03:29:19.17 kernel curcmd = 0 program = RSMServer
00:00000:00107:2005/12/10 03:29:19.17 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x4ffeae8, 0x7d007d, 0x4ffeae8, 0x0)
00:00000:00107:2005/12/10 03:29:19.17 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x4ffeae8, 0x4fff03c, 0x270f, 0x2)
00:00000:00107:2005/12/10 03:29:19.17 kernel pc: 0x883514 pcstkwalk+ 0x224 (0x7d007d, 0x2, 0x270f, 0x0)
00:00000:00107:2005/12/10 03:29:19.17 kernel pc: 0x8830ae ucstkgentrace+ 0x1ce (0x7d007d, 0x1, 0xe0000001, 0x80000000)
00:00000:00107:2005/12/10 03:29:19.17 kernel pc: 0x862864 ucbacktrace+ 0x84 (0x7d007d, 0xffffffff, 0x5208, 0x0)
00:00000:00107:2005/12/10 03:29:19.17 kernel pc: 0x405fe6 terminate_process+ 0x566 (0xe0000001, 0x7800f5b5, 0x4fff430, 0x0)
00:00000:00107:2005/12/10 03:29:19.17 kernel pc: 0x85b56e kiexception+ 0x1ee (0x20018c18, 0x20013a10, 0x7c007c, 0x20018c18)
00:00000:00107:2005/12/10 03:29:19.17 kernel pc: 0x89c23d kpntwrapper+ 0x10d (0x89c130, 0x20018c18, 0x0, 0x0)
00:00000:00107:2005/12/10 03:29:19.17 kernel pc: 0x77ed4f05 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00107:2005/12/10 03:29:19.17 kernel end of stack trace, spid 107, kpid 8192125, suid 0
00:00000:00000:2005/12/10 03:30:59.57 kernel timeslice -501, current process infected
00:00000:00107:2005/12/10 03:30:59.57 kernel SQL Server system exception (0xe0000001) generated by a process exceeding its time slice allotment.
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x77eed7ab KERNEL32.dll (0xe0000001, 0x1, 0x0, 0x0)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x77eed7ab KERNEL32.dll (0x48f577, 0x20967d94, 0x20967d94, 0x0)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x89c276 kpntraise+ 0x26 (0x20967d94, 0x4, 0x0, 0x0)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x8725cb spinobtain+ 0xb (0x20967d94, 0x4, 0x0, 0x0)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x540339 getpage_with_validation+ 0xe9 (0x4ffe4f0, 0x190, 0x20967d94, 0x1)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x5793e5 getrootpage+ 0x95 (0x4ffe85c, 0x20967d94, 0x1, 0x1)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x5775c0 srchindex+ 0x190 (0x20967d94, 0x1, 0x20bf9c54, 0x1)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x53141e apl__startscan+ 0x1ce (0x20967d94, 0x1, 0x1, 0x4fff448)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x530f4f startscan+ 0x21f (0x4ffe9c8, 0x4ffefd0, 0x4ffebcc, 0x4fff1d0)
00:00000:00107:2005/12/10 03:30:59.57 kernel end of stack trace, spid 107, kpid 8192125, suid 0
00:00000:00107:2005/12/10 03:30:59.57 kernel ************************************
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x4ffd898, 0x7d007d, 0x4ffd898, 0x0)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x4ffd898, 0x4ffddec, 0x270f, 0x2)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x883514 pcstkwalk+ 0x224 (0x7d007d, 0x2, 0x270f, 0x0)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x8830ae ucstkgentrace+ 0x1ce (0x7d007d, 0x1, 0xe0000001, 0x80000000)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x862864 ucbacktrace+ 0x84 (0x7d007d, 0xffffffff, 0x5208, 0x0)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x406810 terminate_process+ 0xd90 (0xe0000001, 0x7800f5b5, 0x4ffe1e0, 0x0)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x85b56e kiexception+ 0x1ee (0x20018c18, 0x20013a10, 0x7c007c, 0x20018c18)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x89c23d kpntwrapper+ 0x10d (0x89c130, 0x20018c18, 0x0, 0x0)
00:00000:00107:2005/12/10 03:30:59.57 kernel pc: 0x77ed4f05 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00107:2005/12/10 03:30:59.57 kernel end of stack trace, spid 107, kpid 8192125, suid 0
00:00000:00000:2005/12/10 03:33:40.03 kernel timeslice -500, current process infected
00:00000:00108:2005/12/10 03:33:40.03 kernel SQL Server system exception (0xe0000001) generated by a process exceeding its time slice allotment.
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x77eed7ab KERNEL32.dll (0xe0000001, 0x1, 0x0, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x77eed7ab KERNEL32.dll (0x48f577, 0x2096ecdc, 0x2096ecdc, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x89c276 kpntraise+ 0x26 (0x2096ecdc, 0x4, 0x0, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x8725c8 spinobtain+ 0x8 (0x2096ecdc, 0x4, 0x0, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x540339 getpage_with_validation+ 0xe9 (0x505f740, 0x1a8, 0x2096ecdc, 0x1)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x5793e5 getrootpage+ 0x95 (0x505faac, 0x2096ecdc, 0x2, 0x1)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x5775c0 srchindex+ 0x190 (0x2096ecdc, 0x2, 0x20bf93fc, 0x2)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x53141e apl__startscan+ 0x1ce (0x2096ecdc, 0x2, 0x2, 0x2096ebec)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x530f4f startscan+ 0x21f (0x20018cc0, 0x7d007d, 0x20013a10, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel [Handler pc: 0x452660 hdl_backout installed by the following function:-]
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x42e0e2 login+ 0x432 (0x2, 0x4000, 0x20018cc0, 0x7d007d)
00:00000:00108:2005/12/10 03:33:40.03 kernel [Handler pc: 0x452660 hdl_backout installed by the following function:-]
00:00000:00108:2005/12/10 03:33:40.03 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
00:00000:00108:2005/12/10 03:33:40.03 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x40d355 conn_hdlr+ 0x295 (0x20018cc0, 0x20013a10, 0x7d007d, 0x20018cc0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x20018cc0, 0x0, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x77ed4f05 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel end of stack trace, spid 108, kpid 8257662, suid 0
00:00000:00108:2005/12/10 03:33:40.03 kernel ************************************
00:00000:00108:2005/12/10 03:33:40.03 kernel SQL causing error :
00:00000:00108:2005/12/10 03:33:40.03 kernel ************************************
00:00000:00108:2005/12/10 03:33:40.03 server SQL Text:
00:00000:00108:2005/12/10 03:33:40.03 kernel curdb = 1 pstat = 0x10000 lasterror = 0
00:00000:00108:2005/12/10 03:33:40.03 kernel preverror = 0 transtate = 1
00:00000:00108:2005/12/10 03:33:40.03 kernel curcmd = 0 program = RSMServer
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x505eae8, 0x7e007e, 0x505eae8, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x505eae8, 0x505f03c, 0x270f, 0x2)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x883514 pcstkwalk+ 0x224 (0x7e007e, 0x2, 0x270f, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x8830ae ucstkgentrace+ 0x1ce (0x7e007e, 0x1, 0xe0000001, 0x80000000)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x862864 ucbacktrace+ 0x84 (0x7e007e, 0xffffffff, 0x52b0, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x405fe6 terminate_process+ 0x566 (0xe0000001, 0x7800f5b5, 0x505f430, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x85b56e kiexception+ 0x1ee (0x20018cc0, 0x20013a10, 0x7d007d, 0x20018cc0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x89c23d kpntwrapper+ 0x10d (0x89c130, 0x20018cc0, 0x0, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel pc: 0x77ed4f05 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00108:2005/12/10 03:33:40.03 kernel end of stack trace, spid 108, kpid 8257662, suid 0
00:00000:00000:2005/12/10 03:35:20.43 kernel timeslice -500, current process infected
00:00000:00108:2005/12/10 03:35:20.43 kernel SQL Server system exception (0xe0000001) generated by a process exceeding its time slice allotment.
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x77eed7ab KERNEL32.dll (0xe0000001, 0x1, 0x0, 0x0)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x77eed7ab KERNEL32.dll (0x48f577, 0x2096f0c8, 0x2096f0c8, 0x0)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x89c276 kpntraise+ 0x26 (0x2096f0c8, 0x4, 0x0, 0x0)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x8725da spinobtain+ 0x1a (0x2096f0c8, 0x4, 0x0, 0x0)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x540339 getpage_with_validation+ 0xe9 (0x505e4f0, 0x190, 0x2096f0c8, 0x1)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x5793e5 getrootpage+ 0x95 (0x505e85c, 0x2096f0c8, 0x1, 0x1)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x5775c0 srchindex+ 0x190 (0x2096f0c8, 0x1, 0x20bf9c54, 0x1)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x53141e apl__startscan+ 0x1ce (0x2096f0c8, 0x1, 0x1, 0x505f448)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x530f4f startscan+ 0x21f (0x505e9c8, 0x505efd0, 0x505ebcc, 0x505f1d0)
00:00000:00108:2005/12/10 03:35:20.43 kernel end of stack trace, spid 108, kpid 8257662, suid 0
00:00000:00108:2005/12/10 03:35:20.43 kernel ************************************
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x505d898, 0x7e007e, 0x505d898, 0x0)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x505d898, 0x505ddec, 0x270f, 0x2)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x883514 pcstkwalk+ 0x224 (0x7e007e, 0x2, 0x270f, 0x0)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x8830ae ucstkgentrace+ 0x1ce (0x7e007e, 0x1, 0xe0000001, 0x80000000)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x862864 ucbacktrace+ 0x84 (0x7e007e, 0xffffffff, 0x52b0, 0x0)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x406810 terminate_process+ 0xd90 (0xe0000001, 0x7800f5b5, 0x505e1e0, 0x0)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x85b56e kiexception+ 0x1ee (0x20018cc0, 0x20013a10, 0x7d007d, 0x20018cc0)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x89c23d kpntwrapper+ 0x10d (0x89c130, 0x20018cc0, 0x0, 0x0)
00:00000:00108:2005/12/10 03:35:20.43 kernel pc: 0x77ed4f05 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00108:2005/12/10 03:35:20.43 kernel end of stack trace, spid 108, kpid 8257662, suid 0
00:00000:00000:2005/12/10 03:38:00.89 kernel timeslice -500, current process infected
00:00000:00003:2005/12/10 03:38:00.89 kernel SQL Server system exception (0xe0000001) generated by a process exceeding its time slice allotment.
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x77eed7ab KERNEL32.dll (0xe0000001, 0x1, 0x0, 0x0)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x77eed7ab KERNEL32.dll (0x48f577, 0x2067ac88, 0x2067ac88, 0x0)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x89c276 kpntraise+ 0x26 (0x2067ac88, 0x4, 0x0, 0x0)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x8725cb spinobtain+ 0xb (0x2067ac88, 0x4, 0x0, 0x0)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x540339 getpage_with_validation+ 0xe9 (0x1a1f198, 0x190, 0x2067ac88, 0x1)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x5793e5 getrootpage+ 0x95 (0x1a1f504, 0x2067ac88, 0x1, 0x1)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x5775c0 srchindex+ 0x190 (0x2067ac88, 0x1, 0x20bf9c54, 0x1)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x53141e apl__startscan+ 0x1ce (0x2067ac88, 0x1, 0x1, 0x1a638f0)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x530f4f startscan+ 0x21f (0x1a1f670, 0x1a1fc78, 0x1a1f874, 0x1a1fe78)
00:00000:00003:2005/12/10 03:38:00.89 kernel end of stack trace, spid 3, kpid 917518, suid 0
00:00000:00003:2005/12/10 03:38:00.89 kernel ************************************
00:00000:00003:2005/12/10 03:38:00.89 kernel curdb = 1 pstat = 0x84000 lasterror = 1601
00:00000:00003:2005/12/10 03:38:00.89 kernel preverror = 0 transtate = 1
00:00000:00003:2005/12/10 03:38:00.89 kernel curcmd = 0 program =
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x1a1e540, 0xe000e, 0x1a1e540, 0x0)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x1a1e540, 0x1a1ea94, 0x270f, 0x2)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x883514 pcstkwalk+ 0x224 (0xe000e, 0x2, 0x270f, 0x0)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x8830ae ucstkgentrace+ 0x1ce (0xe000e, 0x1, 0xe0000001, 0x80000000)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x862864 ucbacktrace+ 0x84 (0xe000e, 0xffffffff, 0x930, 0x0)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x405fe6 terminate_process+ 0x566 (0xe0000001, 0x7800f5b5, 0x1a1ee88, 0x0)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x85b56e kiexception+ 0x1ee (0x20014340, 0x20013a10, 0x30003, 0x20014340)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x89c23d kpntwrapper+ 0x10d (0x89c130, 0x20014340, 0x0, 0xb0)
00:00000:00003:2005/12/10 03:38:00.89 kernel pc: 0x77ed4f05 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00003:2005/12/10 03:38:00.89 kernel end of stack trace, spid 3, kpid 917518, suid 0

mysybase

请大侠看看问题出在哪里了!

谢谢!

[em17][em17]

flybean

ASE版本和RS版本？

mysybase

是啊.日志里能不能看出点什么?[em48][em48]

flybean

免费乐捐，感谢支持

ASE版本？记忆中可能是ASE已解决的一个BUG。有可能的话，打一下ASE和RS的PATCH。

aliking

原因之一是字符集不匹配，日志里写的很清楚：

The Data Server 'POS_SERVER' is using the 'cp850' character set for Database 'xbsc'. The Replication Server is using the 'iso_1' character set.

lovelyni

啊~~~~~~~好长,看的头晕了

lovelyni

再来看看

银铠圣袍

字符集不一致。