数据库每天崩溃？
系统每天某个点前后崩溃，不知是什么造成。平台AIX应用：delphi,java ,4gl
onlinelog:
10:33:13Event alarms enabled.ALARMPROG = '/informix/etc/log_full.sh'
10:33:13Booting Language <c> from module <>
10:33:13Loading Module <CNULL>
10:33:13Booting Language <builtin> from module <>
10:33:13Loading Module <BUILTINNULL>
10:33:18DR: DRAUTO is 0 (Off)
10:33:18AIX MP latch code enabled
10:33:18Requested shared memory segment size rounded from 5276KB to 5280KB
10:33:18Requested shared memory segment size rounded from 5276KB to 5280KB
10:33:18Dynamically allocated new message shared memory segment (size 5280KB)
10:33:18IBM Informix Dynamic Server Version 10.00.FC4 Software Serial Number AAA#B000000
10:33:18WARNING! 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(8) 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(18) 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:20IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
10:33:20Physical Recovery Started at Page (2:47432).
10:33:20Physical Recovery Complete: 29 Pages Examined, 29 Pages Restored.
10:33:21Logical Recovery Started.
10:33:2110 recovery worker threads will be started.
10:33:24listener-thread: err = -25580: oserr = 32: errstr = : System error occurred in network function.
System error = 32.
10:33:25Logical Recovery has reached the transaction cleanup phase.
10:33:25Logical Recovery Complete.
16 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
10:33:26Dataskip is now OFF for all dbspaces
10:33:26Checkpoint Completed:duration was 0 seconds.
10:33:26Checkpoint loguniq 70986, logpos 0x7fa7018, timestamp: 0x5c2f3782
10:33:26Maximum server connections 0
10:33:26Dropping temporary TBLspace 0x602715, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x602716, recovering 4 pages.
10:33:26(107) connection rejected - no calls allowed for sqlexec
10:33:26listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in quiescent mode.
0:33:26Dropping temporary TBLspace 0x60272c, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x60274e, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x602753, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x602759, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x602768, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x602769, recovering 4 pages.
10:33:26Dropping temporary TBLspace 0x60276c, recovering 4 pages.
10:33:26Dropping temporary TBLspace 0x602789, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x60278a, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x60278b, recovering 4 pages.
10:33:26Dropping temporary TBLspace 0x60278c, recovering 4 pages.
10:33:26Dropping temporary TBLspace 0x602794, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x602797, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x6027b8, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x6027c1, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x6027c2, recovering 4 pages.
10:33:26Dropping temporary TBLspace 0x6027c3, recovering 4 pages.
10:33:26Dropping temporary TBLspace 0x6027c4, recovering 32 pages.
10:33:26Dropping temporary TBLspace 0x6027c5, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x6027c6, recovering 8 pages.
10:33:26Dropping temporary TBLspace 0x6027c7, recovering 16 pages.
10:33:26Dropping temporary TBLspace 0x6027c8, recovering 4 pages.
10:33:26Dropping temporary TBLspace 0x6027c9, recovering 4 pages. 是不是逻辑日志文件太小了？
回复 #1 白云 的帖子
我也遇到了看來informix用的人太少太少
donw了之後沒有log記錄 原帖由 linuxboy99 于 2010-1-25 12:35 发表 http://bbs3.chinaunix.net/images/common/back.gif
我也遇到了
看來informix用的人太少太少
donw了之後沒有log記錄
从上面的日志里压根就看不出因为什么down掉~~这个日志里只提供了重启后的online.log
页:
[1]