Chinaunix

标题: 数据库每天崩溃？ [打印本页]

作者: 白云 时间: 2007-08-17 08:47
标题: 数据库每天崩溃？
系统每天某个点前后崩溃，不知是什么造成。
平台AIX  应用：delphi,java ,4gl
onlinelog:

10:33:13  Event alarms enabled.  ALARMPROG = '/informix/etc/log_full.sh'
10:33:13  Booting Language <c> from module <>
10:33:13  Loading Module <CNULL>
10:33:13  Booting Language <builtin> from module <>
10:33:13  Loading Module <BUILTINNULL>
10:33:18  DR: DRAUTO is 0 (Off)
10:33:18  AIX MP latch code enabled
10:33:18  Requested shared memory segment size rounded from 5276KB to 5280KB
10:33:18  Requested shared memory segment size rounded from 5276KB to 5280KB
10:33:18  Dynamically allocated new message shared memory segment (size 5280KB)
10:33:18  IBM Informix Dynamic Server Version 10.00.FC4    Software Serial Number AAA#B000000
10:33:18  WARNING! Logical log layout may cause Dynamic Server to get into
      a locked state.  Recommended smallest logical log size
      is 2 times maximum concurrent user threads.

10:33:18  (

connection rejected - no calls allowed for sqlexec
10:33:19  (14) connection rejected - no calls allowed for sqlexec
10:33:19  (15) connection rejected - no calls allowed for sqlexec
10:33:19  (16) connection rejected - no calls allowed for sqlexec
10:33:19  (17) connection rejected - no calls allowed for sqlexec
10:33:19  (1

connection rejected - no calls allowed for sqlexec
10:33:19  (19) connection rejected - no calls allowed for sqlexec

10:33:20  (21) connection rejected - no calls allowed for sqlexec
10:33:20  (22) connection rejected - no calls allowed for sqlexec
10:33:20  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

10:33:20  Physical Recovery Started at Page (2:47432).
10:33:20  Physical Recovery Complete: 29 Pages Examined, 29 Pages Restored.
10:33:21  Logical Recovery Started.
10:33:21  10 recovery worker threads will be started.
10:33:24  listener-thread: err = -25580: oserr = 32: errstr = : System error occurred in network function.
System error = 32.
10:33:25  Logical Recovery has reached the transaction cleanup phase.
10:33:25  Logical Recovery Complete.
      16 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

10:33:26  Dataskip is now OFF for all dbspaces
10:33:26  Checkpoint Completed:  duration was 0 seconds.
10:33:26  Checkpoint loguniq 70986, logpos 0x7fa7018, timestamp: 0x5c2f3782

10:33:26  Maximum server connections 0
10:33:26  Dropping temporary TBLspace 0x602715, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602716, recovering 4 pages.
10:33:26  (107) connection rejected - no calls allowed for sqlexec
10:33:26  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in quiescent mode.
0:33:26  Dropping temporary TBLspace 0x60272c, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x60274e, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602753, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602759, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602768, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602769, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x60276c, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x602789, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x60278a, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x60278b, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x60278c, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x602794, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602797, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x6027b8, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x6027c1, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x6027c2, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x6027c3, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x6027c4, recovering 32 pages.
10:33:26  Dropping temporary TBLspace 0x6027c5, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x6027c6, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x6027c7, recovering 16 pages.
10:33:26  Dropping temporary TBLspace 0x6027c8, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x6027c9, recovering 4 pages.

作者: shanshl 时间: 2007-08-17 08:56
是不是逻辑日志文件太小了？

作者: linuxboy99 时间: 2010-01-25 12:35
标题: 回复 #1 白云的帖子
我也遇到了
看來informix用的人太少太少
donw了之後沒有log記錄

作者: liaosnet 时间: 2010-01-25 12:40

原帖由 linuxboy99 于 2010-1-25 12:35 发表
我也遇到了
看來informix用的人太少太少
donw了之後沒有log記錄

从上面的日志里压根就看不出因为什么down掉~~这个日志里只提供了重启后的online.log

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)