数据库无法连接，救命，在线等呀！！！

橡皮鱼鱼

做了大量清除数据工作导致数据库无响应，现关闭清数据程序，可是无法ISQL进入，ISQL报错如下：
$ isql -Usa -P
CT-LIBRARY error:
        ct_connect(): network packet layer: internal net library error: Net-lib operation timed out


用sybase centrol也报如上错误，请问有什么办法解决吗，估计是LOG满了导致！

橡皮鱼鱼

01:00000:00080:2006/06/07 09:00:52.17 server  Error: 1608, Severity: 18, State: 4
01:00000:00080:2006/06/07 09:00:52.17 server  A client process exited abnormally, or a network error was encountered. Unless o
ther errors occurred, continue processing normally.
01:00000:00061:2006/06/07 09:02:46.87 server  Space available in the log segment has fallen critically low in database 'store'
.  All future modifications to this database will be suspended until the log is successfully dumped and space becomes availabl
e.
01:00000:00006:2006/06/07 09:02:46.95 server  Error: 1105, Severity: 17, State: 4
01:00000:00006:2006/06/07 09:02:46.95 server  Can't allocate space for object 'syslogs' in database 'store' because 'logsegmen
t' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DAT
ABASE or sp_extendsegment to increase size of the segment.
00:00000:00040:2006/06/07 09:02:47.01 server  Error: 2812, Severity: 16, State: 5
00:00000:00040:2006/06/07 09:02:47.01 server  Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use
sp_help to check whether the object exists (sp_help may produce lots of output).
00:00000:00005:2006/06/07 09:02:50.82 server  4 task(s) are sleeping waiting for space to become available in the log segment
for database store.
01:00000:00006:2006/06/07 09:02:52.93 server  Error: 1105, Severity: 17, State: 4
01:00000:00006:2006/06/07 09:02:52.93 server  Can't allocate space for object 'syslogs' in database 'store' because 'logsegmen
t' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DAT
ABASE or sp_extendsegment to increase size of the segment.
00:00000:00086:2006/06/07 09:03:48.14 server  Error: 1608, Severity: 18, State: 4
00:00000:00086:2006/06/07 09:03:48.14 server  A client process exited abnormally, or a network error was encountered. Unless o
ther errors occurred, continue processing normally.
00:00000:00005:2006/06/07 09:03:50.84 server  6 task(s) are sleeping waiting for space to become available in the log segment
for database store.
00:00000:00005:2006/06/07 09:04:50.84 server  10 task(s) are sleeping waiting for space to become available in the log segment
for database store.
00:00000:00042:2006/06/07 09:05:15.63 server  Illegal attempt to rollback transaction (xactname '$user_transaction') that has
already committed in database 'store', spid 42.
00:00000:00042:2006/06/07 09:05:15.63 kernel  Cannot send, host process disconnected: 170060 1196 spid: 42
00:00000:00042:2006/06/07 09:05:15.63 server  Error: 1608, Severity: 18, State: 4
00:00000:00042:2006/06/07 09:05:15.63 server  A client process exited abnormally, or a network error was encountered. Unless o
ther errors occurred, continue processing normally.
00:00000:00042:2006/06/07 09:05:45.83 kernel  timeslice -301, current process infected
00:00000:00042:2006/06/07 09:05:45.92 kernel  ************************************
00:00000:00042:2006/06/07 09:05:45.99 kernel  pc: 0x00000001002fbef4 .pcstkwalk+0x88()
00:00000:00042:2006/06/07 09:05:45.99 kernel  pc: 0x00000001002fc5ac .ucstkgentrace+0x238()
00:00000:00042:2006/06/07 09:05:45.99 kernel  pc: 0x00000001002fb318 .ucbacktrace+0x78()
00:00000:00042:2006/06/07 09:05:46.00 kernel  pc: 0x0000000100236228 .terminate_process[3]+0x12c()
00:00000:00042:2006/06/07 09:05:46.01 kernel  pc: 0x0000000100395a30 .kaclkintr[10]+0x16c()
00:00000:00042:2006/06/07 09:05:46.01 kernel  pc: 0x0000000000000001 ()
00:00000:00042:2006/06/07 09:05:46.01 kernel  pc: 0x000000010003abf8 .s_pop+0x34()
00:00000:00042:2006/06/07 09:05:46.02 kernel  pc: 0x000000010012cdc8 .s_cleanframe[1]+0xc8()
00:00000:00042:2006/06/07 09:05:46.02 kernel  pc: 0x00000001001344f8 .clean_process[1]+0x40()
00:00000:00042:2006/06/07 09:05:46.02 kernel  [Handler pc: 0x000000010022bffc .cleanerr installed by the following function:-]
00:00000:00042:2006/06/07 09:05:46.02 kernel  [Handler pc: 0x00000001001afd94 .hdl_backout installed by the following function
:-]
00:00000:00042:2006/06/07 09:05:46.02 kernel  pc: 0x0000000100136c38 .kill_proc+0x224()
00:00000:00042:2006/06/07 09:05:46.02 kernel  pc: 0x0000000100137268 .terminate_process[1]+0x320()
00:00000:00042:2006/06/07 09:05:46.02 kernel  pc: 0x000000010013c084 .quitfn+0x44()
00:00000:00042:2006/06/07 09:05:46.02 kernel  pc: 0x000000010022d2f4 .conn_hdlr_reg_cleanup[2]+0x124()
00:00000:00042:2006/06/07 09:05:46.02 kernel  [Handler pc: 0x00000001001afd94 .hdl_backout installed by the following function
:-]
00:00000:00042:2006/06/07 09:05:46.02 kernel  [Handler pc: 0x00000001004b76f0 .ut_handle installed by the following function:-
]
00:00000:00042:2006/06/07 09:05:46.02 kernel  [Handler pc: 0x00000001004b76f0 .ut_handle installed by the following function:-
]
00:00000:00042:2006/06/07 09:05:46.02 kernel  pc: 0x0000000100039e04 .conn_hdlr[1]+0x8()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000100013fc0 +0x1c()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000100013f9c .kpinitproc[1]+0x1c()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  pc: 0x0000000000000000 ()
00:00000:00042:2006/06/07 09:05:46.03 kernel  end of stack trace, spid 42, kpid 458424388, suid 1
00:00000:00067:2006/06/07 09:05:46.04 server  Error: 1608, Severity: 18, State: 4
00:00000:00067:2006/06/07 09:05:46.04 server  A client process exited abnormally, or a network error was encountered. Unless o
ther errors occurred, continue processing normally.
01:00000:00073:2006/06/07 09:05:47.77 server  Illegal attempt to rollback transaction (xactname '$ins') that has already commi
tted in database 'store', spid 73.
00:00000:00005:2006/06/07 09:05:50.82 server  14 task(s) are sleeping waiting for space to become available in the log segment
for database store.
00:00000:00041:2006/06/07 09:05:55.29 kernel  Cannot send, host process disconnected:  1344 spid: 41
00:00000:00041:2006/06/07 09:05:55.29 server  Error: 1608, Severity: 18, State: 4
00:00000:00041:2006/06/07 09:05:55.29 server  A client process exited abnormally, or a network error was encountered. Unless o
ther errors occurred, continue processing normally.
01:00000:00073:2006/06/07 09:06:17.96 kernel  timeslice -301, current process infected
01:00000:00073:2006/06/07 09:06:17.96 kernel  ************************************
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x00000001002fbef4 .pcstkwalk+0x88()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x00000001002fc5ac .ucstkgentrace+0x238()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x00000001002fb318 .ucbacktrace+0x78()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000100236228 .terminate_process[3]+0x12c()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000100395a30 .kaclkintr[10]+0x16c()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000100040adc .lm_internal_ctxchain_release[8]+0x10()
01:00000:00073:2006/06/07 09:06:17.98 kernel  [Handler pc: 0x000000010022bffc .cleanerr installed by the following function:-]
01:00000:00073:2006/06/07 09:06:17.98 kernel  [Handler pc: 0x00000001001afd94 .hdl_backout installed by the following function
:-]
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000100136c4c .kill_proc+0x238()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000100137268 .terminate_process[1]+0x320()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x000000010013c084 .quitfn+0x44()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x000000010022eec8 .ussflush[3]+0x21c()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000100039c28 .usseom+0xd0()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x000000010003a130 .conn_hdlr_reg_cleanup+0xac()
01:00000:00073:2006/06/07 09:06:17.98 kernel  [Handler pc: 0x00000001001afd94 .hdl_backout installed by the following function
:-]
01:00000:00073:2006/06/07 09:06:17.98 kernel  [Handler pc: 0x00000001004b76f0 .ut_handle installed by the following function:-
]
01:00000:00073:2006/06/07 09:06:17.98 kernel  [Handler pc: 0x00000001004b76f0 .ut_handle installed by the following function:-
]
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000100039e04 .conn_hdlr[1]+0x8()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000100013fc0 +0x1c()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000100013f9c .kpinitproc[1]+0x1c()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  pc: 0x0000000000000000 ()
01:00000:00073:2006/06/07 09:06:17.98 kernel  end of stack trace, spid 73, kpid 458031150, suid 1
01:00000:00010:2006/06/07 09:06:48.27 kernel  timeslice -301, current process infected
01:00000:00010:2006/06/07 09:06:48.27 kernel  Spinlocks held by  kpid 851981

01:00000:00010:2006/06/07 09:06:48.27 kernel  Spinlock Kernel->kpprocspin[i] at address 0000000160408300 owned by 851981
01:00000:00010:2006/06/07 09:06:48.27 kernel  End of spinlock display.
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x00000001002fbef4 .pcstkwalk+0x88()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x00000001002fc5ac .ucstkgentrace+0x238()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x00000001002fb318 .ucbacktrace+0x78()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x000000010023612c .terminate_process[3]+0x30()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000100395a30 .kaclkintr[10]+0x16c()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000100119ae4 .listener_checkagain[1]+0xec()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000100144ffc .ckpt_process_dbs[5]+0xac()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000100013fc0 +0x1c()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000100013f9c .kpinitproc[1]+0x1c()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  pc: 0x0000000000000000 ()
01:00000:00010:2006/06/07 09:06:48.27 kernel  end of stack trace, spid 10, kpid 851981, suid 0
01:00000:00010:2006/06/07 09:06:48.27 kernel  ueshutdown: exiting

1017of

if you run your ASE on unix platform,follow these commands
ps -ef | grep dataserver
env | grep DS
dataserver -v

橡皮鱼鱼

$ ps -ef | grep dataserver
    root 155780 200802 120   Jan 23      - 20833:52 /opt/sybase/ASE-12_5/bin/dat
aserver -d/opt/sybase/data/master.dat -e/opt/sybase/ASE-12_5/install/ST17.log -c
/opt/sybase/ASE-12_5/ST17.cfg -M/opt/sybase/ASE-12_5 -sST17
$ env | grep DS
DSQUERY=ST17
$ dataserver -v
Adaptive Server Enterprise/12.5.1/EBF 11562 ESD#1/P/RS6000/AIX 5.1/ase1251/1831/
64-bit/FBO/Sat Nov 22 01:51:23 2003

Confidential property of Sybase, Inc.
Copyright 1987, 2003
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. One Sybase Drive, Dublin, CA 94568, USA

1017of

try isql -Usa -SST17 now.if fail,provider your errorlog