关于sybase 复制服务器的排序顺序问题!
时间:2010-08-29
来源:互联网
请教各位,小弟在进行复制服务器的配置时,遇到一个问题。。。
将主、从数据库都通过 rs_init 添加到了复制系统内后,
在执行,以下检查
1> admin healt
2> go
Mode Quiesce Status
---------------- -------- --------
NORMAL TRUE SUSPECT
1>
后,提示,状态可疑。。。
后执行。。
1> admin who
2> go
Spid Name State Info
---- ---------- -------------------- ----------------------------------------
20 DSI EXEC Awaiting Command 101(1) test1.rep1_RSSD
12 DSI Awaiting Command 101 test1.rep1_RSSD
8 SQM Awaiting Message 101:0 test1.rep1_RSSD
22 DSI EXEC Awaiting Command 102(1) test2.dbtest2
13 DSI Awaiting Command 102 test2.dbtest2
16 DIST Active 102 test2.dbtest2
19 SQT Awaiting Wakeup 102:1 DIST test2.dbtest2
10 SQM Awaiting Message 102:1 test2.dbtest2
9 SQM Awaiting Message 102:0 test2.dbtest2
REP AGENT Down test2.dbtest2
21 DSI EXEC Awaiting Command 103(1) test3.dbtest3
14 DSI Awaiting Command 103 test3.dbtest3
11 SQM Awaiting Message 103:0 test3.dbtest3
15 dSUB Active
6 dCM Awaiting Message
7 dAIO Awaiting Message
17 dREC Active dREC
18 dSTATS Active
32 USER Active sa
5 dALARM Awaiting Wakeup
1>
其中。。发现,“REP AGENT Down test2.dbtest2”这项没有启动,
为了找到原因,
我查看了,系统日志。。。如下
仔细看了一下,其中的一段错误提示:
“
W. 2010/08/29 10:02:51. WARNING #13061 DSI(102 test2.dbtest2) - eue(4684)
Server test2 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
W. 2010/08/29 10:02:51. WARNING #13061 DSI(103 test3.dbtest3) - eue(4684)
Server test3 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
”
指出,主库test2和目的库test3的排序顺序与复制服务的不一致,请问,如何进行修改呢?
当前,复制服务器、主库、目的库的排序顺序均设置为:“Dictionary order,case insensitive."
不知道还有什么地方要进行设置才可以一致!
造成状态可疑,是否就是因为这个排序不一致引起的呢?
请各位多多指教!
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. 5000 Hacienda Drive, Dublin, CA 94568, USA.'
I. 2010/08/29 10:02:51. Logging messages in file 'C:\Sybase\REP-12_5\install\rep1.log '.
I. 2010/08/29 10:02:51. Using interfaces file 'C:\Sybase\ini\sql.ini '.
I. 2010/08/29 10:02:51. Server name is 'rep1'.
I. 2010/08/29 10:02:51. SYSAM: Replication Server received a valid 'REP_SERVER' license.
I. 2010/08/29 10:02:51. Reading 'C:\Sybase\REP-12_5\install\rep1.cfg ' for configuration information.
I. 2010/08/29 10:02:51. Using the 'cp850' character set.
I. 2010/08/29 10:02:51. Using the 'us_english' language.
I. 2010/08/29 10:02:51. Using the 'binary' sort order.
I. 2010/08/29 10:02:51. Using the 'binary' unicode sort order.
I. 2010/08/29 10:02:51. Using server 'rep1' for an ID Server.
I. 2010/08/29 10:02:51. Using config file password for the ID user.
I. 2010/08/29 10:02:51. Using user 'rep1_id_user' for the ID Server.
I. 2010/08/29 10:02:51. Using config file maintenance password for the RSSD maint user.
I. 2010/08/29 10:02:51. RSSD maintenace user is 'rep1_RSSD_maint'.
I. 2010/08/29 10:02:51. Using config file password for the RSSD primary user.
I. 2010/08/29 10:02:51. RSSD primary user is 'rep1_RSSD_prim'.
I. 2010/08/29 10:02:51. RSSD database is 'rep1_RSSD'.
I. 2010/08/29 10:02:51. RSSD server is 'test1'.
I. 2010/08/29 10:02:51. Reading 'test1.rep1_RSSD..rs_config' for system configuration parameters.
I. 2010/08/29 10:02:51. Value of the 'memory_limit' config parameter is: 20 megabytes.
I. 2010/08/29 10:02:51. Maximum outbound connections allowed: 64.
I. 2010/08/29 10:02:51. System outbound connection fadeout time: '30'.
I. 2010/08/29 10:02:51. System table cache size: 100 rows.
I. 2010/08/29 10:02:51. Maximum number of Open Server threads allowed: 50.
I. 2010/08/29 10:02:51. Maximum number of Open Server mutexes allowed: 128.
I. 2010/08/29 10:02:51. Maximum number of incoming client connections allowed: 30.
I. 2010/08/29 10:02:51. Maximum number of Open Server message queues allowed: 178.
I. 2010/08/29 10:02:51. Maximum number of Open Server messages allowed: 45568.
I. 2010/08/29 10:02:51. Maximum number of stable queues allowed: 32.
I. 2010/08/29 10:02:51. Password encryption option: 0.
I. 2010/08/29 10:02:51. Use SSL service is set to 'off'.
I. 2010/08/29 10:02:51. Default for connection ha_failover is set to 'off',
I. 2010/08/29 10:02:51. Default directory service provider is: 'InterfacesDriver'.
I. 2010/08/29 10:02:51. System configuration complete.
I. 2010/08/29 10:02:51. Server using Open Server version Sybase Server-Library/12.5/P-EBF10092-10091/PC Intel/BUILD125-012/OPT/Wed Feb 27 11:13:05 2002
I. 2010/08/29 10:02:51. Server using Open Client version Sybase Client-Library/12.5/P-EBF10091/PC Intel/BUILD125-012/OPT/Wed Feb 27 11:13:05 2002
W. 2010/08/29 10:02:51. WARNING #13061 GLOBAL RS(GLOBAL RS) - eue(4684)
Server test1 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
I. 2010/08/29 10:02:51. Server site id is '16777317'.
I. 2010/08/29 10:02:51. Embedded database id is '101'.
I. 2010/08/29 10:02:51. The DSI thread for database 'test1.rep1_RSSD' is started.
I. 2010/08/29 10:02:51. The DSI thread for database 'test2.dbtest2' is started.
I. 2010/08/29 10:02:51. The DSI thread for database 'test3.dbtest3' is started.
I. 2010/08/29 10:02:51. Replication Server 'rep1' is started.
I. 2010/08/29 10:02:51. DIST for 'test2.dbtest2' is Starting
I. 2010/08/29 10:02:51. SQM starting: 102:0 test2.dbtest2
I. 2010/08/29 10:02:51. SQM starting: 101:0 test1.rep1_RSSD
I. 2010/08/29 10:02:51. SQM starting: 103:0 test3.dbtest3
I. 2010/08/29 10:02:51. SQM starting: 102:1 test2.dbtest2
W. 2010/08/29 10:02:51. WARNING #13061 DSI(102 test2.dbtest2) - eue(4684)
Server test2 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
W. 2010/08/29 10:02:51. WARNING #13061 DSI(103 test3.dbtest3) - eue(4684)
Server test3 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
将主、从数据库都通过 rs_init 添加到了复制系统内后,
在执行,以下检查
1> admin healt
2> go
Mode Quiesce Status
---------------- -------- --------
NORMAL TRUE SUSPECT
1>
后,提示,状态可疑。。。
后执行。。
1> admin who
2> go
Spid Name State Info
---- ---------- -------------------- ----------------------------------------
20 DSI EXEC Awaiting Command 101(1) test1.rep1_RSSD
12 DSI Awaiting Command 101 test1.rep1_RSSD
8 SQM Awaiting Message 101:0 test1.rep1_RSSD
22 DSI EXEC Awaiting Command 102(1) test2.dbtest2
13 DSI Awaiting Command 102 test2.dbtest2
16 DIST Active 102 test2.dbtest2
19 SQT Awaiting Wakeup 102:1 DIST test2.dbtest2
10 SQM Awaiting Message 102:1 test2.dbtest2
9 SQM Awaiting Message 102:0 test2.dbtest2
REP AGENT Down test2.dbtest2
21 DSI EXEC Awaiting Command 103(1) test3.dbtest3
14 DSI Awaiting Command 103 test3.dbtest3
11 SQM Awaiting Message 103:0 test3.dbtest3
15 dSUB Active
6 dCM Awaiting Message
7 dAIO Awaiting Message
17 dREC Active dREC
18 dSTATS Active
32 USER Active sa
5 dALARM Awaiting Wakeup
1>
其中。。发现,“REP AGENT Down test2.dbtest2”这项没有启动,
为了找到原因,
我查看了,系统日志。。。如下
仔细看了一下,其中的一段错误提示:
“
W. 2010/08/29 10:02:51. WARNING #13061 DSI(102 test2.dbtest2) - eue(4684)
Server test2 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
W. 2010/08/29 10:02:51. WARNING #13061 DSI(103 test3.dbtest3) - eue(4684)
Server test3 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
”
指出,主库test2和目的库test3的排序顺序与复制服务的不一致,请问,如何进行修改呢?
当前,复制服务器、主库、目的库的排序顺序均设置为:“Dictionary order,case insensitive."
不知道还有什么地方要进行设置才可以一致!
造成状态可疑,是否就是因为这个排序不一致引起的呢?
请各位多多指教!
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. 5000 Hacienda Drive, Dublin, CA 94568, USA.'
I. 2010/08/29 10:02:51. Logging messages in file 'C:\Sybase\REP-12_5\install\rep1.log '.
I. 2010/08/29 10:02:51. Using interfaces file 'C:\Sybase\ini\sql.ini '.
I. 2010/08/29 10:02:51. Server name is 'rep1'.
I. 2010/08/29 10:02:51. SYSAM: Replication Server received a valid 'REP_SERVER' license.
I. 2010/08/29 10:02:51. Reading 'C:\Sybase\REP-12_5\install\rep1.cfg ' for configuration information.
I. 2010/08/29 10:02:51. Using the 'cp850' character set.
I. 2010/08/29 10:02:51. Using the 'us_english' language.
I. 2010/08/29 10:02:51. Using the 'binary' sort order.
I. 2010/08/29 10:02:51. Using the 'binary' unicode sort order.
I. 2010/08/29 10:02:51. Using server 'rep1' for an ID Server.
I. 2010/08/29 10:02:51. Using config file password for the ID user.
I. 2010/08/29 10:02:51. Using user 'rep1_id_user' for the ID Server.
I. 2010/08/29 10:02:51. Using config file maintenance password for the RSSD maint user.
I. 2010/08/29 10:02:51. RSSD maintenace user is 'rep1_RSSD_maint'.
I. 2010/08/29 10:02:51. Using config file password for the RSSD primary user.
I. 2010/08/29 10:02:51. RSSD primary user is 'rep1_RSSD_prim'.
I. 2010/08/29 10:02:51. RSSD database is 'rep1_RSSD'.
I. 2010/08/29 10:02:51. RSSD server is 'test1'.
I. 2010/08/29 10:02:51. Reading 'test1.rep1_RSSD..rs_config' for system configuration parameters.
I. 2010/08/29 10:02:51. Value of the 'memory_limit' config parameter is: 20 megabytes.
I. 2010/08/29 10:02:51. Maximum outbound connections allowed: 64.
I. 2010/08/29 10:02:51. System outbound connection fadeout time: '30'.
I. 2010/08/29 10:02:51. System table cache size: 100 rows.
I. 2010/08/29 10:02:51. Maximum number of Open Server threads allowed: 50.
I. 2010/08/29 10:02:51. Maximum number of Open Server mutexes allowed: 128.
I. 2010/08/29 10:02:51. Maximum number of incoming client connections allowed: 30.
I. 2010/08/29 10:02:51. Maximum number of Open Server message queues allowed: 178.
I. 2010/08/29 10:02:51. Maximum number of Open Server messages allowed: 45568.
I. 2010/08/29 10:02:51. Maximum number of stable queues allowed: 32.
I. 2010/08/29 10:02:51. Password encryption option: 0.
I. 2010/08/29 10:02:51. Use SSL service is set to 'off'.
I. 2010/08/29 10:02:51. Default for connection ha_failover is set to 'off',
I. 2010/08/29 10:02:51. Default directory service provider is: 'InterfacesDriver'.
I. 2010/08/29 10:02:51. System configuration complete.
I. 2010/08/29 10:02:51. Server using Open Server version Sybase Server-Library/12.5/P-EBF10092-10091/PC Intel/BUILD125-012/OPT/Wed Feb 27 11:13:05 2002
I. 2010/08/29 10:02:51. Server using Open Client version Sybase Client-Library/12.5/P-EBF10091/PC Intel/BUILD125-012/OPT/Wed Feb 27 11:13:05 2002
W. 2010/08/29 10:02:51. WARNING #13061 GLOBAL RS(GLOBAL RS) - eue(4684)
Server test1 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
I. 2010/08/29 10:02:51. Server site id is '16777317'.
I. 2010/08/29 10:02:51. Embedded database id is '101'.
I. 2010/08/29 10:02:51. The DSI thread for database 'test1.rep1_RSSD' is started.
I. 2010/08/29 10:02:51. The DSI thread for database 'test2.dbtest2' is started.
I. 2010/08/29 10:02:51. The DSI thread for database 'test3.dbtest3' is started.
I. 2010/08/29 10:02:51. Replication Server 'rep1' is started.
I. 2010/08/29 10:02:51. DIST for 'test2.dbtest2' is Starting
I. 2010/08/29 10:02:51. SQM starting: 102:0 test2.dbtest2
I. 2010/08/29 10:02:51. SQM starting: 101:0 test1.rep1_RSSD
I. 2010/08/29 10:02:51. SQM starting: 103:0 test3.dbtest3
I. 2010/08/29 10:02:51. SQM starting: 102:1 test2.dbtest2
W. 2010/08/29 10:02:51. WARNING #13061 DSI(102 test2.dbtest2) - eue(4684)
Server test2 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
W. 2010/08/29 10:02:51. WARNING #13061 DSI(103 test3.dbtest3) - eue(4684)
Server test3 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
作者: youwei 发布时间: 2010-08-29
修改复制点服务器的字符集,跟主服务器一致,可以解决问题,这是最简单有效的方式
作者: hobbylu 发布时间: 2010-08-30
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28