Oninit cdi / Archive
Talk to an expert →

Add chunk.

Posted in 2000

Summary

F. David added a second chunk to a dbspace on IDS 7.30 UC7 under AIX 4.3.2 and oncheck -ce reported 'Extents overlap'. David Williams and Art Kagel called it likely an engine bug and asked for oncheck output; Williams advised logging a call. Informix told F. David it was a known problem caused by the operating system with some AIX/IDS versions. He fixed it and added the chunk without errors.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management, Platform-Specific Issues, Versions, Editions & End-of-Life

F. David — — source: Informix-list mailing list archive (1991-1998)

Hello, I am a newbie. Working with AIX 4.3.2 and IDS 7.30 UC7. After adding a second chunk to a dbspace I got the error message: extents overlap(oncheck -ce). Chunk was successfully added and onstat -d shows the new chunk. What is the problem? Thanks in advance, Fredo David

↪ replying to F. David
David Williams — — source: Informix-list mailing list archive (1991-1998)

In article <3932b8f9.6270410@news.ivx.de>, F. David <FredoDavid@gmx.net> writes >Hello, >I am a newbie. >Working with AIX 4.3.2 and IDS 7.30 UC7. >After adding a second chunk to a dbspace I got the error message: >extents overlap(oncheck -ce). >Chunk was successfully added and onstat -d shows the new chunk. >What is the problem? > Sounds like an Informix bug. What does oncheck -pe give for the dbspace? >Thanks in advance, >Fredo David > -- David Williams

↪ replying to F. David
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

It's not telling you that the chunks overlap but that somehow, probably due to an engine bug, the engine has created extents in different tables that overlap, ie the start + length of some extent is greater than the start address of some other extent. Run the suggested oncheck -ce and see what is reported and suggested. Art S. Kagel "F. David" wrote: > > Hello, > I am a newbie. > Working with AIX 4.3.2 and IDS 7.30 UC7. > After adding a second chunk to a dbspace I got the error message: > extents overlap(oncheck -ce). > Chunk was successfully added and onstat -d shows the new chunk. > What is the problem? > > Thanks in advance, > Fredo David

↪ replying to David Williams
F. David — — source: Informix-list mailing list archive (1991-1998)

>In article <3932b8f9.6270410@news.ivx.de>, F. David <FredoDavid@gmx.net> >writes >>Hello, >>I am a newbie. >>Working with AIX 4.3.2 and IDS 7.30 UC7. >>After adding a second chunk to a dbspace I got the error message: >>extents overlap(oncheck -ce). >>Chunk was successfully added and onstat -d shows the new chunk. >>What is the problem? >> > > Sounds like an Informix bug. What does oncheck -pe give for > the dbspace? Oncheck gave the information: For the added chunk Chunk: 13 /dev/idbs15 Size Used Free 50000 0 49997 Disk usage for chunk 13 start length OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 FREE 3 49997 For the first chunk Chunk: 2 /dev/idbs22 Size Used Free 50000 0 49997 Disk usage for chunk 2 start length OTHER RESERVED Pages 0 2 ERROR: Extents overlap CHUNK FREE LIST PAGE 2 1 TBLSPACE TBLSPACE 3 50 db:tbl 53 5500 ........... >-- >David Williams Fredo David

↪ replying to F. David
David Williams — — source: Informix-list mailing list archive (1991-1998)

In article <39354ff3.1042125@news.ivx.de>, F. David <FredoDavid@gmx.net> writes > >>In article <3932b8f9.6270410@news.ivx.de>, F. David <FredoDavid@gmx.net> >>writes >>>Hello, >>>I am a newbie. >>>Working with AIX 4.3.2 and IDS 7.30 UC7. >>>After adding a second chunk to a dbspace I got the error message: >>>extents overlap(oncheck -ce). >>>Chunk was successfully added and onstat -d shows the new chunk. >>>What is the problem? >>> >> >> Sounds like an Informix bug. What does oncheck -pe give for >> the dbspace? >Oncheck gave the information: > >For the added chunk >Chunk: 13 /dev/idbs15 Size Used Free > 50000 0 49997 > >Disk usage for chunk 13 start length > >OTHER RESERVED Pages 0 2 >CHUNK FREE LIST PAGE 2 1 >FREE 3 49997 > >For the first chunk >Chunk: 2 /dev/idbs22 Size Used Free > 50000 0 49997 > >Disk usage for chunk 2 start length > >OTHER RESERVED Pages 0 2 >ERROR: Extents overlap >CHUNK FREE LIST PAGE 2 1 >TBLSPACE TBLSPACE 3 50 >db:tbl 53 5500 >........... > > >>-- >>David Williams > > >Fredo David Log a call with Informix, something funny is happening. -- David Williams

↪ replying to Art S. Kagel
F. David — — source: Informix-list mailing list archive (1991-1998)

Thanks for help. Informix told me that it is a known bug. Not the database engine is the reason but the operating system. Some versions of AIX with some IDS show this problem. I could fix it and added the chunk without errors. F. David >It's not telling you that the chunks overlap but that somehow, probably >due to an engine bug, the engine has created extents in different tables >that overlap, ie the start + length of some extent is greater than the >start address of some other extent. Run the suggested oncheck -ce and see >what is reported and suggested. > >Art S. Kagel > > >Oncheck gave the information: >For the added chunk >Chunk: 13 /dev/idbs15 Size Used Free > 50000 0 49997 > >Disk usage for chunk 13 start length > >OTHER RESERVED Pages 0 2 >CHUNK FREE LIST PAGE 2 1 >FREE 3 49997 > >For the first chunk >Chunk: 2 /dev/idbs22 Size Used Free > 50000 0 49997 > >Disk usage for chunk 2 start length > >OTHER RESERVED Pages 0 2 >ERROR: Extents overlap >CHUNK FREE LIST PAGE 2 1 >TBLSPACE TBLSPACE 3 50 >db:tbl 53 5500 >........... >F. David > Sounds like an Informix bug. What does oncheck -pe give for > the dbspace? > >David Williams >"F. David" wrote: >> >> Hello, >> I am a newbie. >> Working with AIX 4.3.2 and IDS 7.30 UC7. >> After adding a second chunk to a dbspace I got the error message: >> extents overlap(oncheck -ce). >> Chunk was successfully added and onstat -d shows the new chunk. >> What is the problem? >> >> Thanks in advance, >> Fredo David

Related threads

Glossary