Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009
    Posts
    1

    Unanswered: Error oncheck -ce

    Hi! Can you please help me with this problem? Is there any way to know which table(s) is corrupted in order to recover it? (Informix 9.2)

    > oncheck -ce

    Validating BLOBSpace 'tppblobs' ...
    ERROR: Chunk: 4 /opt/informix/chunks/tppblobs
    ERROR:BLOB map page 125 contains reference to invalid tblspace 0x10103a
    ERROR:BLOB map page 897 contains reference to invalid tblspace 0x10117a
    ERROR:BLOB map page 910 contains reference to invalid tblspace 0x10118a
    ERROR:BLOB map page 987 contains reference to invalid tblspace 0x10028b

  2. #2
    Join Date
    Jul 2017
    Posts
    2

    Validating BLOBSpace --ERROR: BLOB map page

    Hello. We have a similar problem:
    Oncheck -ce bsp2

    Validating BLOBSpace 'bsp2' ...
    ERROR: Chunk: 30 / inf_chunks_0 / ch_blobs
    ERROR: BLOB map page 30: 234 contains reference to invalid tblspace 0x2075ae

    Has anyone solved a similar problem? Thank you.

  3. #3
    Join Date
    May 2008
    Posts
    36
    Hi, please check your Informix version, you may have run into a bug:

    IC73690 WHILE CHECKING A BLOBSPACE THE 'ONCHECK -PE' COMMAND MAY REPORT A REFERENCE TO AN INVALID TBLSPACE

    It is fixed with version 1.50.xC9
    From the bug description:

    "The application that uses non-logged temp tables with
    blobspace blobs and the Informix Server instance is stopped
    using 'onmode -ky' command (i.e. no cleanup of the running
    sessions is done). The 'oncheck -pe <blobspace>' command
    may report an orphaned blob data when run some time after
    subsequent successfull start of the instance."

  4. #4
    Join Date
    Jul 2017
    Posts
    2
    HI!
    versions IBM Informix Dynamic Server Version 11.50.FC9.

Posting Permissions

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