问题描述:
00:00000:00001:2007/09/15 10:56:14.76 server Completed REDO pass for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.76 server Recovery of database 'ge' will undo incomplete nested top actions.
00:00000:00001:2007/09/15 10:56:14.76 server Started recovery checkpoint for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.79 server Completed recovery checkpoint for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.79 server Started filling free space info for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.80 server Completed filling free space info for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.81 server Started cleaning up the default data cache for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.83 server Completed cleaning up the default data cache for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.83 server Checking external objects.
00:00000:00001:2007/09/15 10:56:14.83 server Space available in the log segment has fallen critically low in database 'ge'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
00:00000:00001:2007/09/15 10:56:14.83 server Error: 1105, Severity: 17, State: 4
00:00000:00001:2007/09/15 10:56:14.83 server Can't allocate space for object 'syslogs' in database 'ge' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:00000:00010:2007/09/15 10:56:14.84 server Error: 950, Severity: 14, State: 1
00:00000:00010:2007/09/15 10:56:14.84 server Database 'ge' is currently offline. Please wait and try your command again later.
00:00000:00010:2007/09/15 10:56:14.84 server Threshold task could not use database 6, and so cannot execute the threshold procedure for segment 2, free space 153616.
00:00000:00010:2007/09/15 10:56:14.84 server Failed to execute the threshold procedure for database 6, segment 2, free space 153616.
00:00000:00001:2007/09/15 10:56:14.84 server SQL Server could not bring database 'ge' online.
00:00000:00001:2007/09/15 10:56:14.84 server Recovery has restored the value of 'local async prefetch limit' for '16K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2007/09/15 10:56:14.84 server Recovery has restored the value of 'local async prefetch limit' for '2K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2007/09/15 10:56:14.88 server Recovery has restored the original size for '16K' pool and '2K' pool in 'default data cache'.
解决方法:
进入isql
1> use master
2> go
1> dump tran ge with no_log
2> go
1> shutdown
2> go
日志中信息如下:
00:00000:00011:2007/09/15 10:59:40.13 server WARNING: ***************************
00:00000:00011:2007/09/15 10:59:40.13 server Attempt by user 1 to dump xact on db ge with NO_LOG
sybase@CHQWEB:/sybase/ASE-12_5/install> 00:00000:00011:2007/09/15 11:01:05.62 server Attempt by user 1 to dump xact on db ge with NO_LOG was successful
00:00000:00011:2007/09/15 11:01:05.63 server WARNING: ***************************
sybase@CHQWEB:/sybase/ASE-12_5/install> 00:00000:00011:2007/09/15 11:02:30.00 server SQL Server shutdown by request.
00:00000:00011:2007/09/15 11:02:30.00 kernel ueshutdown: exiting
然后重新启动数据库即可
参考文章:http://hi.baidu.com/woshi123/blog/item/2328c31166b4c2c7a6ef3f37.html
系统提示Can"t allocate space for object "syslogs" in database 该如何处理?
2007-05-21 21:46
系统提示Can"t allocate space for object "syslogs" in database "cwbase?" because the "logsegment" segment is full……该如何处理?
上面的提示指数据库的日志已满,可用系统管理员按如下方法解决: (1)如果是 master 库: dump tran master with no_log (2)如果是用户数据库(如:cwbase1): 可以等待自动清理,过5分钟后,再重启SQLSERVER;否则: 用WISQL连接该帐套数据库后执行以下语句: use master go sp_dboption cwbase1,"trunc. log on chkpt.",false go checkpoint go dump tran cwbase1 with no_log go sp_dboption cwbase1,"trunc. log on chkpt.",true go checkpoint go
第二套帐依次类推,将1改成2、3、4、5……
|
分享到:
相关推荐
If the table is a heap (in other words, it has no clustered index), the bookmark is a RID, which is an actual row locator in the form File#:Page#:Slot#. Finding Rows with a NC Index on a Heap ...
More complex inline functions may also be put in a .h file for the convenience of the implementer and callers, though if this makes the .h file too unwieldy you can instead put that code in a ...
The disadvantage to running in-process is that DLL has access to the process address space and can potentially cause problems. Out of Process To run outside the calling processes address space. OLEDB...
Basically what it means is if you created your code in such a way that you need to instantiate a prefab at runtime (regardless of whether an instance of it is in the scene already or not) then Unity ...
//Check if the Bye command has indeed come from the user/IP with which we have //a call established. This is used to prevent other users from sending a Bye, which //would otherwise end the call. ...
And feel free to ask questions on the mailing list if you encounter any problems with the software! I am sure it is far from perfect... Downloads To install manually the JAR files, obtain the ...
structure data from PDB files can now be used, and are stored in a database for lookup later dissect structures form can now show a list of known structures (pdb, mono, ...) Added a "revert to saved ...
// This Folder is an mounted device (e.g. flash card) } // Search for the next storage card. bContinue = FindNextFile(hFlashCard, lpwfdFlashCard); //bContinue = FindNextFlashCard (hFlashCard,...
// All of the EXIF properties will return strings to display in the control. // Some of the properties require additional formatting or massaging // of the data once it is returned. Those ...
a "fence" immediately around the requested payload with a known value like 0xCCDEADCC, so that you can check if it has been changed when the block is freed. the size of the block a checksum for the ...
If this is your first time learning C,this book is written for you. In fact,in writing this book I assume that the readers have no previous programming experience. Of course,it’s always a big plus if...
export CODESIGN_ALLOCATE=/Applications/Xcode.app/Contents/Developer/Platforms/iPhoneOS.platform/Developer/usr/bin/codesign_allocate if [ "${PLATFORM_NAME}" == "iphoneos" ] || [ "${PLATFORM_NAME}" == ...
if (n==0) { //Can't take anything? //Wait until there is enough data in the buffer. This only happens when the data feed //rate is too low, and shouldn't normally be needed! // printf(...
When you use Unity's built-in default coroutines you will have to be very careful about how you use them or else they will allocate memory that the garbage collector later has to clean up. This can ...
list (if present) is now obtained and also checked for an ID match. Implemented additional support for the PCI _ADR execution: upsearch until a device scope is found before executing _ADR. This ...
When you use Unity's built-in default coroutines you will have to be very careful about how you use them or else they will allocate memory that the garbage collector later has to clean up. This can ...
Developer and maintenance person of RDBMS... Because DBQueryAnalyzer.ex_ or DBQueryAnalyzer.exe has no destroy or danger to your computer and has no infection. So They are not belong to the virus at all.
When you use Unity's built-in default coroutines you will have to be very careful about how you use them or else they will allocate memory that the garbage collector later has to clean up. This can ...
// you can get the three params from pulist output in target system. // /* 因为登陆的域名和用户名是明文存储在winlogon进程里的,而PasswordReminder是限定了查找本进程用户的密码 (L"USERNAME", UserName, ...
jtoml.zip,用于tomltoml的java解析器用于java的解析器