sybase数据库运行一段时间后，所有进程都不能连接数据库，只能重起sybase数据库。

billychxf

发现不能连接数据库，检查数据库进程：
PID USERNAME LWP PRI NICE  SIZE   RES STATE    TIME    CPU  COMMAND
1980 sybase    52  30    0 2016M 1997M cpu/0   19.2H 49.51% dataserver
1981 sybase    51   0    0 2016M 1997M run     17.8H 42.74% dataserver
发现占用CPU很高。用isql连接数据库超时。

数据库版本：Adaptive Server Enterprise/12.5.2/EBF 11791/P/Sun_svr4/OS 5.8/ase1252/1831/64-bit/FBO/Fri Apr  9 12:47:36 2004。
操作系统信息：SunOS ldims-xz 5.9 Generic_118558-09 sun4u sparc SUNW,Sun-Fire-V440

sybase interfaces：

ldims
        master tcp ether ldims-xz 4100
        query tcp ether ldims-xz 4100
        master tcp ether ldims-xz 6000
        query tcp ether ldims-xz 6000


ldims_TEXT
        master tcp ether ldims-xz 4101
        query tcp ether ldims-xz 4101


ws
        master tcp ether ldims-xz 8183
        query tcp ether ldims-xz 8183

ASE配置文件：
[Configuration Options]

[General Information]

[Backup/Recovery]
        recovery interval in minutes = DEFAULT
        print recovery information = DEFAULT
        tape retention in days = DEFAULT
        max concurrently recovered db = DEFAULT
        number of checkpoint tasks = DEFAULT

[Cache Manager]
        number of oam trips = DEFAULT
        number of index trips = DEFAULT
        memory alignment boundary = DEFAULT
        global async prefetch limit = DEFAULT
        global cache partition number = DEFAULT
        extended cache size = DEFAULT

[Named Cache:default data cache]
        cache size = 1536M
        cache status = default data cache
        cache replacement policy = DEFAULT
        local cache partition number = DEFAULT

[Meta-Data Caches]
        number of open databases = DEFAULT
        number of open objects = 15000
        open object spinlock ratio = DEFAULT
        number of open indexes = 3000
        open index hash spinlock ratio = DEFAULT
        open index spinlock ratio = DEFAULT
        partition groups = DEFAULT
        partition spinlock ratio = DEFAULT

[Disk I/O]
        disk i/o structures = DEFAULT
        number of large i/o buffers = DEFAULT
        page utilization percent = DEFAULT
        number of devices = 30
        disable disk mirroring = DEFAULT
        allow sql server async i/o = DEFAULT

[Languages]
        disable character set conversions = DEFAULT

[Unicode]
        enable unicode normalization = DEFAULT
        enable surrogate processing = DEFAULT
        enable unicode conversions = DEFAULT
        size of unilib cache = DEFAULT

[Network Communication]
        default network packet size = DEFAULT
        max network packet size = DEFAULT
        remote server pre-read packets = DEFAULT
        number of remote connections = 100
        number of remote logins = DEFAULT
        number of remote sites = DEFAULT
        max number network listeners = DEFAULT
        tcp no delay = DEFAULT
        send doneinproc tokens = DEFAULT
        allow sendmsg = DEFAULT
        syb_sendmsg port number = DEFAULT
        allow remote access = DEFAULT

[O/S Resources]
        max async i/os per engine = DEFAULT
        max async i/os per server = DEFAULT

[Parallel Query]
        number of worker processes = DEFAULT
        memory per worker process = DEFAULT
        max parallel degree = DEFAULT
        max scan parallel degree = DEFAULT

[Physical Resources]

[Physical Memory]
        max memory = 1468006
        additional network memory = DEFAULT
        shared memory starting address = DEFAULT
        allocate max shared memory = DEFAULT
        dynamic allocation on demand = DEFAULT
        lock shared memory = DEFAULT
        heap memory per user = DEFAULT

[Processors]
        max online engines = 2
        number of engines at startup = 2
        statement cache size = DEFAULT

[SQL Server Administration]
        procedure cache size = 72180
        default database size = DEFAULT
        identity burning set factor = DEFAULT
        allow nested triggers = DEFAULT
        allow updates to system tables = DEFAULT
        default fill factor percent = DEFAULT
        default exp_row_size percent = DEFAULT
        number of mailboxes = DEFAULT
        number of messages = DEFAULT
        number of alarms = DEFAULT
        number of pre-allocated extents = DEFAULT
        event buffers per engine = DEFAULT
        cpu accounting flush interval = DEFAULT
        i/o accounting flush interval = DEFAULT
        sql server clock tick length = DEFAULT
        runnable process search count = DEFAULT
        i/o polling process count = DEFAULT
        time slice = DEFAULT
        cpu grace time = DEFAULT
        number of sort buffers = DEFAULT
        size of auto identity column = DEFAULT
        identity grab size = DEFAULT
        housekeeper free write percent = DEFAULT
        enable housekeeper GC = DEFAULT
        allow resource limits = DEFAULT
        number of aux scan descriptors = DEFAULT
        SQL Perfmon Integration = DEFAULT
        allow backward scans = DEFAULT
        license information = DEFAULT
        enable sort-merge join and JTC = DEFAULT
        abstract plan load = DEFAULT
        abstract plan dump = DEFAULT
        abstract plan replace = DEFAULT
        abstract plan cache = DEFAULT
        text prefetch size = DEFAULT
        enable HA = DEFAULT
        number of histogram steps = DEFAULT
        sampling percent = DEFAULT
        i/o batch size = DEFAULT
        enable xml = DEFAULT
        enable webservices = DEFAULT
        enable job scheduler = DEFAULT
        job scheduler tasks = DEFAULT
        job scheduler interval = DEFAULT
        percent database for history = DEFAULT
        percent history free = DEFAULT
        percent database for output = DEFAULT
        percent output free = DEFAULT
        maximum job output = DEFAULT

[User Environment]
        number of user connections = 100
        stack size = 231424
        stack guard size = DEFAULT
        permission cache entries = DEFAULT
        user log cache size = DEFAULT
        user log cache spinlock ratio = DEFAULT
        messaging memory = DEFAULT
        enable real time messaging = DEFAULT
        histogram tuning factor = DEFAULT

[Lock Manager]
        number of locks = 100000
        deadlock checking period = DEFAULT
        lock spinlock ratio = DEFAULT
        lock address spinlock ratio = DEFAULT
        lock table spinlock ratio = DEFAULT
        lock hashtable size = DEFAULT
        lock scheme = DEFAULT
        lock wait period = DEFAULT
        read committed with lock = DEFAULT
        print deadlock information = DEFAULT
        deadlock retries = DEFAULT
        page lock promotion HWM = DEFAULT
        page lock promotion LWM = DEFAULT
        page lock promotion PCT = DEFAULT
        row lock promotion HWM = DEFAULT
        row lock promotion LWM = DEFAULT
        row lock promotion PCT = DEFAULT

[Security Related]
        systemwide password expiration = DEFAULT
        audit queue size = DEFAULT
        curread change w/ open cursors = DEFAULT
        allow procedure grouping = DEFAULT
        select on syscomments.text = DEFAULT
        auditing = DEFAULT
        current audit table = DEFAULT
        suspend audit when device full = DEFAULT
        enable row level access = DEFAULT
        check password for digit = DEFAULT
        minimum password length = DEFAULT
        maximum failed logins = DEFAULT
        enable ssl = DEFAULT
        unified login required = DEFAULT
        use security services = DEFAULT
        msg confidentiality reqd = DEFAULT
        msg integrity reqd = DEFAULT
        enable pam user auth = DEFAULT
        enable ldap user auth = DEFAULT
        secure default login = DEFAULT

[Extended Stored Procedure]
        esp unload dll = DEFAULT
        esp execution priority = DEFAULT
        esp execution stacksize = DEFAULT
        xp_cmdshell context = DEFAULT
        start mail session = DEFAULT

[Error Log]
        event logging = DEFAULT
        log audit logon success = DEFAULT
        log audit logon failure = DEFAULT
        event log computer name = DEFAULT

[Rep Agent Thread Administration]
        enable rep agent threads = DEFAULT

[Component Integration Services]
        enable cis = DEFAULT
        cis connect timeout = DEFAULT
        cis bulk insert batch size = DEFAULT
        max cis remote connections = DEFAULT
        cis packet size = DEFAULT
        cis cursor rows = DEFAULT
        enable snmp = DEFAULT
        enable file access = DEFAULT
        cis bulk insert array size = DEFAULT
        enable full-text search = DEFAULT
        cis rpc handling = DEFAULT

[Java Services]
        enable java = DEFAULT
        size of process object heap = DEFAULT
        size of shared class heap = DEFAULT
        size of global fixed heap = DEFAULT
        number of java sockets = DEFAULT
        enable enterprise java beans = DEFAULT

[DTM Administration]
        enable DTM = DEFAULT
        enable xact coordination = DEFAULT
        xact coordination interval = DEFAULT
        number of dtx participants = DEFAULT
        strict dtm enforcement = DEFAULT
        txn to pss ratio = DEFAULT
        dtm lock timeout period = DEFAULT
        dtm detach timeout period = DEFAULT

[Diagnostics]
        dump on conditions = DEFAULT
        maximum dump conditions = DEFAULT
        number of dump threads = DEFAULT
        number of ccbs = DEFAULT
        caps per ccb = DEFAULT
        average cap size = DEFAULT

[Monitoring]
        enable monitoring = DEFAULT
        sql text pipe active = DEFAULT
        sql text pipe max messages = DEFAULT
        plan text pipe active = DEFAULT
        plan text pipe max messages = DEFAULT
        statement pipe active = DEFAULT
        statement pipe max messages = DEFAULT
        errorlog pipe active = DEFAULT
        errorlog pipe max messages = DEFAULT
        deadlock pipe active = DEFAULT
        deadlock pipe max messages = DEFAULT
        wait event timing = DEFAULT
        process wait events = DEFAULT
        object lockwait timing = DEFAULT
        SQL batch capture = DEFAULT
        statement statistics active = DEFAULT
        per object statistics active = DEFAULT
        max SQL text monitored = DEFAULT
        performance monitoring option = DEFAULT

日志摘要文件详见附件。

麻烦各位高手帮忙定位一下原因。谢谢！

zhaoxh

1。该故障通过重启后能解决吗？
2。该故障反复出现吗？

billychxf

重启后能够解决问题，但是过段时间又会重现。

RS9000

看看你的日志错误信息，看看是不是需要升级补丁

jtyhyl

出现不能登陆数据库时错误日志中总是有很多1608错误出现，如何解决？？？网络是没有问题的，重启sybase后可以解决

echoaix

把cpu grace time 调为1000试试，cpu太紧张了吧

billychxf

日志里面不正常的地方主要是：
kernel secleanup:time to live expired  engine 2
不知道各位有没有遇见这个问题。
是不是我缺什么补丁啊？

billychxf

to：RS9000 (守望者)
请问我怎么判断应该安装什么补丁？

echoaix

CR 286098, which is fixed in the 12.5.0.2 release, is found on Solaris and characterized by engine hangs when pre-TDS5 clients send a cancel command. The pre-TDS5 cancel sends a SIGURG signal to the engine pid which is not handled correctly, and can cause engine hang.
打补丁吧

billychxf

应该装哪个补丁阿？CR 286098我没搜索到阿。