网站 › 『 Sybase IQ&RS 』 › IQ数据库启动错误

l5066113 发表于 2006-12-18 16:45:04

IQ数据库启动错误

<p>启动错误信息如下:</p><p>Starting server anly23 on ciisds at port 2648 (12/18 16:33:07)</p><p>Run Directory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : /home/sybiq/ciisanly<br/>Server Executable&nbsp;&nbsp; : /home/sybiq/ASIQ-12_6/bin/asiqsrv12<br/>Server Output Log&nbsp;&nbsp; : /home/sybiq/ASIQ-12_6/logfiles/anly23.078.srvlog<br/>Server Version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 12.6.0/ESD 6<br/>Open Client Version : 12.5.1/P-EBF12010 ESD #4<br/>User Parameters&nbsp;&nbsp;&nbsp;&nbsp; : <a href="mailto:'@ciisanly.cfg'">'@ciisanly.cfg'</a> 'ciisanly.db'<br/>Default Parameters&nbsp; : -gc 20 -gl all -gn 205 </p><p>I. 12/18 16:33:10.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Adaptive Server IQ<br/>I. 12/18 16:33:10.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Version 12.6<br/>I. 12/18 16:33:10.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (64bit mode)<br/>I. 12/18 16:33:10. Copyright 1992-2006 by Sybase, Inc. All rights reserved<br/>I. 12/18 16:33:10. <br/>I. 12/18 16:33:10. 14 physical processor(s) detected.<br/>I. 12/18 16:33:10. Running on AIX 3 5 00CF831F4<br/>I. 12/18 16:33:10. 49152K of memory used for caching<br/>I. 12/18 16:33:10. Minimum cache size: 49152K, maximum cache size: 49152K<br/>I. 12/18 16:33:10. Using a maximum page size of 4096 bytes<br/>I. 12/18 16:33:11. Starting database "ciisanly" (/home/sybiq/ciisanly/ciisanly.db) at Mon Dec 18 2006 16:33<br/>I. 12/18 16:33:11. Database recovery in progress<br/>I. 12/18 16:33:11.&nbsp;&nbsp;&nbsp;&nbsp; Last checkpoint at Mon Dec 18 2006 15:32<br/>I. 12/18 16:33:11.&nbsp;&nbsp;&nbsp;&nbsp; Checkpoint log...</p><p><br/>=============================================================<br/>IQ server starting with:<br/>&nbsp;&nbsp;&nbsp; 200 connections&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -gm )<br/>&nbsp;&nbsp;&nbsp;&nbsp; 38 cmd resources&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ( -iqgovern )<br/>&nbsp;&nbsp; 1145 threads&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (&nbsp;&nbsp;&nbsp;&nbsp; -iqmt )<br/>&nbsp;&nbsp; 1000 Kb thread stack size&nbsp;&nbsp; (&nbsp;&nbsp; -iqtss&nbsp; )<br/>&nbsp; 1145000 Kb thread memory size ( -iqmt * -iqtss )<br/>&nbsp;&nbsp;&nbsp;&nbsp; 14 IQ number of cpus&nbsp; ( -iqnumbercpus )<br/>=============================================================</p><p>&nbsp;<br/>&nbsp;<br/>**************************************************<br/>***&nbsp;&nbsp; Sybase IQ Abort:<br/>***&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; From:&nbsp; s_db.cxx:2500<br/>***&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PID: 553918<br/>***&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Exception Location: 0x165fa8470<br/>***&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Error ID: 533,&nbsp; Exception Type: 32937796<br/>***&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thread: 346699&nbsp; (TID: 1143, Original TID: 1143)<br/>***&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Error #: 2,&nbsp; O/S Error #: 0<br/>**************************************************<br/>&nbsp;<br/>Wrapping iqmsg: Disabled.<br/>DBSPAWN ERROR:&nbsp; -80<br/>Unable to start database server</p><p>Server failed to start (Return Code 1)</p>

ehxz 发表于 2006-12-18 20:02:26

之前发生过什么？

l5066113 发表于 2006-12-19 20:57:00

<p>问题已经找到，是数据库物理磁盘空间满掉了。</p><p>同样感谢<strong><font color="#ff0000">ehxz！</font></strong></p>

标榜天下 发表于 2010-10-25 16:52:17

这个问题很经典。。一般都是日志文件或数据存储文件溢出会报这个错。学习了

查看完整版本: IQ数据库启动错误