在线求助： informix crash

syblx

online.log

11:56:56  Event alarms enabled.  ALARMPROG = '/usr/informix/etc/no_log.sh'
11:56:56  Booting Language <c> from module <>
11:56:56  Loading Module <CNULL>
11:56:56  Booting Language <builtin> from module <>
11:56:56  Loading Module <BUILTINNULL>
11:57:00  Requested shared memory segment size rounded from 480KB to 1024KB
11:57:01  Informix Dynamic Server 2000 Version 9.21.UC6X8   Software Serial Number AAD#J267815
11:57:01  Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized.

11:57:01  Physical Recovery Started at Page(1:690).
11:57:02  Physical Recovery Complete: 396 Pages Examined 396 Pages Restored.

11:57:02  Logical Recovery Started.
11:57:02  10 recovery worker threads will be started.
11:57:02  Assert Failed: Dynamic Server 2000 must abort
11:57:02  Informix Dynamic Server 2000 Version 9.21.UC6X8  
11:57:02   Who: Session(11, informix@motcs, 0, 262391592)
                Thread(16, fast_rec, fa0d7e8, 1)
                File: rslog.c Line: 3203
11:57:02   Results: Dynamic Server 2000 must abort
11:57:02   Action: Reinitialize shared memory
11:57:02  stack trace for pid 273 written to /tmp/af.3f8708d
11:57:02   See Also: /tmp/af.3f8708d, shmem.3f8708d.0
Assertion Failure Type:        CRASH
Host Name:                motcs
Database Server Name:        motcs
Time of failure:        Mon Jan 29 11:57:03 CST 2007
AF file:                /tmp/af.3f8708d
Shared memory file:        None
System Blocking:        OFF

11:57:18  rslog.c, line 3203, thread 16, proc id 273, Dynamic Server 2000 must abort.
11:57:18  PANIC: Attempting to bring system down
11:57:18  semctl: errno = 22

11:57:18  semctl: errno = 22

11:57:18  semctl: errno = 22




/tmp/af.3f8a05a

15:20:59  log_get: page doesn't match loguniq 722 or pagenum 226
15:20:59   pg_uniqid = 704, pg_number = 226
page header
0ab06000: 001004d7 c664b2e8 00000100 00380000   .....d.. .....8..
0ab06010: 000002c0 000000e2                     ........
15:20:59  log_get: cannot read loguniq 722 logpos 0xe2018
15:20:59  logm_read: cannot read loguniq 722 logpos 0xe2018
15:20:59  logerr('logread')
15:20:59   tx 0xfa3c728, tx_flags 0x80001
15:20:59   tx_loguniq 0, tx_logpos 0x0
15:20:59
15:20:59  Informix Dynamic Server 2000 Version 9.21.UC6X8   Software Serial Number AAD#J267815

15:20:59  Assert Failed: Dynamic Server 2000 must abort
15:20:59   Who: Session(11, informix@motcs, 0, 262391592)
                Thread(16, fast_rec, fa0d7e8, 1)
                File: rslog.c Line: 3203
15:20:59   Results: Dynamic Server 2000 must abort
15:20:59   Action: Reinitialize shared memory
15:20:59  Stack for thread: 16 fast_rec

base: 0x100af000
  len:   69632
   pc: 0x0069d520
  tos: 0x100bf668
state: running
   vp: 1

0x0069cad8 (oninit)afhandler(0xa4a800, 0x9d346c, 0xa4a77c, 0x9ae8b0, 0x1, 0x3f8a05a)
0x0069c474 (oninit)afcrash_interface(0xffa7150, 0xffa7150, 0xffd36e0, 0x9ae8b0, 0xc83, 0x0)
0x004b9078 (oninit)logerr  (0xa3b400, 0x8f6400, 0xffa7150, 0xffa7150, 0x100bfde4, 0x100bfde0)
0x004b78e8 (oninit)logread (0x2d2, 0xe2018, 0x1010e018, 0x8000, 0x100aa020, 0x0)
0x00466070 (oninit)builddpt(0xa3b400, 0xa4fc00, 0xa037800, 0x2d2, 0xa4ff74, 0x2d2)
0x00462808 (oninit)fast_recovery(0x8f6400, 0x9a9f14, 0xa037800, 0x6bc8, 0x200, 0x100c1400)
0x0067eca8 (oninit)startup (0xa4ab14, 0x7, 0xa3b800, 0x100ab018, 0x1007ed08, 0xff7b4c4)
0x000d3fa8 (oninit)initseg (0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x00000000 (*nosymtab*)0x0


15:20:59   See Also: /tmp/af.3f8a05a, shmem.3f8a05a.0

---------------------------------
Begin System Alarm Program Output
---------------------------------

Assertion Failure Type: CRASH
Host Name:              motcs
Database Server Name:   motcs
Time of failure:        Mon Jan 29 15:21:01 CST 2007
AF file:                /tmp/af.3f8a05a





===========------------- - - - - - -
/usr/informix/bin/onstat -l:

Informix Dynamic Server 2000 Version 9.21.UC6     -- Fast Recovery -- Up 00:00:10 -- 132096 Kbytes

Physical Logging
Buffer bufused  bufsize  numpages numwrits pages/io
  P-1  0        64       0        0        0.00
      phybegin physize  phypos   phyused  %used
      100107   500      323      0        0.00

Logical Logging
Buffer bufused  bufsize  numrecs  numpages numwrits recs/pages pages/io
  L-1  0        16       0        0        0        0.0        0.0
        Subsystem    numrecs  Log Space used

address  number   flags    uniqid   begin        size     used    %used
a4ce490  1        U-B----  721      1002fb        250      250   100.00
a4ce4ac  2        U---C-L  722      1003f5        250      226    90.40
a4ce4c8  3        U-B----  705      1004ef        250      250   100.00
a4ce4e4  4        U-B----  706      1005e9        250      250   100.00
a4ce500  5        U-B----  707      1006e3        250      250   100.00
a4ce51c  6        U-B----  708      1007dd        250      250   100.00
a4ce538  7        U-B----  709      1008d7        250      250   100.00
a4ce554  8        U-B----  710      1009d1        250      250   100.00
a4ce570  9        U-B----  711      100acb        250      250   100.00
a4ce58c  10       U-B----  712      100bc5        250      250   100.00
a4ce5a8  11       U-B----  713      100cbf        250      250   100.00
a4ce5c4  12       U-B----  714      100db9        250      250   100.00
a4ce5e0  13       U-B----  715      100eb3        250      250   100.00
a4ce5fc  14       U-B----  716      100fad        250      250   100.00
a4ce618  15       U-B----  717      1010a7        250      250   100.00
a4ce634  16       U-B----  718      1011a1        250      250   100.00
a4ce650  17       U-B----  719      10129b        250      250   100.00
a4ce66c  18       U-B----  720      101395        250      250   100.00


怎样才可以在不重建数据库的情况下，恢复它呢？？？？？！！

谢谢先

zhan_yl

逻辑日志有问题