Chinaunix首页 | 论坛 | 博客
  • 博客访问: 213638
  • 博文数量: 28
  • 博客积分: 128
  • 博客等级: 民兵
  • 技术积分: 400
  • 用 户 组: 普通用户
  • 注册时间: 2011-01-19 13:05
个人简介

生活的内容不全是工作,工作只是生活的一部分;享受生活,热爱工作!

文章分类
文章存档

2015年(1)

2014年(23)

2011年(4)

分类: 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参数启动。

阅读(2944) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~