首页 > Linux操作系统 > Linux操作系统 > informix 保留页错误!
1,不能全备,备份的时候报错:
16:36:55 Maximum server connections 36
16:36:57 Level 0 Archive started on rootdbs, llogdbs, plogdbs, datadbs01, datadbs02
16:36:57 Assert Warning: The reserved page is corrupted
16:36:57 IBM Informix Dynamic Server Version 10.00.UC4
16:36:57 Who: Session(3017432, informix@tonykorn97, 12306, 0x85e3bd10)
Thread(3360304, arcbackup1, 85e0f804, 1)
File: rsarcbu.c Line: 2365
16:36:57 Action: The pg_prev and pg_next of the reserved page pair are not consistent.
Patch the pages to make the two fields consistent OR
unload data from current server and reload data after initialising
the server
16:36:57 stack trace for pid 6520 written to /home/informix/tmp/af.4a1852a9
16:36:57 See Also: /home/informix/tmp/af.4a1852a9
16:36:58 The reserved page is corrupted
16:36:58 Archive on rootdbs, llogdbs, plogdbs, datadbs01, datadbs02 ABORTED.
16:36:58 Aborted by client.
16:42:05 Fuzzy Checkpoint Completed: duration was 0 seconds, 95 buffers not flushed.
16:42:05 Checkpoint loguniq 11827, logpos 0x90e630, timestamp: 0xca549845
察看/home/informix/tmp/af.4a1852a9文件
16:36:57 Reserved page 2:
16:36:57 pg_prev:0,pg_next:0
16:36:57 Reserved page 3:
16:36:57 pg_prev:1,pg_next:264
16:36:57
16:36:57 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000
16:36:57 Assert Warning: The reserved page is corrupted
16:36:57 Who: Session(3017432, informix@tonykorn97, 12306, 0x85e3bd10)
Thread(3360304, arcbackup1, 85e0f804, 1)
File: rsarcbu.c Line: 2365
16:36:57 Action: The pg_prev and pg_next of the reserved page pair are not consistent.
Patch the pages to make the two fields consistent OR
unload data from current server and reload data after initialising
the server
16:36:57 Stack for thread: 3360304 arcbackup1
这个数据库两天前发生这样的错误:
14:14:40 Maximum server connections 36
14:23:06 Assert Failed: Page Check Error in btsearch:bad btree node
14:23:06 IBM Informix Dynamic Server Version 10.00.UC4
14:23:06 Who: Session(2952066, shopuser@172.17.3.153, -164169, 0x85e36058)
Thread(3290696, sqlexec, 85e12690, 1)
File: rsdebug.c Line: 1066
14:23:06 Results: Possible inconsistencies in index 'rrldbshop:"informix".goods#'
14:23:06 Action: Run 'oncheck -cI shop:"informix".goods#'
14:23:06 stack trace for pid 6520 written to /home/informix/tmp/af.3a308fd2
14:23:06 See Also: /home/informix/tmp/af.3a308fd2, shmem.3a308fd2.0
14:23:38 Page Check Error in btsearch:bad btree node
14:23:39 Fuzzy Checkpoint Completed: duration was 238 seconds, 68 buffers not flushed.
14:23:39 Checkpoint loguniq 11801, logpos 0x6d4548, timestamp: 0xc9f2855f
14:23:39 Maximum server connections 36
操作步骤,按照数据库的提示把数据导出后重新初始化数据库然后导入数据
需要注意的是:
出现问题后不要关闭数据库然后重新启动,用onmode -j进入单用户导出数据。
我当时导出数据后关闭数据库,然后启动就报错了。
导出数据后用oncheck -cR 和oncheck -ce检测了一下是不行的。
3,oncheck检测
informix@tonykorn97:~/20070820> oncheck -cr
Validating IBM Informix Dynamic Server reserved pages
Validating PAGE_PZERO...
Validating PAGE_CONFIG...
Validating PAGE_1CKPT & PAGE_2CKPT...
Using check point page PAGE_2CKPT.
Validating PAGE_1DBSP & PAGE_2DBSP...
Using DBspace page PAGE_2DBSP.
Validating PAGE_1PCHUNK & PAGE_2PCHUNK...
Using primary chunk page PAGE_2PCHUNK.
Validating PAGE_1ARCH & PAGE_2ARCH...
Using archive page PAGE_2ARCH.
informix@tonykorn97:~/20070820> oncheck -cR
Validating IBM Informix Dynamic Server reserved pages
Validating PAGE_PZERO...
Validating PAGE_CONFIG...
Validating PAGE_1CKPT & PAGE_2CKPT...
Using check point page PAGE_1CKPT.
Validating physical log pages ...
Validating logical logs ...
Validating PAGE_1DBSP & PAGE_2DBSP...
Using DBspace page PAGE_2DBSP.
Validating PAGE_1PCHUNK & PAGE_2PCHUNK...
Using primary chunk page PAGE_1PCHUNK.
Validating PAGE_1ARCH & PAGE_2ARCH...
Using archive page PAGE_2ARCH.
informix@tonykorn97:~/20070820>
informix@tonykorn97:~/20070820> oncheck -ce
Validating extents for Space 'rootdbs' ...
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
1 /informix.links/back/rootdbs 2 64000 4221 59779
ERROR: Missing pages 263 through 264 inclusive
Validating extents for Space 'plogdbs' ...
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
2 /informix.links/back/plogdbs 2 128000 127553 447
Validating extents for Space 'llogdbs' ...
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
3 /informix.links/back/llogdbs 2 512000 350053 161947
Validating extents for Space 'tempdbs1' ...
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
4 /informix.links/back/tempdbs01 2 512000 1903 510097
Validating extents for Space 'tempdbs2' ...
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
5 /informix.links/back/tempdbs02 2 512000 1903 510097
Validating extents for Space 'datadbs01' ...
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
6 /informix.links/back/datadbs01 2 2048000 32264 2015736
Validating extents for Space 'datadbs02' ...
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
7 /informix.links/back/datadbs02 2 36550000 6756590 29793410
informix@tonykorn97:~/20070820>
informix@tonykorn97:~> oncheck -pr
Validating IBM Informix Dynamic Server reserved pages
Validating PAGE_PZERO...
Identity =
?
m2
Database system state 17909
Database system flags 0x4
Page Size 3 (b)
Date/Time created 01/01/1970 09:23:20
Version number of creator 5000
Last modified time stamp 327744
Validating PAGE_CONFIG...
ROOTNAME rootdbs
ROOTPATH /informix.links/back/rootdbs
ROOTOFFSET 16 (k)
ROOTSIZE 128000 (k)
MIRROR 0
MIRRORPATH
MIRROROFFSET 0 (k)
DB_LIBRARY_PATH
JVPHOME /home/informix/extend/krakatoa
JVPJAVAHOME /home/informix/extend/krakatoa/jre
JVPJAVAVM jsig:hpi:jvm:java:net:zip:jpeg
JVPLOGFILE /home/informix/jvp.log
JVPPROPFILE /home/informix/extend/krakatoa/.jvpprops
JVPJAVALIB /bin
JDKVERSION 1.3
JVMTHREAD green
JVPCLASSPATH /home/informix/extend/krakatoa/krakatoa.jar:/usr/informix/extend/krakatoa/jdbc.jar
JVPDEBUG 0
PHYSDBS plogdbs
PHYSFILE 255000 (k)
LOGFILES 70
LOGSIZE 10000 (k)
MSGPATH /home/informix/tonykorn97.log
CONSOLE /dev/console
TAPEDEV /dev/nst0
TAPEBLK 32 (k)
TAPESIZE 10240 (k)
LTAPEDEV /dev/nst0
LTAPEBLK 32 (k)
LTAPESIZE 10240 (k)
DBSERVERNAME ontonykorn97
SERVERNUM 0
DEADLOCK_TIMEOUT 60 (s)
RESIDENT 0
LOCKS 200000
BUFFERPOOL
size=2K,buffers=500000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
PHYSBUFF 32 (k)
LOGBUFF 32 (k)
CLEANERS 1
BUFFSIZE 2048 (b)
SHMBASE 0x44000000
CKPTINTVL 300 (s)
NOFUZZYCKPT 0
SPINCNT 0
STAGEBLOB
LTXHWM 50 (%)
LTXEHWM 60 (%)
TXTIMEOUT 300 (s)
DRNODE 0
DRNAME
DRINTERVAL 30 (s)
DRTIMEOUT 30 (s)
DRIDXAUTO 0
DRAUTO 0
DRLOSTFOUND /home/informix/etc/dr.lostfound
DUMPSHMEM 1
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1
DUMPDIR /home/informix/tmp
NUMCPUVPS 1
NUMAIOVPS 2
SHMVIRTSIZE 32000 (k)
NOAGE 0
AFF_SPROC 0
AFF_NPROC 0
RA_PAGES 8 (p)
RA_THRESHOLD 4 (p)
STACKSIZE 32 (k)
OFF_RECVRY_THREADS 10
ON_RECVRY_THREADS 1
SHMADD 16000 (k)
EXTSHMADD 8192 (k)
SHMTOTAL 0 (k)
SINGLE_CPU_VP 0
ALRM_ALL_EVENTS 0
ALARMPROGRAM /home/informix/etc/alarmprogram.sh
ONLIDX_MAXMEM 5120 (k)
DS_MAX_QUERIES 2
DS_TOTAL_MEMORY 256 (k)
DS_MAX_SCANS 1048576
MAX_PDQPRIORITY 100
DBSPACETEMP tempdbs1,tempdbs2
DATASKIP off
ONDBSPACEDOWN 2
OPCACHEMAX 0 (k)
BAR_MAX_BACKUP 1
Validating PAGE_1CKPT & PAGE_2CKPT...
Using check point page PAGE_1CKPT.
Time stamp of checkpoint 0xcaa223a3
Time of checkpoint 08/20/2007 23:47:35
Physical log begin address 2:53
Physical log size 127500 (p)
Physical log position at Ckpt 36910
Logical log unique identifier 11838
Logical log position at Ckpt 0x11cb018 (Page 4555, byte 24)
DBspace descriptor page 1:5
Chunk descriptor page 1:6
Mirror chunk descriptor page 1:8
Log file number 7
Unique identifier 11837
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 3:53
Log size 5000 (p)
Number pages used 5000
Date/Time file filled 08/20/2007 22:33:41
Time stamp 0xca6d1b36
。。。。。。
informix@tonykorn97:~/20070820> oncheck -pe | more
DBspace Usage Report: rootdbs Owner: informix Created: 05/30/2005
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
1 /informix.links/back/rootdbs 2 64000 4221 59779
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 12
CHUNK FREELIST PAGE 12 1
rootdbs:'informix'.TBLSpace 13 250
ERROR: Missing pages 263 through 264 inclusive
RESERVED PAGES 264 1
sysutils:'informix'.systables 265 8
sysutils:'informix'.syscolumns 273 16
sysutils:'informix'.sysindices 289 24
sysutils:'informix'.systabauth 313 16
sysutils:'informix'.syscolauth 329 8
sysutils:'informix'.sysviews 337 8
sysutils:'informix'.sysusers 345 8
sysutils:'informix'.sysdepend 353 8
sysutils:'informix'.syssynonyms 361 8
sysutils:'informix'.syssyntable 369 8
sysutils:'informix'.sysconstraints 377 8
sysutils:'informix'.sysreferences 385 8
sysutils:'informix'.syschecks 393 8
sysutils:'informix'.sysdefaults 401 8
informix@tonykorn97:~/20070820>
4,关闭数据库,重新启动报错:
Initialize Async Log Flusher...succeeded
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list...succeeded
oninit: Fatal error in shared memory initialization
informix@tonykorn97:~> onstat -m
shared memory not initialized for INFORMIXSERVER 'ontonykorn97'
Message Log File: /home/informix/tonykorn97.log
Mon Aug 20 23:59:32 2007
23:59:32 Event alarms enabled. ALARMPROG = '/home/informix/etc/alarmprogram.sh'
23:59:32 Booting Language
23:59:32 Loading Module
23:59:32 Booting Language
23:59:32 Loading Module
23:59:37 DR: DRAUTO is 0 (Off)
23:59:37 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000
23:59:40 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
23:59:40 Physical Recovery Started at Page (2:36963).
23:59:40 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
23:59:40 Logical Recovery Started.
23:59:40 10 recovery worker threads will be started.
23:59:40 Logical Log File not found.
23:59:40 Cannot Rollforward from Checkpoint.
23:59:41 IBM Informix Dynamic Server Stopped.
23:59:41 mt_shm_remove: WARNING: may not have removed all/correct segments
informix@tonykorn97:~>
tonykorn97:~ # ipcs
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
------ Semaphore Arrays --------
key semid owner perms nsems
------ Message Queues --------
key msqid owner perms used-bytes messages
0x00001f58 0 root 600 0 0
tonykorn97:~ #
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/312079/viewspace-245742/ ,如需转载,请注明出处,否则将追究法律责任。