生活的内容不全是工作,工作只是生活的一部分;享受生活,热爱工作!
分类: Sybase
2014-06-10 16:19:26
最近有一个用户,从IQ 集群数据库的备份恢复成功后,启动时报以下错误:
start_iq @idspiqdb.cfg -iqmpx_sn 1 -iqmpx_ov 1 -iqnotemp 100000 idspiqdb.db
Starting server idspiqdb_test on HAP-ASE-A99 at port 6666 (06/09 08:25:35)
I. 06/09 08:25:37. Sybase IQ
I. 06/09 08:25:37. Version 15.2
I. 06/09 08:25:37. (64bit mode)
I. 06/09 08:25:37. Copyright 1992-2010 by Sybase, Inc. All rights reserved
I. 06/09 08:25:37.
I. 06/09 08:25:37. 16 physical processor(s) detected.
I. 06/09 08:25:37. Maximum number of physical processors the server will use: 16
I. 06/09 08:25:37. Running Linux 3.0.13-0.27-default #1 SMP Wed Feb 15 13:33:49 UTC 2012 (d73692b) on X86_64
I. 06/09 08:25:37. Server built for X86_64 processor architecture
E. 06/09 08:25:37. Note: database page size is smaller than the cache
page size, resulting in inefficient use of memory.
I. 06/09 08:25:37. 1048576K of memory used for caching
I. 06/09 08:25:37. Minimum cache size: 1048576K, maximum cache size: 2097152K
I. 06/09 08:25:37. Using a maximum page size of 16384 bytes
=============================================================
IQ server starting with:
100 connections ( -gm )
42 cmd resources ( -iqgovern )
945 threads ( -iqmt )
1024 Kb thread stack size ( -iqtss )
967680 Kb thread memory size ( -iqmt * -iqtss )
16 IQ number of cpus ( -iqnumbercpus )
512 MB maximum size of IQMSG file ( -iqmsgsz )
4 copies of IQMSG file archives ( -iqmsgnum )
=============================================================
I. 06/09 08:25:37. Starting database "idspiqdb" (/sybiq/idspiq/idspiqdb.db) at Mon Jun 09 2014 08:25
E. 06/09 09:02:55. Error: Disk is or will be full on I/O to or allocation of file /sybiq/idspiq/idspiqdb_test_temporary.iqtmp
-- (hos_bion.cxx 182)
E. 06/09 09:02:55. Disk is or will be full on I/O to or allocation of file /sybiq/idspiq/idspiqdb_test_temporary.iqtmp
-- (hos_bion.cxx 182)
I. 06/09 09:02:55. Database server shutdown due to startup error
I. 06/09 09:02:55. Database server stopped at Mon Jun 09 2014 09:02
DBSPAWN ERROR: -82
Unable to start specified database: autostarting database failed
Note: database page size is smaller than the cache Error: Disk is or will be full on I/O to or allocation of file /sybiq/idspiq/idspiqdb_test_temporary.iqtmp Disk is or will be full on I/O to or allocation of file /sybiq/idspiq/idspiqdb_test_temporary.iqtmp
Server failed to start
从错误信息来看,问题原因是 -iqnotemp 参数设置的过大,为100G,而文件系统空间太小导致的。
注意:IQ集群数据库备份恢复成功后,启动时需要加上 -iqmpx_sn 1、 -iqmpx_ov 1和 -iqnotemp 参数。
-iqnotemp 单位为M,占用文件系统空间,启动成功后,需要add file到IQ_SYSTEM_TEMP DBSPACE下,然后stop server,去掉 -iqnotemp参数启动。