Can't allocate space for object 'syslogs' in database 'ge' because 'logsegment' segment is full/has no free extents. If you ran

最新推荐文章于 2015-07-27 16:51:50 发布
最新推荐文章于 2015-07-27 16:51:50 发布
阅读量8.1k 收藏 1
点赞数
分类专栏： Sybase 文章标签： database object server sql server sybase sqlserver
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zwhfyy/article/details/1786097
版权

 问题描述：
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……

 

 

zwhfyy
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
syslog可能引起得问题_记录SysLog使用碰到的问题
weixin_39781930的博客
12-20 476
环境：nutz 1.r.62 JDK1.8 Tomcat8.5问题描述：使用Syslog记录系统日志(req.getParameter("xxx"))，发现通过forward转发的请求，在SysLog中会报错，信息如下：org.nutz.lang.InvokingException: Fail to invoke [org.apache.catalina.core.ApplicationHttpR...
Redis HyperLogLog问题
sinat_27016095的博客
04-19 258
不管存储的内容是什么，在 Redis 中每个HyperLogLog键占用的内容都是 12K，理论存储近似接近 2^64 个值。 这是一个基于基数估计的算法，只能比较准确的估算出基数，可以使用少量固定的内存去存储并识别集合中的唯一元素。但是这个估算的基数并不一定准确，是一个带有 0.81% 标准错误（standard error）的近似值。但是，也正是因为只有 12K 的存储空间，所以，它并不实际存储数据的内容。 HyperLogLog本质上来源于生活中一个小的发现，假设你抛了很多次硬币，你告诉在这次抛硬币
Can't allocate space for object 'syslogs' in database:Sybase
Web开发Q&A
11-27 1658
使用Sybase时候，遇到下面的错误： Can't allocate space for object 'syslogs' in database 'master' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction l
Can't allocate space for object 'syslogs' in database 'ge' because 'logsegment' segment is full/has ...
alex的博客
09-15 484
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
SYbase解决Can't allocate space for object 'syslogs'错误
li153069252的专栏
07-15 2613
Can't allocate space for object 'syslogs' in database 'master' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use AL
Could not allocate space for object in database because the filegroup is full
我的学习成长日记
09-18 4150
今天遇到了这个问题。但是data filesuozai
SYBASE 12.5 维护手册 5. 灾难恢复篇
Alvin-He的专栏
12-09 8754
5. 灾难恢复篇    5.1 数据库服务不能启动        5.1.1 如何查找数据库启动失败原因 在实际环境中，数据库Server无法启动的原因很多，本文仅列出了几种常见的情况，供您参考。 首先，应检查Server的日志文件。不同版本缺省的日志文件如下（其中为Sybase Server的名称： UNIX: 11.0*: $SYBASE/install/errorlog 11
large-object-allocation.rar_What Is What Was
09-21
Allocate a very large object that is guaranteed to overflow the instance_size field in the map resulting in an object that is smaller than what was called for.
dev_addr_lists.rar_If...
09-23
// Address is free, allocate it. } ``` 这里的`find_address_in_list()`函数会遍历上述提到的数据结构，查找`new_addr`是否存在于列表中。如果找到，说明地址已被使用，程序可能需要抛出错误或提示用户；否则，...
cvmx-fpa.rar_Free!_cvmx-fpa.h
09-19
《Free! CVMX-FPA：硬件自由池分配器的支持库》 在计算机科学和IT领域，内存管理是一项至关重要的任务，特别是在嵌入式系统和高性能计算中。OCTEON SDK提供了一套完整的工具和库，使得开发者能够有效地利用硬件资源...
Alloc_src1[1].zip_Alloc_src1_This Just In.._disk_memory test
09-23
Sometimes it is very helpful to test your applications in extreme situations like low resources, full hard disk, or low memory conditions. This tool covers just the last - memory. It allows you to ...
Unit 2　What is happiness to you作业题及答案解析6份2精选.docx
09-25
- 不努力工作，你就会失败：You will fail if you don't work hard. - 无论从哪一方面看，这个局面都很尴尬：The situation is awkward from every aspect. - 我不确定他来还是不来：I’m uncertain whether he ...
Sybase ASE:Can't allocate space for object in database 'tempdb' because 'default' segment is full
wengyupeng 蜗牛一步一步向前。。。
07-27 3879
Sybase ASE:Can't allocate space for object in database 'tempdb' because 'default' segment is full
清空数据库日志
u014230987的专栏
10-18 540
原址：http://blog.csdn.net/paoluo/article/details/1524043
ASE Can't allocate space for object 'syslogs' in database 'WEN' because 'logsegment' segment is full
wengyupeng 蜗牛一步一步向前。。。
06-23 2080
1、问题：  server  Can't allocate space for object 'syslogs' in database 'WEN' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. 
用Winhttp写一个POST https://sellercentral.amazon.com.au/ap/signin 的自定义函数，参数有请求头和请求数据，return响应头和响应内容
最新发布
06-01
好的，我可以帮你编写一个Winhttp的POST请求函数。以下是示例代码： ```c++ #include <windows.h> #include <winhttp.h> #include <iostream> #include <string> #pragma comment(lib, "winhttp.lib") std::string postRequest(std::string url, std::string headers, std::string postData) { HINTERNET hSession = NULL, hConnect = NULL, hRequest = NULL; DWORD dwSize = 0; DWORD dwDownloaded = 0; LPSTR pszOutBuffer = NULL; std::string response; // Initialize WinHTTP. hSession = WinHttpOpen(L"WinHTTP Example/1.0", WINHTTP_ACCESS_TYPE_DEFAULT_PROXY, WINHTTP_NO_PROXY_NAME, WINHTTP_NO_PROXY_BYPASS, 0); if (!hSession) { goto cleanup; } // Specify an HTTP server. hConnect = WinHttpConnect(hSession, L"sellercentral.amazon.com.au", INTERNET_DEFAULT_HTTPS_PORT, 0); if (!hConnect) { goto cleanup; } // Create an HTTP request handle. hRequest = WinHttpOpenRequest(hConnect, L"POST", L"/ap/signin", NULL, WINHTTP_NO_REFERER, WINHTTP_DEFAULT_ACCEPT_TYPES, WINHTTP_FLAG_SECURE); if (!hRequest) { goto cleanup; } // Add request headers. if (!WinHttpAddRequestHeaders(hRequest, headers.c_str(), headers.length(), WINHTTP_ADDREQ_FLAG_ADD)) { goto cleanup; } // Send a request. if (!WinHttpSendRequest(hRequest, WINHTTP_NO_ADDITIONAL_HEADERS, 0, (LPVOID)postData.c_str(), postData.length(), postData.length(), 0)) { goto cleanup; } // End the request. if (!WinHttpReceiveResponse(hRequest, NULL)) { goto cleanup; } // Query headers size. if (!WinHttpQueryHeaders(hRequest, WINHTTP_QUERY_RAW_HEADERS_CRLF, WINHTTP_HEADER_NAME_BY_INDEX, NULL, &dwSize, WINHTTP_NO_HEADER_INDEX)) { goto cleanup; } else { // Allocate memory for the buffer. pszOutBuffer = new char[dwSize]; if (!pszOutBuffer) { goto cleanup; } // Read the headers. if (!WinHttpQueryHeaders(hRequest, WINHTTP_QUERY_RAW_HEADERS_CRLF, WINHTTP_HEADER_NAME_BY_INDEX, pszOutBuffer, &dwSize, WINHTTP_NO_HEADER_INDEX)) { goto cleanup; } else { response.append(pszOutBuffer); response.append("\r\n"); } } // Read the response. do { dwSize = 0; if (!WinHttpQueryDataAvailable(hRequest, &dwSize)) { goto cleanup; } if (dwSize == 0) { break; } // Allocate space for the buffer. pszOutBuffer = new char[dwSize + 1]; if (!pszOutBuffer) { goto cleanup; } // Read the data. ZeroMemory(pszOutBuffer, dwSize + 1); if (!WinHttpReadData(hRequest, (LPVOID)pszOutBuffer, dwSize, &dwDownloaded)) { goto cleanup; } // Append the response to the buffer. response.append(pszOutBuffer); // Free the memory allocated to the buffer. delete[] pszOutBuffer; } while (dwSize > 0); cleanup: // Clean up the resources. if (hRequest) WinHttpCloseHandle(hRequest); if (hConnect) WinHttpCloseHandle(hConnect); if (hSession) WinHttpCloseHandle(hSession); if (pszOutBuffer) delete[] pszOutBuffer; return response; } ``` 这个函数接受三个参数： - `url`：请求的URL地址，这里是`https://sellercentral.amazon.com.au/ap/signin`。 - `headers`：请求头，可以自行构造需要的请求头。 - `postData`：请求数据，可以自行构造需要POST的数据。 函数返回的是一个字符串，其中包含了响应头和响应内容。你可以使用这个函数来向指定URL发送POST请求，并获取响应。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值