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.

Can you post the 'onstat -d' output?

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

Hi,
oncheck -pe tells you what's in it.

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