2008年7月19日星期六

SYBASE复制服务器报错,不能同步了.怎么办??

isql -Usa -P -SRS126
1> admin who_is_down
2> go
Spid Name State Info
---- ---------- -------------------- ----------------------------------------
DIST Down 102 ds1.db1
SQT Down 102:1 DIST ds1.db1
SQM Down 102:1 ds1.db1
REP AGENT Down SYBASE.fydb
DSI EXEC Down 105(1) SYBREP.fydb
DSI Down 105 SYBREP.fydb
1> admin health
2> go
Mode Quiesce Status
---------------- -------- --------
NORMAL TRUE SUSPECT
另外SYBASE系统日志有另一个报错,跟Sybase Central有关
00:00000:00011:2006/10/20 14:40:08.33 server There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure SQL Server with more user connections.
第一次SYBASE central可以连的,现在连就老报以上这个错
0:00000:00026:2006/10/19 16:43:01.93 server Error 1204, Severity 17, State 2 occurred for User 'RS126_RSSD_prim'. Client IP address is '192.168.5.8.



--------------------------------------------------------------------------------
1> admin who_is_down
2> go
Spid Name State Info
---- ---------- -------------------- ----------------------------------------
DIST Down 102 ds1.db1
SQT Down 102:1 DIST ds1.db1
SQM Down 102:1 ds1.db1
REP AGENT Down SYBASE.fydb
DSI EXEC Down 105(1) SYBREP.fydb
DSI Down 105 SYBREP.fydb
昨天用了以下命令就可以了,今天却不行了.....怎么办啊????
1> resume connection to SYBREP.fydb skip tran
2> go
Msg 15467, Level 12, State 0:
Server 'RS126':
Stable queue '102:1' is down. Please resume the stable queue before executing
this command.

--------------------------------------------------------------------------------
重新启动了两个数据库sybrep,rs126...问题有了新的进展...看看下面的状态报告
$ isql -Usa -P -SRS126
1> admin who
2> go
Spid Name State Info
---- ---------- -------------------- ----------------------------------------
DIST Awaiting Wakeup(之前这里是DOWN的) 102 ds1.db1
SQT Awaiting Wakeup(之前这里是DOWN的) 102:1 DIST ds1.db1
SQM Awaiting Message(之前这里是DOWN的) 102:1 ds1.db1
9 SQM Awaiting Message 102:0 ds1.db1
21 DSI EXEC Awaiting Command 103(1) SYBASE.fydb
11 DSI Awaiting Message 103 SYBASE.fydb
REP AGENT Down SYBASE.fydb
19 DSI EXEC Awaiting Command 101(1) SYBREP.RS126_RSSD
12 DSI Awaiting Message 101 SYBREP.RS126_RSSD
SQM Awaiting Message 101:0 SYBREP.RS126_RSSD
DSI EXEC Down 105(1) SYBREP.fydb
DSI Down 105 SYBREP.fydb
14 dSUB Sleeping
6 dCM Awaiting Message
7 dAIO Awaiting Message
16 dREC Sleeping dREC
17 dSTATS Sleeping
103 USER Active sa
5 dALARM Awaiting Wakeup

--------------------------------------------------------------------------------
用户连接数不够了,要修改ASE的用户连接数

--------------------------------------------------------------------------------

数据库重启后,连接数的问题已经解决了..数据开始可以同步.但过一会又不行了,有没有碰到类似情况的!

--------------------------------------------------------------------------------
又不行了是什么错误呢?

没有评论: