informix 增加chunk失败报：Error calculating area boundaries - 第2页 - Informix - Chinaunix

yyc6219869 发表于 2013-02-01 10:21

回复 10# liaosnet

还需要什么信息？

liaosnet 发表于 2013-02-01 10:36

onstat -d
oncheck -pr
oncheck -pe

以后执行这些命令的时候的记录（如果有af，请一并付上），还有online.log

yyc6219869 发表于 2013-02-01 11:48

回复 12# liaosnet

$ onstat -d

IBM Informix Dynamic Server Version 11.10.FC2 -- On-Line -- Up 01:46:14 -- 848896 Kbytes

Dbspaces
address       number flags    fchunk nchunkspgsize flags owner name
10b6b6e88    1    0x60001 1    2    2048 NB informix rootdbs
10b7d4d60    2    0x60001 2    10    2048 NB informix ems
10b7bdc50    3    0x68001 3    12    2048 N SB informix ems_sp
10b7bdde8    5    0x60001 25    1    2048 NB informix tmpdbs
10b6b7278    6    0x42001 26    1    2048 N TB informix tempdbs
5 active, 2047 maximum

Chunks
address       chunk/dbs offset size    free    bpages flags pathname
10b6b7028    1    1    0       15000    7                   PO-B/var/informix/dblink/rootdbs
10b6b75f8    2    2    0       1048576 170                PO-B/var/informix/dblink/emsdbs01
10b6b77e0    3    3    250    10240    0       8457    POSB/var/informix/dblink/ems_sp
                              Metadata 1730    0       1730
10b6b79c8    4    3    150    1098575 0       859824 POSB/var/informix/dblink/ems_sp01
                              Metadata 238748 0       238748
10b6b7410    5    1    150    1098575 1095972             PO-B/var/informix/dblink/rootdbs01
10b6b7bb0    6    3    500    1024000 0       852652 POSB/var/informix/dblink/ems_sp02
                              Metadata 171345 0       171345
10b6b7d98    7    3    500    1024000 345    699055 POSB/var/informix/dblink/ems_sp03
                              Metadata 324942 0       324942
10c324028    8    2    0       1024000 0                   PO-B/var/informix/data/ems_sp04
10c324210    9    3    600    2048000 72       1705334 POSB/var/informix/dblink/ems_sp05
                              Metadata 342663 0       342663
10c3243f8    10 2    500    1024000 0                   PO-B/var/informix/dblink/emsdbs02
10c3245e0    11 2    500    2048000 0                   PO-B/var/informix/dblink/emsdbs03
10c3247c8    12 3    500    774000 0       644479 POSB/var/informix/dblink/ems_sp06
                              Metadata 129518 0       129518
10c3249b0    13 3    500    1024000 23       801453 POSB/var/informix/dblink/eoms_sp07
                              Metadata 222544 0       222544
10c324b98    14 2    500    512000 511997             PO-B/opt/ems_sps/ems_sp08
10c324d80    15 3    500    1024000 12       852652 POSB/var/informix/dblink/eoms_sp09
                              Metadata 171345 0       171345
10c325028    16 2    500    1024000 8                   PO-B/var/informix/dblink/ems_sp10
10c325210    17 3    500    1024000 0       801453 POSB/var/informix/dblink/ems_sp11
                              Metadata 222544 0       222544
10c3253f8    18 3    500    1536000 0       1125397 POSB/var/informix/dblink/ems_sp12
                              Metadata 410600 0       410600
10c3255e0    19 2    500    1536000 78326             PO-B/var/informix/dblink/ems_sp13
10c3257c8    20 3    500    1536000 14927    1278995 POSB/var/informix/dblink/ems_sp14
                              Metadata 257002 0       257002
10c3259b0    21 2    500    512000 511997             PO-B/var/informix/dblink/ems_sp21
10c325b98    22 2    500    512000 511997             PO-B/var/informix/dblink/ems_sp22

oncheck-pr

**Warning : 'oncheck' Failure: Possible inconsistency detected
      for the 'ch_nxchunk' field in a Chunk Descriptor.
      Chunk Number = 20
      Chunk Name = /var/informix/dblink/ems_sp14
      DBSpace Name = ems_sp
This inconsistency may result in to a System Hang.

oncheck -pe
**Warning : 'oncheck' Failure: Possible inconsistency detected
      for the 'ch_nxchunk' field in a Chunk Descriptor.
      Chunk Number = 20
      Chunk Name = /var/informix/dblink/ems_sp14
      DBSpace Name = ems_sp
This inconsistency may result in to a System Hang.

online 中没什么异常，再执行oncheck -pe时也是报上面信息

liaosnet 发表于 2013-02-01 12:11

尝试先把没用的几个chunk先删除，然后先给rootdbs增加一个chunk...
如ems_sp21/22这些没用的chunk

当前的你rootdbs上都没空间了。估计没法增加保留页的原因。。

yyc6219869 发表于 2013-02-01 12:51

本帖最后由 yyc6219869 于 2013-02-01 12:54 编辑

回复 14# liaosnet

IBM Informix Dynamic Server Version 11.10.FC2 -- On-Line -- Up 01:46:14 -- 848896 Kbytes

Dbspaces
address       number flags    fchunk nchunkspgsize flags owner name
10b6b6e88    1    0x60001 1    2    2048 NB informix rootdbs
10b7d4d60    2    0x60001 2    10    2048 NB informix ems
10b7bdc50    3    0x68001 3    12    2048 N SB informix ems_sp
10b7bdde8    5    0x60001 25    1    2048 NB informix tmpdbs
10b6b7278    6    0x42001 26    1    2048 N TB informix tempdbs
5 active, 2047 maximum

Chunks
address       chunk/dbs offset size    free    bpages flags pathname
10b6b7028    1    1    0       15000    7                   PO-B/var/informix/dblink/rootdbs
10b6b75f8    2    2    0       1048576 170                PO-B/var/informix/dblink/emsdbs01
10b6b77e0    3    3    250    10240    0       8457    POSB/var/informix/dblink/ems_sp
                              Metadata 1730    0       1730
10b6b79c8    4    3    150    1098575 0       859824 POSB/var/informix/dblink/ems_sp01
                              Metadata 238748 0       238748
10b6b7410    5    1    150    1098575 1095972          PO-B/var/informix/dblink/rootdbs01
rootdbs怎么会没空间呢？这不是还有2G的free吗
其它dbspaces增加chunk都没问题，就ems_sp（flag SB）这个增加有不上。

liaosnet 发表于 2013-02-01 13:11

回复 15# yyc6219869

看描述是 chunk 20 在保留页的信息有异常 Chunk Descriptor 。或者找IBM修复下，或者自己导保留页修改。。。

yyc6219869 发表于 2013-02-01 13:34

回复 16# liaosnet

the 'ch_nxchunk' field in a Chunk Descriptor.
这个什么意思，'ch_nxchunk' ？？？？如何导保留页？

页: 1 [2]

Chinaunix's Archiver