Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2007
    Posts
    2

    Red face Unanswered: Unable to drop chunk even when it's empty



    Hi all,

    I've tried dropping a chunk (cooked file) with onspaces but it is not able to do it. I get the error "Chunk not empty". But when I do an oncheck -pe, this is what I get:

    Chunk: 10 /usr/chunk2 Size Used Free

    250 91 159

    Disk usage for Chunk 10 Start Length

    ------------------------------------------- --------- ---------
    OTHER RESERVED Pages 0 2
    CHUNK FREE LIST PAGE 2 1
    FREE 51 8
    FREE 99 151


    I'm very sure it's empty since I've moved the table out to another dbspace.
    Anyway I can clear out drop this chunk?

    This is the error I get:
    WARNING: Dropping a chunk.

    Do you really want to continue? (y/n)y

    Chunk not dropped.

    ISAM error: Chunk not empty

    Will appreciate any help. Thanks.

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    Can you post the 'onstat -d' output?

  3. #3
    Join Date
    Aug 2007
    Posts
    2
    Hi! Here's my onstat -d output for that chunk.

    Chunks
    address chk/dbs offset size free bpages flags pathname
    6065ad90 10 1 0 250 127 PO- /usr/chunk2

    I just did an oncheck -pe again today:
    Chunk: 10 /usr/chunk2 Size Used Free
    250 123 127

    Disk usage for Chunk 10 Start Length
    ------------------------------------------- --------- ---------
    OTHER RESERVED Pages 0 2
    CHUNK FREE LIST PAGE 2 1
    FREE 115 8
    FREE 131 119


    More info, this band-aid chunk is a chunk of rootdbs which was suspiciously filling up fast. Found out what caused it, now want to clean up.

    Thanks

  4. #4
    Join Date
    May 2002
    Location
    Osnabrueck Germany
    Posts
    59
    Hi,
    oncheck -pe tells you what's in it.
    Juergen Ladwig

  5. #5
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    Yeah, both the onstat and oncheck output show that the chunk is about half full (123/127 pages). Doesn't the oncheck -pe output show any tables following the output you posted? It's a very small chunk if the pagesize is 2K but an empty chunk can only contain some administrative pages to be dropped. If half the chunk was filled with administrative pages I wonder what a curious table was in it. But what about the indexes for the table you moved from this chunk? Check the table and it's (index)pages with oncheck -pt database:table.

    Hans

    BTW. Pls. paste your column outlined output inside [CODE] tags for readability, like
    Code:
    Dbspaces                                                                         
    address  number   flags      fchunk   nchunks  pgsize   flags    owner    name   
    7885f7e8 1        0x40001    1        1        2048     N  B     informix rootdbs
    
    Chunks                                                                                                   
    address  chunk/dbs  offset     size       free       bpages     flags pathname                           
    7885f948 1     1    0          128000     125207                PO-B  /data/productiedbs/LINKS/rootdbs.00
    Last edited by Tyveleyn; 08-28-07 at 05:44.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •